Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Copy-Paste-Append Data in Real time

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    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

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  5. #5
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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


  6. #6
    New Member
    Join Date
    Feb 2004
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copy-Paste-Append Data in Real time

    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

  7. #7
    New Member
    Join Date
    Jan 2013
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copy-Paste-Append Data in Real time

    same problem as of milton.Could you post the code?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •