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

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

Market Discussions

 
  • Topic is locked indefinitely.
 

How do you pull an items volume from Eve Centrals API?
Author
Previous Topic Next Topic
Rakiris Maloris
Caldari Provisions
Caldari State
#1 - 2015-06-28 05:05:29 UTC
So i'm trying to pull a items volume from Eve Central, how do I do this?
0000000000ZERO0000000000
Zero Zentharis
#2 - 2015-06-28 05:22:02 UTC
Assuming you are using marketstat: volume is the first value returned.
Rakiris Maloris
Caldari Provisions
Caldari State
#3 - 2015-06-28 15:55:09 UTC
0000000000ZERO0000000000 wrote:
Assuming you are using marketstat: volume is the first value returned.


So if I want to pull the volume of i'll put something like =importxml(CONCATENATE(TypeID!B:C,B3))

The typeid b:c is another sheet I have with all the typeid's on it.
Reizwasche
The Scope
Gallente Federation
#4 - 2015-06-28 23:35:36 UTC
Rakiris Maloris wrote:
0000000000ZERO0000000000 wrote:
Assuming you are using marketstat: volume is the first value returned.


So if I want to pull the volume of i'll put something like =importxml(CONCATENATE(TypeID!B:C,B3))

The typeid b:c is another sheet I have with all the typeid's on it.


Just use the fuzzworks script, you can only get 50 importXMLs on a google doc, but you can get a huge number of items in one pull with a script
0000000000ZERO0000000000
Zero Zentharis
#5 - 2015-06-28 23:41:13 UTC
Yeah this^ way might be easier since you will probably want a lot of other information as well
Soldarius
Dreddit
Test Alliance Please Ignore
#6 - 2015-06-29 15:04:22 UTC
Reizwasche wrote:
Rakiris Maloris wrote:
0000000000ZERO0000000000 wrote:
Assuming you are using marketstat: volume is the first value returned.


So if I want to pull the volume of i'll put something like =importxml(CONCATENATE(TypeID!B:C,B3))

The typeid b:c is another sheet I have with all the typeid's on it.


Just use the fuzzworks script, you can only get 50 importXMLs on a google doc, but you can get a huge number of items in one pull with a script


Use the new google sheets. the 50 limit has been removed.

And that import call quoted above is bad it won't work. I recommend Steve's script. Its good. But to make it quick and if you only need to pull one item, importXML works most of the time. But it tends to break regularly if you use it for importing a large number of items.

The below code will pull the universal aggregate data for one item type, which is listed in cell B15. Since this is universe-wide, it will include the outliers in far-flung nulsec in the max and min values. The returned data is an array of values 7 columns by 3 rows.
=importXML("http://api.eve-central.com/api/marketstat?typeid="&B15,"//type/*")


You can pull just the volume. But I recommend you pull the entire data set, rather than just the volume. Then just reference the data as required from another sheet. This will save you more effort later on when you want more than volume. (You will, trust me.)


http://youtu.be/YVkUvmDQ3HY
Rakiris Maloris
Caldari Provisions
Caldari State
#7 - 2015-06-30 21:09:53 UTC
Soldarius wrote:
Reizwasche wrote:
Rakiris Maloris wrote:
0000000000ZERO0000000000 wrote:
Assuming you are using marketstat: volume is the first value returned.


So if I want to pull the volume of i'll put something like =importxml(CONCATENATE(TypeID!B:C,B3))

The typeid b:c is another sheet I have with all the typeid's on it.


Just use the fuzzworks script, you can only get 50 importXMLs on a google doc, but you can get a huge number of items in one pull with a script


Use the new google sheets. the 50 limit has been removed.

And that import call quoted above is bad it won't work. I recommend Steve's script. Its good. But to make it quick and if you only need to pull one item, importXML works most of the time. But it tends to break regularly if you use it for importing a large number of items.

The below code will pull the universal aggregate data for one item type, which is listed in cell B15. Since this is universe-wide, it will include the outliers in far-flung nulsec in the max and min values. The returned data is an array of values 7 columns by 3 rows.
=importXML("http://api.eve-central.com/api/marketstat?typeid="&B15,"//type/*")


You can pull just the volume. But I recommend you pull the entire data set, rather than just the volume. Then just reference the data as required from another sheet. This will save you more effort later on when you want more than volume. (You will, trust me.)




The new Google Sheets?