Convert Excel RTDTo DDE or Import Live data from Excel

Discussion in 'AmiBroker' started by barnzee, Mar 19, 2008.

  1. barnzee

    barnzee New Member

    Joined:
    Mar 19, 2008
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Hello gentlemen,

    I have just discovered Amibroker and think it has amazing potential and am looking forward to my journey, however have encountered my first challenge.

    My broker supplies live data in Excel RTD format NOT DDE. This presents a problem as Amibroker's plug in is only compatible with DDE and NOT RTD.

    Therefore I am assuming I have two options:

    1. Have a script written to convert the data from RTD to DDE. (The RTD program I have from my broker is in VBA)

    2. Use excel as a DDE server for live quotes and configure Amibroker DDE accordingly


    I have countless hours trying to do the latter, and as I have no programming skills, I respectfully ask for any assitance with either option.

    I'm sure my problem is not unique. (Of course things would be much easier if Amibroker just released a RTD plug in. Afterall DDE was superceded in 2002 when Microsoft introduced RTD)

    Many thanks

    Barnzee
     
  2. NAVEEVIa

    NAVEEVIa Member

    Joined:
    May 11, 2006
    Messages:
    138
    Likes Received:
    7
    Trophy Points:
    18
    Sorry
    I have a question
    Can u plz tell about this RTD data, which broker is providing thia & are commodities quoted from MCX included
    One more thing suppose i want one min OHLC V data , so after every minute data is enterd in a new row , Is this possible?
    Thanks
    Naveen
     
  3. barnzee

    barnzee New Member

    Joined:
    Mar 19, 2008
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Hi Naveen,

    the broker is fpmarkets.com.au and the platform is iress (iress.com.au) in australia and is equities only. The RTD feed updates every time prices change in the same row. It does not add a new row.

    I can send the VBA project if you want to see it.

    regards

    Barnzee
     
  4. Raju

    Raju Well-Known Member

    Joined:
    Jul 1, 2006
    Messages:
    991
    Likes Received:
    507
    Trophy Points:
    93
    Hi barnzee ,
    Please confirm if it is .xls or .csv , as it seems to be same initially,but when u try to convert in req s/w e.g METASTOCK the issue appears.I am not aware of Amibroker .But in MS u have option of converting to MS format in Downloader section.If it is .xls , please tell us abt the broker who provides .xls format , even I may be interested in opening demat with him.
    Raju
     
  5. barnzee

    barnzee New Member

    Joined:
    Mar 19, 2008
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Hi Raju,

    I don't really understand what you are asking. The RTD feed is an excel add in that iress programmed. What I need to do is either convert this to DDE somehow or use excel (where I already have my live data) as a DDE server and use Amibrokers DDE plug in to read from excel. Unfortunately I don't know how to do either and was wondering if someone could help.

    I would imagine it would be easier just to use excel as a DDE server, but I need help configuring the AB plug in to read from excel
     
  6. rrdesai_goa

    rrdesai_goa Member

    Joined:
    Nov 11, 2005
    Messages:
    42
    Likes Received:
    2
    Trophy Points:
    8

  7. barnzee

    barnzee New Member

    Joined:
    Mar 19, 2008
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    I'm still lost if anyone has a coonection to excel could they please provide instructions or a screen shot of the AB dde plug in configuration.

    Many Thanks
     
  8. rgvinothkumar

    rgvinothkumar New Member

    Joined:
    Feb 7, 2008
    Messages:
    14
    Likes Received:
    1
    Trophy Points:
    3



    Hi

    BARNZEE

    If u get the software pls update me (vino_boys@indiatimes.com)
     
  9. rgvinothkumar

    rgvinothkumar New Member

    Joined:
    Feb 7, 2008
    Messages:
    14
    Likes Received:
    1
    Trophy Points:
    3
    Dear barnzee

    Can u send your VBA Project for me


    with regards
    R.Vinothkumar.

    vino_boys@indiatimes.com
     
  10. vepul

    vepul New Member

    Joined:
    Mar 5, 2008
    Messages:
    22
    Likes Received:
    4
    Trophy Points:
    3
    Hi,
    Can u send ur VBA project to me than i will make a "format: or :plugin: for u
    now a day 3 days vacation in mkt so if possible send me fast so i will makt is in my free time.
    Have a nice time

    pls send me on my mail vepuldamani @ y a h o o . c o . i n

    Vepul
     
    shanki99 likes this.
Loading...

Share This Page