Advertisement
Problem with Standard Deviation and Avg. Trade Length stats
Jun 03, 2020 at 07:42
702流覽
1 Replies
會員從May 26, 2020開始
1帖子
Jun 03, 2020 at 07:42
Hello everyone! I have a problem with understanding two stats - Avg. Trade Length and Standard Deviation - and comparing them with values in my strategies.
1) It looks like Avg. Trade Length should be calculated as a sum of lengths of all booked trades divided by the number of trades. For example, for the attached example:
(9+8+5+5+9+9+41+10+11+309*60+9*60)/11/60 = 29 minutes
but in my profile it is displayed as 38 minutes, and I have checked that it does not depend on open trades.
2) According to the description of Standard Deviation, it should be calculated based on expectancy:
"Standard Deviation is a statistical measure of volatility. It shows how much variation or dispersion there is from the mean (Expectancy)."
But it doesn't look like true because my expectancy is changed on each interest change, while Standard Deviation remains unchanged. For example, the total profit is -371.27. Expectancy is -371.27/11 = -33.75.
But SD = sqrt( (-18.63+33.75)^2+(-11.01+33.75)^2+(-13.55+33.75)^2+(-1.1+33.75)^2+(-127.73+33.75)^2+(-3.65+33.75)^2+(-0.26+33.75)^2+(0+33.75)^2+(0+33.75)^2+(0+33.75)^2+(0+33.75)^2)/11) = 40.04154126
While the value in the profile = 35.64
Please help me understand where I am wrong.
1) It looks like Avg. Trade Length should be calculated as a sum of lengths of all booked trades divided by the number of trades. For example, for the attached example:
(9+8+5+5+9+9+41+10+11+309*60+9*60)/11/60 = 29 minutes
but in my profile it is displayed as 38 minutes, and I have checked that it does not depend on open trades.
2) According to the description of Standard Deviation, it should be calculated based on expectancy:
"Standard Deviation is a statistical measure of volatility. It shows how much variation or dispersion there is from the mean (Expectancy)."
But it doesn't look like true because my expectancy is changed on each interest change, while Standard Deviation remains unchanged. For example, the total profit is -371.27. Expectancy is -371.27/11 = -33.75.
But SD = sqrt( (-18.63+33.75)^2+(-11.01+33.75)^2+(-13.55+33.75)^2+(-1.1+33.75)^2+(-127.73+33.75)^2+(-3.65+33.75)^2+(-0.26+33.75)^2+(0+33.75)^2+(0+33.75)^2+(0+33.75)^2+(0+33.75)^2)/11) = 40.04154126
While the value in the profile = 35.64
Please help me understand where I am wrong.
附件:
會員從Mar 27, 2018開始
12帖子
Jun 03, 2020 at 10:39
It may just be that MYFXBook needs a few days to update the figures
*商業用途和垃圾郵件將不被容忍，並可能導致帳戶終止。
提示：發佈圖片/YouTube網址會自動嵌入到您的帖子中！
提示：鍵入@符號，自動完成參與此討論的用戶名。
