LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carl
 
Posts: n/a
Default Capturing The First Change in a Formula

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
I Need a formula to evaluate a cell with + or - values Bob in Oklahoma Excel Worksheet Functions 6 October 31st 05 02:41 PM
Change sheet name in formula kojimm Excel Worksheet Functions 4 July 15th 05 11:43 PM
How to change a visible formula into a value? (Quickbooks download Carrie Excel Worksheet Functions 2 May 30th 05 04:14 PM
Cannot change a formula Richard F Excel Discussion (Misc queries) 1 January 18th 05 01:57 AM


All times are GMT +1. The time now is 02:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"