✅International Stock Tracker in Google Sheets

📈 Link to download all my Portfolio Trackers: https://www.patreon.com/thinkstocks
🚀 Link to Think Stocks Meme Shirts: https://thinkstocks.us/
🌎 Link to join my discord server: https://discord.gg/eAMBYqK3t2
🎥 Link to the camera I use for my videos: https://amzn.to/2PB865Q

Check out my favorite books!
📕 Favorite Book About Stocks: https://amzn.to/3gRGCmj
📙 Favorite Book About Bitcoin: https://amzn.to/3iXFXCz
📗 Favorite Book About Money: https://amzn.to/35HA6JS
📘 Favorite Book About Business: https://amzn.to/3wLqRnz

In this video, I will show you how to pull INTERNATIONAL stock data into google finance! Many of you have been asking how to do this for months now and I finally figured it out for everyone! Thanks to Yahoo Finance we can pull international stocks data including price, market cap, dividend data, and more! In addition, I will also show you how to convert the stock currencies into your currency so make sure to watch until the very end!

🔷Google Sheets Functions:

🔸Price: =IF(A3=””,””,if(D3=”USD”,(GOOGLEFINANCE(A3,”Price”)),(index(IMPORTXML(“https://finance.yahoo.com/quote/”&A3,”//*[@id=’quote-header-info’]//span”),4))))
🔸Cost: =IF(A3=””,””,C3*B3)
🔸Value: =IF(A3=””,””,E3*B3)
🔸Growth: =IF(A3=””,””,(E3-C3)/C3)
🔸Div $: =IF(A3=””,””,SUBSTITUTE((SPLIT(INDEX(IMPORTHTML(concatenate(“https://finance.yahoo.com/quote/”,A3),”table”,2),6,2),” ()”)),”N/A”,”0.00″))
🔸Div %: =IF(A3=””,””,I3/E3)
🔸Currency: =IF(A3=””,””,if(D3=$K$2,G3,G3*GOOGLEFINANCE(“currency:”&D3&””&$K$2&””)))

#googlefinance #internationalstocks #currencyconvert


We have taken this video from YouTube and posted it on our site and if you are the owner of this video or you have any problem with this video please contact us

LEAVE A REPLY

Please enter your comment!
Please enter your name here