Tweet
Hi,
I am doing some backtesting with the mini S&P 500 and am looking for some help with how to set up a formula to extract specific information over a 2 year date range.
I am using the MacD system as an indicator as to when to enter the market. As of now I am going back over the daily charts one day at a time to extract the specific entry points, highs, lows, etc. of each trading day. I would like to gather this information for a two year period and it would take me a very long time to do this manually.
Can anyone help me with setting up a formula to automatically pull the information that I am looking for over this time period?
Thank you!
I am doing some backtesting with the mini S&P 500 and am looking for some help with how to set up a formula to extract specific information over a 2 year date range.
I am using the MacD system as an indicator as to when to enter the market. As of now I am going back over the daily charts one day at a time to extract the specific entry points, highs, lows, etc. of each trading day. I would like to gather this information for a two year period and it would take me a very long time to do this manually.
Can anyone help me with setting up a formula to automatically pull the information that I am looking for over this time period?
Thank you!