API access to market data: Difference between revisions

Line 56:

* <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>

* =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.

@@ Line 56: / Line 56: @@
 * <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>
+* =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.