i have a spreadsheet in which i have a live bloomberg feed
providing price updates. i'd like to store these prices
as they come in so i can calculate amoving average.

i tried to put some code in my worksheet_change event but
it doesn't pick up price changes from the feed. i am
guessing this is because the cell where the value appears
to be changing actually has a formula in it. since the
formula stays the same, excel isn't recognizing the new
values that come in as worksheet changes.

has any one worked with this before? is there a way to
track the changes so i can keep an average thanks for
your help.

sarah

What version of Excel. xl2000 and later should fire the change event I
believe.

Regards,
Tom Ogilvy

sarah wrote in message
...
i have a spreadsheet in which i have a live bloomberg feed
providing price updates. i'd like to store these prices
as they come in so i can calculate amoving average.

i tried to put some code in my worksheet_change event but
it doesn't pick up price changes from the feed. i am
guessing this is because the cell where the value appears
to be changing actually has a formula in it. since the
formula stays the same, excel isn't recognizing the new
values that come in as worksheet changes.

has any one worked with this before? is there a way to
track the changes so i can keep an average thanks for
your help.

sarah