Hi All
I hope I havn't duplicated this request
I have real time share price Tick data into my computer. Via a DDE link,and have
set up an excel spreadsheet with one symbol only
It updates: Date, Time,Price,Volume across the 4 columns in one line
Whenever there is a change to price or volume, it updates in the existing
cells,overwriting the previous price or volume and time
What I am after is a way to:
IF PRICE CHANGES,automatically copy/append....date,new time,new price,volume,to the next spreadsheet line
IF VOLUME CHANGES, immediately update(add new volume to previous volume and leave this updated volume in the same cell(continue adding new volume transactions until)there is a price change,whereby a new line of info is created for all,namely...
Date, Time,Price,Volume
Continue automatically updating in real time,creating a large spreadsheet
There could be several price or volume changes every few seconds in busy periods
Have Excell 2002
Maybe someone could help or point me in the right direction
Thanks kindly
Milton Cooper
I hope I havn't duplicated this request
I have real time share price Tick data into my computer. Via a DDE link,and have
set up an excel spreadsheet with one symbol only
It updates: Date, Time,Price,Volume across the 4 columns in one line
Whenever there is a change to price or volume, it updates in the existing
cells,overwriting the previous price or volume and time
What I am after is a way to:
IF PRICE CHANGES,automatically copy/append....date,new time,new price,volume,to the next spreadsheet line
IF VOLUME CHANGES, immediately update(add new volume to previous volume and leave this updated volume in the same cell(continue adding new volume transactions until)there is a price change,whereby a new line of info is created for all,namely...
Date, Time,Price,Volume
Continue automatically updating in real time,creating a large spreadsheet
There could be several price or volume changes every few seconds in busy periods
Have Excell 2002
Maybe someone could help or point me in the right direction
Thanks kindly
Milton Cooper