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

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

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

importing eve-central market data to google spreadsheets
Author
Previous Topic Next Topic
Gilbaron
The Scope
Gallente Federation
#1 - 2012-03-27 13:16:43 UTC
hey,

im making a spreadsheet for my fuel block production and i thought it would be pretty cool to have the Jita Median for each fuel block listed in the spreadsheet itself

can someone tell me how to do that ? or at least point me in the right direction

would be awesome

thanks !
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2012-03-27 13:39:14 UTC
http://eve-central.com/home/develop.html#xml

IDs:
4247 - Amar
4051- Caldari
4312 - Gallente
4246 - Minmatar


=importxml("http://api.eve-central.com/api/marketstat?typeid=4247&regionlimit=10000002","//sell/median")

Easiest to keep it in 4 separate loads.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Gilbaron
The Scope
Gallente Federation
#3 - 2012-03-27 13:44:57 UTC
thank you very very much, works like a charm

next step EvE API (can it be done ?)
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2012-03-27 13:50:50 UTC
Yup.

Same method, really. I'd suggest doing a little reading up on how xpath works, for pulling out the bits you want.

It's troublesome though, as you'll be wanting attributes. Excel really handles this better.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Cliftonberg
Deep Core Mining Inc.
Caldari State
#5 - 2012-03-28 17:34:01 UTC
Gilbaron wrote:
thank you very very much, works like a charm

next step EvE API (can it be done ?)


What are you trying to do with the eve api? Not sure I quite understand.
Gilbaron
The Scope
Gallente Federation
#6 - 2012-03-28 18:32:00 UTC
Cliftonberg wrote:
Gilbaron wrote:
thank you very very much, works like a charm

next step EvE API (can it be done ?)


What are you trying to do with the eve api? Not sure I quite understand.


query eve api for amount of fuel blocks

query eve-central api for approximate prices

calculate how rich i am/could be