I remembered that table for 34 days.
Tonight when the US stocks market opens, I couldn’t be bothered to check the charts, so I casually flipped through the rate table I’d written down. Starting from August 20th, not a single day was missed—34 entries.
When I got to the third row, I froze: the columns for the highest and the lowest were filled in backward. I compared with the current price going back, and in half the rows the current price was actually higher than the “highest price.”
In other words, half of the drawdown I’ve been talking about this month was calculated using the lowest price.
The cup of tea on my desk went from steaming hot to completely cold, and I just sat there smiling. I can calculate positions and fees for other people just fine—yet my own table was wrong for over thirty days, and not a single person noticed.
The unbelievable part is that I still don’t want to delete it now, thinking I can tweak it and still make it usable.
Have you ever stuck with something for a long time, only to look back and realize it was all for nothing? Tell me one. I want to know if I’m the only stubborn one.
#Data Perspective
Tonight when the US stocks market opens, I couldn’t be bothered to check the charts, so I casually flipped through the rate table I’d written down. Starting from August 20th, not a single day was missed—34 entries.
When I got to the third row, I froze: the columns for the highest and the lowest were filled in backward. I compared with the current price going back, and in half the rows the current price was actually higher than the “highest price.”
In other words, half of the drawdown I’ve been talking about this month was calculated using the lowest price.
The cup of tea on my desk went from steaming hot to completely cold, and I just sat there smiling. I can calculate positions and fees for other people just fine—yet my own table was wrong for over thirty days, and not a single person noticed.
The unbelievable part is that I still don’t want to delete it now, thinking I can tweak it and still make it usable.
Have you ever stuck with something for a long time, only to look back and realize it was all for nothing? Tell me one. I want to know if I’m the only stubborn one.
#Data Perspective
