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.
 

Trade volume from eve-marketdata into Google Docs

Author
Herr Nerdstrom
Perkone
Caldari State
#1 - 2014-01-01 13:20:05 UTC
This is more of an XML question I suppose, but I have been stumped on this for a while now. I am trying to obtain the volume traded information for mutliple items from a single region, and can't figure out how to process the returned data in Google Docs. Here is the URL for testing:

http://api.eve-marketdata.com/api/item_history2.xml?char_name=Unknown%20&region_ids=10000035&type_ids=23057,34

As you can see it returns various volume data for the two items, but in no apparent order, probably due to spotty data availability. I would like to get the average daily trade volume over the returned data (30 days) for each item.

Any suggestions how to do this? I would happy to do it in a separate Google sheet or via the ImportXML call, whichever makes more sense (or something else).

Thanks.
Wafflehead
Garoun Investment Bank
Gallente Federation
#2 - 2014-01-01 17:18:41 UTC  |  Edited by: Wafflehead
Quote:
but in no apparent order


It is in date order?.

Have you tried the website itself?.
http://eve-marketdata.com/developers/google_docs.php
Herr Nerdstrom
Perkone
Caldari State
#3 - 2014-01-02 01:17:40 UTC
Yes, the results are in date order, but not every item is reported for each day, so it's somewhat inconsistent. The docs on eve-marketdata doesn't really cover this, as it's more application level rather than API.

http://api.eve-marketdata.com/api/item_history2.xml?char_name=Unknown%20&region_ids=10000035&type_ids=23057,34,645
Wafflehead
Garoun Investment Bank
Gallente Federation
#4 - 2014-01-02 17:56:00 UTC
Herr Nerdstrom wrote:
Yes, the results are in date order, but not every item is reported for each day, so it's somewhat inconsistent. The docs on eve-marketdata doesn't really cover this, as it's more application level rather than API.

http://api.eve-marketdata.com/api/item_history2.xml?char_name=Unknown%20&region_ids=10000035&type_ids=23057,34,645


I use the eve-marketdata with no problems, however I do not use spreadsheets or google docs. So you need to find someone thats good with google docs :).
Herr Nerdstrom
Perkone
Caldari State
#5 - 2014-01-02 22:28:57 UTC
After two days of struggling, it turns out, as usual, that the solution was staring me in the face. Since I could only extract a single attribute per XML data item, I couldn't get both the typeID and the volume at the same time to disambiguate the results. So I instead just made two XML calls: one for the typeID, one for the volume. From there, it was just a matter of some spreadsheet matching functions to average the volume for each typeID for the final result.

Thanks so much for your help!