EOD Download/ Convert from NSE and BSE

[RANJITSINGH66]

hi pankaj,
will it be possible to get indices data in a single csv file like this
thanks and regards.
RANJITSINGH66

 

[SUMOGAN]

I tried with your option of Copying from Backup , problem persists

I took prior steps as
1. as Said Regenerated Settings Ini
2. Deleted the Files in Converted 20080714.txt 20080715.txt 20080716.txt

Checked with the options in Output , everthing found normal as usual.

But the Converted file Size is of 12K and that too with Symbols alone

It is quite Normal before the updation of patch , guide me if i am worng in any stage.

Regards
SunilMogan

 

[soundrex]

I too am facing the same problem.
Thanks.
Regards
soundrex

 

[SUMOGAN]

Hi

You can do two things.
1. Go to Options>>settings and click on regenerate settings.
That will take care of default settings

2. Go to converter page ans see if all files are visible in input box for the selected exchange. .If not copy files from Backup folder to Equities Folder(assuming EOD for equities)
Then check again and set Input/ output settings in advanced Settings option. Once done, delete all files in Converted and Stockwise folder.
After that hit click.

Shortest way to do that is to use rebuild option using either file or database option that will output all data depending on files/data in database and your settings.

pk

I tried with your option of Copying from Backup , problem persists

I took prior steps as
1. as Said Regenerated Settings Ini
2. Deleted the Files in Converted 20080714.txt 20080715.txt 20080716.txt

Checked with the options in Output , everthing found normal as usual.

But the Converted file Size is of 12K and that too with Symbols alone

It is quite Normal before the updation of patch , guide me if i am worng in any stage.

Regards
SunilMogan

 

[pkjha30]

I tried with your option of Copying from Backup , problem persists

I took prior steps as
1. as Said Regenerated Settings Ini
2. Deleted the Files in Converted 20080714.txt 20080715.txt 20080716.txt

Checked with the options in Output , everthing found normal as usual.

But the Converted file Size is of 12K and that too with Symbols alone

It is quite Normal before the updation of patch , guide me if i am worng in any stage.

Regards
SunilMogan

Hi Sumogan

Setup file still contains ver 2.2.21 since only patch was released for 2.2.22. So you can backup your database by renaming it as eoddlc_bak.mdb and run the setup again. Then try with renaming new database as eoddlc_new.mdb and eoddcl_bak.mdb to eoddlc.mdb and run the programme.
see if you get the same error or it is rectified. That will eliminate one source of error i.e. either program or database.

Then give me feedback. I think database config values have been corrupted. or it is not properly saving.

Same advice for soundrex as problem is same.
pk

 

[neo1599]

Hi,

Thanks for your instructions on downloading the downloader.

I had been using an older version of the program and the symbols for indices were different. However, merging solved that problem.

The data for other symbols such as RELiance etc is not getting loaded into the program(i am using Amibroker). I dowloaded the EOD bhavcopy and converted then import to Ambibroker. Somehow the data does not show up.

How may I correct this?

Regards

Neo

 

[pkjha30]

Hi,

Thanks for your instructions on downloading the downloader.

I had been using an older version of the program and the symbols for indices were different. However, merging solved that problem.

The data for other symbols such as RELiance etc is not getting loaded into the program(i am using Amibroker). I dowloaded the EOD bhavcopy and converted then import to Ambibroker. Somehow the data does not show up.

How may I correct this?

Regards

Neo

Hi neo

In old version I used ^NSEI etc which is y a h o o type symbols.

Many members wanted ^ to be removed so I provided a method to do that and in subsequent release removed ^ from Symbols of Indices. ^ being special symbol, I check for that and don't allow since eoddlc is now using database.I am glad that this issue has been solved by you.

As for Reliance not showing up, if you could be more specific, it would be better.

If you are downloading BSE and Reliance is not showing up then We need to provide Reliance and its BSE Scrip Code for Listed Equity table.

If it is NSE then you can use update functions which updates symbols company names etc. So if any of Reliance company is not there it will be inserted. Any problem then let me know.

Also show the sample output file few lines near reliance symbols

Did you check if downloaded EOD files had Reliance symbols.

Do let me know so I can go through it.

pk

 

[pkjha30]

Hi Soundrex and Sumogan

Here is the link to patch
ver 2.2.23

http://cid-cf8290b687b3435f.skydriv...nloader/EODDownloadConvert|_patch|_2.2.23.zip

This rectifies a mistake which inadvertantly creeped in in ver 2.2.22

All are advised to download this patch and
feedback on any problem

Old setup file will continue with Ver 2.2.21 Those installing fresh may backup exe and copy patch.

