How to get Market Data Using Real Time Feeder

Real Time Feeder is the utility which updates Real Time, IEOD and EOD (nse) data to the best charting software Amibroker.

A New Version of Real Time Feeder ( RTF - 2.0 ) has been released with some additional features. click here to get it.

Updating Realtime Tick Data to Amibroker
Today almost all broker provide the Trading Terminal which has a facility to export the watch list to Excel sheet, When you exported you watch list to excel sheet you will get streaming live quote is excel . RTF updates the Realtime Tick data from excel to Amibroker.


Lets see how to update Tick Data:
Step 1: Create a watch list in your trading terminal. To update tick data we must need Symbol, Latest Time, Latest Price and Latest Quantity column in watch list (you may add other columns if you required but those columns are not necessary to get tick data).

Step 2: After creation of watch list, open a Excel sheet and copy the watch list from Trading Terminal and paste it to Excel sheet (to paste the watch list in excel, select the A1 cell in excel, right click the cell and press paste.
Remember when you  paste the watch list to to Sheet 1 and you should not change the sheet name, it should be Sheet 1 only.
After pasting the watch list to Excel, in excel time column should looks like hh:mm:ss (hour:minute:second) format. If time is not looking this format, you should format excel column (see help file available in the software to know how to format).

Step 3: Now open RTF, Go to > Settings > RealTime.
Here you have to do important setting i.e. you have to specify the required excel columns in RTF.
  • Under Symbol field specify in which column Symbol is presented in Excel. For example, in excel if symbol is presented in Column A then you have select Column A under Symbol field. 
  • Under Time field specify in which column Time is presented in Excel. For example, in excel if Time is presented in Column B then you have select Column B under Time field. 
  • Under Latest Price field specify in which column Latest Price is presented in Excel. For example, in excel if Latest price is presented in Column C then you have select Column C under Latest Price field. 
  • Under Latest Quantity field specify in which column Latest Quantity is presented in Excel. For example, in excel if Latest Quantity is presented in Column D then you have select Column D under Latest Quantity field. 

After all these settings press SAVE button in RTF (see help file available in the software for detailed help).

Step 4: Open Amibroker, in Amibroker you should do the necessary settings  (see help file available in the software to see the amibroker settings).

Step 5: Now in RTF main window press Start RealTime Update button. Now in status teller window you will get a massage that "Excel is Connected and Waiting for Dtata to Change". When data started to update you will get a massage that "Tick Data is Updating to Amibroker" with Green background color.

We would suggest you to start RTF 1 or 2 minutes before market starts (i.e before 9.15 AM ) so that you will never miss single second data. If you press Start RealTime Update button before start of normal market hour (i.e 9.15 Am), Amibroker will not display pre-open market data.

Back filling Intrday Data:
For any reason if you missed any intraday data, say for example you have started the application at 10 AM, so you have missed the data from 9.15 AM, for this reason we enabled the backfill option. You can get one minute interval data through backfilling. Lets see how to back fill:
  • Do all the settings required to get realtime tick data as explained above. 
  • Before pressing Start RealTime Update button, press Start IEOD update button, after completion of IEOD update immediately press Start Realtime Update button. now you will able to get missed intraday data as well as realtime tick data.
Before pressing IEOD update button make sure that you have made following settings, to make necessary settings in RTF Go to > Settings > IEOD
  • Select the required Exchange under Exchange List menu. 
  • Add the required Symbol in Manage Symbol button.
  • Select the check box Update IEOD data to Amibroker.
  • Make the Intervals to 1 Minutes and Days to 1 day. 

How to Update IEOD Data?
RTF downloads IEOD data from Google Finance it supports 21 stock exchanges in the world.
Let's see how to get IEOD data,
  • Select Settings in main window,  IEOD configuration section will open. 
  • Select the required Exchange in drop down exchange list. 
  • Add the required SYMBOLS in Manage Symbol button (see help file for more info).
  • Specify the required Interval and Days of data in the box. You can get minimum of 1 minute interval data and maximum of 60 minute interval data. You can download maximum of last 15 days data. 
  •  If you don't want to update downloaded data to Amibroker then you can uncheck the Update IEOD Data to Amibroker check box.
  •     After all these settings press save and press Start IEOD Update.


How to Update End Of Day and Historical Data?
RTF downloads and updates EOD  and Historical data (equity and futures) of National Stock Exchange of India. Data is directly downloaded from NSE website.  let's see how to update EOD data.
  • Select Settings in main window.
  • Go to EOD in configuration section.  
  • Select the required "From Date" and "To Date".
  • Select required Check Box. To download Equity data select the Download Equity  check box, select Update Equity to Amibroker to auto update downloaded equity data. 
  • To download Futures data select the Download Futures check box, select Update Futures to  Amibroker to auto update downloaded Futures data. You may select both Equity and Futures or any one as you required. 
  • After all these settings select SAVE and press Start EOD Update in main window. 
        Thats All !!!

Previous
Next Post »

42 comments

Write comments
Sibi Thomas
AUTHOR
15 January 2015 at 16:12 delete

Sir Getting error in realtime update Error "There was some error while updating Amibroker"

Reply
avatar
15 January 2015 at 18:44 delete

Close the excel, ami and RTF and then re launch it.

Reply
avatar
Sibi Thomas
AUTHOR
16 January 2015 at 09:21 delete This comment has been removed by the author.
avatar
Sibi Thomas
AUTHOR
16 January 2015 at 10:08 delete

Now working Good, tried Opening RTF using "Run as Admin",now working fine...Thanks a LOT

Reply
avatar
YASKAN PATEL
AUTHOR
31 January 2015 at 11:17 delete

PROBLEM WAS HOW TO GET STOCK FUT BACKFILL...? ..... GOOGLE PROVIDE ONLY STOCK CASH BACKFILL... ANY OTHER SOURCE FOR STOCK FUT BACKFILL IN 1MIN FORMAT ?...

Reply
avatar
31 January 2015 at 17:57 delete

As of now there is no free data source is available for future data.

Reply
avatar
Anu Jain
AUTHOR
2 February 2015 at 18:38 delete

Is this software only for registered Amibroker ? or trial version ? how to save data in trial version amibroker ? first time it successfully but when i launch amibroker after restart error not enough data available . any problem plz tell me

Reply
avatar
3 February 2015 at 06:44 delete

You can use this software with trial and registered versions but trial version of Amibroker doesn't save any data.

Reply
avatar
Anu Jain
AUTHOR
5 February 2015 at 17:06 delete

ok sir thanks but some other method .
1-trading terminal symbols not copy to excel sheet - its link to excel sheet and excel sheet save as .xlsx format . formula bar showing just like '=RTD("nest.scriprtd",,"nse_cm|ACC-EQ","Symbol") '
i have Qu. why not future symbols showing in real time data

ERROR just like -ACC15FEBFUT -- Data is not available at this moment from server. It may be because this symbol is not present in the selected Exchange

Reply
avatar
5 February 2015 at 18:15 delete

you cannot get intraday futures data using RTF.

Reply
avatar
Anu Jain
AUTHOR
5 February 2015 at 18:49 delete

thanks sir but other data provider give futures data how it possible ?

Reply
avatar
6 February 2015 at 07:41 delete

We are giving data from free sources, there is no free source available for futures data and no one is giving futures data for free.

Reply
avatar
YASKAN PATEL
AUTHOR
8 February 2015 at 11:27 delete

try to make little software that fetching data from terminal chart data... most of terminal like nest now odin tt etc providing intraday chart with tick format data saving... use this data for backfill as per fut data concern its very usefull... it is possible to make this type backfill fetching software..

Reply
avatar
8 February 2015 at 16:09 delete

We will try to make useful software's in our free times, thanks for your suggestion.

Reply
avatar
VARSHA
AUTHOR
17 February 2015 at 12:53 delete

How to get google finance data?

Reply
avatar
17 February 2015 at 16:02 delete

Please read How to Update IEOD Data? in above section or read help file which is included in our software.

Reply
avatar
rajenvyas
AUTHOR
3 March 2015 at 11:24 delete

Got error msg "Unable to create files to get started. Please relaunch the application"

Reply
avatar
3 March 2015 at 17:05 delete

Relaunch the application, If you get same error then restart your pc and then check.

Reply
avatar
Sangita Oswal
AUTHOR
19 April 2015 at 17:56 delete

how to get data in excel file . i dont understand the concept clearly.

Reply
avatar
20 April 2015 at 06:37 delete

To get data to excel, copy the watch list from your trading terminal and paste it in excel sheet. check out our help file in software.

Reply
avatar
27 April 2015 at 12:56 delete

Sir is it possible to fetch commodity futures intraday rt data from odien or nest trader to amibroker using this software

Reply
avatar
saumya
AUTHOR
27 April 2015 at 19:16 delete

Sirs
I installed RTF but unable to launch it (It stuck with the first image of the tool). May be JRE is a problem. Please let me know, which version is necessary for launching RTF (not the latest one one), I am still using Windows XP and the latest versions are not configurable on XP. I have jre-7u76-windows-i586 installed.
Please help me

Reply
avatar
28 April 2015 at 06:42 delete

JTE 7 is fine, try to re install the JRE and RTF, if problem continues you have to re install the operating system.

Reply
avatar
neel vr
AUTHOR
3 May 2015 at 15:48 delete

sir can we get nifty options data ?

Reply
avatar
5 May 2015 at 07:11 delete

As of now you cannot get option data using rtf @neel vr

Reply
avatar
neel vr
AUTHOR
5 May 2015 at 20:02 delete

ok sir. by any chance ur trying to build any such applications ? or u have any idea where i can get live options data for free ? ( i know possibilities are very less )

thank you :)

