In Progress

excel formula to to record previous value of dde linked cells

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...

Skills: Excel, Visual Basic, Visual Basic for Apps

See more: excel dde, excel record previous cell value, continuously record previous value dde linked cells, Value, time record, linked, excel formula, cells, excel feed price, excel record, record excel, price formula, real time feed, real time excel, previous, hold excel, excel real time, real time feed excel, price feed excel, excel price feed, dde visual, dde excel, time price excel, excel hold, excel dde feed

About the Employer:
( 8 reviews ) KOLKATA, India

Project ID: #4022373

3 freelancers are bidding on average ₹750/hour for this job


I have interest in r project. I have good experience with DDE in [url removed, login to view] i have good experience with macros in excel. Thank you.

₹750 INR / hour
(15 Reviews)

Please, refer to my private message to get my exclusive and cheapest bib.

₹750 INR / hour
(15 Reviews)

Let me do this for you.

₹750 INR / hour
(0 Reviews)