Главная

Live Cryptocurrency Dashboard in Google Sheets - Real-Time Portfolio Tracker

00:00

00:00

HD

undefined

<iframe src='' width='768' height='432' frameborder=0 webkitAllowFullScreen mozallowfullscreen allowFullScreen></iframe>

Copy

https://z.wmarmenia.com/video/M9dnEli-RoY?id=0

Copy

1080p

HD

720p

HD

480p

360p

240p

144p

auto

Skip advertisement

Advertisement

(00:00)

Кадры Live Cryptocurrency Dashboard in Google Sheets - Real-Time Portfolio Tracker

Описание Live Cryptocurrency Dashboard in Google Sheets - Real-Time Portfolio Tracker

Коментарии Live Cryptocurrency Dashboard in Google Sheets - Real-Time Portfolio Tracker

CAN I GET THAT EXCEL SHEEY Comment from : mohan viswanadha

I don't get it It just doesn't work I type the command correctly but I get answer Ν/Α with error: Imported content is empty brIt worked for some minutes but not anymore (didn't change anything) Comment from : Spiros Zochios

Some of them just don't work while opthers so Like "bnb", "polkadot-new" etc Comment from : BullMarketBeaver

The only tutorial that really worked for me, thank you! Comment from : WisdomIsFree

Hi Martin, I got the 24h price to work last year but the same form doesnt work anymore Any guess why? Does it still work for you? I tried to update the Xpaths as Coinmarketcap does that sometimes but thats not the reason Updating the price work as I fetch the css class instead but the 24h change doesnt have that so Im reliant on your solution Comment from : frederic berghmans

Hello, thank you very much for your wonderful video I have a problem on set up refresh data, I have followed your step carefully, but it does not refresh the data price The price is still keeping the same amount (not changing) Could you show more on your sheet when you refresh your sheet? thanks in advance Comment from : Angkor Empire

shows price but doesnt update price Comment from : keith davies

How to get realtime stock price for HONG KONG MARKET? Comment from : luck Simi

how can i know if the change 24h is positive or negative, when im pulling the data its just show whole not knowing if its positive or negative Comment from : CryptoBroPH

Hi, Is there any way I can purchase the completed spreadsheet in the demo you give? Along with any updates you have made? I am a very beginner tech person and would like to analyze the way it works and study the formulas in case I need some hand holding I would gladly send you a zelle, cash app or paypal payment for the completed google sheets link Comment from : MPS Manger

Thank you for the videobrbrEverytime its showing "loading" when triger activebrbrits annoying,, is there any way to stop "loading"??brbronly updated value will appear without showing "loading"?? Comment from : puding puding

Error : Resource at URL contents exceeded maximum size,,,, is the website too big to be processed by sheets?? Comment from : Dubey Dubey

Danke Martin! Comment from : Mounir Hilal

zoom lol cant see Comment from : gonshu gaming

Why didn't you used API to get data Comment from : jatin verma

hello and thanks for your video but i have some problems br br"Parameter 1 of the "ADD" function" has number values However, "1913549" is a text value and cannot be coerced to a number value br brcan someone help me Comment from : Z C

Followed steps most of it worked Can I share googlesheet with you? to clean up some errors Comment from : Brodie Sharpe

this isnt working more? doesnt matter what i do doesnt work for me im doing exactly the same steps 1:1 Comment from : Stichwaffe

I followed the steps, but there is a 'resource at URL not found‘, need help Comment from : Smart Investing 101

I cannot get the refreshes to work properly The macro is functioning fine, but the data is not updating It's more like coiinmarketcap only updates their XML streams every 30 minutes or so Is there a way to get it to update more regularly? Comment from : Steven Galvano

Very helpful, thanks Comment from : Steven Galvano

The CHANGE_AMOUNT_XPATH is not working for me Google sheet says that the imported content is empty Can anyone help me? Please Thank you sooooo much! Comment from : Louwella Andres

Hello guys, is it possible that, few coins don't work? I had issue with Cronos and polkadot, other coins works What can be the issue? Comment from : Arek Ste

Hi Thanks for the video One question In Change_Amount_Xpath section, when u were copying from Coinmarket, u had highlighted the change amount, and this was reflected in ur xpath I have 2 problems, 1 I dont know how to highlight the change and 2 whenever im copying the change_amount_xpath data from coinmarket to google sheets, it is showing error Rest of the changes are working Kindly let me know how i can resolve this?br Comment from : Farouk Merchant

Don't work today ; / Comment from : HeYz / Miłość do kultury

¿Como puedo hacer para poner una casilla de si el volumen ha subido o bajado en las ultimas 24H? Ya intente de todo y no he podido hacerlobrbrAgradezco me ayudes Comment from : Santiago Jimenez

this video is the ONLY ONE that solved HOW TO CONVERT CURRENCY into NUMBER really made my day, I lost weeks before getting to this video LOVE bro Comment from : Metal Sir

Hi Martin, thanks for this wonderful tuturial I am a googlesheets for dummies type of level and even I was able to follow your tutorial Is there any way I can do the same for floor prices on opensea? I could not make it work brWould appreciate if you could do a tutorial on that Comment from : vadia100

Martín, genial el vídeo Te hablo en castellano porque me es más fácil hacer la pregunta Tenés idea se cómo hacer un Google Sheets que haga una línea nueva cada día? Quiero hacer un seguimiento del tipo de cambio, pero me gustaría que la hoja mantenga los valores históricos día a día Un abrazo! Comment from : Ruben Pesoa

spent over 40h now trying to firgure out how to get the sheet to automatically refresh and noting seems to work and can't find any information what so ever on how to do this not possible in current version or smth? Comment from : Łīƀɍⱥ ȼᵾꞩⱦꝋꞩ

Is it just me or did this code break suddenly and no longer works? Comment from : George W Kush

My deepest appreciation for this Tutorial You are amazing and so helpful Helped me a lot to track all my cryptos in one spreadsheetand from any page of coin base market web site Thank you Comment from : ali khidhir

i have issue with the math function with the price value, there is an errror cause the price value is a text and can't be used as number in the multiply function Comment from : andrea ficetti

can we have a copy of that doc plis? thanks and good video Comment from : Heinz19946

Can this work with sites that require a login or is it better to use API access for that data? Comment from : Jacob Seeger

i can't do itthe price keep reloadingdidnt show upanything i can do? Comment from : Bella

Not working right now Comment from : Dhanush saji

I'm strugglin with SHIBA, I can't import the price Comment from : Vicente Anfruns

I followed the step but its not refreshing Comment from : Josef Madrid 111

How about those crypto name that have this " - " ex Shiba-inu, cause the formala is not working anymore Comment from : Ian Cris Vasaya

I followed all the steps and it worked! brbut after a while it stopped updating, any tips ? Comment from : Bvdz024

getting error while loading the price resource at url not found Comment from : G P Krishna Prasad

Thankyou so much! By far the fastest tutorial i've seen in youtube Comment from : Reverae

How to import the 24 change when its negative? Comment from : Gia955

HELLO THANKS FOR YOUR VIDEO, WHY DOES THE CHANGE IN 24H MARK ONLY THE POSITIVE NUMBER AND NOT THE (-) NEGATIVE ONE? brHOW CAN I SOLVE? THANK YOU Comment from : Marcello Resta

It is not working with BTC price Absolutely working fine with USD Is there any way to work with BTC Comment from : Manzar Tech

FANTASTIC VIDEO, CONGRATS! Comment from : Giovanni Ciet

you never fixed the change 24 hrs so it still shows positive changes even tho its negative that day Comment from : IPrinzeX

Lol cant you send me this document so I can use it? I'm computer dumb Comment from : Scott Maynard

Very helpful thank you Suggestion: post a link to a "read-only" version of your Google Sheet so that everyone who watches doesn't have to recreate themselves they can just use your template as a starting point and save a copy Comment from : Ryan Yada

I was really searching for a video which tells how to refresh the data automaticallybrGreat tutorial ! Very helpful Comment from : Manu K

Genius Comment from : Philip Armstrong

Hey Martin, any chance you can share the googlesheet doc, so we can download it ? I'm not too good with Excel and I didn't manage to create the tracker :( Comment from : MrCLM

for some reason, terra-luna doesnt pick up for me, any idea why? Comment from : thebadguy

Hithanks for posting it I am able to get BITCOIN data but when I copy that string down to include Shiba and Powerledger all I get is N/A Can you explain? Comment from : vince1964100

Would be cool to see how to handle different currency formats in google sheets Comment from : Rob van Breemen

Had to struggle for a bit with the format when trying to pull the data via the ImportXML function It was due to a delimiter setting I needed to use semi colon instead of a comma ;) Thanks for sharing the video! Comment from : Rob van Breemen

buy high sell low lol love it and fumo omg perfect Comment from : chirpthird

"I also have ICP because I like to buy high and sell low" Comment from : Daffer

Thanks for your videos I´ve got a problem on this one I cannot calculate the position value because it says "in multiply function the value 1 is TEXT and cannot be forced to number" I changed the cell format and no change Is there a way to convert text to number? I cant find that command Thanks! Comment from : Miguel Vera

hi, i have a problem, i do the same formula as you to get out the "$" but it still gets me the error #VALUE!, that says it is a text format can u help me? tyvm Comment from : tiago sousa

Can i get file your do spreed sheet live for example Comment from : Tasty eater

lol😂brICP for buy high sell low Comment from : Ashwini N K

It is working! Thank you so much Comment from : Evren

got ERROR EVERYFUCKIING TIME, only works on the first day shit Comment from : Rui Almeida

I followed all your steps and i finally manged to pull the data i wanted from coinmarket My problem is that i cannot do arithmetic with my data like you didi tried to use the substitute function but it keeps teeling me that my data is in text format I already tried to chenge the format of my collumns, lines and cells to numbers, but i keep getting the error any idea? Comment from : Alexandre Falcão

try to import the price of polkadot, but its URL has a dash like polkadot-new,brthe cell can't read, how to make it able to read? Comment from : T K

Why have you NOT added a share link to this or maybe you did and I am blind Comment from : Jeremy Murphy

"Function MULTIPLY parameter 1 expects number values But '55714' is a text and cannot be coerced to a number" Google sheet is google SHIT really i stuck since 40 minutes ago but im still search my error on your tutorial Comment from : Rémi Maubeuge

The Best brThanks for Sharing Comment from : aMan

This was teh video that i needed Comment from : Sochitra Mam

great video i just have a tiny problem with sandbox, i've tried every way to write it, but it still won't work do you have an idea why is that? Comment from : Space movie 1992

Hi, how can i add timeframes like 1m | 5m | 15m | 1H | 2H Comment from : Kot

Why you do this while it’s already in the market cap ? Can you explain the benefits? Thank you 🙏 Comment from : James Bond

more like this Comment from : Ricky V

you are a rock star - truly a hidden gem you solved my problem thank you very much mate Comment from : robinhood

I´m brazilian and I got it, I´m so grateful to you Comment from : Néia Santos

"And I also have some DOGE, because you have to have some fear of missing out at least once in your life" I couldn't stop laughing! Comment from : Nick S

IT WORKS! AWESOME! Comment from : Paustina Chou

Hey man! I've seen 5 tutorials of these tried out 5 different formulas this one is the first that works for me Thanks a lot!brIs there a way to track a historic price? or maybe a way of defining a price with a macro? I create new columns every 2 weeks to keep a track in time, duplicate the columns of price token and total of each, to check in new movements in price, buyings and sellings but once I create this new column (which I want the price to be updated), I wish the previous price column does not update price anymore so I know what price it was 15 days ago Makes sense? Is there a way? Thanks! Comment from : Gianluca Bonfanti Mele

Does anyone have a completed live spreadsheet with the top 500 coins? Would be greatly appreciated if you could send this across! Comment from : Cairo

this is fantastic thank you! any suggestions on how to get values displaying AUD not USD? Comment from : Michael Egan

What an awesome video, thank you can somebody tell me how to get the euro prices? Comment from : Tiberius Morterius

Thanks a lot, i have to put some url of cripto and its change manually, but it works! This helped me very much Comment from : Tomás Gazzotti

Похожие на Live Cryptocurrency Dashboard in Google Sheets - Real-Time Portfolio Tracker видео

How To Build a Crypto Portfolio Tracker in Google Sheets ? Real-Time Portfolio Tracker РѕС‚ : CoinSutra - Crypto Investors and Traders Community Download Full Episodes | The Most Watched videos of all time

Import Cryptocurrency Price In Real Time In Google Sheets РѕС‚ : Jie Jenn Download Full Episodes | The Most Watched videos of all time

How to Install Chat GPT for Google Sheets - Use GPT AI in Sheets РѕС‚ : Evan Does Tech Download Full Episodes | The Most Watched videos of all time

Coinmarketcap API + Google Sheets - SIMPLE EASY crypto tracker РѕС‚ : Lee Schloss Download Full Episodes | The Most Watched videos of all time

[LIVE] Coronavirus Pandemic: Real Time Dashboard, World Maps, Charts, News РѕС‚ : Roylab Stats Download Full Episodes | The Most Watched videos of all time

Import Cryptocurrency Live Price In Google Sheets (From CoinMarketCap) РѕС‚ : Jie Jenn Download Full Episodes | The Most Watched videos of all time

Import Cryptocurrency Live Data In Google Sheets (Template Free Download) РѕС‚ : Jie Jenn Download Full Episodes | The Most Watched videos of all time

GPS TRACKER GF-07 | Best GPS Tracker for Bike in Bangla | সব থেকে কম খরচে জিপিএস ট্র্যাকার РѕС‚ : Kom Dam. Download Full Episodes | The Most Watched videos of all time

GPS TRACKER GF-09 и GPS TRACKER GF-22 РѕС‚ : Добрый Кот Download Full Episodes | The Most Watched videos of all time

How to Import Cryptocurrency prices from CoinMarketCap Data to Google Sheets РѕС‚ : Dr. Larry Sarpong Download Full Episodes | The Most Watched videos of all time