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 contact@bradjasper.com or @bradjasper
Happy trading—be safe out there!