International Stock Tracker in Google Sheets! (Build Your Own!)

Link to download this spreadsheet:
https://www.patreon.com/dividendology

Get up to 12 free stocks now using my link for Webull! (Free Money!!): https://a.webull.com/i/Dividendology

Get 50% off of Seeking Alpha Premium!
https://www.sahg6dtr.com/9D5QH2/R74QP/

In this video, I take you step by step on how to build an international stock tracker in google sheets! Let me know if you have any questions in the comments below.

Formulas:

Company name:
=if(C23=0,"", GOOGLEFINANCE(C23&":"&B23,"name"))

1 YR Terndline:
=if(C24=0,"", sparkline(index(GOOGLEFINANCE(C24&":"&B24,"price",today()-364,today()),,2),{"Charttype","column";"color","purple"}))

Cost (Currency converted):
=if(B25="","",if(D25=$P$21,I25,I25*GOOGLEFINANCE(("currency:"&D25&""&$P$21&""))))

Current Value (currency converted):
=if(B23="","",if(D23=$P$21,J23,J23*GOOGLEFINANCE(("currency:"&D23&""&$P$21&""))))

Social Media (and other fun stuff): https://linktr.ee/dividendology

I am not a Financial advisor or licensed professional. Nothing I say or produce on YouTube, or anywhere else, should be considered as advice. All content is for educational purposes only. I am not responsible for any financial losses or gains. Invest and trade at your own risk. Some of the links in the description may be affiliate links.