I’m trying to build a spreadsheet to give me fast access to market values. I’m using the following “=importxml(“https://api.evemarketer.com/ec/marketstat?typeid=35&usesystem=30000142”, “//sell/min”)” to look up the value of pyerite (type id is 35) in Jita (system id 30000142). I want to do the same thing, but by referring to a cell (D2) in the spreadsheet instead of specifying the number 35 for the typeid. Anyone know what the correct syntax is for that?
I figured it out, sharing in case someone else has the same question:
=IMPORTXML(“https://api.evemarketer.com/ec/marketstat?usesystem=“&30000142&”&typeid=“&D2,”//sell/min”)
Evemarketer has had some stability problems, especially with the API. You may also want to consider Fuzzwork Market Data
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.