EOD Download/ Convert from NSE and BSE

[pkjha30]

Urgent

New Patch Ver 2.2.22 due to change in BSE download date formats for Indices.

Earlier BSE used d-m-yyy date format and now I found that it is changed to m-d-yyyy. So made some modification.

Rediff link
http://f1mail.rediff.com/bn/br/pjhapondy///Shared/EODDownloadConvert_Patch.zip?d=0


Skydrive link

http://cid-cf8290b687b3435f.skydrive.live.com/self.aspx/eoddownloader/EODDownloadConvert|_Patch.zip


Extract and Copy exe to programme folder. Run and Click on Options>>Settings>>General Settings and also click Regenerate Ini Values

I have added Combo to change BSE Date Format . If it is not m-d-yyy ( usually it will be d-m-yyyy in previous version) then change it to m-d-yyyy and save there itself.

Now BSE download indices will work.

Explanation:
It so happens that due to load on server they keep changing formats which will cause such autodownloaders to not to download data. Hence this provision will change dataformat whenever problem is experienced in downloading BSE Indices.

pk

 

[chintan786]

Urgent

New Patch Ver 2.2.22 due to change in BSE download date formats for Indices.

Earlier BSE used d-m-yyy date format and now I found that it is changed to m-d-yyyy. So made some modification.

Rediff link
http://f1mail.rediff.com/bn/br/pjhapondy///Shared/EODDownloadConvert_Patch.zip?d=0


Skydrive link

http://cid-cf8290b687b3435f.skydrive.live.com/self.aspx/eoddownloader/EODDownloadConvert|_Patch.zip


Extract and Copy exe to programme folder. Run and Click on Options>>Settings>>General Settings and also click Regenerate Ini Values

I have added Combo to change BSE Date Format . If it is not m-d-yyy ( usually it will be d-m-yyyy in previous version) then change it to m-d-yyyy and save there itself.

Now BSE download indices will work.

Explanation:
It so happens that due to load on server they keep changing formats which will cause such autodownloaders to not to download data. Hence this provision will change dataformat whenever problem is experienced in downloading BSE Indices.

pk

Hi Pankaj, i get data in this format.....the period i have choosen was 1july2008 to 11july 2008...... file downloaded is BSE indices..... i think there is something wrong with this.......

take a look.. i am attching file with this message

 

[pkjha30]

Hi Pankaj, i get data in this format.....the period i have choosen was 1july2008 to 11july 2008...... file downloaded is BSE indices..... i think there is something wrong with this.......

take a look.. i am attching file with this message

Hi Chintan

I could not replicate this issue with any date format.However,there are two things I noticed. One is that output seems to have come from older version where this problem was there. Values corresponding to dates are ok.Second one is that your database contains data for indices from various dates, not in continuous sequence.

I would advise you to clean database by deleting all data.For this go to Options>>Database Admin>>Clear Dataabse>>Clear EOD_BSE

Then Download data with new version and check if problem persists.
Please tell me what is your system date format and Dateformat set for EODDlc.
(Both are two different things)

BSE Dateformat is meant for downloading data and has nothing to do with output which will be governed by Dateformat you set. Order of Output is in Ascending order meaning earlier date will come first and later date will come second.

I have run EODDlc with different system date format and also by setting different date format and output seems consistent.

pk

 

[chintan786]

Hi Chintan

I could not replicate this issue with any date format.However,there are two things I noticed. One is that output seems to have come from older version where this problem was there. Values corresponding to dates are ok.Second one is that your database contains data for indices from various dates, not in continuous sequence.

I would advise you to clean database by deleting all data.For this go to Options>>Database Admin>>Clear Dataabse>>Clear EOD_BSE

Then Download data with new version and check if problem persists.
Please tell me what is your system date format and Dateformat set for EODDlc.
(Both are two different things)

BSE Dateformat is meant for downloading data and has nothing to do with output which will be governed by Dateformat you set. Order of Output is in Ascending order meaning earlier date will come first and later date will come second.

I have run EODDlc with different system date format and also by setting different date format and output seems consistent.

pk

