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

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

Science & Industry

 
  • Topic is locked indefinitely.
 

How to pull order volumes from Eve-Central using ImportXML

First post
Author
Previous Topic Next Topic
Jennifer Anterion
Lowsec Liberty Miners
#1 - 2014-12-28 07:46:15 UTC
So I've gotten the buy and sell prices from orders into a spreadsheet but I still have no idea how many of those items are being sold at that price... I want to know the volume at which that buy/sell order is trying to buy or sell... Would it be something like ImportXML(URL,//volume/buy or sell)? I've had little luck with this in the past but it has occasionally brought up some results... also is there a way in general to find the query? The only reason I know what I know is from youtube videos but I don't know WHY it works. Thank you in advance!
Whalt Thisney
StellarTech Industries
#2 - 2014-12-28 16:46:10 UTC 

=importXML("http://api.eve-central.com/api/marketstat?typeid=34&usesystem=30000142";"/evec_api/marketstat/type/sell/min")


You can specify multiple typeids: typeid=34&typeid=35&typeid=36&usesystem=...
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2014-12-28 18:33:10 UTC
consider using something like https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs

That way, you have a sheet of price data you can refer to, rather than requiring multiple calls to pull them.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Dunamis55
State War Academy
Caldari State
#4 - 2014-12-29 08:26:57 UTC  |  Edited by: Dunamis55
Hey Steve, I've tried to get your code to work to create the price list using the instructions on your blog post, but I have no idea what I'm doing with programming.

Do you have an idiot's guide for how to set up the code to run in Google Docs step by step? Big smile

Edit: Nevermind, got it to work now.

Director, NER Industries

Now Recruiting!
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2014-12-29 11:16:37 UTC
Dunamis55 wrote:
Hey Steve, I've tried to get your code to work to create the price list using the instructions on your blog post, but I have no idea what I'm doing with programming.

Do you have an idiot's guide for how to set up the code to run in Google Docs step by step? Big smile

Edit: Nevermind, got it to work now.


\o/ Smile

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter