R
Roger MacInnis
Portfolio Problem
Here is my problem; I keep track of a Stock Portfolio in a worksheet
collecting data using "Import External Data" - everything works fine. Now I
would like to save every successive high and be able to calculate any 20%
depreciation from the high.
The idea is to catch stocks that go up and then down by 20% from their high.
For example, if a stock cost $10.00 and goes to $30.00 and then to $24.00 I
would like to be alerted. Can this be done in Excel and how? Thank you.
Here is my problem; I keep track of a Stock Portfolio in a worksheet
collecting data using "Import External Data" - everything works fine. Now I
would like to save every successive high and be able to calculate any 20%
depreciation from the high.
The idea is to catch stocks that go up and then down by 20% from their high.
For example, if a stock cost $10.00 and goes to $30.00 and then to $24.00 I
would like to be alerted. Can this be done in Excel and how? Thank you.