DDE Links to Excel

Forums › ProRealTime English forum › General trading discussions › DDE Links to Excel

Viewing 9 posts - 1 through 9 (of 9 total)
  • 11/26/2022 at 11:19 PM #204876
    Canoehq

    May I ask, do any of the 3 broker trading accounts PRT promotes (Saxo, IB and IG) offer DDE linking of real time data to an excel spreadsheet via their own broker versions of the PRT software ?

    Many thanks indeed for any kind help anyone can offer.

    Regards

    11/26/2022 at 11:56 PM #204880
    JS

    Hi @Canoehq

    There is already a lot of information on the forum about “DDE -Links”…

    Maybe here are all your answers…

    1 user thanked author for this post.
    avatar Canoehq
    11/27/2022 at 12:06 AM #204882
    Canoehq

    Thank you, yes. Unfortunately, I did notice that many of those posts were from a number of years ago and as time has now moved on, I wondered if someone knew if the situation had changed / improved ?

     

    11/27/2022 at 11:33 AM #204885
    JS

    Hi @Canoehq

    I don’t use DDE links, maybe there is someone on the forum who uses this and can say something about it…?

    11/27/2022 at 3:56 PM #204896
    PeterSt

    Hi @Canoehq,

    I am not sure what your question is about specifically (to me it reads a kind of ambiguously) but

    • The DDE links works as advertised for the PRT-IB platform (PRT with broker IB). However :

     

    I never could find any use case for it, because when you read the texts here and there literally … it is for “quotations” of prices. And Yes, that is what you can do with it. So your spreadsheet will show the changed prices in pretty real-time (read : at the same moment the prices show in the charts ort lists (maybe a couple of ms later) the price appears in Excel too).
    And then what ? Then it shows the same data you already have on-screen per that List ?

    If only someone got the brilliant idea that it could show the data from e.g. the portfolio. But sadly it only works from Lists you have on screen. And Lists are just Lists. One exception : you determine what is in a List, so the Excel forms from that List. And careful : as far as I recall from one List only (you might have several on screen).

    Maybe @Nicolas can describe what this can actually be used for. Technically it is such a nice feature …

    Btw : https://www.prorealtime.com/en/help-manual/dde-data-export

     

    1 user thanked author for this post.
    avatar Canoehq
    11/27/2022 at 4:56 PM #204907
    Nicolas

    Technically, you can use the DDE data as you want: store them in a database, take action upon quote condition in Excel or whatever software you want, …

    1 user thanked author for this post.
    avatar Canoehq
    11/27/2022 at 5:19 PM #204908
    Canoehq
    Nicolas wrote:

    Technically, you can use the DDE data as you want: store them in a database, take action upon quote condition in Excel or whatever software you want, …

    Thanks Nicolas, that is extremely kind of you to confirm and just what I wanted to hear.

    I was asking because the last time this issue was raised on this forum, the answer given was ‘the DDE download function was only available and operating correctly via an account held directly with PRT, but did not work via the broker versions from IG/IB etc.

    However, as your answer mentions ‘technically’, does that imply there is a chance that the DDE download may not operate via the IB version ?   My thinking is that I don’t want to go through all of the hassle and rigmarole of opening accounts at IG and IB to access their versions of PRT, only to find this effort has been wasted because they have somehow restricted the DDE part of PRT in some way, so that it does not operate as it should.

    Once again, many thanks indeed for your kind responses everyone.

    11/28/2022 at 9:14 AM #204929
    Nicolas

    Works fine with a PRT Trading/IB account (see attached picture).

    Open account through this page: https://trading.prorealtime.com/en/InteractiveBrokers

    11/28/2022 at 9:21 AM #204933
    Canoehq
    Nicolas wrote:

    Works fine with a PRT Trading/IB account (see attached picture).

    Open account through this page: https://trading.prorealtime.com/en/InteractiveBrokers

    You’re very kind and much appreciated.

    I’ll head over to IB then.

  • Author
    Posts
Viewing 9 posts - 1 through 9 (of 9 total)

Find exclusive trading pro-tools on ProRealCode Marketplace

Similar topics:
thousand separator and excel

Create your free account now and post your request to benefit from the help of the community
Register or Login