Automatically Import Crypto Prices that Auto Update Google Sheets #bitcoin

Automatically Import Crypto Prices that Auto Update Google Sheets #bitcoin
👉 Support the Channel if you're feeling Generous

Cash App $TradeIntuition

Always have a VPN

MEXC Exchange

TradingView
#bitcoin #supercycle #crypto

Automatically Import Crypto Prices that Auto Update Google Sheets

Now there's 2 things that we need to do for this coin
we have NEAR
now we have to go to coin market cap
go to the price area and we're gonna right click
next we're gonna go to inspect
now you can see that this part is highlighted
what we're gonna do is we're gonna right click
we're gonna go to copy and now copy full X path
once we've done that
we're gonna come over here to our XML part
and we're gonna go ahead and just paste this
now we need the URL
so we're back on coin market cap
and all we're gonna do is come up here
and we're gonna right click
we're gonna copy this
come back to our sheets and now in the URL
we're gonna click on this and paste this
and you can see the price automatically updates
now the formula for this is equal sign import XML
open parentheses
the cell that the URL is in comma
the cell that the XML is in
and then end parentheses
make sure you hit enter
give it a few moments and you'll get your price

Import Crypto Prices Automatically =IMPORTXML(F18,G18)
F18 refers to the URL
G18 refers to the XML

crypto,how to create a trading journal - made easy,trading journal,trading journal excel,day trading live,forex trading journal,trading journal google sheets,free trading journal,trading journal forex,excel trading journal,how to build a forex trading journal,forex trading journal download,trading psychology,forex trading journal excel,trading journal spreadsheet,forex trading strategies,trading journal software,how to create a day trading journal,bitcoin,btc

[monicalaborde]

You were so much more helpful than the 5+ extensions I downloaded. Thank you!!

[database]

Thank you for sharing. This is the only simple instruction that works.!!

[sabre]

Thank you for this! Great to the point explanation.

[Iamthetoan]

Do u have any excel to download like exit plan?

[zaidmomin]

Thanks You but this doesn't update the live solution for that to get live updated prices in excel or googlesheet?

[michsmell]

I have microsoft 2024 and this sadly didnt work. I got a name error. :(

[fahim]

Thanks, it worked and was able to get the prices in my Google Sheet, however I checked back after 15min but I dont see the prices are updating in my google sheet. Any tips how can I get updated.

[NewYorkCityGardener]

why isn't this working any longer?