Return cell contents during a time slot.

I have a spreadsheet to monitor 10 stocks. It is dynamically linked to another program which updates the stock value at every trade. I want to capture the sum total of the portfolio value at 9:30, 9:40, etc. and create a list of value vs time with a subsequen chart.

The problem is that whenever the time slot is not "TRUE", the value posted is "FALSE". I can not figure out a way to simply post the value and then forget it.

The formula I am using is: =IF(AND($F$24>F25,$F$24<F26),$H$18) where
$F$24 is the current time and $H$18 is the Total Portfolio value. F25 and F26 represent 9:30 and 9:40 respectively.

Thank to anyone for any help.

Tom

Tom,

Not clear what you want to do, but the equation you are using appears to do the do the following:

IF Current Time is greater than 9:30 AND greater than 9:40 (i.e. IF Current Time is greater than 9:40) then Cell value equals Total Portfolio Value. Also, since you have no 'ELSE' result defined in your IF statement, the IF statement is defaulting the ELSE result to 'FALSE'. You need to decide what the result should be IF the Current Time is not the time when you want the value to be updated.

Also, I think you may well need to resort to VBA for what you are trying to do - depends what you actually are after.

The formula that I origianlly used in cell H25 was:

=IF(AND($F$24>F25,$F$24<F26),$H$18,H25)

My thinking was that Excel would replace a blank cell with SHS18 when the time slot was "TRUE" and then when the next time slot was "TRUE", H25 would remain filled with the last update of SHS18. However all I got was a "circlar reference" error message, which makes sense.

A better definition of what I am trying to do is this:

I want a column of portfolio values filled out in 10 minute intervals. A particular cell in this column should be:

1. Blank if greater than the current time.
2. Contain the portfolio value during the current time.
3. Contain the last portfolio value if less than the current time.

I hope this makes more sense.

Again, thanks for any help.