TK Journal 2020-06-11

I watched our record­ing of using the QAV Mas­ter­sheet and saw a bug.

When I copied in the down­load data, I copied in all rows, but I should have copied in the data only. This would have left the first data row as row 13.

In col­umn AV, I test for the yield being greater than 3%, which is a test that refers to cell AV12.

In the QAV Down­load Data tab, over­writ­ing the entire spread­sheet has moved the head­ing row to be row 33, which throws out this test.

Luck­i­ly, the Watch­list tab still has the head­er row at row 12, so that works.

The fix is to delete some of the rows above the data in the first tab, so that the head­er row is always row 12, and in future only copy the data rows in from the down­load.

—

I raised a price alert in SD for AGL with a buy price of $19.70.