I have a data set of stock prices where each line represents a day and has a price.
For each row, I want to determine which condition is eventually met first: the price increased by 10%, or it decreased by 5%.
Can someone please help me with a formula (or formulas)? I have no idea of how to do this.
Date | Price |
---|---|
6/1/1987 | 122.35 |
6/2/1987 | 119.98 |
For each row, I want to determine which condition is eventually met first: the price increased by 10%, or it decreased by 5%.
Can someone please help me with a formula (or formulas)? I have no idea of how to do this.