EOD Download/ Convert from NSE and BSE

Raju

Well-Known Member
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
 
Last edited:

pkjha30

Well-Known Member
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

yes it seems to be an issue here. I will check and in the evening correct it.
Two more things which are underway is bse delivery data and updation of bse master table for constituent stocks. With all three things I will post correction .

pk:)
 
hi pankaj,
i have found two problems-
1)the input sequence does contain del_percent column while converting from files and after rebulding from files.
the default format shuld be Symbol,date,open,high,low,close,volume,delivery-volume,delivery-percent

2) symbol for NIFTY is S&P cnx nifty but the symbol changing procedure is not accepting & character.
as regards your request mentioned earlier i am sorry to say i am not a computer wizard like you mere bhai. my knowledge is limited to cut and paste only. hope you will continue your endeviour to help us as before.finally i want you to publish a complete version with a help file very soon.
may god bless you
RANJITSINGH66
 
Last edited:

pkjha30

Well-Known Member
hi pankaj,
i have found two problems-
1)the input sequence does contain del_percent column while converting from files and after rebulding from files.
the default format shuld be Symbol,date,open,high,low,close,volume,delivery-volume,delivery-percent

2) symbol for NIFTY is S&P cnx nifty but the symbol changing procedure is not accepting & character.
as regards your request mentioned earlier i am sorry to say i am not a computer wizard like you mere bhai. my knowledge is limited to cut and paste only. hope you will continue your endeviour to help us as before.finally i want you to publish a complete version with a help file very soon.
may god bless you
RANJITSINGH66
Hi ranjit

1. if you have selected del-percent then it should become default for future conversion. even when rebuilding from files. So first you have to convert NSE EOD files with that option to make it default. and close the programme. next time that should come automatically.

2. S&P CNX NIFTY is name of the indices Symbol is NIFTY or ^NSEI or NSEI or any similar thing. & is reserved hence not allowed except in names. In future & or any special character will not be allowed as they would hinder database operations especially SQL.

Further , name is already used in one column and if you select that it will be shown in converted files but then you might get names of company instead of symbols, not much use having Associated Cement Company Ltd etc for charting.
Also if you tinker too much with symbol name changes , you might end up corrupting database. Right now what was provided was as per your request.

pk :)
 

pkjha30

Well-Known Member
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.

Delivery Percent should show when converting from files.

If you want to change anything here this format means like this

KeyWord,MetaHeader,Default Header, Header Index No.

You can change MetaHeader and DefaultHeader as you like. But Keyword and index should be left untouched.

pk :)
 

rpc

Active Member
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
 

Similar threads