Jump to content

Keep track of Bitcoin price in Excel and Google Sheets


 Share

Recommended Posts

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 Ripple, use this one simple function:

=FS_Latest("COINBASE:XRP-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 Ripple from the beginning of today (04/25/2022) until now:

=FS_CryptoCandles("COINBASE:XRP-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.

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Quote

The website is completely free right now since we just launched

Which suggests a payment model later once you have a user base. Seems odd considering I can easily run api queries from excel on countless free data sources already, eg. coinmarketcap, binance, coingecko, etc. and my queries are a single line too. Not really sure how you're adding value here - maybe I'm missing something ???

Link to comment
Share on other sites

  • 2 weeks later...

There is a way to use IMPORTXML function. This method is more flexible because you can choose a site or exchange from which you will transfer cryptocurrency quotes to Google Table with automatic updates. The second advantage of this option - there are no restrictions in terms of available tokens because not all of them are represented by Google. I personally took the Coinmarketcap website as a source of information about cryptocurrency rates. It's a reputable site. There is also a resource that allows you to export data not only on the rates of cryptocurrencies. If interested, you can go here.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.