Excel trading model
Budget: $10 – $30 USD
I would like to model the returns in excel for a trading strategy. Can you do this?
Buy signal would be if the close price is >3% higher than the previous close AND the close price is above the 15 period simple moving average.
The sell signal would be if the next day (after the buy) closes below the buy price OR when the price closes below the 15 SMA.
I would like an excel model which calculates the daily position return if I put in 100 on day 1. You can use any stock data to run the calculation.
Buy signal would be if the close price is >3% higher than the previous close AND the close price is above the 15 period simple moving average.
The sell signal would be if the next day (after the buy) closes below the buy price OR when the price closes below the 15 SMA.
I would like an excel model which calculates the daily position return if I put in 100 on day 1. You can use any stock data to run the calculation.