More actions
m →Google Sheets Method: - corrected TypeID for "Iron Charge S" in example URLs from 216 to 215 (see https://www.fuzzwork.co.uk/api/typeid.php?typename=Iron%20Charge%20S) |
m Functional Google Sheets Market Data Spreadsheet no longer works. Deleted. |
||
| Line 58: | Line 58: | ||
* <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?",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?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. | * =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. | ||
[[Category:Guides]] | [[Category:Guides]] | ||
[[Category:Trade]] | [[Category:Trade]] | ||