Keep min with formulas

[alrodopial]

Hi everyone,
As BA updates odds is it possible using only formulas in a cell to keep the lowest odds of lets say cell B6 so far?
e.g in cell AA6 some formulas (other cells with formulas are also required) that shows the lowest price of cell B6 so far (this may happened 50 refreshes ago) .
I have the feeling that I saw it somewhere here but I can't find it.

[mak]

probably you search for this?
http://www.gruss-software.co.uk/forum/v ... =iterative

[silver]

To 'record' lowest odds appearing in cell F5, with the equation itself going in to cell AA5:

=IF(F5<=AA5,F5,AA5)

That's the basic structure. However, if you want to log several events in succession you would need to add a further clause/mechanism to reset the equation each time a new market loads, or it will continue to show the lowest odds from the last event ,if they are lower than the odds that are presently being logged.

There are many ways to add such a mechanism. For example, if your strategy allows you to log events up to the point where the market closes, you could use:

=IF($F$2="Closed",1000,IF(F5<=AA5,F5,AA5))

That should log lowest odds until the present market closes, at which point it will revert to 1000 until the next market loads.

I think these self-referential equations are maybe only possible in Excel 2007 onwards and you must enable iterative calculations in preferences.

[alrodopial]

Thanks guys, enabling the circular referencing will do the job.

My memory isn't great but I think when I read it I was amassed that something like this was possible without enabling the circular referencing.
But I may be wrong.