Standard deviation in % terms

• 05/11/2023 at 1:39 PM #214544
  Alfy

  Good morning guys, is there any way you can build using the Standard deviation in % terms rather than just price terms? Any help much appreciated

  Thanks in advance

  

  Alfy

  Participant

  Topics: 34

  Replies: 53

  Been thanked: 5 times
  05/11/2023 at 3:53 PM #214555
  JS

  Hi @Alfy

  You can divide the standard deviation by the mean multiplied by 100…

  Standard Deviation %

  Mu = Average[n](Close) MuSquared = Square(Mu) XiSquared = Square(Close) xStd = SQRT(1/n * Summation[n](XiSquared) - MuSquared) StdPro = xStd / Mu * 100 Return StdPro as "StdPro"

  1 2 3 4 5 6

  Mu = Average[n](Close) MuSquared = Square(Mu) XiSquared = Square(Close) xStd = SQRT(1/n * Summation[n](XiSquared) - MuSquared) StdPro = xStd / Mu * 100 Return  StdPro as "StdPro"

  1 user thanked author for this post.

  Alfy

  

  JS

  Participant

  Topics: 22

  Replies: 1423

  Been thanked: 557 times
  05/11/2023 at 4:15 PM #214557
  Alfy

  Thanks so much for your help!

  1 user thanked author for this post.

  JS

  

  Alfy

  Participant

  Topics: 34

  Replies: 53

  Been thanked: 5 times
  05/15/2023 at 6:46 AM #214692
  JS

  Hi @Alfy

  The official name for this calculation is:

  Coefficient of Variation (CV)

  1 user thanked author for this post.

  Alfy

  

  JS

  Participant

  Topics: 22

  Replies: 1423

  Been thanked: 557 times
• Author
  Posts