Skip to content

Instantly share code, notes, and snippets.

@hesido
hesido / coingecko.js
Last active November 13, 2023 23:15
Coingecko Add On for Google Spreadsheets
/**
* Returns Market Value From Coingecko api
* Function accepts ranges as well, please use it to reduce server lookups, so it fetches data only once.
* Update: 17.02.2020
*
* @param {string} symbol pair (required)
* @param {string} Default Value Missing Data (optional)
* @return {number} ticker price
* @customfunction
**/