Get info from changing cell to static cell

[Maxibo]

Hi, let me explain...

I have a link from the web which is a share price. I would like to record
the last 3 price changes and then average of all three. ( price changes can
happen in seconds or minutes)

I believe I am looking to copy the content initially as a static
value(cell1), when it changes to copy it to another static cell (cell3),
when it changes again copy this to another static cell (cell3)... I hope
this is clear enough

I can work out the average...lol

The next stage would be average of another change, cell 2 + 3 + 4 but lets
get the initial problem first...

TIA

 

[Maxibo]

It seems I need to paste ' special ' with just the value so there is no
reference to the original cell. Of course I could do an if statement if
value changes to ' paste special ' to the next cell.

Any ideas how I would automatically 'paste special ' just the value ? or any
other alternative?