Useful cryptocurrency tools (like getting the current price, of Bitcoin, Ethereum) for Google Spreadsheets.
This is the utility script used in the Cryptocurrency Financial Spreadsheet:
https://docs.google.com/spreadsheets/d/1lnE260-F7TSs6onegSVYgRAP0ZZeuUy2YsfO2Ww_eJY/edit?usp=sharing
The easiest way to use it is to make a copy of the spreadsheet above.
Add script in Tools > Script editor. Then to use, simply add =getCoinPrice("SYMBOL") in a row. For example, Bitcoin would be
=getCoinPrice("BTC")
Ethereum would be
=getCoinPrice("ETH")
Litecoin would be
=getCoinPrice("LTC")
Almost every crypto currency should work because data is fetched from coinbin.org API, which has many and updates pretty regularly. Data is cached for 25 minutes.
Questions or comments email [email protected] or @bradjasper
Happy trading—be safe out there!