Reply
avatar
7 May 2015 at 07:49 delete

I don't think there is free software available to get option data, but you can track live option price at http://www.nseindia.com/live_market/dynaContent/live_watch/option_chain/optionDates.jsp?instrument=OPTIDX&symbol=NIFTY&strike=8200.00

Reply
avatar
ManuAdam
AUTHOR
8 July 2015 at 13:11 delete

Dear Rashmith,
First of all, thanks for a great utility. It is so handy for amibroker users. I would like to draw ur kind attention (as I saw you making this commnet twice that there is no free utility to get realtime future data) that there is one which thousands of people like me have been using for 3 years - thanks to the effort of Josh, Tracerbullet and their team at TRaderji Ref: http://www.traderji.com/intraday/97637-real-time-data-now-nest-trader-amibroker-fcharts-29.html

Your software is very nice and more auto too. I am sure with a little improvement here and there it can become much more powerful. With expertise of ur kind, it shud not be difficult to do some symbol mapping and then draw future data.
On terminal (I use ZT zerodha terminal), stock future is shown as : eg. TATASTEEL15julFUT while on amibroker we show it as TATASTEEL_F1. Similarly stocks on terminal are like TATASTEEL-EQ while in ami we show it as just TATASTEEL.
I also feel there should be a way to selct only some symbols for real time update or today backfill .. For instance, I maintain an IEOD data base for around 80 symbols and 30 futire stocks. I added them in RTF symbol list. Now when I press Start update realtime button or Start IEOD update, software naturally tries to update all. But practically we need realtime update of just a few select ones.. if there is way to selct those. that woud be so nice.
In any case, thanks a lot for a nice software utility, Sir. I wish you and your company all the best. Manu Adam

