Referencing an updating cell by determined time.

[voltrader]

Hey all,

I have a data feed, that provides a constant changing stock market price. I am trying to capture the price every hour to a different cell.

For example
Cell with data feed, feeds prices "100.00,100.01,100.20,101.00 " between time frame of 9:30-12:30.

I am trying to format the data to look like:

Time Price​

Cell1 9:30 100.00
Cell2 10:30 100.01
Cell3 11:30 100.20
Cell4 12:30 101.00

Any thoughts / direction out there?
Regards,
Elliot.