Bitcoin Forum

If you guys are working on a spreadsheet and didn't have time to check the Bitcoin price on the exchange or other flatform, you can use it in the sheet while you work.

It's just a tutorial, and I just make it easy without a ticker or any tool to check the price.

1. You have open your Google spreadsheet and write the code:

=GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])

For example:


https://i.postimg.cc/K8Dhv4QX/bp1.png

so just simply like that, you can be modified the ticker you want like currency (Euro, GBP, etc), and also the date you want.

let's have fun.

cheers.

Due my work I use Google spreadsheets on the daily basis (and several hours per day) and this way of checking for BTC price seems slower and more complicated than using CMC/Coingecko or simply googling "btc price".

Yes, I agree, each people have a different point of view to see something, For me even if it is more complicated, it's enough simple to check the table price because I bookmark it and I just copy-paste the code. And, the spreadsheet looks like accumulates all prices from the exchange source, so there is an average comparison when the trader wants to calculate sell and buy. If using a spreadsheet, we can also use a filter, day by day, and price to price, so for me, it's enough simply to learn self-taught trading without a special teacher.

This is good however you can check Bitcoin price by a Google search but I understand this can be used to make your own custom portfolio sheet etc.
For that, I would prefer an excellent plugin for Google Sheets - https://cryptosheets.com/

Here is the GIF of it working on Google Sheet -
https://res.cloudinary.com/cryptosheets/image/upload/v1571966039/cryptosheets-docs/excel/functions/exrate-hp-9.gif

You should try this one: Portfolio Performance [Open Source] - Keep track of your Crypto Portfolio! (https://bitcointalk.org/index.php?topic=5381647.msg59003367#msg59003367)

wow this is so cool i could remember back then when i started bounty hunting and airdrops too, i was always going to preev.com (http://preev.com) to check the price of BITCOIN and other few coin that was in the list. i think with this i can actually keep track with some coin without much stress.

This is just an alternative, some people are more comfortable checking it manually on exchange. but it's good if you think this way it to reduce your stress, and make your work easier. I just find if we can check Bitcoin prices using Microsoft 365 subscription also, I don't try it, but when I read the resource, it's easier to use because there are already tools on the data tab,

https://images.squarespace-cdn.com/content/v1/52b5f43ee4b02301e647b446/1609477474972-6GW50STYF6QR4Y0BYDCW/Convert+to+Stock+Data+Type.png?format=1000w

There are already 5 cryptos listed which you can tick differently at the same time.

Bitcoin (BTC)
Ethereum (ETH)
Litecoin (LTC)
Bitcoin Cash (BCH)
Ripple (XRP)

but, I think Google spreadsheet is better because Office 365 doesn't automatically refresh the price data when we want to change a specific interval time.

https://www.thespreadsheetguru.com/blog/cryptocurrency-prices-excel