EOD Download/ Convert from NSE and BSE

[pkjha30]

Pankaj
as regards the indices not downloading, it works perfectly at my home computer (wherein i just started the new eod downloader without the extra registry file suggested by u) but in office PC i have used extra registry file . maybe that is reason.
regards

Hi

Can you tell me what is that extra registry file?

What I found during investigation is that database access was becoming slow since records are added and then indices file are writte in sorted order. I am just working on new algorithm to do it quickly.The problem is when datafile becomes large, current approach would show considerable delay. I hope to set it right this holiday

One more thing you can do is to use options>database admin> Optimise database. Don't forget to use backup databas option also.It will save your data from any crash.

pk

 

[pkjha30]

Hi

New version uploaded. Version 2.2.0.38
1. Indices data update problem taken care of.
2. NSE portfolio can be updated.
3. new indices download added

a.'S&P CNX NIFTY SHARIAH
b.S&P CNX 500 SHARIAH
c.CNX REALTY
d.CNX IT
f.CNX INFRASTRUCTURE​

For these indices download sqlUpdate.sql file and put it in BIN folder. On running the programme, go to Options>database admin>Run critical updates and click. It will update database.
If you don't want them , no need to run update.

NSE give volume of indices so that is taken instead of calculating it. Delivery data of indices have been dropped as it took lot of time when database is large.Datewise indices data is also dropped for the same reason.

If you are redownloading indices data or dates are overlapping e.g you downloaded for 1.10.2009 to 18.12.2009 and now you are downloading from 1.09.2009 to 23.12.2009 then once you have downloaded all data just go to

options>Stock Functions> Write NSE Indices from Database. It will write all data in sorted order.

Lastly I would advice to use backup function to backup your data and also use optimise data function. It will reduce the size of file on the disk almost by 40%.

If you want to keep data yearwise then you can copy the mdb file with year name and then use option>database Admin>Clear Data base>Clear EOD_exchangename. Thereafter you can download data from say, 1.1.2010.


on saturday and sunday or holidays you can run download missing files to make your database complete for missing dates. You can also run Update database to fill up the gaps. Though if you are running it regularly it may not be nneded.

Download links

EODDlc Patch 2.2.0.38

http://cid-cf8290b687b3435f.skydriv...nloader/EODDownloadConvert^_Patch^_2.2.38.rar

SQL Update file
http://cid-cf8290b687b3435f.skydrive.live.com/self.aspx/eoddownloader/sqlUpdate.sql

pk

 

[addadutta]

Dear Pankaj,
I am not able to download currently the EOD NSE data. The error meswsage is as follows:
Incompatible DLL version discovered.
The UnZip DLL requires a version structure of length 1240552, but the VB frontend expects the DLL to need 68 bytes.
The program cannot continue.

I am on windows 7 32 bit.
Can you have a look into the issue?
I was able to download till 30/11/09 with windows 7 and convert the data.

 

[pkjha30]

Dear Pankaj,
I am not able to download currently the EOD NSE data. The error meswsage is as follows:
Incompatible DLL version discovered.
The UnZip DLL requires a version structure of length 1240552, but the VB frontend expects the DLL to need 68 bytes.
The program cannot continue.

I am on windows 7 32 bit.
Can you have a look into the issue?
I was able to download till 30/11/09 with windows 7 and convert the data.

This is answered in the following post

http://www.traderji.com/software/5966-eod-download-convert-nse-bse-83.html#post389992

Just download latest unzip dll version 6. and follow the instruction.

Oh my god, you are telling that eoddlc is running on windows 7

pk

 

[addadutta]

This is answered in the following post

http://www.traderji.com/software/5966-eod-download-convert-nse-bse-83.html#post389992

Just download latest unzip dll version 6. and follow the instruction.

Oh my god, you are telling that eoddlc is running on windows 7

pk

Thanks Pankaj. Now it is working again with Windows 7.

 

[pkjha30]

Thanks Pankaj. Now it is working again with Windows 7.

