Excel dynamic array problem

Hi its my first time posting here and any responses are greatly appreciated!!

The Problem::

I have a cell A1 which is a RTD link so it contains live data and is constantly being updated (prob 100 changes per min)

What i want to is record each change in data and display it as a column of prices but im having trouble with coding this.

Is this even possible does anybody know?

Cheers

Darb