I have just updated two spreadsheets:
1. Dividend History of all current stocks listed on the ASX, complete with franking %
2. Most recent dividends paid or known to be due, sorted by ex-div date
View attachment 66092
I use these sheets to alert me of upcoming dividends, also showing the amount of franking credits I could expect at my next Tax Return. It is then easy to work out the total yield relative to the latest share price, which in this case is yesterday's Close.
Note: the yield relates to the period for which the dividend is paid, usually half a year.
Due to size restrictions, I can only attach one of them (#2) because the complete history exceeds 1MB.
Feel free to download it and extract the info you are after: Number of companies with 100% franking vs unfranked and anything in between.