Jump to content

Keep track of Bitcoin price in Excel and Google Sheets


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 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.

Link to comment
Share on other sites

  • 2 years later...

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 by RobySul
Link to comment
Share on other sites

  • 3 months later...

For me, that Finsheet tool sounds pretty handy. The =FS_Latest function for getting Bitcoin prices directly into a sheet could save a lot of time. Same with the 1-minute price data function—it’s perfect if you’re into detailed analysis or backtesting.
I’ve messed around with Excel courses before, and learning a few tricks really helped me set up better tracking sheets. If you’re looking to level up your skills, Microsoft Excel Books is worth checking out.

 

Edited by Ronastiny
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
  • 👍 Join TopGold.Forum Now

    Join The Most Welcoming Crypto & Trading Community

    We are over 25,000 members and 700 companies on our journey to strike GOLD.💰

    👩 Want to make money online? 
    💼 Represent a company? 
×
×
  • Create New...