Build an Automated Stock Watchlist in Google Sheets!

In this video, I take you step by step on how to build an automated stock watchlist in google sheets! Let me know if you have any questions in the commenrts down below!

Social Media (and other fun stuff):

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.

[Johnnytrades]

I love your spreadsheet. Looks great. I’m a numbers guy. So I’m so happy you made this

[splinx]

It says error when I try to input the dividend payout (5:45)

[DamienGGW]

any way to have current price to show up in a pacific color if its equal or greater than the 52 week low?

[ryanbayne]

Brilliant thank you - what do we do with "BA." as it doesn't seem to work as "BAE" or "BA" is Boeing Co 🤔

[paulevans]

Hi, is it possible to set an alert on Google sheets for when the stock price crosses a simple moving average? Say 50 SMA

[angrycarbonara]

New subscriber here! Love your videos! Do all your spreadsheets such as REIT valuation, ultimate stock valuation work for international markets as well?

[tomaszmazur]

Hi. Thank you sharing this tutorial! I have one question' If i would like to have Tickerdata visible (as an option) in my Google Spreadsheet's Extensions, i guess first of all i need to create my own account on TD? Is there any need of merging those two together? Sorry, if this type of questions, i'm new to the this stuff... thank you Tomasz

[zandertrinidad]

hey bud do you know how can i fetch data for Philippine Stock Exchange ?

[DeDagelijkseBelegger]

Hi, nice vid. I have a problem. I come from Europe and here we write $1.30 with a comma example $1, 30. So i can not get out the Div. yield. How can i change that? Now i must add another row and i fill every number with hand.

[thejudge]

Hi. Got as far as the tickerdata bit and then it does not work....comes up with an error. Iam Logged in. Signed up for ticker Put the formula in twice just in case I made a mistake. Still no joy. Suggestions please?

[bjorkthetree]

Dors this work for non-US stocks as well?

[dineshkewlani]

I downloaded 52 wee high low sheet on daily basis how to merge all sheet in one ?

[pauldiener]

any reason why AVG antivirus free software is refusing to allow Tickerdata to connect?

[JohnHenry-ne]

Do you prefer online brokerage to buy and sell dividends stocks? Please answer my question!!!!