Min & Max of a dynamically updating cell value


G

Guest

I am somewhat new, so please bear with me if I ask a question that you
talented folks are prompted to say "Duh!"
I have a spreadsheet that is dynamically updated from a quote service
(Bloomberg). The spreadesheet has a cell that calulates a simple yield
spread between two securities. I would like to have another cell display the
minimum spread displayed during the day and a second cell display the maximum
spread during the day. I have tried the MIN & MAX functions, however they
seem to be oriented to find the mim and max of an aray not a dynamically
updating cell value.

Now the question; Can the canned Excel functions (like MIN & MAX) be used,
or is this something that requires a VBA routine to periodically sample the
value and compare it to the maximum (or minimum) for the day, and if
different (higher or lower) update the cell and the daily (high and low) test
value? If standard functions can be used, could you please include a syntax
example listing? Thanks in advance for any help!
 
Ad

Advertisements

Ad

Advertisements

G

Guest

Thanks Ivan--looks like there are several examples to learn from and perhaps
modifiy to fit my needs.
Thanks!
Dave LeVeck
 

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

Top