Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Digital Messiah
Heroic Era
286
|
Posted - 2013.05.24 21:32:00 -
[1] - Quote
I have spent quite a few hours how I can use import xml to get market data from eve central into an excel sheet. I currently use google docs but because of the 50 limit its hurting my ability to see what im comparing. Is there a way to use a import xml like this?
=importXml("http://api.eve-central.com/api/marketstat?&hours=6&typeid=21898&usesystem=30000142&minQ=5000","//buy/max")
where I can get the buy/max or avg being the only data it pulls into a cell like in google docs? Join a Heroic Era today! |
Rengerel en Distel
Amarr Science and Industry
1499
|
Posted - 2013.05.24 23:15:00 -
[2] - Quote
I don't use excel, but you do know in google docs, you can add more than one type to the query, right? What I generally do is have every type of something, like PI, in one query. So instead of needing 80 queries or whatever, it's just one.
https://docs.google.com/spreadsheet/ccc?key=0Ar_YTOcXpvb9dGFIdHJlb0VmYXBORWRrcXFkeHNjcWc#gid=19 is a good example.
With the increase in shiptoasting, the Report timer needs to be shortened.
|
Digital Messiah
Heroic Era
286
|
Posted - 2013.05.25 01:00:00 -
[3] - Quote
I'm not super savory with any form of code or function use. Could you give me a tutorial on how to do this by type id and buy / max. I've put about an hour staring at your link. But I can't make sense of it. Join a Heroic Era today! |
Rengerel en Distel
Amarr Science and Industry
1499
|
Posted - 2013.05.25 02:14:00 -
[4] - Quote
Digital Messiah wrote:I'm not super savory with any form of code or function use. Could you give me a tutorial on how to do this by type id and buy / max. I've put about an hour staring at your link. But I can't make sense of it.
https://docs.google.com/spreadsheet/ccc?key=0Ar0bSABZqzrWdHNVbE1IS3VFUWVJbkxkc09jM0hSNEE&usp=sharing
I don't know if that will make more sense, but hopefully it does.
With the increase in shiptoasting, the Report timer needs to be shortened.
|
Steve Ronuken
Fuzzwork Enterprises
1445
|
Posted - 2013.05.25 09:08:00 -
[5] - Quote
If you're wanting to use Excel, just create the url you want, go to the data tab, and use 'from web'
Stick the url in, import the whole sheet, then use vlookups from where you actually need the data.
It's a far more elegant way to handle it than the way you have to do with goo Steve Ronuken for CSM 9!-á I'm starting early :) Handy tools and an SDE conversion Twitter: @fuzzysteve on Twitter |
Digital Messiah
Heroic Era
287
|
Posted - 2013.05.25 12:08:00 -
[6] - Quote
Rengerel en Distel wrote:
I got it to work flawlessly, it pulls all the data completely and made my life and profits much better. Thank you so much. Join a Heroic Era today! |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |