jrarmstrong
03-31-2010, 09:35 AM
Hi,
I have been wrestling with this for a while and am hoping you can help.
I have a piece of trading software that can be connected to a spreadsheet. The software sends price data to cell A1 at various intervals between 0.1 and 0.5 seconds. Each time the price refreshes it overwrites the previous price in the same cell.
I have been trying to export the price data from that cell into new cells every half second (I do not need it more frequently) so that the price is copied into cell B1 , B2 , B3 etc so I end up with a single column containing a list of prices.
Is there a macro that will do this?
Apologies if this is a basic question.
Thanks,
James
I have been wrestling with this for a while and am hoping you can help.
I have a piece of trading software that can be connected to a spreadsheet. The software sends price data to cell A1 at various intervals between 0.1 and 0.5 seconds. Each time the price refreshes it overwrites the previous price in the same cell.
I have been trying to export the price data from that cell into new cells every half second (I do not need it more frequently) so that the price is copied into cell B1 , B2 , B3 etc so I end up with a single column containing a list of prices.
Is there a macro that will do this?
Apologies if this is a basic question.
Thanks,
James