main.gs

/**
 * Binance to Google Sheets!
 * Diego Manuel - diegomanuel@gmail.com
 * https://github.com/diegomanuel/binance-to-google-sheets
 */


/**
 * Main formula wrapper to call supported operations.
 *
 * @param operation The operation tag to call.
 * @param range_or_cell A range of cells or a single cell or a literal/string value.
 * @param opts Additional options like the symbol/ticker to match against or an option list like "ticker: USDT, headers: false" (depending the called operation).
 * @param force_refresh_cell Cells are automatically refreshed, but you can force it by passing any changing value here.
 * @return Depends on the operation given.
 * @customfunction
 */
function BINANCE(operation, range_or_cell, opts, force_refresh_cell) {
  const options = BinUtils().parseOptions(opts);

  if (DEBUG) {
    Logger.log("OP: "+operation);
    Logger.log("RANGE: "+JSON.stringify(range_or_cell));
    Logger.log("OPTS: "+JSON.stringify(opts));
    Logger.log("OPTIONS: "+JSON.stringify(options));
  }

  if (operation == "version") {
    return VERSION;
  }
  if (BinDoLastUpdate().is(operation)) {
    return BinDoLastUpdate().run();
  }
  if (BinDoCurrentPrices().is(operation)) {
    return BinDoCurrentPrices().run(range_or_cell, options);
  }
  if (BinDoHistoricalData().is(operation)) {
    return BinDoHistoricalData().run(range_or_cell, options);
  }
  if (BinDo24hStats().is(operation)) {
    return BinDo24hStats().run(range_or_cell, options);
  }
  if (BinDoAccountInfo().is(operation)) {
    return BinDoAccountInfo().run(range_or_cell, options);
  }
  if (BinDoOrdersOpen().is(operation)) {
    return BinDoOrdersOpen().run(range_or_cell, options);
  }
  if (BinDoOrdersDone().is(operation)) {
    return BinDoOrdersDone().run(range_or_cell, options);
  }
  if (BinDoOrdersTable().is(operation)) {
    return BinDoOrdersTable().run(range_or_cell, options);
  }
  
  throw new Error("Unsupported operation given: '"+operation+"'");
}

/**
 * This is just a dummy function, use `BINANCE` instead!
 * It only serves to help to [R]efresh (the "R" from there) spreadsheet formulas
 * by switching between `BINANCE` and `BINANCER`.
 * 
 * @customfunction
 */
function BINANCER(operation, range_or_cell, opts, force_refresh_cell) {
  return BINANCE(operation, range_or_cell, opts, force_refresh_cell);
}