Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a spreadsheet that monitors the opening time of some stocks. In the
morning before trading starts it looks like this: Stock TIME QQQQ-O 2/15/06 AAPL-O 2/15/06 GOOG-O 2/15/06 CSCO-O 2/15/06 SPY-A 2/15/06 When trading starts, the TIME value records the time of the last trade, thus the first time will represent the time of the first trade - I am trying to capture this time value. The problem is that if another trade occurs, the TIME value updates to the time of that last trade. The TIME value is fed by a DDE link from a data source. Is there a way to capture the "first" change in the TIME value ? Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Change sheet name in formula | Excel Worksheet Functions | |||
How to change a visible formula into a value? (Quickbooks download | Excel Worksheet Functions | |||
Cannot change a formula | Excel Discussion (Misc queries) |