International Stock Tracker in Google Sheets! (Build Your Own!)
19 هزار بار بازدید -
2 سال پیش
-
Access Tickerdata and my Spreadsheets:
Access Tickerdata and my Spreadsheets: https://tickerdata.com/
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.
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.
2 سال پیش
در تاریخ 1401/08/16 منتشر شده
است.
19,069
بـار بازدید شده