Reply
avatar
11 July 2015 at 07:54 delete

Dear Manu Adam, You can can download ieod & realtime data of only required symbols, just add the required symbols in symbol list and also create a wachlist of required symbol in trading terminal so that you can download the data of required symbosl. RTF downloads the data of those symbols which are in symbol list and watchlist. We will try to improve our software in coming days.

Reply
avatar
prash
AUTHOR
21 July 2015 at 00:19 delete

pls make it work on Windows7 64bit OS

Reply
avatar
Author1
AUTHOR
2 August 2015 at 07:59 delete

How can I get EOD of custom List rather than whole equity..?

Reply
avatar
Its me.
AUTHOR
7 August 2015 at 02:33 delete

Looks like a good application. I downloaded and tried IEOD and EOD.

1. IEOD - Download worked but auto update did not happen.
2. EOD - tried 2010-2011 download, on first VIX download application hanged.

Reply
avatar
bhargav
AUTHOR
14 September 2015 at 20:04 delete

i m use odin with amibroker with rtf but rtdata is not run with amibroker pls help me


abhishek
9336737643

Reply
avatar
19 November 2015 at 14:29 delete This comment has been removed by the author.
avatar
19 November 2015 at 17:15 delete This comment has been removed by the author.
avatar
19 November 2015 at 17:18 delete


Sir i done all the things correctly and RTF showing GREEN {Tick data is updating to amibroker happy trading} But it not showing amibroker any data.but EOD is Working. Plz help me sir. Iam using windows 10 64bit excel 2013
amibroker 5.70

Reply
avatar
N Uma
AUTHOR
7 December 2015 at 19:40 delete

sir, Err. "Unable to create required files to get started please relaunch the application". pl reply

Reply
avatar
xyz
AUTHOR
29 February 2016 at 09:38 delete

Link for data feeder for amibroker

Reply
avatar
ADMIN
AUTHOR
15 March 2016 at 09:27 delete

Sir, this utility is not working on Windows 10 (64 Bit). how I can run this utility on mentioned version of windows.
Thanks

Reply
avatar
Rambhao
AUTHOR
7 July 2017 at 12:33 delete

Dear Anil, Rashmith,

I am following your videos and testing RTF.

I have one question, I setup NSE index futures and stock futures in my watch list and exported them to excel.
Done changes to excel as you explained.
Till that point everything was fine....but next things doesn't happened.

Does this feeder takes futures n options data? or not?

Error:

BANKNIFTY17JULFUT -- BackFill Data is not available at this moment from server. It may be because this symbol is not present in the selected Exchange.
NIFTY17JULFUT -- BackFill Data is not available at this moment from server. It may be because this symbol is not present in the selected Exchange.

Reply
avatar
ruchi
AUTHOR
14 September 2017 at 09:41 delete

RTF PRO 2.1 , today not updating back fill,

Reply
avatar