How to get real time excel data into Amibroker through DDE.

Hello everybody,
[Note: Now we have recently released a software called Real Time Feeder, which updates RealTime, IEOD and EOD data to Amibroker. Before reading this article just check it out our software, it will help you.]
Are you searching to get real time data for free? if so then stop searching because you are in a right place. In this article I will explain you to get real time data from excel to Amibroker software. Now most of trading software support to exports its watch list to excel file i.e. you can get the real time changing tick data in excel file. If your trading software support this facility then it is easy to get these data to Amibroker. Now I will explain you to how to do this,

1)First you have to do is, create a watch list of stocks (If your trading software saves your watch list as it is for future then I would suggest you to create a watch list of   those stocks which you are tracking because you need not to do all these work every day if you do so). In watch list we just need latest price and latest quantity because presently available DDE plugin takes time from your system. Then copy your watch list from your trading software and paste it into excel file. It looks like bellow image:

(In above image you can see the exchange name, it not necessary to get the data; I just created it for my reference)
2) Then you have to define name for all the cells of latest price and quantity in excel sheet.
To define the name for latest price, select the latest price cell then select “Formulas” from above section of excel sheet, in that you can see a define name option, select that, a box will appear called “New Name” in that type a name like this “Stock Name”_P ( _P is common for all the names, I have entered here “stock name” for there you have to enter a specific stock name like this ADANIENT_P  for Adani Enteprises. AMBUJACEM_P for Ambuja cement). Look at the bellow image:

Like this do this for all the cells of latest price column.
3) Then you have to repeat all the steps to name the latest quantity column. Do the same procedure and name it as like this “Stock Name”_V  like I said above _V is common for all the stocks, I have entered here stock name for there you have to enter a specific stock name like this ADANIENT_V for Adani Enteprice. AMBUJACEM_V for Ambuja cement). Look at the bellow image:

Like this do this for all the cells of latest price column.
After naming of each cell, if you check the cell it looks like this,


Remember naming is very important because Amibroker takes the stock name as you have entered (It takes only stock name, it will not take _P or _V).

After that you can close the other two excel sheets and change the current sheet name as NSE the close the file and save it as NSE.
4) Now we have to do some settings in Amibroker, for that open your AMibroker and go to File>Database setting, the database setting window will appear, in that select the “DDE universal data plug-in” for data source in drop down menu as mentioned in bellow image:

After that change the number of bars to “50,000” and base time interval as “Tick” and select “configure” like bellow image:

In configure DDE plugin window select the preset as “generic 2” like bellow image:

Then name the DDE server as “EXCEL”
In DDE field definitions, name the Last box as NSE!{Ticker}_P
In Last size box name it as NSE!{Ticker}_V and clear all other boxes because we don’t need that and press ok.

If you need any intraday setting, then you can make it in intraday setting window like bellow image:



Then press ok to database setting window. After these settings you can see the plugin states as WAIT in  Amibroker like bellow image:




5) After that go to Window>Symbol Information, Information window will appear, in that select “use only local database” and make it No. You have to do this for all the stocks which you want to get real time data. 
     


6) Then in the window>Real time quote, Real time Quote window will appear like bellow image:
                                                               


7) Then go to Symbol>Real Time Quote>Add selected symbol. You have to add all the stocks to real time quote window which you want to get real time data. Type the name of stock in name box and add it as said above.


These are the settings to do with Amibroker. Now you can close your Ambroker.
8) Then open the excel file which you have saved as NSE. If you get any security alert like bellow image then select “options” and select “Enable this content”.

Now open your Amibroker. Open any stock which you have added to real time quote window, now you can see the Plugin status as “CONN” like bellow image:

Now you have to open real time quote window and in that open the list where you have added the stocks to real time quote. Like bellow image:

Remember, after opening of Amibroker you have to open real time quote list to get real time data. You have to open real time quote list every time when you open the Ambroker to get real time data after that you can auto hide the window. If you are not open the list of stocks in real time quote window, the quotes will not display.
That’s it, now you can able to get real time data.


Previous
Next Post »

32 comments

Write comments
My Facebook
AUTHOR
5 March 2014 at 17:07 delete

Great Man Good Work.

Reply
avatar
Rithi G
AUTHOR
22 September 2014 at 13:27 delete

how can i do this with excel 2003
pl. help me
thanks
Rithika

Reply
avatar
23 September 2014 at 07:48 delete

Same method works on excel 2003 too, if you are facing any difficulty, wait for some more days because we are coming with a free software using which you can realtime data in amibroker so stay with our blog. Thank you.

Reply
avatar
Rithi G
AUTHOR
30 September 2014 at 18:03 delete

Dear sir, Can you suggest any Algo Trading Software compadiable with NOW , is there any free version. pl. reply
Thanks,
Rithi

Reply
avatar
Unknown
AUTHOR
7 May 2015 at 23:55 delete

Still showing " waiting ".

Reply
avatar
17 May 2015 at 00:38 delete

Hi
In my Amibroker 5.4 version Symbol information box nothing is displayed. so I could not follow from step 4 onwords. Kindly help
Thanks
M.Anantha Raman

