Copy-Paste-Append Data in Real time

[Milton]

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

[Tom Schreiner]

Where are your external link(DDE) values going to be placed?

Which cells for Date, Time, Price, Volume?

Give me the sheet name and cells for each of the above and I'll write you a macro.

Let me know if you are familiar enough with Visual Basic to edit the macro and will not need detailed instructions...
Thanks




[ This Message was edited by: TsTom on 2002-03-21 05:38 ]

[Milton]

Dear TsTom
Thanks for your prompt response

The external DDE link automatically updates the spreadsheet, once I setup the connection between it and excel which is easy to do

Date cell is at: A6
Time cell is at: B6
Price cell is at :C6
Volume is at 6

They can be at any cell to suit , EG any line, be it Line 10,line 20 etc, or can be in another sheet if required

Sheet name is called :Tick Data

I am personally not sufficiently familiar with Visual Basic to edit the macro, however I can discus this with a family member who will assist in this respect.
My preference is to receive a more detailed instruction so I can better understand and increase my knowledge, however I certainly do not wish to impose on what already is a generous offer.
Would be prepared to contribute toward your expense for this if necessary, or take it as it comes
Either way, will leave to you to decide

Do really appreciate this help

Regards

Milton Cooper

[Tom Schreiner]

Don't want any money...
This is fun and I wish I knew this kind of help was available when I started out...

I can either E-Mail you a completed Excel Workbook or paste the code in here...

Will be easier just to E-Mail it and it will be ready to use

If you do not want to post your E-Mail then just email me at

TsTom@hotmail.com and I'll send it to you.

[Ivan F Moala]

If you are going to code this using the Sheets change event then I'm not sure it will
fire on a DDE link for excel 2002.
If not then just reference the data cells
to another cell and use the Sheets calculate
Event.


Ivan

[hiattj]

I know this post is a couple of years old but I hope you all are still familiar with it. I have the same question that Milton had and was wondering if someone could help me with setting up a macro. I receive bond quotes to excel from a DDE Link and would like to create a spreadsheet that does the following:

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

Would any of you know how I might go about doing this?? Any help would be much appreciated.

Jason