EOD Download/ Convert from NSE and BSE

[RANJITSINGH66]

hi pankaj,
Hi Ranjit

Regarding delivery percent not showing it was an oversight. In BIN folder open file NSEHEaderFormat.txt and add following line
DeliveryPercent,<DeliveryPercent>,DeliveryPercent,13
at the end and save and close.
sorry brother its not working but i expect it to be rectified with final version.will wait till then.i will not bother you anymore.
Thanks and regards
RANJITSINGH66

 

[RANJITSINGH66]

hi pankaj,
your advise
"Regarding delivery percent not showing it was an oversight. In BIN folder open file NSEHEaderFormat.txt and add following line
DeliveryPercent,<DeliveryPercent>,DeliveryPercent,13
at the end and save and close." did not work. i hope you will rectify it in your final version.i will wait till then and will not bother you any more.
THANKS FOR YOUR HELP
RANJITSINGH66

 

[pkjha30]

Hi pkjha30 ,

I think there surely is an issue when we download only Indices data.I have attached a table which contains correct/incorrect values downloaded and dispalyed.Please confirm.

Thanking You,
Raju

Hi Raju

I have gone through the entire logic and could not find any problem with the data downloaded or the database records or output file.
My output was consistent with the data given by NSE for respective indices.

here is the sample output for each indices ( Name of Indices show new format as per request of ranjit. But same is true for older ones in the format like ^NSEI etc)

NIFTY
<ticker>,<Date>,<Open>,<High>,<Low>,<Close>,<Volume>,
NIFTY,5/30/2008,4844.05,4908.85,4833.45,4870.1,131791932,
NIFTY,6/5/2008,4586.95,4690.6,4536.25,4676.95,155581579,
CNXDEFTY
<ticker>,<Date>,<Open>,<High>,<Low>,<Close>,<Volume>,
CNXDEFTY,5/30/2008,3943.75,3995.1,3938.2,3970.55,131791932,
CNXDEFTY,6/5/2008,3707.85,3788.95,3664.75,3776.65,155581579,
CNXMIDCAP
<ticker>,<Date>,<Open>,<High>,<Low>,<Close>,<Volume>,
CNXMIDCAP,5/30/2008,6606.25,6635.65,6518.25,6562.7,44849828,
CNXMIDCAP,6/5/2008,6199.1,6224.7,6086.6,6214.95,58523305,
CNXIT
<ticker>,<Date>,<Open>,<High>,<Low>,<Close>,<Volume>,
CNXIT,5/30/2008,4592.4,4704.35,4543.15,4688.35,17365735,
CNXIT,6/5/2008,4420.2,4635.95,4410.9,4615.7,14875735,
JRNIFTY
<ticker>,<Date>,<Open>,<High>,<Low>,<Close>,<Volume>,
JRNIFTY,5/30/2008,8281.35,8305.2,8113.25,8221.35,114691590,
JRNIFTY,6/5/2008,7596.35,7778.85,7471.4,7749.95,113687736,

CNX100
<ticker>,<Date>,<Open>,<High>,<Low>,<Close>,<Volume>,
CNX100,5/30/2008,4670.25,4706.4,4630.65,4669.2,246483522,
CNX100,6/5/2008,4391,4483.9,4335.75,4472.65,269269315,
CNX500
<ticker>,<Date>,<Open>,<High>,<Low>,<Close>,<Volume>,
CNX500,5/30/2008,3973.25,3992.5,3927.75,3959.65,322316042,
CNX500,6/5/2008,3724.75,3782.15,3669.2,3774.6,371544175,
CNXBANK
<ticker>,<Date>,<Open>,<High>,<Low>,<Close>,<Volume>,
CNXBANK,5/30/2008,6608.6,6651.5,6502.45,6584.35,14414020,
CNXBANK,6/5/2008,6151.35,6238.8,5974.1,6211.8,16438031,

Current Snapshot of NSE website Indices watch on front page

Index,Current close, previous Close,%change,volume
S&P CNX NIFTY, 4676.95 , 4585.60 ,1.99%
CNX NIFTY JUNIOR, 7749.95 , 7596.00 ,2.03%
CNX IT, 4615.70, 4418.50 ,4.46%
BANK NIFTY ,6211.80 , 6113.65 ,1.61%
CNX 100, 4472.65 , 4385.10 ,2.00%
S&P CNX DEFTY ,3776.65, 3728.50 ,1.29%
S&P CNX 500 ,3774.60 , 3719.40 ,1.48%
CNX MIDCAP ,6214.95 , 6200.25 ,0.24%

