RE: How To Use Blockfolio App Without Risking Losing Your Money

You are viewing a single comment's thread from:

How To Use Blockfolio App Without Risking Losing Your Money

in bitcoin •  7 years ago  (edited)

In case you didn't know, you can now use Google Sheets formula to reflect the current crypto prices.
Here is a sample:
=CRYPTOFINANCE("BTCUSD","price").
You can also replace "price" with "change", "marketcap", "volume", "total_supply", and I think a couple other options as well.

Addendum: Also, on Google Sheets, under the "MENU / ADD-ONS" you need to activate "CRYPTOFINANCE" in order to use in Google Sheets. I think it has to be activated for each individual Sheet that uses "CRYPTOFINANCE" formulas.
Happy Number Crunching!

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Thanks for that Google Sheet tip!

Excellent tip! Thank you!

IMO, Google is the last entity I want knowing I am tracking BTC, ETH, etc.

Why the last? Seems there are way worse companies out there... Plus given how big Google is, I doubt they're interested in your portfolio, even if you had a $1mill worth of coins. I'm not too worried about Google. The information they collect on your everyday moves are way more valuable to them than what coins everyone owns. They're dealing with BILLIONS per day.

That's amazing, had no idea that Google Sheets was so extensible. Thanks for the tip bud!

I would like to recommend "Crypto Rewards" option of a spreadsheet tracker. He has great explanations on his Youtube site and the link for his spread sheet is here: