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