Academy ↓
Hey there stranger!
How To Track Crypto Prices
About this Tutorial
Featured Formulas
Video Transcript
In Google Sheets, we can actually show little, uh, spark lines or little graphs of up and down. Maybe you want to set a price of your, uh, Service in crypto and you wanna know the u s D price or you wanna know how many Bitcoin per crypto. So you wanna do a quick calculation, um, and we can quickly get the crypto price of three crypto currencies.
Bitcoin, Bitcoin Cash and Ethereum. We can do this all in Google Sheets and maybe you wanna calculate your investments as you gain investments over time. You might increase your count of how many you have, um, from 1.1 to 1.3 to 2.3 0.4. You wanna know what is the actual net value. Um, as you can see, I have it here and how we're gonna do.
Between use Google Finance. Google Finance is usually meant for, um, uh, you can do currencies, but you can also do stocks. So you can put like Nasdaq, Google, g o o g, and find the price of Google. Actually, we can do that right now. Uh, Google Finance, Google Translate will science, and we can do Nasda. Is, uh, where it's traded, goop or colon go.
And now we can find out what the price of goop is. 1,216. Today on it's April 12th. Uh, 22nd. 2020. And so very similar, we can find a cryp, uh, a currency. So, idr, I'm in, uh, Indonesia right now. Idr, U s d. We don't need, uh, the colon for, um, curr. And it'll come out. Oh, we can also switch this. So that's ID r to U S D.
So U one US dollar to IBR R is 15,590. And so the same can be said about Bitcoin and this is what you need. You need U S D B, TC or B C H or E T H, and you can flip 'em both ways. You can say U S D, btc.
There you go. That's one US dollar to vc. So one BTC to U S D is 6,857. And then you can use this, uh, Google Finance in calculations such as this. Here, I'll show you how this goes. So I'm using the cell in D six, multiplying it by Google Finance. Btc, U S D. Make sure you have the quotation marks there and now you can find out okay if I have, you know, 3.45 bitcoin, I have that amount.
You can even change this format as currency and you can get that in currency, uh, if you wish. And that's how you can track crypto prices. in Google Sheets. If you want to learn how to take this kind of data, track it month over month, week over week, day over day, add in progress bars. Maybe you're trying to save up a Bitcoin to a goal.
Uh, if you want to track, uh, just see some charts next to it. I, I create nice little spark lines next to there. Um, Go ahead and check out better sheets.co. I'm offering a lifetime access deal right now. All of the, uh, videos I ever make are now available to you. I'll never charge you again. Purchase now and you can find out how to create cool dashboards if you are, um, tracking something.
Our tracking crypto prices, I'm literally working right now. If, uh, if you are watching this later, I'm literally working right now on a crypto dashboard to track your. Day over day or week over week, calculate how much gains, how much losses, and put up charts next to here. Uh, so I hope you come and join me over@bettersheets.co.
And there's also tons of free tutorials all the time. Thanks for watching.
Courses
14 Sheet Ideas You Can Sell
How do I prevent people from sharing my spreadsheets by making a copy?
Add Title Case to Google Sheets
Why Different Cell References in AI Integration in Sheets?
100 Tweet Starters
00:10:24
Ali Abdaal's Google Sheet | Year at a Glance
Create a Podcast Advertising Calculator
00:29:07
How to Redirect Domains to Google Sheets and Google Docs
Maximize Spreadsheet Sales to Startups
Create Hundreds of Tweets in a Google Sheet
00:11:29
1 Simple Formula to Make Writing Tweets Easier or Make $1,000
Announcing OnlySheets
00:14:15
Generate Hundreds of Business Names
00:09:25
10 Google Sheets I Wish Someone Would Make
00:57:33
How To Track Crypto Prices
00:04:18
How To Improve: 1,000 Business ideas: Business Idea Generator
00:11:20
Roast: Sales Tax Calculator
00:08:45
Transform Information Into an Info Product
00:41:48