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.
-
8:50
Good Kid Productions
16 hours agoWhy Soldiers Miss War - With Sebastian Junger (Convo)
24.1K4 -
LIVE
SNEAKO
10 hours agoSneako x Zherka back in Miami
6,877 watching -
4:02:35
Fresh and Fit
1 day agoWho Killed JFK: The Biggest Coverup In American History With Cory Hughes
166K102 -
31:53
Afshin Rattansi's Going Underground
22 hours agoMax Blumenthal: ‘TARGETED FOR EXPOSING ISRAEL’S LIES’- The Washington Post Attacks The Grayzone
31.5K13 -
8:36
Adam Does Movies
8 hours agoThe Bikeriders Movie Review - It's Not What You Think
40.8K7 -
1:00:52
Man in America
13 hours agoMartin Armstrong: The Need WW3 to Mask Dollar Collapse & Force CBDC
56.5K30 -
54:47
Alexis Wilkins
17 hours agoBetween the Headlines with Alexis Wilkins: Brilyn Hollyhand's Book, The Youth Vote IS Conservative
44.1K5 -
1:34:07
Kim Iversen
13 hours agoJaw Dropping Footage: Journalist Embedded Himself Within Israeli Nationalists At The Gaza Border.
78.4K142 -
1:46:50
Glenn Greenwald
11 hours agoComedian and Political Analyst Dave Smith on Uniparty Politics, Free Speech Since October 7th, and Libertarianism | SYSTEM UPDATE #287
85.4K179 -
2:00:26
Roseanne Barr
1 day agoDanger Close with Patrick Byrne Part 1 | The Roseanne Barr Podcast #53
98.1K128