These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Science & Industry

 
  • Topic is locked indefinitely.
 

import XML to excel help needed
Author
Previous Topic Next Topic
Digital Messiah
Center for Advanced Studies
Gallente Federation
#1 - 2013-05-24 21:32:47 UTC
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?

Something clever
Rengerel en Distel
#2 - 2013-05-24 23:15:35 UTC
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
Center for Advanced Studies
Gallente Federation
#3 - 2013-05-25 01:00:10 UTC
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.

Something clever
Rengerel en Distel
#4 - 2013-05-25 02:14:51 UTC
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
Vote Steve Ronuken for CSM
#5 - 2013-05-25 09:08:12 UTC
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

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Digital Messiah
Center for Advanced Studies
Gallente Federation
#6 - 2013-05-25 12:08:18 UTC
Rengerel en Distel wrote:
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.



I got it to work flawlessly, it pulls all the data completely and made my life and profits much better. Thank you so much.

Something clever