TK Journal 2021-05-28

Lis­ten­er Con­rad picked up anoth­er error in TK’s mas­ter check­list:

“On the TK Mas­ter Spread­sheet I noticed col­umn AN was work­ing sim­i­lar to the columns Tony recent­ly updat­ed (CB and AU).Currently col­umn AN “Is IV2>2* Share price?” will return a 0 if there is no future EPS.”

Tony says:

Yes, it is an incor­rect for­mu­la. I had left it there because it doesn’t make much dif­fer­ence. It means that some­thing like GLE has a qual­i­ty score of 13/13 instead of 13/12 because the blank future eps fore­cast was adding to the denom­i­na­tor as it is being record­ed as a 0 instead.

I’ll make the change.

The for­mu­la in col­umn AN at row 37 should now be:
=IF(I37=””,””,IF(AL37>=AM37,1,0))

This should be copied all the way through­out the col­umn.

There is a new Mas­ter Check­list spread­sheet with the changes made in Drop­box.

Thanks Con­rad!