Improved average weekly equity calculations

AsstModerator

FPA Forums and Reviews Admin
Messages
5,745
Originally the weekly equity for performance test was just the total gain or loss divided by the number of weeks. Then FPA member MikeDnC pointed out the flaw in this logic. He wrote...

The Performance Tests section has been of great use to me. However today I noticed that the "avg equity per week" stat is miscalculated. For example, take RoboMiner ( RoboMiner Metatrader Expert Adviser Performance Test by Forex Peace Army. ):

Gross Equity is 56.36%, therefore average equity per week is 1.77%.


Check:

{1.0177 per week} ^ {25.5 weeks} ~= {1.564 times your money} .

Therefore the reverse formula should be used to go backwards and calculate the the {per week} part:
{per week} = {times your money} ^ (1 / {weeks}).


Thanks for a site that stands out on the internet as awesome.

Being a little less mathematically inclined, I decided to try this with a simpler calculation to verify the problem...

If a service has been running for 10 weeks and doubled the account (initial balance * 2), this would be a 100% gain. Under the old calculations, the average weekly equity would be 100% / 10 weeks = 10% per week.

The problem is that if an EA, Signals Service or managed account was making 10% per week, that would be compounded. 10 weeks would be the initial balance times 1.1 ten times...

Initial balance * 1.1* 1.1* 1.1* 1.1* 1.1* 1.1* 1.1* 1.1* 1.1* 1.1 = Initial balance * 2.59, not times 2.

The original method seemed like an easy way to calculate the weekly equity, but it was wrong. After smacking the programmers a few times with my stapler, they agreed to look into incorporating compounding into the weekly equity calculation. When they didn't get it done after a couple of weeks, I cut off the beer supply to the dungeon where I keep them locked up. Two days later, it was done.

The average number of pips per week is not affected by this. Pips don't compound.

My deepest thanks to MikeDnC for helping the FPA to further improve the performance.
 
Back
Top