pao13
Member
Hi. First post here. Hope to have a pleasant stay. Now to my problem.
I have attached my spreadsheet. I have some closing prices of a stock and have already created a formula that results 1 if the stock falls by 10% or more and 2 if the third Friday of every odd month happens first. This is column H. When the "event" occurs this price becomes the "initial price".
I would like to have a table (grey area) so that when event in column H occurs (1 o 2) the cells in the table to have the date, the price and the volatility of that event.
ie 17/01/2014 27.39 18.79
03/02/2014 24.41 29.01
21/03/2014 22.31 37.52
Any help would be greatly appreciated.
I have attached my spreadsheet. I have some closing prices of a stock and have already created a formula that results 1 if the stock falls by 10% or more and 2 if the third Friday of every odd month happens first. This is column H. When the "event" occurs this price becomes the "initial price".
I would like to have a table (grey area) so that when event in column H occurs (1 o 2) the cells in the table to have the date, the price and the volatility of that event.
ie 17/01/2014 27.39 18.79
03/02/2014 24.41 29.01
21/03/2014 22.31 37.52
Any help would be greatly appreciated.
Attachments
Last edited: