DDE link to AB Future realtime through Excel Success

#1
DDE link to AB-Nifty Future(nseindia) realtime through Excel

Hi Everybody,

Without claiming any credit,(becouse, so many of u must be aware of the configuration) I have to share that I have been able to get free realtime Future data from nseindia to AB through DDE link with an excel shhet.Refresh is possible as per wish time interval (sec also).Can be done for equity also.

Problem:
Nseindia itself updates its quote after very long time interval.Exce fetches and communicate to AB every second but nse remains unchanged for longer period. Thus actual tick is missed.

Anyone knows? any site wich gives realtime quote of future evenif requires mannual refresh. or any other way anybody can suggest.


thanks.
 
Last edited:

faith

Active Member
#2
Re: DDE link to AB-Nifty Future(nseindia) realtime through Excel

Hi Everybody,

Without claiming any credit,(becouse, so many of u must be aware of the configuration) I have to share that I have been able to get free realtime Future data from nseindia to AB through DDE link with an excel shhet.Refresh is possible as per wish time interval (sec also).Can be done for equity also.

Problem:
Nseindia itself updates its quote after very long time interval.Exce fetches and communicate to AB every second but nse remains unchanged for longer period. Thus actual tick is missed.

Anyone knows? any site wich gives realtime quote of future evenif requires mannual refresh. or any other way anybody can suggest.


thanks.
:)can you share the method
faith
 
#6
Re: DDE link to AB-Nifty Future(nseindia) realtime through Excel

Dear Lee,
I have performed all the functions as detailed by you..However the connectivity status is yellow and showing WAIT..

Also what is the procedure to add symbols in the excel sheet??
Regards
Anshuman
 
#7
Last edited:
#8
Lee sir,
i have downloded dde excel file. But when i create database in amibroker i get only two data source 1. Local database,2. Metastock@8 data plugin. But could not get ddedownloader . Could you please guide me.
Thanks in advance.
Regards,
raj
 
#9
Lee sir,
i have downloded dde excel file. But when i create database in amibroker i get only two data source 1. Local database,2. Metastock@8 data plugin. But could not get ddedownloader . Could you please guide me.
Thanks in advance.
Regards,
raj
Hi Raj,

I wish u very happy new year,
I have explained above how to create Excel file and name the sheet, better u create urself. As far as prob with ur AB,download the attached zip file, unzip, and paste it Plugin folder at ur Amibroker Directory. (try C:program Files-Amibroker-Plugin). Next time u will be able to c DDE plug in at data source.

cheers.
thanks.
 
#10
Re: DDE link to AB-Nifty Future(nseindia) realtime through Excel

Dear Lee,
I have performed all the functions as detailed by you..However the connectivity status is yellow and showing WAIT..

Also what is the procedure to add symbols in the excel sheet??
Regards
Anshuman
anshuman did u got rt data in ab if yes kindly
tell me 2 i 2 got wait button