As you can see , data for current date matches and in between dates, I had not downloaded data so it did not show up. For respective dates it shows correct values.

Now to come to your data, I am not sure how it might have happened, as I tried hard to replicate the error, but it keeps throwing correct values.

Only for volume , it is an approximation, which I will be going over the weekend.

pk

 

[pkjha30]

hi pankaj,
your advise
"Regarding delivery percent not showing it was an oversight. In BIN folder open file NSEHEaderFormat.txt and add following line
DeliveryPercent,<DeliveryPercent>,DeliveryPercent,13
at the end and save and close." did not work. i hope you will rectify it in your final version.i will wait till then and will not bother you any more.
THANKS FOR YOUR HELP
RANJITSINGH66

Hi ranjit

I am adding BSE delivery data. When that is done, I will post patch and give header formats for both BSE and NSE.

That you can place in BIN folder and it should work.

Working on Constituents of BSE indices so that additional details can be added.

Also checking NSE indices constituents stocks for correctness.

pk

 

[pkjha30]

hi pankaj
recently dnlded EODDlC after a long time.Thks for greatly improved program.In the downloader options I did not find any option to download BSE indices.Pls advice how to download these
thks
rpc

Hi rpc

BSE Indices data is downloaded when you select EOD-Daily.

But your point is well taken.

There should be consistent interface. I will provide separate option for Indices and delivery similar to NSE, just working on it. It will not affect the process but interface will be same.


pk

 

[ramash]

hi pankaj,

how r u. I downloaded the latest version and tried to import cash. it works fine. when i tried to convert the downloadede bse data it say the files from 02/06/08 to 06/06/08 it converts only 2 files and gives a messg as process over. then again i need to convert. and sometimes it stops in the middle of conversion giving a messg that process is over. I tried again and again and finally i got all converted. I use all the default settings.

Also a humble suggestion from my side. If you can provide us with a help file for the latest version it will be more useful as many options like delivery data i don't understand it properly. Kindly tell me where am going wrong if there is any.

ramash

 

[Raju]

Hi pkjha30 ,

I will again try just to make sure on Monday June 9th EOD .By the way which version (dated) utility shows "Name of Indices - new format".Maybe I will downloaded that and try and inform u accordingly ,

Thanks,
Raju

 

[rpc]

Hi rpc

BSE Indices data is downloaded when you select EOD-Daily.

But your point is well taken.

There should be consistent interface. I will provide separate option for Indices and delivery similar to NSE, just working on it. It will not affect the process but interface will be same.


pk

hi Pankaj
Thks for the quick reply.I tried to dnld BSE indices using EOD-Daily option .
1) It seems to dnld for 1 yr even if a particular date is entered.
2) It did not dnld Sensex.The first index was "3IINFOTECH".
3) The last date was "20081205".
Just one sugesstion.It seems only one option can be selected (out of first column of BSE,NSE,MCX... and second column of EOD bhavcopy ...).I think it will be better if radio-buttons instead on tick-boxes are used.
Pls check if you also get same errors.
TIA
rpc

 

[pkjha30]

hi Pankaj
Thks for the quick reply.I tried to dnld BSE indices using EOD-Daily option .
1) It seems to dnld for 1 yr even if a particular date is entered.
2) It did not dnld Sensex.The first index was "3IINFOTECH".
3) The last date was "20081205".
Just one sugesstion.It seems only one option can be selected (out of first column of BSE,NSE,MCX... and second column of EOD bhavcopy ...).I think it will be better if radio-buttons instead on tick-boxes are used.
Pls check if you also get same errors.
TIA
rpc

Hi

It will download all stocks that you have selected as portfolio. All BSE indices are selected by default. 3IINFOTECH is scrip symbol included by default in portfolio and it gets downloaded first. Sensex is called BSE30 which is internal name of SENSEX by which it gets downloaded. Now Indices constituents are updated.Will be available as update statements in patch.

It will download one year data from last date/current date unless you increase from date to more than one year back. However files are written using database to avoid duplication.

Regarding last date, I get data up to latest date, so request you to check again.

Check boxes are used as when user makes selection other configuration choices are set. Radio buttons had some problem during initial coding period so switched to Check boxes. Event handling is better.

Your suggestion to have indices separately downloaded is implemented. It will take some time to debug and finalize code. May be completed today but not sure as delivery data and totaling for each indices is in progress. neen to look closely.

pk

 

[ramash]

hi pankj,

I also tried to download BSE indices using EOD-Daily option . It downloads one year data though we give a specific date and it comes from 20070102 till 20081205 as rpc mentioned. I am able to remove 3IInfotech from my portfolio.

kindly guide me as how i should do that.

ramash