Forex Zone - Forex Forum

Keep track of Bitcoin price in Excel and Google Sheets

Discussion started on General Cryptocurrency Discussion

  • Starter
  • Posts: 2
  • Points: 504
  • Likes Received: 0
  • Reputation: +0/-0
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.


Linkback: https://www.forex.zone/general-cryptocurrency-discussion/32/keep-track-of-bitcoin-price-in-excel-and-google-sheets/3741/
#1 - April 26, 2022, 12:49:46 PM

Members:

0 Members and 1 Guest are viewing this topic.