EOD Download/ Convert from NSE and BSE

[pkjha30]

Ok let me explain my problem at first i downloaded all the historical data of nse from 02-01-1995 to 31-8-2008 then after the download completed i uncheck the convert from database option and select the input and output of conversion criteria and then click on convert button the conversion process begins the conversion process runs smoothly but unfortunately except file named 20000110.csv,20000223.csv,20000330.csv,20010511.csv,20021017.csv,
20021030.csv,20021227.csv all the files are converted successfully.i have also adopted your process after deleting data from option menu and then rebuild from file and the start conversion process but again all the files converted except these files given above.

I hope now you understand my problem pls help me

thanking you in advance

Hi

Could you please attach those files? You can zip all files in one and attach to your post. I will go through these files and see what could be the problem.

Meanwhile as all conversion process is over try putting these files one by one and click on convert again. You will get datewsie files, hopefully or some error will be recorded in error.log (which is in BIN folder)

pk

 

[VJAY]

Hai,
Pankaj.I am new to this thread.I read all posts and confussions in it.Bcaz of the s/w updated with patch so many times.So if I want to use this s/w first time then which s/w to download.Please guide me
Thanks

 

[pkjha30]

Hai,
Pankaj.I am new to this thread.I read all posts and confussions in it.Bcaz of the s/w updated with patch so many times.So if I want to use this s/w first time then which s/w to download.Please guide me
Thanks

Hi Vijay

First download Setup from Skydrive link (which includes MDAC_TYP) and install. Then Download Patch and copy the exe to programme folder. That's all.

PK

 

[rpc]

Hi Vijay

First download Setup from Skydrive link (which includes MDAC_TYP) and install. Then Download Patch and copy the exe to programme folder. That's all.

PK

Hi Pankaj
I have installed new HDD in my laptop and installed exactly the way you have advised and downloaded BSE indices from 2/Jul/08 to 1/Aug/08.I am enclosing the sensex.txt I dont know why I am still not able to get the correct quotes.
with best wishes
rpc

 

[pkjha30]

Hi Pankaj
I have installed new HDD in my laptop and installed exactly the way you have advised and downloaded BSE indices from 2/Jul/08 to 1/Aug/08.I am enclosing the sensex.txt I dont know why I am still not able to get the correct quotes.
with best wishes
rpc

Hi rpc

I downloaded from 2/jul/08 to 1/Aug/08 using ver 2.2.23. Only BSE Indices and this is what I got

<ticker>,<name>,<date>,<open>,<high>,<low>,<close>,<volume>,<Turnover>,<Del_Vol>,<Del_per>
100001,Sensex,20080702,12948.05,13712.31,12822.75,13664.62,0,0,0,00.00
100001,Sensex,20080703,13530.68,13530.68,12934.92,13094.11,0,0,0,00.00
100001,Sensex,20080704,13127.1,13509.74,13027.79,13454,0,0,0,00.00
100001,Sensex,20080707,13561.92,13793.39,13475.78,13525.99,0,0,0,00.00
100001,Sensex,20080708,13292.8,13451.67,13049.96,13349.65,0,0,0,00.00
100001,Sensex,20080709,13581.41,13998.48,13581.41,13964.26,0,0,0,00.00
100001,Sensex,20080710,13861.6,14047.43,13763.94,13926.24,0,0,0,00.00
100001,Sensex,20080711,14032.06,14066.36,13351.34,13469.85,0,0,0,00.00
100001,Sensex,20080714,13360.34,13559.36,13269.62,13330.51,0,0,0,00.00
100001,Sensex,20080715,13067.08,13067.08,12605,12676.19,0,0,0,00.00
100001,Sensex,20080716,12740.78,12935.25,12514.02,12575.8,0,0,0,00.00
100001,Sensex,20080717,12909.57,13150.35,12843.79,13111.85,0,0,0,00.00
100001,Sensex,20080718,13234.53,13684.27,13093.34,13635.4,0,0,0,00.00
100001,Sensex,20080721,13782.13,13878.88,13581.19,13850.04,0,0,0,00.00
100001,Sensex,20080722,13837.64,14206.13,13798.18,14104.2,0,0,0,00.00
100001,Sensex,20080723,14568.22,14979.9,14568.22,14942.28,0,0,0,00.00
100001,Sensex,20080724,15082.37,15130.09,14608.05,14777.01,0,0,0,00.00
100001,Sensex,20080725,14451.95,14484.39,14210.63,14274.94,0,0,0,00.00
100001,Sensex,20080728,14267.03,14421.61,14219.38,14349.11,0,0,0,00.00
100001,Sensex,20080729,14085.53,14153.12,13727.14,13791.54,0,0,0,00.00
100001,Sensex,20080730,14007.32,14322.67,14002.19,14287.21,0,0,0,00.00
100001,Sensex,20080731,14359.48,14369.59,14161.76,14355.75,0,0,0,00.00
100001,Sensex,20080801,14064.26,14682.33,14032.87,14656.69,0,0,0,00.00