Thanks for confirming that it works on windows 7 . I never expected that.

Working on dotnet version.Now it can wait a little>

pk

 

[S N Bajpai]

Dear Shri Jha,
First, Thanks to you and Traderji for this wonderful thread.
I downloaded the basic program along with unzip32.dll ver.6 from your briefcase in Post one and then overwrote it with version 32. Nse Bhavcopy
download and convert functioned perfectly.
I could not download NCDEX data. Problem is, as soon as I click 'Download'. Download complete window appears w/o downloading anything, because when I clik 'Convert", it says 'No File to convert'.
Jha Ji please help.
Baj

 

[pkjha30]

Dear Shri Jha,
First, Thanks to you and Traderji for this wonderful thread.
I downloaded the basic program along with unzip32.dll ver.6 from your briefcase in Post one and then overwrote it with version 32. Nse Bhavcopy
download and convert functioned perfectly.
I could not download NCDEX data. Problem is, as soon as I click 'Download'. Download complete window appears w/o downloading anything, because when I clik 'Convert", it says 'No File to convert'.
Jha Ji please help.
Baj

Hi

There is a file called error.log in BIN folder, where you installed this programme. If you can paste last few lines starting from

Date Time *** EODDownloadConvert Started

then I will be able to locate the cause.

At my end version 38 is functioning fine.

On second thought Just give a date range of one week and see if files are downloaded. Normally ncdex files are delayed so only one day older records are available.

pk

 

[S N Bajpai]

Shri Jha Ji,
Thanks for the prompt reply Since I could not find previous entry in the error log, I tried to download NCDEX data from 14 to 18 Dec. No download as reported in my last post. As desired copy of the error log is reproduced below:-
Dec 29 2009 12:01:32 AM *** File: classLogFile ***** Procedure: Private Sub Class_Terminate()
Dec 29 2009 12:01:32 AM *** Terminating LogFile Object
Dec 29 2009 12:01:32 AM *** Removing log entries greater than 1 days old.
Dec 29 2009 12:01:32 AM **********************************************************************************
Dec 29 2009 12:01:32 AM *** File: classLogFile ***** Procedure: Private Sub Class_Terminate()
Dec 29 2009 12:01:32 AM *** Normal Exit
Dec 29 2009 12:01:32 AM **********************************************************************************
Dec 29 2009 12:21:17 AM **********************************************************************************
Dec 29 2009 12:21:17 AM *** File: classLogFile ***** Procedure: Private Sub Class_Initialize()
Dec 29 2009 12:21:17 AM *** EODDownloadConvert Started
Best Regards, Baj

 

[pkjha30]

Shri Jha Ji,
Thanks for the prompt reply Since I could not find previous entry in the error log, I tried to download NCDEX data from 14 to 18 Dec. No download as reported in my last post. As desired copy of the error log is reproduced below:-
Dec 29 2009 12:01:32 AM *** File: classLogFile ***** Procedure: Private Sub Class_Terminate()
Dec 29 2009 12:01:32 AM *** Terminating LogFile Object
Dec 29 2009 12:01:32 AM *** Removing log entries greater than 1 days old.
Dec 29 2009 12:01:32 AM **********************************************************************************
Dec 29 2009 12:01:32 AM *** File: classLogFile ***** Procedure: Private Sub Class_Terminate()
Dec 29 2009 12:01:32 AM *** Normal Exit
Dec 29 2009 12:01:32 AM **********************************************************************************
Dec 29 2009 12:21:17 AM **********************************************************************************
Dec 29 2009 12:21:17 AM *** File: classLogFile ***** Procedure: Private Sub Class_Initialize()
Dec 29 2009 12:21:17 AM *** EODDownloadConvert Started
Best Regards, Baj

Log file shows that program has functioned normally. So you may have to get new key from ncdex.

Go to options>Delete Keys(new Keys will be obtaine)> Delete NCDEX Key.

Once done , try download again.

PK