Dividend Ten

Freelance & personal finance journal

Odds & Ends, Watchlist

Google Sheets Dividend Stock Watchlist With Automated Email Notifications

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.

Dividend Growth Investor Automatic Watchlist by Dividend Ten

Next we’ll go over:

  1. How to set up the spreadsheet
  2. How to make it email you when a tripwire is activated

[divider]

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.

DGI Spreadsheet GDrive

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!

Zapier Sign Up

3. Click on Google Sheets

Zapier Google Sheets

4.  Click “Updated Spreadsheet Row” and continue.

Set up DGI spreadsheet with Zapier

 

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

Dividend Investing Spreadsheet Set up with Zapier

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.

Dividend Set Up Zapier Continued

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)

Dividend Investing Google Sheets Zapier

10. Make sure the test gmail looks right to you, then click create & continue.

Test gmail

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?

DGI Tripwire On

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.

[divider]

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.

2 Comments

  1. Wow cool tutorial! For FMV you could also use gurufocus they provide 4 or 5 different values

    • Greg Gee

      Cool, thanks. It looks like a premium membership is needed to access this info, unless I’m missing something.

Leave a Reply

CommentLuv badge

Theme by Anders Norén