I have a data stream live from the market. I need to have the data stream number continuously updating.
I need another number that will update with the first when it is increasing ,but not update when it is decreasing.
The first number is the ask price. the second number is going to be the sell price. when the ask price is rising I want the sell price to rise, but when the ask price is decreasing I want the sell price to stay where it is.
I have tried this using IF functions and ran into circular references. I can not change the auto iterate function in the etrade excel mgr. I can not use VBA in the etrade excel mgr. I can only use formulas and functions.
I will appreciate any help.