Moving average for highest & lowest price

 

Hi all,


I would like to get matched moving average of highest & lowest price for each day.

Example: Highest price for yesterday is 1.2

20MA= 1.15, 21MA= 1.22

I want to get the nearest MA that match with the highest price automatically which is 21MA.

Is it possible to do that?


Thank you.


Add-on: I don't need a chart. I just need the number shows on the respective date e.g. High= 21MA, Low= 15MA for 17/3/2017

 

Forum on trading, automated trading systems and testing trading strategies

Welcome,

  • Usually people who cannot code do not receive free help on this forum, although it could happen if you are lucky. Be patient.
  • If you show your attempts and describe your problem clearly, you will most probably receive an answer from the community.
  • If you do not want to learn to code, that is not a problem. You can either look at the Codebase if something free already exists, or in the Market for paid products (also sometimes free).

Good luck. 

Reason: