GOOGLE SHEETS CRYPTOCURRENCY TICKER HOW TO
GOOGLE SHEETS CRYPTOCURRENCY TICKER FULL

This cookie is set by GDPR Cookie Consent plugin. The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category 'Functional'. The cookie is used to store the user consent for the cookies in the category 'Analytics'. These cookies ensure basic functionalities and security features of the website, anonymously. Necessary cookies are absolutely essential for the website to function properly. If any changes need to be made, I will be updating my followers there.ĭisclaimer: This blog post is for informational and educational purposes only and should not be construed as financial advice. Keep an eye on the comments section of my YouTube video which I have linked above. But be patient, as it will come back again. Note from time to time, the price may stop working if are doing some updates to their website. Once you have the prices pulled in to your Google Sheets its a simple few steps to build out a portfolio tracker like this: But if you want the prices to keep updating every so often while you work on the sheet you may need to use the like of a simple macro which can at the click of a button can cut and re-paste the formula in order to get a ping of fresh data from the website. Step 3 – Price refresh (optional)Įvery time you access your Google Sheets, the prices will refresh automatically. If it doesn’t, then make sure that the very first part of the formula (referenced as B2 in the above) is linking directly to where you have pasted the URL from. The price should not automatically feed into your Google doc. Your next step will be to copy and paste this formula ‘]”) into the adjacent cell on your google sheet tracker. Your first step will be to go to the specific page for the chosen cryptocurrency you want to pull prices for and to paste it into a new Google Sheet. Step 1 – copy the URL of your chosen crypto from Įvery cryptocurrency has its own dedicated page on – for example the URL for Ethereum is.

GOOGLE SHEETS CRYPTOCURRENCY TICKER HOW TO

How to simply pull prices directly from the website into Google Sheets If you are a fan of Altcoins, then using then the Google Finance formulae will not be enough for you. To pull the price of Bitcoin into your google sheet you can use the formula =GOOGLEFINANCE(“BTCUSD”).īut the problem is, there are over 21,000 different cryptocurrencies listed on at the time of writing and that number is continuously growing.

GOOGLE SHEETS CRYPTOCURRENCY TICKER FULL

Google has only added a limited amount of information for some of the larger cryptocurrencies such as Bitcoin and Ethereum to their Google Finance Database – you can find a full list of what is covered here. On this Google Finance database, you also have some crypto information which you can use formulae to add to your crypto trackers, but the information they provide only barely scratches the surface of what you will need. Google Finance is a huge database where you can pull lots of different useful company data such as stock prices, market caps, P/E ratios, etc. ACCESS MY GOOGLE SHEETS CRYPTO TRACKER Why you can’t just use Google Finance Formulae for Crypto Prices

Google sheets cryptocurrency ticker