update and store new high values

J

jack

I have an Excel add-in which continually updates the
prices and other date on stocks which I specify. I might
have a worksheet that looks like the following


Symbol MktPrice HighPrice
ABC $12.50 $13.90
MSFT $35.85 $65.20
TEL $18.99 $19.00


The prices in the second column are continually changing
as the data is refreshed.

How can I create a UDF which will replace the value in the
HighPrice column ONLY when the MktPrice is higher?

I know how to do this with a macro, but this requires
someone to run the macro when a new higher value is
seen. I'd like to have this done automatically whenever
the data changes.

Can anyone suggest a way to do this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro on a timer 2
Storing automatically updated data 1
Maintain lowest value in an "external connection" cell 0
Input a Value to Lookup the Data Series for a Chart 5
Delay while database updates 2
Excel formulation to automate values 3
a macro to count coloured values and copy.... 0
Update a Web Query and be able to change the WebAddress manually from a specific Cell 0

Top