TK Journal 2020-07-09

by | Jul 9, 2020 | Blog, TK-journal | 0 comments

TK Check­list Error #1.

Mark Dug­more picked up an error in v3.7 of TK’s check­list:

I think I have picked up an error in the for­mu­la in Col­umn BJ of the first tab of the spread­sheet.
It should read as fol­lows;
=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 Bor­der­line 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.
_______________________________________________________________________________________________________
Dux­ton Water (D2O) has just gone above its buy price and is added to the watch­list as a Buy with a QAV score of 0.11
_______________________________________________________________________________________________________
I like read­ing the Dogs of the Dow arti­cle each year as a start­ing point for think­ing about val­ue invest­ing.
It’s not part of my invest­ment process, but it does embody the con­cepts that we use: Con­trar­i­an invest­ing and regres­sion to the mean.
This list only shows top 100 ASX com­pa­nies and this list under­per­formed in 2019, but on aver­age beats the mar­ket.
Regards,
TK
_______________________________________________________________________________________________________
From Damstra:
Unlock­ing the Vault
To read this Report click here (14 pages)
DTC announces the acqui­si­tion of the list­ed VLT and above expec­ta­tions results for FY20.
_______________________________________________________________________________________________________
TK v3.7 Check­list Error #2:
I found anoth­er error in the QAV Mas­ter spread­sheet.
This time in col­umn BK.
The for­mu­la that checks for price < SD IV or Con­sen­sus tar­get should be:
=IF(M13=””,IF(L13<=100,1,0),””)
Fixed in v3.8
_______________________________________________________________________________________________________

Submit a Comment

Your email address will not be published. Required fields are marked *

Secret Link