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.
 

EVE + Google Doc Question
Author
Previous Topic Next Topic
DeepSpaceBart
Content Vacant
#1 - 2012-09-14 12:45:21 UTC



I'm trying to make my API Pulled Doc run better; right now I pull down the data using the following.

=importXml("http://api.eve-central.com/api/marketstat?&typeid=24698&typeid=2410&typeid=5975&typeid=19814&typeid=2281&typeid=8529&typeid=3841&typeid=2301&typeid=1447&typeid=22291&typeid=2048&typeid=31790&typeid=31372&typeid=27413&typeid=207&typeid=206&typeid=208&typeid=23707&usesystem=30000142","//sell/min")

it works, but I enter all the Eve Central Codes into Column "B" and the Code itself into "C" how do I set it up so I am not required to enter each Item type myself into the code. I want the Document to add them into the equation automatically.


Thanks
TheSkeptic
Federal Navy Academy
Gallente Federation
#2 - 2012-09-17 08:06:28 UTC
Not 100% sure I understand what you mean.

You're saying in B you have the itemID's? so like B1, B2, B3 etc are all itemIDs? then in C1 you put the code you pasted and that populated the list next to each of B1, B2, B3 etc?

try something like this in C1:

=ImportXML("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid="&JOIN("&typeid=",$B1:$B100), "//sell/min")

It should create all the &join= references pulling the values from B for you so they're hard coded in the api string.

...

Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2012-09-17 11:28:17 UTC
I'd suggest using //sell/percentile if you're using this for getting prices for materials.

It's the price you'd pay, per unit, if you bought the lowest 5% of the volume on the market. It edges out the really cheap, but low volume, orders, and ignores the high ones.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter