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.
 

Parsing Data From EVE API: Market Volume Data
Author
Previous Topic Next Topic
Liara Zhang
Perkone
Caldari State
#1 - 2016-06-13 20:05:18 UTC
Hey everybody,

I currently have a Tradesheet that allows me to look at the minimum and maximum buy and sell prices, respectively, in many of EVE's largest Empire space trade hubs.

It utilizes an API call:
http://api.eve-central.com/api/marketstat?typeid=
As well as the typeid for each system - for example, 30000142 for Jita.

The spreadsheet is based in Excel 2013 and I used the formula:
=FILTERXML(WEBSERVICE(CONCATENATE(Sell_Swap & TypeID&B3)),"//sell/min")
as well as the formula:
=FILTERXML(WEBSERVICE(CONCATENATE(Buy_Swap & TypeID&B3)),"//buy/max")
in conjunction with a drop-down list that ensures the Tradesheet is pulling data from the correct system API in order to generate a list of gross margin data, the taxes I will have to pay, my net margins, and finally, my net percentage margins.

I want one other piece of information though - the volume of items being traded in the system. I believe this data exists - I've seen that the EVE central market website has data on the volumes of items traded.

If I can combine my net percentage data with volume data, I'll be able to pinpoint the best items to invest in for maximum profits in the shortest amounts of time.

Does anyone have any idea what I'd need to replace "//sell/min" with in order to generate a new swap column for my Tradesheet?
Kelly Traklamor
Dayra Industries
#2 - 2016-06-16 00:43:37 UTC  |  Edited by: Kelly Traklamor
If I understand the question correctly and understand the formula/process you are utilizing. I believe "//sell/volume", "//buy/volume" and/or "//all/volume" may be the correct replacements.

Unfortunately without seeing the way your spreadsheet/formulas interact nor seeing exactly what information /volume is feeding because EveCentral is apparently down atm I can't confirm the best one for you to use nor that it feeds you the exact information that you seek. But hopefully it does and it was helpful =)

At any rate, your post at least gave me a few new ideas to update my spreadsheet with.
Zad Murrard
Frozen Dawn Inc
Frozen Dawn Alliance
#3 - 2016-06-16 08:43:44 UTC  |  Edited by: Zad Murrard
Eve central does not provide daily sales amount unfortunately, it provides the total number of items being sold atm.
This is probably not what you're looking for.

There was a post in the forum some months ago where I described how you can get number of items sold/day using gdocs and
http://eve-marketdata.com/. The site API is very often unreliable & broken. But perhaps you can fubd the post and do something similar in excel and make some use of the site.
Mark 117
Caldari Provisions
Caldari State
#4 - 2016-06-17 15:55:53 UTC
Zad Murrard wrote:
Eve central does not provide daily sales amount unfortunately, it provides the total number of items being sold atm.
This is probably not what you're looking for.


Data, lots of data.

The Citadel, Trit
https://crest-tq.eveonline.com/market/10000002/history/?type=https://crest-tq.eveonline.com/inventory/types/34/