I am not quite sure how you end up with more data then what will be downloaded and inserted into DB.

you can download only DB and put it in DATA folder. Ensure that EOD_BSE is cleared of all data (goto options Database Admin >>Clear Database>>Clear EOD_BSE and then download only these dates. Once done please zip the mdb file and BSE>>Indices Folder with all its content and upload it to your public folder giving me the link in post so that I can download it and analyse its content.you can also send file through y a h oo mssn /g o o gle talk when I am online.

I might be able to find what's troubling your version of programme.

pk

 

[chandan2007]

the error seen in error.txt file

Aug 01 2008 11:19:09 PM *** File: classLogFile ***** Procedure: Private Sub Class_Initialize()
Aug 01 2008 11:19:09 PM *** EODDownloadConvert Started
Aug 02 2008 12:17:56 AM *** Error 9 (Subscript out of range)in Line Number 480 in procedure Convert_EOD_NSE of Module basConverter
Aug 02 2008 12:19:25 AM *** Error 9 (Subscript out of range)in Line Number 480 in procedure Convert_EOD_NSE of Module basConverter
Aug 02 2008 12:20:22 AM *** Error 9 (Subscript out of range)in Line Number 480 in procedure Convert_EOD_NSE of Module basConverter
Aug 02 2008 12:29:56 AM *** Error 9 (Subscript out of range)in Line Number 480 in procedure Convert_EOD_NSE of Module basConverter
Aug 02 2008 12:38:33 AM *** Error 9 (Subscript out of range)in Line Number 480 in procedure Convert_EOD_NSE of Module basConverter
Aug 02 2008 12:38:45 AM *** Error 9 (Subscript out of range)in Line Number 480 in procedure Convert_EOD_NSE of Module basConverter
Aug 02 2008 12:39:38 AM *** Error 9 (Subscript out of range)in Line Number 480 in procedure Convert_EOD_NSE of Module basConverter
Aug 02 2008 01:10:34 AM


and accordint to the rule of forum ia m not able to attach 7 file out of 7 file i am attaching 5 file for the remaining file just tell me the solution.


thanking u in advance

Hi

Could you please attach those files? You can zip all files in one and attach to your post. I will go through these files and see what could be the problem.

Meanwhile as all conversion process is over try putting these files one by one and click on convert again. You will get datewsie files, hopefully or some error will be recorded in error.log (which is in BIN folder)

pk

 

[pkjha30]

Hi Chandan

you can delete these attachments. I have downloaded them and will work on this issue.

pk

 

[pkjha30]

Hi Chandan

I have gone through your files. For these dates files are coming in non-standard form. I also tried to download for these dates and still got the similar files. Ver 2.2.23 will get stuck here as you would have noticed in error.log file.The strange thing is that files contain data for more than the total stocks listed so some data are repeated twice or thrice. This you can verify by opening in Excel and ordering symbol field. There are gaps in between lines so EODDlc throws up exceptions and stops.Even data is not entered into Db.

I have changed certain parameters to take care of these issue. However conversion from files will not eliminate duplicate records. So better option would be to convert from database.


As you have downloaded lots of data from NSE so I have converted these dates and put in zipped format and rar format four files each.

You can download these files.

Also new version 2.2.24 as a result of your feedback is being uploaded for which I will put links in next post.

Please notify when you have downloaded these files. I will delete them due to certain disadvantageous quota restrictions.

I must thank you for your feedback and responding to my queries and requests so fast.

It helps in improving this programme.

pk

 

[chandan2007]

ok i have downloaded your file now you can delete attached files but converting from database is very slow and some times it shows message that data not found first download the data and then begin conversion and then when i close that pop up window then again the conversion process begins



and you really made a such a nice software

and if u can add the dowjones data also then that will be much better

 

[pkjha30]

EODDlc Ver-2.2.24

Upgraded Setup files also

Skydrive link for setup (incl MDAC_TYP)

http://cid-cf8290b687b3435f.skydrive.live.com/self.aspx/eoddownloader/EODDlc.exe

Patch only ( for exiting installations which are updated upto 2.2.23)

http://cid-cf8290b687b3435f.skydriv...wnloader/EODDownloadConvert|_patch-2.2.24.zip

Rediff Briefcase link

Setup files(without MDAC_TYP)

http://f1mail.rediff.com/bn/br/pjhapondy///Shared/EODDlcsetup.exe?d=0

Patch only

http://f1mail.rediff.com/bn/br/pjhapondy///Shared/EODDlc_patch-2.2.24.zip?d=0

Thanks to chandan for feedback which led to changes.
Although may not be needed for those not downloading data before 2002.

pk