Get NSE data 2-3 min delay with AmbiBorker and MetStock support

Hi All,
Few days back, there have been some major changes made on NSE Site (From Programmer view). All previous versions (before v5) of NSE Tracker will not work because of these changes. I have re-written most part of the code and released NSE Tracker v5.1. I have added some good functionality which will make the software very friendly to use.
Now the refresh time is reduced to 1 Min. Data displayed is not real time but its just old by about 1-2 min.


New Features:
 Added new search engine which is extremely efficient.

 Now you remove any scrip directly from DataGridView by simply right click and selecting remove.

 Right click on any scrip either from DataGridView or CheckedListBox and select NSE Intraday Graph. It will get data directly from NSE Site for that particular day and display it for selected scrips.



 You can even monitor through Candlestick Graph. This will be generated locally.

 You can select Yearly Graph from DataGridView or CheckedListBox and view candlestick graph from Jan, 2008. I have added data from Jan, 2008. In case user wants to get older data then they can download it manually through download button.



 You can left click on taskbar icon of NSE Tracker and view the current value scrips displayed in datagridview.



Refresh time is reduced drastically. It gets the data extremely fast as compared to previous versions.
Automatically generates ASCII Files which compatible with Metastock software:
NSE Tracker automatically generates ASCII Files for each Scrips and stores it in Metastock ASCII Files Folder. Every day it automatically downloads data for earlier days and appends the value to its corresponding scrips present in MetaStock ASCII Files folder. If users views yearly graph for any scrips, it will show data till last working days.

For Metastock users:
It will generates binaries which is readable by Metastock softwares. Users just have to direct path to C:\Program Files\Manav\NSE Tracker\Temp in Metastock. Whenever new data arrives, NSE tracker updates ASCII Files as well as Metastock compatible files.


you can visit my blog to post your valuable suggestion or else you can download the file from here.

My Blog


Download from site



I have always been asked to give support for AmbiBroker.
I have installed AmbiBorker and found NSE Tracker to be working fine.

Few settings you need to do to make it work:
For past days NSE tracker automatically downloads data and generates ASCII Files. After this it will automatically update Metastock files.

AmbiBorker users have an option from file menu Import Metastock Data. You select this option. Select Browse and point to folder location C:\Program Files\Manav\NSE Tracker\Temp (if default location of installation path is not changed). Select MASTER file. Press Import and you are done. First time it takes around 10-15 sec to import. After this it will take less than 2 secs to update.

Let me know if you have any issue with it.
Any suggestion are always welcome. Thank you.

Hi Manav Ji,

Kudos to your efforts.

There are numerous Yahoo downloader tools in the market but most Indian
traders like us badly need an NSE live data tool.

Your utility comes as a manna from heaven.

I have a few queries:
1]

2]

3]

4]

5]


In fact we can try figuring out the points 1, 2, 3 that I have listed above, then it will involve time,,,,, so many of our forum members will repeat the same ,,,,, it would be very considerate of you to answer them here as it will save us from repeating the routine.


As regards F&O data, please forgive me for being so demanding. Then I suggest, you can offer the basic version free and charge something for the enhanced features, serious traders like us would not mind paying for your hard work.

I am not sure if all the features listed by me are possible for you, if yes then please confirm.

Thanks and regards,

Dear Manav Ji,

Another important issue, we also need a feature to adjust bonus & split data.

Thanks and regards

Answering your queries:
I want to clarify few things here. When you install NSE Tracker, it will have data for each scrip’s from 1 Jan, 2008 till last working Sensex day, say it 09th Oct here. For ex for scrip ‘Larson & Turbo (LT)’:

<TICKER>,<NAME>,<DATE>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>,<OPENINT>
LT,LT,20080101,4183.00000,4190.00000,4125.20000,4146.25000,856675939,0
LT,LT,20080102,4146.25000,4174.40000,4080.50000,4138.35000,1605860510,0
.
.
.
LT,LT,20091006,1659.00000,1688.00000,1621.00000,1680.60000,2205348584,0
LT,LT,20091007,1685.00000,1729.40000,1668.00000,1677.25000,4443717115,0
LT,LT,20091008,1695.00000,1698.00000,1630.00000,1650.80000,4052175768,0
LT,LT,20091009,1660.00000,1660.00000,1625.05000,1633.30000,2235288703,0

This data is present as ASCII files which is readable by Metastock software.

Open the default installation folder, say ‘C:\Program Files\Manav\NSE Tracker’. Here you will see 3 folders namely, ‘MetaStock ASCII Files’, ‘StockData’ and ‘Temp’.

