Keep track of Bitcoin price in Excel and Google Sheets
-
If you use spreadsheets (Excel or Google Sheets) to manage your crypto portfolio, do check out Finsheet (finsheet.io), a website my friends and I started recently. To get latest quote of Bitcoin, use this one simple function:
=FS_Latest("COINBASE:BTC-USD")
If you are a trader that needs intra-day data to do technical analysis or backtesting, this function will give you 1-minute price of Bitcoin from the beginning of today (04/25/2022) until now:
=FS_CryptoCandles("COINBASE:BTC-USD", "1", "04/25/2022")
The website is completely free right now since we just launched. Really appreciate if you guys can check it out and let me know any feedback you may have. Thanks a lot.