Source Post

I Built The Best Dividend Stock Watchlist (Google Sheets & Excel)

Dividend DataApr 17, 2026

The creator introduces a free dividend stock watchlist spreadsheet for Google Sheets and Excel that automatically updates with live market data. The tool includes a yield target tracker to identify buy opportunities based on desired dividend yields and a yield history tab to analyze historical dividend yields for optimal entry points, using PepsiCo as an example.

Linked Mentions

Tickers discussed in this post

MSFTNeutralLow ConvictionResearch Only

Microsoft is used as an example for entering tickers into the dividend watchlist tool.

ADPBullishHigh ConvictionSignal-backedPrimary

ADP is currently showing deep value, trading at the 97th percentile of its historic dividend yield.

PEPNeutralLow ConvictionResearch Only

PepsiCo's dividend yield history is analyzed to find optimal entry points, with the 90th percentile being a target.

MOBullishMedium ConvictionSignal-backedSecondary

MO is a buy when its dividend yield reaches 6% or higher, with 6.75% being a strong indicator.

Linked Signals

Tracked calls opened from this post

ADP
buy opened Apr 17, 2026
+16.39%