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