[Tutorial] How to Check Bitcoin Price using Google Speadsheet.

Sarah Azhari

hero member

Activity: 868

Merit: 737

Quote from: Timmzzy on June 08, 2023, 12:10:14 PM

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

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

Timmzzy

member

Activity: 785

Merit: 34

SOL.BIOKRIPT.COM

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

dzungmobile

sr. member

Activity: 854

Merit: 424

I stand with Ukraine!

You should try this one: Portfolio Performance [Open Source] - Keep track of your Crypto Portfolio!

ImThour

copper member

Activity: 1470

Merit: 1609

Bitcoin Bottom was at $15.4k

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 -

Sarah Azhari

hero member

Activity: 868

Merit: 737

Quote from: Rikafip on May 01, 2023, 01:28:04 AM

Quote from: Sarah Azhari on May 01, 2023, 12:02:51 AM

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.

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.

Rikafip

legendary

Activity: 1722

Merit: 5937

Quote from: Sarah Azhari on May 01, 2023, 12:02:51 AM

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.

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

Sarah Azhari

hero member

Activity: 868

Merit: 737

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:

Code:

=GOOGLEFINANCE("CURRENCY:BTCUSD", "price", DATE(2023,4,20), DATE(2023,5,1), "DAILY")

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.

Topic: [Tutorial] How to Check Bitcoin Price using Google Speadsheet. (Read 161 times)