tag:blogger.com,1999:blog-1597676555600759067.post208012097260854661..comments2024-03-22T08:28:53.318+00:00Comments on marketsforISK: Excel reading prices from Eve-Central - step by step guideCrodahttp://www.blogger.com/profile/16620994327943613623noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-1597676555600759067.post-91004727125399030662017-02-11T12:13:33.031+00:002017-02-11T12:13:33.031+00:00This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/10833318493200069881noreply@blogger.comtag:blogger.com,1999:blog-1597676555600759067.post-48892345745305256492016-05-20T05:08:25.837+01:002016-05-20T05:08:25.837+01:00This comment has been removed by the author.Newbie looking for help pleasehttps://www.blogger.com/profile/06083386120901644580noreply@blogger.comtag:blogger.com,1999:blog-1597676555600759067.post-15261113258555309442016-05-12T00:46:36.912+01:002016-05-12T00:46:36.912+01:00https://www.youtube.com/watch?v=bLm0FQD_cN4 (part ...https://www.youtube.com/watch?v=bLm0FQD_cN4 (part 1)<br />https://www.youtube.com/watch?v=6DuavODssDE (part 2)<br />These videos aren't spam fyi, it's a video about making a google docs worksheet that pulls the data from eve-central. I wan't to do something similar via excel but cannot figure it out. I'm not very knowledge with excel but if anyone can provide me with a help link or something that gives directions how to do this with excel I'd greatly appreciate it.<br />Newbie looking for help pleasehttps://www.blogger.com/profile/06083386120901644580noreply@blogger.comtag:blogger.com,1999:blog-1597676555600759067.post-82164948520820114542016-05-09T13:02:49.282+01:002016-05-09T13:02:49.282+01:00=NUMBERVALUE(FILTERXML(WEBSERVICE("http://api...=NUMBERVALUE(FILTERXML(WEBSERVICE("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid="&A32);"/evec_api/marketstat/type/sell/min");".")<br /><br />For people ho need the data in number, not text.Anonymoushttps://www.blogger.com/profile/15729678472931970117noreply@blogger.comtag:blogger.com,1999:blog-1597676555600759067.post-7727434104477966062016-05-04T05:09:19.133+01:002016-05-04T05:09:19.133+01:00i wish google would fix the issue that keeps error...i wish google would fix the issue that keeps erroring when you re-open the spreadsheets. Anonymoushttps://www.blogger.com/profile/16508540613416009877noreply@blogger.comtag:blogger.com,1999:blog-1597676555600759067.post-50703155690638362702016-04-26T23:53:06.374+01:002016-04-26T23:53:06.374+01:00Hey Daniel, would you be so kind and teach me how ...Hey Daniel, would you be so kind and teach me how to retrieve prices from other systems / regions excepting Jita? I would be so greatfullAnonymoushttps://www.blogger.com/profile/03477827201353666426noreply@blogger.comtag:blogger.com,1999:blog-1597676555600759067.post-23719148693929838072014-08-03T13:17:30.424+01:002014-08-03T13:17:30.424+01:00Just for your information: You DON'T need to r...Just for your information: You DON'T need to request a share! <br /><br />All you need to do, is to click on "Data" and then copy it to your Google Drive account. Now you got your own copy and may edit it as you wish. :-)Daniel F.https://www.blogger.com/profile/03610562061728787166noreply@blogger.comtag:blogger.com,1999:blog-1597676555600759067.post-5201826968872696612014-07-20T02:18:51.456+01:002014-07-20T02:18:51.456+01:00yes, very much so.yes, very much so.Crodahttps://www.blogger.com/profile/16620994327943613623noreply@blogger.comtag:blogger.com,1999:blog-1597676555600759067.post-5848657616778746982014-07-16T18:25:41.423+01:002014-07-16T18:25:41.423+01:00Hi Croda thanks for the help. Question on the &qu...Hi Croda thanks for the help. Question on the "downloaded data" page and where you're placing everything. Because if I start doing 10-20 items maybe more, that page just gets longer and longer, is that correct? marseillefroghttps://www.blogger.com/profile/08243742922387269796noreply@blogger.comtag:blogger.com,1999:blog-1597676555600759067.post-17321480504806787882014-07-14T13:59:53.041+01:002014-07-14T13:59:53.041+01:00You may also just make an example public...
Here&...You may also just make an example public...<br /><br />Here's a fully completed spreadsheet, with automatic update from Jita prices: https://docs.google.com/spreadsheet/ccc?key=0Am1DnUpYOEztdE9BaU01cFNEaDNURGtZV2JWRnZkRVE#gid=0<br />Feel free to copy it and edit it with your settings. <br />EnjoyDaniel F.https://www.blogger.com/profile/03610562061728787166noreply@blogger.comtag:blogger.com,1999:blog-1597676555600759067.post-73585779348458432232014-05-07T13:56:59.808+01:002014-05-07T13:56:59.808+01:00Thanks for all this, it was a great help!
I ended ...Thanks for all this, it was a great help!<br />I ended up using (with Excel 2013) the formula<br /><br />=VLOOKUP(F7,typeid!B:C,2,FALSE)<br /><br />where cell F7 has the name of the item.<br />and since I only need one bit of data, say the selling price in Jita, my eve-central formula is<br />=FILTERXML(WEBSERVICE("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid="&G7),"/evec_api/marketstat/type/sell/min")<br /><br />Hartley Pattersonhttps://www.blogger.com/profile/02502699889108493831noreply@blogger.comtag:blogger.com,1999:blog-1597676555600759067.post-34708878474547523732013-12-25T15:07:10.184+00:002013-12-25T15:07:10.184+00:00You need to unzip the file first. I prefer 7-zip. ...You need to unzip the file first. I prefer 7-zip. Google it...it's free. Once it's unzipped it will be a standard excel file.Guerrothttps://www.blogger.com/profile/06895168382521145501noreply@blogger.comtag:blogger.com,1999:blog-1597676555600759067.post-82467794486523596612013-11-26T00:01:24.640+00:002013-11-26T00:01:24.640+00:00Hi - Love your blog
Have you got a source of the ...Hi - Love your blog<br /><br />Have you got a source of the file that Steve put up with the type id's that isn't a bz2 file<br /><br />http://www.fuzzwork.co.uk/dump/odyssey-1.0-89097/invTypes.xls.bz2<br /><br />having issues trying to extract the excel spreadsheetTempesthttps://www.blogger.com/profile/00381317184864425717noreply@blogger.com