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.
 

Need help to link TypeID to Jita Prices
Author
Previous Topic Next Topic
Restodruid
wizards never die
#1 - 2014-04-23 15:14:26 UTC  |  Edited by: Restodruid
I just started today making my own spreadsheet. I use it to keep track of loot that I want to link to Jita prices.

It looks like this
Loot:..........................TypeID....Jita Price
Stasis Webifier II.....527.........1000000

I have been able to link the Loot with TypeID, but not TypeID with Jita Price. The problem is I need to make an url everything for every item, get the derived url and past it there. I want it to look up the price without copy/pasting the new derived url every time.

Is this possible, can anyone guide me to the right direction if so?

Thanks in advance
Restodruid
wizards never die
#2 - 2014-04-23 15:31:01 UTC
Just found out how:

The cell for Jita Price you put this in

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

So you just change B7 to your TypeID cell of the loot :)