Reply
avatar
17 May 2015 at 07:15 delete

Go to Symbol > Information in amibroker menu.

Reply
avatar
chamsure6
AUTHOR
24 May 2015 at 05:16 delete

Hi Rashmith Shetty,
Can you please do same type tool for metastock11.
Thanks for the great work.
Regards,
Suresh

Reply
avatar
24 May 2015 at 07:34 delete

Thank you Suresh,
we will try to make useful software's in our free times.
Regards,
Rashmith Shetty.

Reply
avatar
Sanju
AUTHOR
27 October 2015 at 14:06 delete

As the procedure explained above by you i'm not able to update live data from excel to amibroker. Can u help me out in the procedure through Amyadmin

Reply
avatar
Sanju
AUTHOR
27 October 2015 at 14:06 delete

Can u give ur mobile no..i will give u a call.

Reply
avatar
Sanju
AUTHOR
27 October 2015 at 14:07 delete

My mobile no is 9497282865

Reply
avatar
sushant verma
AUTHOR
15 December 2015 at 17:46 delete

I am not able to retrieve any symbol in amibroker. I followed all your instructions. Can you pls. help me. I can give u access to my system as well. I mail id is sushant.verma1977@gmail.com

Reply
avatar
15 December 2015 at 20:23 delete

@ RASHMIT HEY YOU SAID IN EARLIER POST THAT YOU WERE COMING WITH SOFTWARE FOR THIS THING. SO HAVE YOU DONE IT.

Reply
avatar
BEST TRADING
AUTHOR
1 January 2016 at 16:57 delete

dear sir not connect,only wait display

Reply
avatar
Vinod Kumar
AUTHOR
20 January 2016 at 15:08 delete

Great Post!thanks for the detailed information. Algo Trading software

Reply
avatar
Ace Investor
AUTHOR
24 February 2016 at 12:17 delete

not connecting only wait in yellow colour

Reply
avatar
24 February 2016 at 16:46 delete

Use our RTF software, By using RTF you can easily get data.we are updating and adding new features to our RTF software, wait for some days, we will release it soon.

Reply
avatar
Ace Investor
AUTHOR
25 February 2016 at 10:27 delete

dear rashmith many thanks for the reply, I wanted to ask you that does your new software will solve the connection problem? is this the problem with amibroker or with the connection with the excel? I have 64 bit windows 8.1 I tried your existing RTF it doesn't work on it.

Reply
avatar
Ace Investor
AUTHOR
25 February 2016 at 10:55 delete

Why the Plugin status as “CONN” is not showing?

Reply
avatar
26 February 2016 at 10:49 delete

New software will work on 64 bit os, we have fixed the issue,release it soon.

Reply
avatar
Ace Investor
AUTHOR
26 February 2016 at 16:45 delete

Thank You!
kindly live your comments on this thread after releasing the same so that all of us will come to know about it
thanks again

Reply
avatar
Unknown
AUTHOR
10 March 2016 at 14:39 delete

ANIL JAIN SIR CAN GUIDE ME TO AMIBROKER LIVE DAT THROUGH EXCEL

Reply
avatar
Raja 512
AUTHOR
1 November 2016 at 21:19 delete

sir how to get 5 day data back fill

Reply
avatar
2 November 2016 at 07:28 delete

To get backfill data you can use rtf software.

Reply
avatar
John Maddison
AUTHOR
30 March 2017 at 15:01 delete

It worked well but it miss some ticks,is it possible to make it refresh every second.so that it can copy mostly all data from nest to amibroker.

Reply
avatar
30 March 2017 at 17:30 delete

We can not do anything sir, it depend on rtd function.

Reply
avatar
Glenn
AUTHOR
16 April 2017 at 17:08 delete

Basically they dont want people to connect to Excel and get live data !!!
They want people to spend money for data source.

Reply
avatar
Gee Meyyl
AUTHOR
31 August 2017 at 19:28 delete

Namaste Rakshit,
Thanks a zillion for making it easy to setup DDE with simple approach.
I hope you would help me sort out one minor hurdle ---> The NSE Equity Tickers are Named as "ABCDEF-EQ", and DDE does not accept this string with special characters or space except _/underscore, any solution to this ? other than cropping the name/renaming ticker ?
Aliassing is NOT practical in my case because i have already aliases for tickers for different purpose.
How to Resolve this ?
Thanks n Regards,
looking forward to your kind Guidance.

Reply
avatar
31 August 2017 at 19:57 delete

try changing the name column as u want.

Reply
avatar
Gee Meyyl
AUTHOR
31 August 2017 at 21:59 delete

aapujji Shetre,
Name change malpuna is NOT my Problem , Problem is DDE is NOT accepting the ticker name like SBIN-EQ, LT-EQ etc as it is, with this kind of ticker Names (WHICH I NEED) ,the DDE is NOT CONNECTED, but if names change malthnda like SBIN_EQ or SBIN , DDE connect aapundu, but avu yank prayojana ijji , yank Ticker names should be exactly like it appears in NSE MARKET WAtCH (Trading Symbols)

Reply
avatar