Google Sheets Real-Time Crypto Prices - Meme Coin Update

Hey everybody, so a couple of months ago I made a video on how to get real-time crypto prices

directly from the coin market cap website into your Google Sheets portfolio trackers

And the video got a good response and a lot of people seem to find it very useful

Because at the time Google had no official formula where you could actually pull in crypto prices

So that made it very difficult for people to try and track their performance of their stocks and crypto all in one place

They have since added a crypto database which would allow you to pull prices for some of the very large cap

coins but it only works for the likes of Bitcoin, E, and Cardano and XRP. This is the formula here

so if you only hold the likes of Bitcoin or Eater, for example, I highly recommend you just use this

one. But if you hold anything else such as like Salana or Dot or even some of the meme coins

like Shiba Inu, or Floke Enu, then you will need to use my method. In my first video, I didn't

cover the formula that you need to use if you have some meme coins. Basically, anything that has a price of

0.001. If you want to pull the price for one of these meme coins from coin marker cap into your Google Sheets

then you need to use a slightly different formula, which I will go through in this video. I am in by no way

advocating that you should go and buy these meme coins. I don't hold any myself and I probably never will

But for anybody who does hold them and wants to track their performance, then this is probably a good way to do it

When I go through the process of showing you how to set up this on your Google Sheets

Do not worry if you cannot recreate what I'm showing you. You also have the option of buying my stocks and crypto portfolio tracker, which I'm setting on Etsy

I will leave a link to that below in the description section for anybody that is really stuck

My Etsy store is called accountancy school and it's all just one word. So let's just kick it off

So first things first, what you need to do is just open up a blank Google Sheets

And then what I like to do here is just to keep the regular cryptos and the meme coins separate

it will just make life a bit easier on yourself so i just created a few simple headings just to get us going here The symbol the URL and the price So the symbol is not very important You can just put in the

regular name of the crypto here. This won't actually affect anything. But what you will need to do

is go on to the coin market cap website then and try and get the URL for each of these different

cryptocurrencies. So I'll show you what I mean here. So if I wanted to get say I'm on say the

home page here basically of coin market cap now, If I wanted to get say the URL of Pocodot, I just type in say dot here, and I'll find the specific Pocodot page on CoinMarker Cap

So as you can see here, it's Coinmarker Cap for slash currencies for slash Pocodotot new

So I want to copy that URL and paste it in here beside dot

I'll do the same for Solana here. Copy the URL and paste it back in here

and I'll do that for Sheba and Floki here also. Once you have that done then you need to just copy in the formula that is going to actually import the price from that page into your Google Sheets

So I have the formulas just save down here at the bottom of the sheet. You don't have to worry about pausing the video to write these down

I'm just going to copy them down into the description section so anybody can go and copy and paste them at their leisure

And if there is ever an update on the Coin Marker Cap website, sometimes they change the performance

parameters and if the formula slightly updates as it does sometimes I will go back to the video and update them there so for a regular crypto price here is the formula here it's import xlm and then open brackets the cell so see where it says here c3 so this has to link up with the URL that you just paste it in to the Excel sheet so I'll just show you here for example I want to copy my my formula here in regular price and just paste it up beside a Sol here into the price

As you can see here this is after breaking it because I don have it link now to the URL So I just need to just delete out this ref part here and then just link it to where I just pasted in my URL and hit enter and that pulls in the price of Salana and then I just

going to copy it down to dot as well and that pulls in the price of poca dot so it's actually very

easy to do and and then there's a slightly different formula then for the meme coins because as you can

see they have like a price of 0 0 0 0.635 for for shiba so if I just copy it after

formula here and paste it into into the price here beside Shiva and then it's

after break in here again so I just need to relink it to the correct URL here and bang

that's that done so that's the Sheba price and the flokey price then should work as well

as I see it's after break in here for flokey but what I think might have happened here is

you don't need to use the meme coin formula for a flokey it's probably just a regular

regular formula you need to use so I'm just going to try that instead and so I just

link this to the other formula here and link it to the URL and so yeah that's

working for for flokey so the regular formula is working for flokey obviously

it doesn't have as many decimal places so it probably works with the normal

formula so the last thing you really need to do here is just to create a macro to

refresh these prices because when they pull in from coin market cap they're going to

be kind of static so you want to create a quick and easy method to refresh these

prices so what I usually do here is I create a very simple macro so don't worry

these are very easy to do so all you do is come up here to tools macros record

macro and what this will actually do is it's going to record every little action

that you do until you save your macro and at a click of a button then it will repeat

those actions anytime you ever want to do it so if I wanted to say refresh the

prices what I would do is I would just delete out my formulas and then I would copy the one I have saved here and just redo it again

to repaste them in so i have them in so i have them all re-updated then i can it's

and then you can just name your macro I'm going to name it just refresh prices you

could even create a shortcut so I'm just going to call it control alt-shift plus one and hit

save and then whenever you want to refresh the prices on your sheet all you need to do then is

go to tools macros and you'll see you now refresh prices is one of the options on the list

here so if I click that it will automatically do all those actions again and copy and paste

everything and refresh all of the prices which is really easy to do in just literally a second and you can also use the shortcut that you created and so that is the

basics of just getting the price into your google sheets then you can try and build it out a bit more like

um so like my spreadsheet here that i have on it see i have my just stocks in here and i have then my

my crypto so you can add in your average cost and your market value you can even convert it into

different your base currency wherever you were from and so you can try and build it out whatever

way you want to do it i know a lot of people ask me can i pull in the

market cap and the daily price changes from coin market cap also that is actually not something i am able

to do myself yet if there's anybody really good with html and that is watching the video and knows how to

pull in the market cap and the daily price change please let us know and i can do an update the video

again so but this will get you to the basics anyway of getting your your price and your market value

of your holdings basically and tracking everything you own so i hope everybody found this video

useful and if you have any questions leave me know in the comments. I would really appreciate

it also if you could drop a thumbs up on the video and subscribe to the channel