Thursday, November 11, 2010

Adjustment to trade log projection calculation

While working on some potential enhancements to the performance log template tonight, I uncovered an error in the average trade length calculation (which is a hidden formula) - if an individual trade had been closed several weeks ago, it was treating it as still being open, and therefore still increasing the trade length. This meant that this metric was being overstated, and therefore adversely affecting the figures on the 'projection' tab.

It's a good job I'm a better trader than Excel programmer...

Apologies to all.

No comments:

Post a comment