Getting Started

Before you can apply the criteria framework, you need a list of candidate stocks to analyse. This page explains how to find and import them.

Finding stocks for your radar

It is strongly recommended to use multiple data sources and cross-check them against each other. Calculated metrics such as PE ratio, dividend yield and forward earnings forecasts can vary significantly between providers depending on their methodology.

Your broker’s stock selector tool — most major Australian brokers include a basic screener
Yahoo! Finance screener — useful for forward annual dividend yield and EPS data
Wallet Investor — forward dividend yield and short-term price forecasts for ASX stocks
Simply Wall St — current and 3-year dividend yield forecasts; free account tracks up to 5 stocks
Market Index ASX Workbook — a weekly downloadable Excel file covering the top 500 ASX stocks. Free account required. An excellent starting point for building your initial radar.

Cross-check your data. There are several different conventions for calculating PE ratio, dividend yield and “current year” dividend forecasts — some providers use calendar year, some use financial year, some use the last two dividends paid. Never rely on a single source for a buy decision.

Importing data into Excel with Power Query

Using Excel’s Power Query Editor, you can import data from the ASX Workbook or other sources and automatically extract only those fields relevant to your criteria — ticker, price, PE ratio, dividend yield, market cap, EPS and forward yield. This eliminates manual data entry and ensures your radar is refreshed consistently each week.

Stocks filtered by criteria using Excel Power Query

Using Excel’s Power Query to import the ASX Workbook and filter only those stocks that meet the initial radar criteria — market cap, dividend yield and consistency.

What to look for initially

When scanning for candidates, focus first on the two radar criteria:

Market capitalisation > $500m — filter out smaller, less liquid companies first
Grossed-up dividend yield > 11.13% — only track stocks where the forward income is above the grossed-up target rate of 11.13% pa

Once a stock is on your radar, it stays there permanently — even if you sell it or it temporarily fails the criteria. This allows you to monitor whether it recovers and becomes attractive again, and to track its long-term dividend history for context.