If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Portfolio Question??
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
database design question | e-mid | Database Design | 9 | June 16th, 2004 09:42 PM |
Designing a question paper | Ken | New Users | 2 | April 28th, 2004 10:13 PM |
Question on Array Formula | John | Worksheet Functions | 1 | February 21st, 2004 05:40 PM |
Charting in a single cell question... | LSMark | Charts and Charting | 3 | January 8th, 2004 03:00 PM |
second question - vlookup table_array reference listed | James Dean | Worksheet Functions | 1 | December 12th, 2003 09:49 PM |