How To Track Cryptocurrencies In Google Sheets
HTML-код
- Опубликовано: 13 сен 2024
- How To Track Cryptocurrencies In Google Sheets
📈 Link to download all my Portfolio Trackers: / thinkstocks
🌎 Follow me on Twitter: / keithfrislid
🎥 Here is the camera I use for my videos: amzn.to/2PB865Q
🔶Get 50% off Seeking Alpha Premium with my Promo Link!!!🔶
www.sahg6dtr.c...
In this video, I will show you have to pull Cryptocurrency data into Google Sheets. This data will include prices, market cap, and circulating supply. As you will see in the video you can pull data for a bunch of different cryptos including all the big ones. If you like this video don't forget to smash the like button and subscribe!
🔷Google Sheets Functions:
🔸Price: =IF(ISBLANK(A3),"",INDEX(IMPORTHTML(CONCATENATE("finance.yahoo....",A3),"table",1),1,2))
🔸Market Cap: =IF(ISBLANK(A3),"",INDEX(IMPORTHTML(CONCATENATE("finance.yahoo....",A3),"table",2),1,2))
🔸Circulating Supply: =IF(ISBLANK(A3),"",INDEX(IMPORTHTML(CONCATENATE("finance.yahoo....",A3),"table",2),2,2))
AFFILIATE DISCLOSURE: Some of the links on this channel and in video descriptions are affiliate links. At no additional cost to you, we receive a commission if a purchase is made after clicking the link.
#googlesheets #cryptocurrencies #cryptotrackers
How do you add trades there, tho? Say, if I sell 25% of that BTC and purchase with that value ADA. What would be the best way to track that in the sheet? thanks!
I tired this but it kept giving #N/A
I tired both typing it in and copy and paste your function in description.
=KDYŽ(JE.PRÁZDNÉ(A2);"";index(IMPORTHTML(CONCATENATE("finance.yahoo.com/quote/";A2);"table";1);1;2))
=KDYŽ(JE.PRÁZDNÉ(A2) is the same like =IF(ISBLANK(A2)...my google sheets works in my language... but there are some update or what and you have to use ; not just , ... I had to wrote it by myslef to succes.
Hope I helped you.
Have a nice day!
But I tried to do it with ATOM1, AVAX and it doesn't work... It works at BTC, ETH, ADA... strange things happens here...
yes , i think you should find an other way
Hi Thank you so much for this video, I just started investing on stocks and crypto... Have a qq: If I buy 0.005 btc today at x price and tomorrow more 0.01 btc... how can I track both days and keep tracking all my buys? thanks
Good tutorial. I've been trying to import coin info from other sites (yahoo doesn't list some of the smaller ones) but have been having trouble. Any tips?
I think the Yahoo thing changed and it’s not working anymore any updates?
Thanks for your video. Unfortunately, there are very few cryptocurrencies on YF, so this option is not working. Even NEO and EOS from the example are not working right now.
Check out my coin market cap tracker! That one is much better
if you are getting the cannot find error. Type the entire formula by hand copy paste does not always work correctly
Hi there, Managed to do that and it worked for most. Thank you. However, I cannot get it to recognize Theta or Dent for example. Still comes up and NA. Any suggestions or help gratefully appreciated.
yes that is correct
what is the difference between that query and =GOOGLEFINANCE("CURRENCY:BTCUSD") ? Maybe the sources, but that query looks pretty convoluted to read
Hi... Can I use this for two-word names of cryptos? Like Shiba Inu? I saw that your other video about crypto tracker I cannot, so I was wondering if you can do it with this one? thank you.
i was wondering the same
Thank you
how do i look up the full name of the coin from the table? What will the formula be? Thanks.
Think Stocks...... you mentioned that all your sheets are available through Patreon. I would like to do that but do you make sure the sheets function properly. No offense, but there are a lot of comments (mine included) about errors that people keep getting. Thanks for your feedback.
Yes, all the sheets are working properly. And I update the sheets in my Patreon if any errors happen down the road. The biggest problem people come across is they are dealing with non US stocks which some times the functions don't work for them. I did make an international tracker to try and resolve that problem.
you may need to double check the formula and and add in the info.i.e the formula will be there and say postion but not have the place to get it from so may have enter the column and rows. real easy. maybe it was just me but I found not to be a big issue I just followed the video and it was worht it. also if you adjust some like I did you might need to change like A2 to A3.
Not all the coins i have pull through. Half of mine show an N/A for the price and I double checked the notation on yahoo finance was correct. Example, VGX-USD, HNT-USD..
Why it's not updating in real time? Any clue?
Thanks a lot for this video. But if I want the live updated price, not the close of last day, what can I do? Thanks Bruno
Friday I'm releasing a video that shows you how to get the live price of BTC & ETH!
@@ThinkStocks thank you, i look forward to see it, what will be the link of the video?
For some reason in the charts for pie and chart all of the data is showing except for 2 crypto’s , I made sure they are in the formula ; any tips ? Not sure what I’m doing wrong
Why it is showing error for BAT-USD
Hi, When I try for BTC-INR, It doesn't work. Any help is much appreciated
I'm getting (for price) "imported content is empty". Assistance appreciated.
I have the same problem. Help please.
Need to know how to track my cost basis not total value .
How to import from Binance?
Thanks, that's great
How do I see its daily change?
Can I use this in excel?
Thank you so much for this. Amazing! I just wanted to know though, When i try BTC-AUD my price is N/A with the error "Resource at url not found" ? Is there a way to fix this?
Check the correct notation BTC-USD
@@Admiravel-kc5db sir, BTC-AUD is also correct, just the price in Australian Dollars
Hi
how to import date wise
Simple, easy, amazing. Congratulations 👏👏👏
Would you be able to do a video tracking both Crypto and Stocks in google sheets?
Yes! I'm actually working on a tracker like that right now
@@ThinkStocks When do you think it will be done. Really need one.
You just use his same formula with the stock ticker instead of the crypto-USD
legend thanks!
hey, just wondering if there is any reason why in the last 24 hours this stopped working for me? google sheets says 'resource at url not found'?? haven't changed anything??
Sometimes google sheets can be glitchy. Try to close out and refresh the page
Great content just what I was looking for I have subscribed keep up the good work
Thanks for the sub, and I plan on it!
You deserve a LIKE before I even press play... THANK YOU VERY MUCH!
How do I refresh data prices? Doesn't refresh upon opening of sheet .
hit refresh button on top like a webpage.
This was so cool
Has anybody gotten a "resource at url not found" error message?
Same error for me.
Wow sorry i didnt search harder! Thanks for this video! *** actually its coming up as resource URL invalid. any fix to this?
type the entire string by hand copy paste does not always work correctly
You are the best
you sir, deserve a medal of honor!
HELP PLEASE- I have followed the instruction and get the BTC populated. I then ensured other rows were populated with the code. However, it comes up as 'NA" each time for these rows. So for example I type in row LTC-USD and I get NA. Any help gratefully appreciated.
So btc is working but the other cryptos aren't?
@@ThinkStocks Hi there, since messaging you I have got others on. The crypto's I am struggling with are DENT, Theta, Tfuel and One.
Hmm, does yahoo finance have data for those coins? If yahoo doesn't then there would be no data to pull from
@@ThinkStocks One and Dent are not on there, so I understand that. However, Theta and Tfuel are on Yahoo Finance and shows as NA with the calculation. Also, after I couple of hours my total sum has not changed? Surely it should change after 2 hours, or is it only a daily thing re yahoo finance. Any solutions to the above is greatly appreciated.
I'll have to look more into that. Yahoos code might be slightly different for less popular cryptos
Can u make a crypto sheet in the future that shows cost basis and gain\loss in addition to what u already have on this sheet? That would be really nice, Thanks!
Another GREAT sheet! Thank you.
Thanks for watching!
sorry friend, I tried to put these commands here, and nothing worked. I think I'm really stupid
your formula dont work bro ...correct it
Thank you thank you thank you!!!
This doesnt work anymore
Hey, I just checked the tracker on my end and its working for me. I have 15 cryptos on the tracker and all of them are still able to be pulled from yahoo finance!
@@ThinkStocks I tried a method that someone left in a comments below and it’s working now!
Okay awesome, glad you got it to work on your end
@@ThinkStocks Hey, I got it working when I first configured my sheet, however, it is not updating when I refresh or try reopening the sheet? Any idea why?
Ofcourse doesn't work....
၊.