hi Pankaj, thanks for quick reply... i am using EODLC version 2.2.22...and even updated with new patch also...... i am uploading the file again.. i ahve done wht u sasid and changed the date fomat to m-d-yy format....

but i think the problem is still there....

Chintan786

 

[pkjha30]

hi Pankaj, thanks for quick reply... i am using EODLC version 2.2.22...and even updated with new patch also...... i am uploading the file again.. i ahve done wht u sasid and changed the date fomat to m-d-yy format....

but i think the problem is still there....

Chintan786

Your Database is still not clean. If you download i/7/2008 to 11/7/2008 then you will have data only for those dates as below.

date format mm/dd/yyyy

<ticker>,<name>,<date>,<open>,<high>,<low>,<close>,<volume>,<Turnover>,<Del_Vol>,<Del_per>
100003,AUTO,07/01/2008,3585.58,3595.09,3388.01,3409.47,0,0,0,00.00
100003,AUTO,07/02/2008,3400.39,3519.35,3355.74,3498.05,0,0,0,00.00
100003,AUTO,07/03/2008,3482.5,3500.69,3339.83,3377.76,0,0,0,00.00
100003,AUTO,07/04/2008,3415.33,3456.51,3353.85,3432.41,0,0,0,00.00
100003,AUTO,07/07/2008,3352.75,3529.8,3332.43,3508.96,0,0,0,00.00
100003,AUTO,07/08/2008,3494.52,3506.95,3391.31,3498.38,0,0,0,00.00
100003,AUTO,07/09/2008,3503.31,3626.58,3503.31,3606.02,0,0,0,00.00
100003,AUTO,07/10/2008,3618.95,3642.07,3543.62,3565.67,0,0,0,00.00
100003,AUTO,07/11/2008,3577.29,3600.2,3502.77,3529.44,0,0,0,00.00

another format dd/mm/yyyy

<ticker>,<name>,<date>,<open>,<high>,<low>,<close>,<volume>,<Turnover>,<Del_Vol>,<Del_per>
100003,AUTO,01/07/2008,3585.58,3595.09,3388.01,3409.47,0,0,0,00.00
100003,AUTO,02/07/2008,3400.39,3519.35,3355.74,3498.05,0,0,0,00.00
100003,AUTO,03/07/2008,3482.5,3500.69,3339.83,3377.76,0,0,0,00.00
100003,AUTO,04/07/2008,3415.33,3456.51,3353.85,3432.41,0,0,0,00.00
100003,AUTO,07/07/2008,3352.75,3529.8,3332.43,3508.96,0,0,0,00.00
100003,AUTO,08/07/2008,3494.52,3506.95,3391.31,3498.38,0,0,0,00.00
100003,AUTO,09/07/2008,3503.31,3626.58,3503.31,3606.02,0,0,0,00.00
100003,AUTO,10/07/2008,3618.95,3642.07,3543.62,3565.67,0,0,0,00.00
100003,AUTO,11/07/2008,3577.29,3600.2,3502.77,3529.44,0,0,0,00.00

Dateformat m-d-yyyy

<ticker>,<name>,<date>,<open>,<high>,<low>,<close>,<volume>,<Turnover>,<Del_Vol>,<Del_per>
100003,AUTO,7-1-2008,3585.58,3595.09,3388.01,3409.47,0,0,0,00.00
100003,AUTO,7-2-2008,3400.39,3519.35,3355.74,3498.05,0,0,0,00.00
100003,AUTO,7-3-2008,3482.5,3500.69,3339.83,3377.76,0,0,0,00.00
100003,AUTO,7-4-2008,3415.33,3456.51,3353.85,3432.41,0,0,0,00.00
100003,AUTO,7-7-2008,3352.75,3529.8,3332.43,3508.96,0,0,0,00.00
100003,AUTO,7-8-2008,3494.52,3506.95,3391.31,3498.38,0,0,0,00.00
100003,AUTO,7-9-2008,3503.31,3626.58,3503.31,3606.02,0,0,0,00.00
100003,AUTO,7-10-2008,3618.95,3642.07,3543.62,3565.67,0,0,0,00.00
100003,AUTO,7-11-2008,3577.29,3600.2,3502.77,3529.44,0,0,0,00.00

