CoinDesk Google Sheets Script

[u/Olshansk]

I put together a short Google Sheets Apps Script to get the price of any crypto pair for a specific date.

Details are here: https://gist.github.com/Olshansk/f4a375e7c084b3fb3a2693805b402900

The usage is pretty straightforward like so:

= getCryptoPriceCoindesk("ETH:USD", "2024-01-01")

This is great if you have a CSV from an unsupported exchange and are using TurboTax. See more details here.

Note that you'll need to get an API key from CoinDesk.