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.
 

Volume API Help

First post
Author
Previous Topic Next Topic
Blademaster Hattori
Ruby Code
#1 - 2013-08-30 17:19:26 UTC  |  Edited by: Blademaster Hattori
Evening,

I'm in the middle of creating my market station flipping spreadsheet but I have hit a bottleneck and I need some help with.

Basically i'm calling the following API which imports the best sell price in Jita for item x

Quote:
=ImportXML("http://api.eve-central.com/api/marketstat?usesystem=30002659&typeid="&JOIN("&typeid=",$B4:$B39), "/evec_api/marketstat/type/sell/min")


What i'm trying to do is add a second column that would tell me how many sell orders there are for that max price. I have tried

Quote:
=ImportXML("http://api.eve-central.com/api/marketstat?usesystem=30002659&typeid="&JOIN("&typeid=",$B4:$B39), "/evec_api/marketstat/type/sell/volume")


But this gives me the total of all the sell orders and not just the one at the max price.

I then tried:

Quote:
=ImportXML("http://api.eve-central.com/api/marketstat?usesystem=30002659&typeid="&JOIN("&typeid=",$B4:$B39), "/evec_api/marketstat/type/sell/min/volume")


and

Quote:
=ImportXML("http://api.eve-central.com/api/marketstat?usesystem=30002659&typeid="&JOIN("&typeid=",$B4:$B39), "/evec_api/marketstat/type/sell/volume/min")


But neither of these seem to be supported API's

I have search for a few days now and not found what I need. There has to be way as Eve Mentat can do it. I have this tool but I'm a big fan of having everything on one screen and not have to keep selecting each item.

Below is an example of my profit trader

Profit Trader

Thank you for your time

PI_Trader - Creating, designing and managing your PI sales market tool
Hagen Stein
Biotronics Inc.
#2 - 2013-09-07 08:10:32 UTC
For technical/programming questions, the Tech Lab Forum is the better place.

FYI: I reported this thread to be moved there, because a) I'm pretty sure you'll find an answer there, if you browse that forum and b) as that's the place were the 3rd party devs hang out, your chance of getting an answer is higher.
Wafflehead
Garoun Investment Bank
Gallente Federation
#3 - 2013-09-07 16:36:46 UTC  |  Edited by: Wafflehead
http://eve-marketdata.com/developers/item_history2.php

Isn't this what you are looking for?

//Edit only for regions.
ISD Ezwal
ISD Community Communications Liaisons
ISD Alliance
#4 - 2013-09-07 23:43:23 UTC
This thread has been moved to EVE Technology Lab.

ISD Ezwal Community Communication Liaisons (CCLs)
Muscaat
EVE Markets
#5 - 2013-09-10 11:22:29 UTC
The EVE Central marketstat API just gives aggregate statistics. If you want individual orders, you'll need to look at the quicklook API instead. See http://dev.eve-central.com/evec-api/start for documentation.