Dateformat d-m-yyyy

<ticker>,<name>,<date>,<open>,<high>,<low>,<close>,<volume>,<Turnover>,<Del_Vol>,<Del_per>
100003,AUTO,1-7-2008,3585.58,3595.09,3388.01,3409.47,0,0,0,00.00
100003,AUTO,2-7-2008,3400.39,3519.35,3355.74,3498.05,0,0,0,00.00
100003,AUTO,3-7-2008,3482.5,3500.69,3339.83,3377.76,0,0,0,00.00
100003,AUTO,4-7-2008,3415.33,3456.51,3353.85,3432.41,0,0,0,00.00
100003,AUTO,7-7-2008,3352.75,3529.8,3332.43,3508.96,0,0,0,00.00
100003,AUTO,8-7-2008,3494.52,3506.95,3391.31,3498.38,0,0,0,00.00
100003,AUTO,9-7-2008,3503.31,3626.58,3503.31,3606.02,0,0,0,00.00
100003,AUTO,10-7-2008,3618.95,3642.07,3543.62,3565.67,0,0,0,00.00
100003,AUTO,11-7-2008,3577.29,3600.2,3502.77,3529.44,0,0,0,00.00

If you see there is no other data. In all dateformat its consistent.

If you want to check if you had data in EODDlc just download ODBC Viewer
http://www.sliksoftware.co.nz/download/odbcv310.exe
and install it. Run the programme and Select System DSN as EODDlc . In Sql query Box just type

Select * from  EOD_BSE where ScripCode=100003 order by sDate ASC

This will give you what data is there in respect of AUTO index

to delete data use this query

 delete * from EOD_BSE  where ScripCode=100003

Copy them to query window and click execute. Once done try to run EODDlc again.
pk

 

[chintan786]

Your Database is still not clean. If you download i/7/2008 to 11/7/2008 then you will have data only for those dates as below.

date format mm/dd/yyyy

<ticker>,<name>,<date>,<open>,<high>,<low>,<close>,<volume>,<Turnover>,<Del_Vol>,<Del_per>
100003,AUTO,07/01/2008,3585.58,3595.09,3388.01,3409.47,0,0,0,00.00
100003,AUTO,07/02/2008,3400.39,3519.35,3355.74,3498.05,0,0,0,00.00
100003,AUTO,07/03/2008,3482.5,3500.69,3339.83,3377.76,0,0,0,00.00
100003,AUTO,07/04/2008,3415.33,3456.51,3353.85,3432.41,0,0,0,00.00
100003,AUTO,07/07/2008,3352.75,3529.8,3332.43,3508.96,0,0,0,00.00
100003,AUTO,07/08/2008,3494.52,3506.95,3391.31,3498.38,0,0,0,00.00
100003,AUTO,07/09/2008,3503.31,3626.58,3503.31,3606.02,0,0,0,00.00
100003,AUTO,07/10/2008,3618.95,3642.07,3543.62,3565.67,0,0,0,00.00
100003,AUTO,07/11/2008,3577.29,3600.2,3502.77,3529.44,0,0,0,00.00

another format dd/mm/yyyy

<ticker>,<name>,<date>,<open>,<high>,<low>,<close>,<volume>,<Turnover>,<Del_Vol>,<Del_per>
100003,AUTO,01/07/2008,3585.58,3595.09,3388.01,3409.47,0,0,0,00.00
100003,AUTO,02/07/2008,3400.39,3519.35,3355.74,3498.05,0,0,0,00.00
100003,AUTO,03/07/2008,3482.5,3500.69,3339.83,3377.76,0,0,0,00.00
100003,AUTO,04/07/2008,3415.33,3456.51,3353.85,3432.41,0,0,0,00.00
100003,AUTO,07/07/2008,3352.75,3529.8,3332.43,3508.96,0,0,0,00.00
100003,AUTO,08/07/2008,3494.52,3506.95,3391.31,3498.38,0,0,0,00.00
100003,AUTO,09/07/2008,3503.31,3626.58,3503.31,3606.02,0,0,0,00.00
100003,AUTO,10/07/2008,3618.95,3642.07,3543.62,3565.67,0,0,0,00.00
100003,AUTO,11/07/2008,3577.29,3600.2,3502.77,3529.44,0,0,0,00.00

