ESI market data and cost index for Google sheet

Veritas_Totient · June 29, 2017, 10:23pm

Since I only find a google app script for CREST data, I rewrite for supporting ESI and caching the data.

gist.github.com

https://gist.github.com/NomadThanatos/01e4fa356cf924cfbad4488cb44958cb

main.gs

function test() {
  Logger.log(getBuyPrice(34, 10000002));
  Logger.log(getSellPrice(34, 10000002, 60003760));
  Logger.log(getPrice(34, "adjusted_price"));
  Logger.log(getCostIndex(30000142, "invention"));
}

function getCostIndex(systemId, costType) {
  url = "https://esi.tech.ccp.is/latest/industry/systems/";
  result = fetchESI(url);

This file has been truncated. show original

Topic		Replies	Views
Google Sheet by Crest Third Party Developers	5	769	August 8, 2018
[GCES] Google CREST/ESI Script 12 series : Now with 100% more ESI errors Third Party Developers	7	1825	May 17, 2018
Market data Market Discussions	3	720	April 13, 2018
ESI for Citadel orders in Google Sheets Science & Industry	5	1272	May 19, 2019
Market Sell Price Third Party Developers	5	1681	August 23, 2018

ESI market data and cost index for Google sheet

Related topics