Hello! I’d like to share with you this free & lightweight dividend growth investor watchlist. For reference, my current watchlist can be found here.
I embedded a small visual indicator column next to the ticker – what I call the “tripwire” – when any of the stocks I’m keeping an eye on falls under a desired price that I want to pay. I also set it up so that I’ll get an email notification anytime this column changes color.
Next we’ll go over:
- How to set up the spreadsheet
- How to make it email you when a tripwire is activated
How to set up the spreadsheet
The first thing you need to do is get the watchlist spreadsheet and customize it to your needs.
1) Download the DGI automated watchlist spreadsheet here:
(Optional) if you use & like the spreadsheet, leave a review. I appreciate it!
2. As you’ll see, this is a very lightweight tracker that takes just a few minutes to set up. Fill in the ticker symbols you want to track in column B, then enter in whatever price you’d like to pay per share in column D. Everything should automatically populate once you enter the symbol.
If you don’t know what a fair price is to pay, you can always check with 3rd party services like Morningstar. Protip: You can get free Morningstar and analyst reports by holding a small balance at Capital One Investing.
Note: Columns F + G are optional. Feel free to delete these columns if you don’t have or won’t find this extra information helpful.
3. If you need more rows, simply copy the entire row at the bottom, and paste into the row beneath it. All the calculations will copy over as well.
Boom, done! You’re good to go and can sit around lovingly staring at your watchlist, embed it on your blog, or whatever else you want to do. When your tripwire turns green, you can spring into action – or not. Whatevver makes you happy.
If you want to learn how to have the tripwire send yourself automatic alerts, then read on!
How to make it email you when a tripwire is activated
The way we will do this is to use a Zapier integration to set up an integration between your Google Sheets and your email.
1. Go to Zapier and sign up.
3. Click on Make a Zap!
3. Click on Google Sheets
4. Click “Updated Spreadsheet Row” and continue.
5. Connect your Google Sheets Account. Click save and continue.
6. Select these options:
- Spreadsheet: Dividend Growth Investor Automated Watchlist by Dividend Ten
- Worksheet: Holdings
- Trigger Column: gsx$tripwire
7. Ignore everything on the next screen, click “fetch and continue.” Then when the test is successful, then click continue again.
Ok, so far so good. You set up the trigger, now you want to set up the action. In this case we want to email ourselves, but we could do all sorts of creative things, like slack ourselves, or make a Trello notification. For now, let’s just email ourselves. Click Gmail.
8. Select “Send Email” and continue.
9. Connect your gmail account. Click save & continue.
10. Fill out the email notification you’d like to send yourself. fill out the “required” fields:
- To: Entire your email address
- Subject: Stock watchlist tripwire notification! (or whatever you want the alert to be)
- Body: A notification to check your stock watchlist (or whatever you want to write to yourself)
10. Make sure the test gmail looks right to you, then click create & continue.
11. Give your great zap a name, and turn it on. You’re good to go and will start receiving email notifications when your tripwires are activated. Easy enough, right?
12. If you want, you can go back to your spreadsheet and test it by entering a different value that would trigger your tripwire. Be aware that there can be a delay in the email sending of up to a few minutes.
Now you should be all automated & set up.
Also note that Zapier has a free plan, and since this is a simple recipe, you should be good to go.
Finally, as always, information is provided ‘as is’ and solely for informational and entertainment purposes, not for trading purposes or advice. I am not a licensed investment advisor or investment professional. I make no representations as to accuracy, completeness, recentness, or validity of any information on this spreadsheet and will not be liable for any errors, omissions, or delays in this information or any losses, injuries, or damages arising from its display or use. Please do not rely on this data for tax purposes. Unless your investments are FDIC insured, they may decline in value. Please consult with an investment professional before investing any of your money.
So that’s it.
Was this watchlist/ info helpful? Did I miss anything? Anything you’d like to see different in the document?
Thanks for reading.