Dateformat m-d-yyyy

<ticker>,<name>,<date>,<open>,<high>,<low>,<close>,<volume>,<Turnover>,<Del_Vol>,<Del_per>
100003,AUTO,7-1-2008,3585.58,3595.09,3388.01,3409.47,0,0,0,00.00
100003,AUTO,7-2-2008,3400.39,3519.35,3355.74,3498.05,0,0,0,00.00
100003,AUTO,7-3-2008,3482.5,3500.69,3339.83,3377.76,0,0,0,00.00
100003,AUTO,7-4-2008,3415.33,3456.51,3353.85,3432.41,0,0,0,00.00
100003,AUTO,7-7-2008,3352.75,3529.8,3332.43,3508.96,0,0,0,00.00
100003,AUTO,7-8-2008,3494.52,3506.95,3391.31,3498.38,0,0,0,00.00
100003,AUTO,7-9-2008,3503.31,3626.58,3503.31,3606.02,0,0,0,00.00
100003,AUTO,7-10-2008,3618.95,3642.07,3543.62,3565.67,0,0,0,00.00
100003,AUTO,7-11-2008,3577.29,3600.2,3502.77,3529.44,0,0,0,00.00

Dateformat d-m-yyyy

<ticker>,<name>,<date>,<open>,<high>,<low>,<close>,<volume>,<Turnover>,<Del_Vol>,<Del_per>
100003,AUTO,1-7-2008,3585.58,3595.09,3388.01,3409.47,0,0,0,00.00
100003,AUTO,2-7-2008,3400.39,3519.35,3355.74,3498.05,0,0,0,00.00
100003,AUTO,3-7-2008,3482.5,3500.69,3339.83,3377.76,0,0,0,00.00
100003,AUTO,4-7-2008,3415.33,3456.51,3353.85,3432.41,0,0,0,00.00
100003,AUTO,7-7-2008,3352.75,3529.8,3332.43,3508.96,0,0,0,00.00
100003,AUTO,8-7-2008,3494.52,3506.95,3391.31,3498.38,0,0,0,00.00
100003,AUTO,9-7-2008,3503.31,3626.58,3503.31,3606.02,0,0,0,00.00
100003,AUTO,10-7-2008,3618.95,3642.07,3543.62,3565.67,0,0,0,00.00
100003,AUTO,11-7-2008,3577.29,3600.2,3502.77,3529.44,0,0,0,00.00

If you see there is no other data. In all dateformat its consistent.

If you want to check if you had data in EODDlc just download ODBC Viewer
http://www.sliksoftware.co.nz/download/odbcv310.exe
and install it. Run the programme and Select System DSN as EODDlc . In Sql query Box just type

Select * from  EOD_BSE where ScripCode=100003 order by sDate ASC

This will give you what data is there in respect of AUTO index

to delete data use this query

 delete 8 from EOD_BSE where where ScripCode=100003

Copy them to query window and click execute. Once done try to run EODDlc again.
pk

Hi pankaj, while deleteing i get follwing error...

 

[chintan786]

i have replaced 8 by *.... still same error.....in delet command i added this also....

order by sDate ASC..... still same error

chintan786

 

[kkseal]

I hope you used a single 'where' instead of two.

 

[pkjha30]

i have replaced 8 by *.... still same error.....in delet command i added this also....

order by sDate ASC..... still same error

chintan786

There were two typos

replace 8 by * and

delete one Where instead of two.

'order by sDate Asc' is not needed

Sorry for the mistake.

pk

 

[chintan786]

ya now it is working..... this time i entered ur delete query... but databse remain as it is...

sorry pankaj if i am bothering u....... i am not aware of such things........ after all this i downloaded again.... and it is showing me same kind of wrong data in BSE indicies...

chintan