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.
 

Need help with API-Spreadsheet formula.

First post
Author
Previous Topic Next Topic
Bushdoctor Vanderspliff
The Scope
Gallente Federation
#1 - 2016-01-04 12:08:58 UTC
Good day,

I need to import certain market prices into a Google Spreadsheet.
I prefer Excel, but this one has to be done in Google sheets.

This is the (incorrect) formula that I'm using: 

=importXML("http://api.eve-central.com/api/marketstat?typeid=20&typeid=17453&typeid=17452&typeid=1227&typeid=17867&typeid=17868&station_ids=60003760","//buy/percentile")


When I paste this formula in a cell, it will import the prices for the requested items and drop those prices
in the same column where the formula was pasted. That part seems to work, however I noticed that my
added part for the stationID does not work. Can anybody spot the mistake and/or have a solution for that?

Also, I'm not sure about the last part 'percentile'. I believe it's an average, but what I need is the highest,
most recent buy price, in that particular station (in this case Jita). Any advice on that part maybe?

Thanks for looking into this.
Greets,
Doc.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2016-01-04 13:53:52 UTC
Percentile is the average price if you do a simulated buy/sell of 5% of the market volume. Helps eliminate outliers.

https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs may be of interest, for an alternate, and more stable way to get data from eve central. Doesn't currently work with just stations, but that should be simple enough to add in.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Zad Murrard
Frozen Dawn Inc
Frozen Dawn Alliance
#3 - 2016-01-04 14:27:18 UTC
https://eve-central.com/home/develop.html does not list station_ids as an allowed parameter.

Of interest may be

regionlimit Restrict statistics to a region. Can be specified more than once.
usesystem Restrict statistics to a system.
Bushdoctor Vanderspliff
The Scope
Gallente Federation
#4 - 2016-01-04 20:15:42 UTC  |  Edited by: Bushdoctor Vanderspliff
Steve, thank you for your reply.
I'm afraid that working with scripts isn't for me yet.
Perhaps I'll get that skill book soon.

Zad, thank you for pointing out that the StationID parameter doesn't work for Eve-Central api's.
Your suggestion for UseSystem could be my solution. I'm going to give that a try.

What should I replace 'percentile' with? Does 'max' give me the top listed buy price?
Zad Murrard
Frozen Dawn Inc
Frozen Dawn Alliance
#5 - 2016-01-05 06:55:54 UTC
"//buy/max" should work