We want a formula to continuously record the previous value of dde linked cells (real time feed).
say for example we have dde cell is a1 and the current value is 50 we want a formula in b1 that will record the previous value of a1.
now when the price changed to 45 b1 will hold the previous value that is 50 again when the price of a1 changes to 42 b1 will now hold the value 45 and so on...