Dear members
I am struggling to do the following in Excel.
I am testing stock trading strategy.
I have generated variable Trade_1. It takes value 1 for buy signal and -1 for sell.
My next step is to generate Trade_2. It is almost the same as Trade_1. The only difference is that I need to replace any signal with =. for the following 10 days.
In other words after a first buy/sell signal one should wait for the next 10 days and ignore any signals within this period.
The column I is my objective. The signals in red cells I deleted manually to show my end goal.
I have to do it over 100 stocks so the prosess should be automated to reduce human error.
Any tought how to do it?
Thank you.
Lena
I am struggling to do the following in Excel.
I am testing stock trading strategy.
I have generated variable Trade_1. It takes value 1 for buy signal and -1 for sell.
My next step is to generate Trade_2. It is almost the same as Trade_1. The only difference is that I need to replace any signal with =. for the following 10 days.
In other words after a first buy/sell signal one should wait for the next 10 days and ignore any signals within this period.
The column I is my objective. The signals in red cells I deleted manually to show my end goal.
I have to do it over 100 stocks so the prosess should be automated to reduce human error.
Any tought how to do it?
Thank you.
Lena
Last edited:
