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