Keep track of Bitcoin price in Excel and Google Sheets

[finsheet]

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.

[MichaelXras]

Thanks for sharing! I’m always looking for ways to streamline my crypto tracking, and this looks like a great tool to test out.

[RobySul]

Been using Google Sheets to keep track of my crypto stuff, and that Finsheet tool looks interesting. The quick Bitcoin quote function could make things way easier. I’ve been pulling in data manually, which is kind of a pain, so something like =FS_Latest("COINBASE") sounds useful. I’ve taken a few courses at www.myexcelonline.com in the past to brush up on Excel, and honestly, they really helped me set up some solid tracking sheets. It’d be cool to combine those skills with Finsheet for more detailed analysis, especially with the 1-minute price data function.

Edited October 7 by RobySul

[DediRock]

I think it's a must try! Thanks for the info!