Bitcoin Forum
April 28, 2024, 02:10:21 PM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Keep track of Bitcoin price in Excel and Google Sheets  (Read 139 times)
noidaubachu (OP)
Newbie
*
Offline Offline

Activity: 1
Merit: 0


View Profile WWW
April 26, 2022, 02:46:05 PM
 #1

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
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!