Is there an EFS file out there that would take the (High – Low) of the past 5 days and divided by 5 to see average movement?
Example:
...............Day1........Day2........Day3....... .Day4........Day5
High.........20............21............22....... .....23............24
-
Low.........19.50.......20.............21.50...... .22............23.50
------------------------------------------------------------------------
................0.5...+.....1......+.......0.5.... .+....1.....+.......0.5....=...3.5
3.5 divided by 5 = 0.7
It would return 0.7 (Which is the average movement for the past 5 days).
Thank you
Keto
Example:
...............Day1........Day2........Day3....... .Day4........Day5
High.........20............21............22....... .....23............24
-
Low.........19.50.......20.............21.50...... .22............23.50
------------------------------------------------------------------------
................0.5...+.....1......+.......0.5.... .+....1.....+.......0.5....=...3.5
3.5 divided by 5 = 0.7
It would return 0.7 (Which is the average movement for the past 5 days).
Thank you
Keto
Comment