TK Checklist Error #1.

Mark Dugmore picked up an error in v3.7 of TK’s checklist:

I think I have picked up an error in the formula in Column BJ of the first tab of the spreadsheet.
It should read as follows;
=IF(Q13=”Star Income Stock”,0.5,IF(Q13=”Star Growth Stock”,1,IF(Q13=”Borderline Star Stock”,1,IF(Q13=”Borderline Star Stock and Star Income Stock”,1,IF(Q13=”Star Growth Stock and Star Income Stock”,1.5,0)))))
…and not this.
=IF(Q173=”Star Income Stock”,0.5,IF(Q173=”Star Growth Stock”,1,IF(Q173=”Borderline Star Growth Stock”,1,IF(Q173=”Star Borderline Star Growth Stock and Star Income Stock”,1,IF(Q173=”Star Growth Stock and Star Income Stock”,1.5,0)))))
Cheers,
Mark
I’ve fixed it in v3.8.
_______________________________________________________________________________________________________
Duxton Water (D2O) has just gone above its buy price and is added to the watchlist as a Buy with a QAV score of 0.11
_______________________________________________________________________________________________________
I like reading the Dogs of the Dow article each year as a starting point for thinking about value investing.
It’s not part of my investment process, but it does embody the concepts that we use: Contrarian investing and regression to the mean.
This list only shows top 100 ASX companies and this list underperformed in 2019, but on average beats the market.
Regards,
TK
_______________________________________________________________________________________________________
From Damstra:
Unlocking the Vault
To read this Report click here (14 pages)
DTC announces the acquisition of the listed VLT and above expectations results for FY20.
_______________________________________________________________________________________________________
TK v3.7 Checklist Error #2:
I found another error in the QAV Master spreadsheet.
This time in column BK.
The formula that checks for price < SD IV or Consensus target should be:
=IF(M13=””,IF(L13<=100,1,0),””)
Fixed in v3.8
_______________________________________________________________________________________________________
What? A free weekly investing newsletter? Oh yes please.

Every Monday we publish a newsletter with updates on our podcast and portfolio activity. Sign up now to get your copy completely free!