Capturing and freezing values from a floating calculation window

[SDruley]

I have a column of values that keeps changing based on a web query. If we could take a movie of it it would look as follows (based on the first 5 columns below):

__1 #N/A #N/A #N/A #N/A ____________________ 1
#N/A 1.1 #N/A #N/A #N/A ____________________ 1.1
#N/A #N/A 2.3 #N/A #N/A ____________________ 2.3
#N/A #N/A #N/A 1.8 #N/A ____________________ 1.8
#N/A #N/A #N/A #N/A 0.9 ____________________ 0.9
#N/A #N/A #N/A #N/A #N/A ___________________#N/A

My hope is that we can capture the number in the helper column to the right. How do I approach this?

Please note that the first 5 columns of data are actually only one column. We are simply trying to show what the first column would look like over a period of a few seconds.

[SDruley]

I have come to the conclusion that the cells in the helper column (to the right) can not manifest anywhere on the worksheet through the use of a function. I guess I knew this but forgot. So, the only other way of creating this helper column is by using some sort of refresh event to passively trigger a subroutine or to actively engage a subroutine to create the column of values. I have changed my stock market interface to xlq (Qmatix). It is a C++ app that places values into Range C as described in my previous thread.
My primary challenge remains and that is to create the helper column consisting of values and not formulas.The values are then thought of as frozen since they are not affected by calculation. The purpose behind the freeze is to ensure that algorithmically generated BUY SELL signals are not subject to calculation and retroactive change. There must be a way to do this

[zbor]

Try:

=LOOKUP(99^99, A1:A5)

and pull down

[zbor]

For freezing you'll need to include macro... But you'll need to give further info on what basics to freeze: MAX value, AVG value, in x columns last x values etc.

[SDruley]

I have been able to solve this problem in a simple manner by setting up simple formulas in the column to the right, then when the update appears in the column on the left, i simple knock the "=" signs out from under them