Copy-Paste-Append Data in Real time

Milton

New Member
Joined
Mar 20, 2002
Messages
2
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
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
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
 
Upvote 0
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 :biggrin: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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,243
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top