pk

 

[pkjha30]

hi pankaj,
will it be possible to get indices data in a single csv file like this
thanks and regards.
RANJITSINGH66

Sorry for not replying earlier.

This option to output indices in date files will be put for nse and bse in next version if there is no further issues with 2.2.23

awaiting feedback from rpc sumogan soundrex neo and others

pk

 

[pkjha30]

hi pankaj,
will it be possible to get indices data in a single csv file like this
thanks and regards.
RANJITSINGH66

Hi ranjit

Coding part is over. Output file will be in yyyymmdd.csv format. It will contain indices data for the day.

I will integrate and issue in next release.
sample

<ticker>,<date>,<open>,<high>,<low>,<close>,<volume>,<Turnover>,<Del_Vol>,<Del_Per>
AUTO,20080724,3744.96,3823.32,3744.82,3771.16,0,0,0,00.00
BANKEX,20080724,7397.76,7467.85,7017.28,7163.48,0,0,0,00.00
BSE100,20080724,7832.72,7880.04,7605.2,7682.46,16103873,2111719573,5128882,31.85
BSE200,20080724,1823.8,1836.17,1772.91,1790.31,6235681,1269665600,1675916,26.88
BSE30,20080724,15082.37,15130.09,14608.05,14777.01,2239724,1000370091,428700,19.14
BSE500,20080724,5740.6,5783.45,5589.43,5641.17,26447136,4091419669,5823065,22.02
BSECD,20080724,3758.31,3806.66,3623.99,3649.9,0,0,0,00.00
BSECG,20080724,12511.33,12526.95,11932.72,12119.16,0,0,0,00.00
BSEFMCG,20080724,2143.4,2159.56,2111.06,2119.09,0,0,0,00.00
BSEHC,20080724,4200.45,4231.64,4154,4183.61,228066,75497651,97205,42.62
BSEIT,20080724,3729.15,3745.49,3532.94,3630.04,2898137,239373235,1077423,37.18
BSEPSU,20080724,6835.42,6910.28,6659.19,6728.21,4745866,394425859,1691042,35.63
DOL100,20080724,1918.31,1937.23,1872.16,1884.63,0,0,0,00.00
DOL200,20080724,718.85,726.48,702.53,706.82,0,0,0,00.00
DOL30,20080724,2931.49,2951.94,2856.33,2876.9,0,0,0,00.00
METAL,20080724,13256.54,13331.41,12554.74,12696.25,0,0,0,00.00
METAL,20080724,13256.54,13331.41,12554.74,12696.25,0,0,0,00.00
MIDCAP,20080724,5644.07,5723.23,5544.51,5580.9,7309837,787918631,2921453,39.97
OILGAS,20080724,9963.61,10142.65,9905.04,10013.4,6195483,942374612,2495777,40.28
POWER,20080724,2749.72,2753.25,2628.35,2654.45,27403293,4032648600,5089936,18.57
REALTY,20080724,5262.17,5380.57,5132.01,5230.15,7320416,2001595485,2022865,27.63
SMLCAP,20080724,6836.32,6924.37,6771.88,6796.11,8070112,802748663,3345880,41.46
TECK,20080724,3095.28,3100.58,2957.97,2986.03,6839179,499515144,2455883,35.91

<ticker>,<date>,<open>,<high>,<low>,<close>,<volume>,<Turnover>,<Del_Vol>,<Del_Per>
CNX100,20080724,4309.45,4321.15,4175.35,4221.3,440318564,134385683238.7,118097699,26.82
CNX500,20080724,3595.15,3607.35,3491.1,3524.5,570421313,156410872217.25,157479212,27.61
CNXBANK,20080724,6445.3,6468.4,6103.1,6213.6,27782866,18106980615.85,11312883,40.72
CNXDEFTY,20080724,3708.3,3760.7,3608.9,3642.05,176953954,92688537228.3,72257425,40.83
CNXIT,20080724,3816.15,3816.15,3609.55,3682.8,17453890,11292717733.7,8871570,50.83
CNXMIDCAP,20080724,5667.8,5705.95,5542.25,5585.4,58270836,13202860775.3,21872327,37.54
JRNIFTY,20080724,7225.15,7363.2,7029.4,7117.25,263364610,41697146010.4,45840274,17.41
MIDCAP50,20080724,2159.45,2206.55,2122.65,2156.2,182152851,21034039191.35,28325112,15.55
NIFTY,20080724,4476.2,4539.45,4385.85,4433.55,176953954,92688537228.3,72257425,40.83

tell me if format is alright or need some change?
pk