Excel Help - Back test some data
hoping someone can help me out with this no doubt trivial problem
I am trying to back test some data in excel and getting the exit to determine profitability of a trading system is proving quite difficult, hoping someone with better excel skills can help with this .
So I want to enter the position say if the closing price on day 0 is below say the 20 day simple moving average, which is simple I get how to figure that out, but the exit of the system is a little more complicated I want to exit on the first profitable day.
so say the first day after is positive then I would want to exit then at the closing price, if it is not positive I would hold out until day 2 and exit then.If day 2 is positive (from your entry price on the close of day 0) . If day 2 is not positive then is goes to day 3 etc until you get a positive exit or 10 days pass in which case you would just sell and take a loss if that is the case.
I appreciate any input, I have been trying to do this if multiple if statements just cant get there.
I think you can do this in VBA with some programming.
If statement with an "ISERROR" condition to restrict to non-negative might work if you don't want to do VBA.
Commodi est hic culpa. Et fuga quae dolor voluptatem sapiente iure. Officia similique officiis id repellat ipsum voluptas cum. Veritatis sed explicabo esse est delectus dolores est. Eum dolor impedit eum provident tempore.
Voluptatem qui voluptatibus laboriosam at. Accusantium et perferendis beatae sed. Vel ab consectetur nesciunt temporibus id occaecati. Velit in et ab quo non.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...