NSEIndia Data Downloader

[murthymsr]

Hi preston and FCharts users,

I have imported EOD data from NSE DD by prestonmyers into FCharts successfully on a trial basis with a fewdays data, as I am not using FCharts. A sample screen shot is attached.

Also, I copy an abstract of data specification for importing into FCharts from the FCharts manual.

The most common EOD format is known as Metastock Ascii. This is a comma-delimited file with one line per ticker laid out as follows. (It may also have a header row):
ADU,20010720,0.135,0.135,0.135,0.135,50000
ADUO,20010720,0.04,0.04,0.04,0.04,25000
ADX,20010720,0.16,0.165,0.16,0.165,80000
ADXO,20010720,0.001,0.001,0.001,0.001,0
ADZ,20010720,2.22,2.22,2.15,2.22,802724

Note that each line consists of the ticker and the date, followed by the open, high, low and close for the day. The last value is the volume. The date can be in any format BUT the program will use the international settings on your computer to decide whether a date is DD/MM/YYYY or MM/DD/YYYY. If you are in the US and are trying to import a DD/MM/YYYY file you will need to edit the date field before you can do so. Same if you're in Australia or Europe, and wish to import a file with US dates. In the example above (YYYYMMDD) there is no confusion, and this is the preferred date format.
The program will work with 2-digit years, by calculating whether to add a 20 or a 19 in front. (If the year is less than 50, it assumes it's a 2000 date)

murthymsr

 

[prestonmyers2]

Hello Murthy,
Thanks for your valuable input... I will try and answer your questions one at a time so lets go!!

2) FO Bhav copy, when downloaded, saves to a file name as earlier. 'Use Date as File Name' option may be made applicable to FO Bhav copy also.

The above was something that I thought I had done whre I done it for the EQ Bhave... Its done now.

3) The two options 'Use Fixed File Name' and 'Use Date as File Name' in Bhav Copy Options use a check Box and I am able to select both, which is confusing to the user and may be to the program also. The two check Boxes may be made 'Mutually Exclusive - like a Radio Button)

The above was a very good catch by you It is a logical error in the input to the program I somehow missed. Its done now.

4) It appears that Options are always saved on exit of program and restored on restart of the program. In each run, the program picks the options from the 'current' set. - This is how I understood the program to be working. But however, with the FO option, this is not happening always. This is what i reported earlier as 'FO Option not working.

I looked into the problem and I think its fixed now please let me know if you have any problems agaion.

5) Historical Indice data downloaded does not have the ticker field. This may be added.

This is data provided by NSEIndia as is I can change it to add the tickers but that entails a bit of time which I don't have so I decided to not do that. The file name will have to sufice as the ticker name for now.

6) Live NSE quotes are going to Live quotes Opted folder. Good.
Live Yahoo quotes are going to Program folder. These may also go to Live quotes Opted folder.
Ticker history data goes to Live Quote folder. This may go to Historical folder like the indice historical data.

I somethies hurry to put out the next version that I dont check... I was supposed to do just that but somehow it was missed!! now its done.

7) I was thinking if we can run the program as a portable application. This will facilitate running the program from pen drive, moving across different systems etc. Looks like no registry entries are added / modified. (Am I right?). An option to enable folder structure will achieve this objective. Please look into.

This program does not depend on the registry for any settings all is stored in the ini file. It should work from your thumb drive. I don't understand what you mean by

An option to enable folder structure will achieve this objective.

please explain what you mean.

8) 'Add Header' option may be applied to ALL downloads.

In an earlier message in this thread somebody wanted the headder missing from the data.... So I gave the user to either add it or remove it. I think that feature should be left to the user's choice.

9) EQBEBhav, Index Historical and Stock Historical: All may have the fields Ticker, date, open, high, low, close, volume.

V is already in that format. The others will be how they are because it is downloaded from NSEIndia as is. IF that foermat is to be changed it will take some time which I dont have so we will see about that in future.

11) Volume, when not available like for Indian indice and some foreign indice may be shown as zero.

If I am not mistaken thats how volume is shown...'0' if missing.

I hope I have answered all your questions. I hate long messages like this but I see that you take alot of trouble writting to me and espically testing the program for me I am gratefull and so dont' mind!!.
Thanks & Reghards,
Preston.


Please download the latest version !!!!! on the next page.

 

[murthymsr]

Hello Murthy,
Thanks for your valuable input... I will try and answer your questions one at a time so lets go!!

..........................
Preston.

Hi Preston,

Thanks for your next version.
Point Nos 2,3,4 & 6 attended by you are in order.

About other points, I will inform later.

murthymsr

 

[prestonmyers2]

Hello Murthy & Fiends,
Please find attached the latest version I found some errors in the last version when trying to download to 'Fixed File name Option' and 'Indice Update' Option and corrected it.
Regards,
Preston.


See below for the latest version!!

 

[murthymsr]

Hello Murthy & Fiends,
Please find attached the latest version I found some errors in the last version when trying to download to 'Fixed File name Option' and 'Indice Update' Option and corrected it.
Regards,
Preston.

Hi preston,
I feel the current version does not addressthe problem completely.

One way of doing is to have a radio button with three options
1) EQBE
2) Indice
3) Both
so that only ONE file is generated, but meets all the currently available options.

When one selects FixedFileName, the converted file may be so named.

When one selects Date option, with EQBE option, the file mat be named as EQBEYYYYMMDD, with Indice Option, the file may be namedas IndiceYYYYMMDDand with the 'Both' option, the name may be a simple YYYYMMDD. All will be going into the same directory, but still finding misssing files is easy.

 

[pra]

dear sir

Still your latest upgrade version is in some problem. When data download range more than 10 days, error came. Pl, look this matter at your earliest.

thanks

Pra

 

[murthymsr]

dear sir

Still your latest upgrade version is in some problem. When data download range more than 10 days, error came. Pl, look this matter at your earliest.

thanks

Pra

hi pra,
which data EQBE or FO? which dates? give an example.
I will also check and revert if I can help you.

murthymsr

 

[pra]

hi pra,
which data EQBE or FO? which dates? give an example.
I will also check and revert if I can help you.

murthymsr

DEAR MURTHYMSR

I have selected indice update more than 10 days range & save it EQ&BE folder(my choicable sub folder). If days range within 10 days it works without error but problem on beyond 10 days.

If i am done anything wrong with set up pl, guide me.

Thanks

pra

 

[murthymsr]

DEAR MURTHYMSR

I have selected indice update more than 10 days range & save it EQ&BE folder(my choicable sub folder). If days range within 10 days it works without error but problem on beyond 10 days.

If i am done anything wrong with set up pl, guide me.

Thanks

pra

hi pra,

yes, i too am getting the same problem!request preston to look into it.

When we download EQBE with AddIndice selected, ChangeFormat of BhavCopy Options ramain 'grey'. But when I select Indice Update, the Change Format becomes active and gets deselected. However, I manually selected this option.

In this state, when I downloaded for the period 06-10-2008to 31-10-2008, I get Bhav copies downloaded for the full range of dates RAW WITHOUT CONVERSION. But the indice files are saved for the period05-10-2008 to 15-10-2008 only (7files spanning 10 calender days)and the program terminates with "RunTime Error 380 ".

Screenshot of the problem attached for ready reference. Hope preston will look into along with other issues posted. In the meantime, pra and other users may use it spans of 10 days at a time.

murthymsr

 

[prestonmyers2]

Thanks for pointing out that error. I have corrected the problem try this version.!!


see below for a newer version!!