Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
TheBlueMonkey
Don't Be a Menace That Red Alliance
380
|
Posted - 2013.02.10 13:59:00 -
[1] - Quote
I'm trying to setup a spreadsheet than can pull market data from eve central.
I managed to work out (google found me) how to import single items into google docs with =importxml("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid=16633","/evec_api/marketstat/type/buy/max")
etc
The only trouble is this limits me to 50 items per sheet.
I found this old forum post http://community.eveonline.com/ingameboard.asp?a=topic&threadID=1190856
and followed it through but when I run the macro it sits there and then does nothing.
I've found multiple other posts that either contain spreadsheets that no longer work or contain locked ones that hide pages etc protecting their magic.
So, Is it possible to have a single sheet that imports all the market data for best buy\best sell in a jita and then lets me work from there?
and how would I go about doing that? Help or pointers in the right direction would be hugely apprecieated |
TheBlueMonkey
Don't Be a Menace That Red Alliance
380
|
Posted - 2013.02.10 14:31:00 -
[2] - Quote
and there in is the miracle of posting on a forum as 30 seconds after I hit post I find
https://forums.eveonline.com/default.aspx?g=posts&m=543322#post543322 |
TheBlueMonkey
Don't Be a Menace That Red Alliance
380
|
Posted - 2013.02.10 15:29:00 -
[3] - Quote
Actually, scratch that, I still don't quite get it
If I use =ImportXML("http://eve-marketdata.com/api/item_prices_jita.xml?type_ids="&JOIN(",",A2:A15), "/eve/price")
It steps through each of the typeid's in A2 to A15 and gives a number but it's out.
If I use =ImportXML("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid="&JOIN("&type id=",$A2:$A15), "/evec_api/marketstat/type/sell/min")
It gives me the correct min sell but doesn't step through and do the same for cells A3 to A15
I'm guessing the numbers being out is a difference between eve-marketdata.com and eve-central.com
Eve central has always been more accurate so I'd love to know how to do the first import but to EC instead of EMD
Is that possible? How? |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |