API access to market data: Difference between revisions

Line 54:

* <nowiki>=importxml("https://api.evemarketer.com/ec/marketstat?typeid=216", "//buy/median") Median buy price for Iron Charge S </nowiki>

* <nowiki>=importxml("https://api.evemarketer.com/ec/marketstat?typeid=216&usesystem=30000142]", "//sell/min") Minimum sell price for Iron Charge S in Jita </nowiki>

* <nowiki>=importxml("https://api.evemarketer.com/ec/marketstat?typeid=216&usesystem=30000142", "//sell/min") Minimum sell price for Iron Charge S in Jita </nowiki>

* <nowiki>=importxml(CONCATENATE("https://api.evemarketer.com/ec/marketstat?typeid=", A1)), "//sell/volume") Volume of sell orders for the typeid in cell A1</nowiki>

* <nowiki>=importxml(CONCATENATE("https://api.evemarketer.com/ec/marketstat?",typeid&JOIN(typeid,$B2:B201)), "//sell/median") Median sell price for each typeid provided in cells B2 through B201. Remember that the API limits you to 200 items per call.</nowiki>

* <nowiki>=importxml(CONCATENATE("https://api.evemarketer.com/ec/marketstat?usesystem=30000142","&typeid="&JOIN("&typeid=",$B2:B201)), "//sell/median") Same as above except looking at Jita specifically and if you aren't using the named variables referenced in the Market Data Spreadsheet linked below.

== Functional Google Sheets Market Data Spreadsheet ==

@@ Line 54: / Line 54: @@
 * <nowiki>=importxml("https://api.evemarketer.com/ec/marketstat?typeid=216", "//buy/median") Median buy price for Iron Charge S </nowiki>
-* <nowiki>=importxml("https://api.evemarketer.com/ec/marketstat?typeid=216&usesystem=30000142]", "//sell/min") Minimum sell price for Iron Charge S in Jita </nowiki>
+* <nowiki>=importxml("https://api.evemarketer.com/ec/marketstat?typeid=216&usesystem=30000142", "//sell/min") Minimum sell price for Iron Charge S in Jita </nowiki>
 * <nowiki>=importxml(CONCATENATE("https://api.evemarketer.com/ec/marketstat?typeid=", A1)), "//sell/volume") Volume of sell orders for the typeid in cell A1</nowiki>
 * <nowiki>=importxml(CONCATENATE("https://api.evemarketer.com/ec/marketstat?",typeid&JOIN(typeid,$B2:B201)), "//sell/median") Median sell price for each typeid provided in cells B2 through B201. Remember that the API limits you to 200 items per call.</nowiki>
+* <nowiki>=importxml(CONCATENATE("https://api.evemarketer.com/ec/marketstat?usesystem=30000142","&typeid="&JOIN("&typeid=",$B2:B201)), "//sell/median") Same as above except looking at Jita specifically and if you aren't using the named variables referenced in the Market Data Spreadsheet linked below.
 == Functional Google Sheets Market Data Spreadsheet ==