Stockdata folder contains downloaded data from NSE Site and stores according to its date label and keeps it in StockData Folder. You don’t have to manually download data for last working day. It will automatically download data for previous working days.
For ex: Say NSE Tracker had data for last day for 8th oct 2009 and today is 9th oct, 2009. If today time crosses 8pm then you will notice in stockData folder, a new file has automatically been downloaded with date as ‘9OCT2009.csv’. In case you don’t open NSE Tracker today, say you open software after few days, it will automatically download data for all missed previous days without user intervention.

Now for folder ‘Metastock ASCII Files’. I have already given example for ‘LT’. After downloading new file in Stockdata folder, NSE Tracker will append data for previous days for each scrip’s automatically.
For example, LT ASCII Files contained last data for 8th oct, 2009. But once csv file for 9th oct arrives in stockdata folder, you will notice that now LT ASCII Files have data for 9th oct.
LT,LT,20091008,1695.00000,1698.00000,1630.00000,1650.80000,4052175768,0

Here 20091008 is date format where 2009(year)-10(Month)-08(day).

After updating each ASCII Files, NSE Tracker also updates Metastock files present in temp folder. Metastock user can open folder “D:\Program Files\Manav\NSE Tracker\Temp” to read all scrip’s value through Metstock software. I have already mentioned ways to read scrip values for AmbiBroker users.

Now coming to your queries:
1. If you want to download data for any single day then you can use ‘Get Data’ Button. But for any given date range use ‘Download’ button. Yes you can build entire data range at one go, in case if you need data earlier than year 2008.
2. Yes. I have already explained. Metastock ASCII Files folder contains ASCII Files and Temp folder contains Metastock format files.
3. I have not worked for NSE Futures EOD. Currently NSE Tracker only works NSE Listed scrip’s.
4. I will consider this for future release. I will provide features to export to excel file. For increase in Number of rows and if you are willing to pay then I can provide this separately.
5. This question I did not understand well. Can you explain a bit here.

Can you explain what do you mean by adjust bonus & split data?

Please let me know if still something is not clear here or you find any bug.

how to get intraday live (1 min delayed data) and annalyse in metastock to do intraday trading

Hi Vicky
I have not worked for feeding live data to metastock (1-2 min delay). May be i will work on it on my next release.
If you have any other suggestions then do let us know.
Thanks
Manav

--repeat so removing...

Hi Manav Ji,

Your post is so enlightening, kudos to your sincere concerns.

In last point I meant live Future & Options data, for ex, please see  http://www.myiris.com/nse_fno/stock_option/companySearchShow.php?type=1&show=1&derivative=BHEL

Nseindia.com provides faster & free F&O data with more fields like Open Interest, it is easier to fetch nse data, would be great if you can tweak your utility to fetch them, it is available here, nseindia.com F&O market information market today get quote.

Adjust bonus-splits mean price adjustment in chart database after a stock undergoes bon-split for continuity of studies. Please note carefully the 3rd pic in your 1st post above, L&T made a 1:1 bonus in Sept 2008 and its chart depicts a 50% correction ----, similarly RIL price will fall to Rs 1000 from current Rs 2000++ [approx] after 1:1 adj.

Alongwith cash+fut+option live data+backfill+excel export+bonus&split adj, features your utility will be a full fledged integrated data product.

Also it should also be able to support large watchlists and a number of them simultaneously.

I also want to compare some of popular data products & how they lack something or the other.

 Truedataindia offers live & eod cash data from Yahoo at a very affordable price, offers Eod Futures+Options data, supports many watchlists, can export them to excel, but it can only feed data to Metastock & Amibroker directly [not into other softwares like Metatrader for which we have to use excel]

 realtime data express same as TDI

 market-data-provider offers live cash+futures data, but has no watchlist, let alone export to excel feature, cannot be used for softwares other than metastock & amibroker.

 http://www.equalsolution.com/glcharge.html, offers good quality cash+fut+option eod & live data, though live data is a bit expensive, its eod & ieod data range is widest among all data vendors,,,,, but even this product falls short from being a full fledged data product ---- its watchlists lack export to excel feature.

 options oracle from samoasky.com, brilliant for options analytics, offers free live NSE options data, but lacks export to excel feature, doesnt offer cash+fut data, no historical data.

Traders have a tough time managing too many tools. Hence we need an integrated data package. I believe since you are proficient enough to fetch NSE live data, you can modify your utility to support other features as well with little more efforts. Certainly you will be rewarded for your efforts.

Thanks and regards.

Nse option data source=> live prices have to be fetched from here

best regards

Thanks for providing me details. I will start working on these. Will post you if i need any guidance.
Thanks a lot.
Manav