EOD Download/ Convert from NSE and BSE

[pkjha30]

hi pankaj,

I too face the same issue while converting fut data as shunya for the past 3-4 days. Can u pls help me in sorting out. Am attaching the error file details below as i couldn't attach by way of file here.

ramash75

---------------
Error File
--------------

Jan 29 2008 09:47:42 AM

**********************************************************************************
Jan 29 2008 09:47:42 AM *** File: classLogFile ***** Procedure: Private Sub

Class_Initialize()
Jan 29 2008 09:47:42 AM *** EODDownloadConvert1.25.2 Started
Jan 29 2008 09:49:04 AM *** Error 9 (Subscript out of range)in Line Number 530 in procedure

GetHeaders1 of Module basConverter
Jan 29 2008 09:49:10 AM *** Error 13 (Type mismatch)in Line Number 360 in procedure

GetUserOutPutFormat of Module basConverter
Jan 29 2008 09:49:15 AM *** Error 6 (Overflow)and at Line Number 310in procedure ConvertFO of

Module basConverter
Jan 29 2008 09:49:52 AM *** Error 13 (Type mismatch)and at Line Number 30in procedure

CleanAndWriteData of Module basIndices
Jan 29 2008 09:49:53 AM *** Error 13 (Type mismatch)and at Line Number 30in procedure

CleanAndWriteData of Module basIndices
Jan 29 2008 09:49:53 AM *** Error 13 (Type mismatch)and at Line Number 30in procedure

CleanAndWriteData of Module basIndices
Jan 29 2008 09:49:54 AM *** Error 13 (Type mismatch)and at Line Number 30in procedure

CleanAndWriteData of Module basIndices
Jan 29 2008 09:49:54 AM *** Error 13 (Type mismatch)and at Line Number 30in procedure

CleanAndWriteData of Module basIndices
Jan 29 2008 09:49:54 AM *** Error 13 (Type mismatch)and at Line Number 30in procedure

CleanAndWriteData of Module basIndices
Jan 29 2008 09:49:55 AM *** Error 13 (Type mismatch)and at Line Number 30in procedure

CleanAndWriteData of Module basIndices
Jan 29 2008 10:02:50 AM

**********************************************************************************
Jan 29 2008 10:02:50 AM *** File: classLogFile ***** Procedure: Private Sub Class_Terminate()
Jan 29 2008 10:02:50 AM *** Terminating LogFile Object
Jan 29 2008 10:02:50 AM *** Removing log entries greater than 1 days old.
Jan 29 2008 10:02:50 AM

**********************************************************************************
Jan 29 2008 10:02:50 AM *** File: classLogFile ***** Procedure: Private Sub Class_Terminate()
Jan 29 2008 10:02:50 AM *** Normal Exit
Jan 29 2008 10:02:50 AM

**********************************************************************************

Hi Ramesh

Thanks for sharing error log file. I have noticed the problem and I can understand why it is not working .Highlighted part is the culprit.
Earlier NSE was giving FNO that was less than 32767 lines. The counter which I used had maximum capacity of accommodating 32676 lines only. From 23rd NSE FNO files contain 35518 lines which is more than the counter could accommodate.

The compiled exe can not do much. However I think if you manually delete lines and bring it to less than 32000 then it will work. This is tedious but will work.
You can filter excel sheet for zero values(volume) and delete those lines.

Meanwhile I will try to finish next version in two three days.

Thanks for pointing out this.

 

[pkjha30]

Dear PK
by 'metastock help file' what you mean ?
pl explain if i could help.
and how can i have your "rising sun" type program have you uploaded it anywhere ?

hi easydls
I mean user manual which is generally a pdf file detailing programme features and how to use the software.

You can find the link in the first post. But read latest post by Ramesh and my reply .

Pankaj

 

[Rajan]

HI Pankaj,
This is the first time i am posting a latter to the forum.
I had gone through your thread & found your work very interested.
I try to download the file from the given link,
http://briefcase.rediff.com/bn/br/pjhapondy
&
http://rapidshare.de/files/15994041/NSE_Down_Loader.zip.html
But c'nt get it. Pl. advise me what to do?
I need this programme as i am getting a problem using metastock data in to the AdGet programme.
I am comfortable with the all NSE data, But in BSE data after converting CSV file to Metastock formate it say invalid type. After Lot of R&D i found that while converting it creates XMASTER file & that creates problem. The moment i delet the file AdGet took the data immidiatly.
Is it possible for you to sort out the problem for me?
Thanks In Advanced.
Raj

 

[abcdgetright]

Hi

If u want i can provide metastock programming help guide. Recently i acquire that one.

All the best....

 

[pkjha30]

pkjha30,

I am using your nice utility for the last three months.I find some errors while updating.
First one, some scrips updated irrelevantly for oneday and the next day its normal.
secondly, if I update three four days data at once some scrips are left.not updated afterward s from that day.

If someone point out this errors already ,pls kindly ignore this message.

With Regards

Rajesh

Hi

I am not able to get your point.
Could you please attach
1.sample converted files where you found errors indicating line number/scrip names where error occur.
2. the original file for the day where this error happened.(available in backup folder.
3. error log file in bin folder.
4.Name of the exchange whose files give this error.

This will help in finding out what actually happened.

pankaj

 

[pkjha30]

pkjha30

Titan - when I converted it shows two data per day in converted txt file.ie It takes titan N1 series and eq series in one txt file.row no 1090 1091 in csv file.

Ispat- It has taken Ispatind eq data instead of Ispatind p1 data on 19/12/2007 and 27/12/2007.other days are normal.

Til- stopped to update after 18/12/2008.when I checked the 19,20th eod csv files it show data for that scrip.no series change.I don't have converted txt file for this scrip on that day.

I cannot find error log file for the error'ed date.Bin contains 31/01/2008 log file only.

all error occurred for NSE scrips only.

Hi Rajesh

Thanks for giving this information. I have gone through the NSE files and scrips/dates where you faced this issue.

ISPATIND,EQ,79,84,72.55,81.4,83.75,78.05,62211216,4874102160.75,18-DEC-2007,
ISPATIND,P1,13.8,15.5,10.7,15.2,15.5,12.9,1548320,20948355.05,18-DEC-2007,
ISPATIND,EQ,85.05,87,80.1,85.6,85.25,81.4,69860559,5925941537.45,19-DEC-2007,
ISPATIND,P1,15.5,18.2,15.5,17,17.15,15.2,1147687,19608690.7,19-DEC-2007,
ISPATIND,EQ,81.9,83.2,80.1,80.7,81.2,81.6,38997389,3182733493.35,27-DEC-2007,
ISPATIND,P1,16.4,16.4,15,15.1,15,15.6,378860,5857663,27-DEC-2007,

TITAN,EQ,1412,1469,1356,1460.4,1460,1386.05,145063,206575151.7,18-DEC-2007,
TITAN,EQ,1285,1290,1020.65,1132.55,1132,1102.5,98872,109037194.2,23-JAN-2008,
TITAN,N1,220,220.25,220,220.25,220.25,220,51,11221.25,23-JAN-2008,

TIL,BE,699,699,666.8,677.75,670,701.9,446,301281.9,18-DEC-2007,
TIL,BE,666,699,652,654,654,677.75,197,130737,19-DEC-2007,
TIL,BE,650,650,648.1,648.1,648.1,682.2,580,375962,23-JAN-2008,
TIL,BE,725.1,754,695,717,717,718.4,650,474782.8,27-DEC-2007,

Now I think of two possible scenario.
1.If you have selected " All " option then Ispat Eq and P1 as well as N1 would come.Same for titan.
2. If you selected EQ then only EQ series would come.BE and other series would be omitted.That may be the reason why TIL might be omitted if EQ only is selected.

This issue was discussed in detail during development of this programme. It was opined that mostly EQ series is needed so special attention was paid for that while omitting all other series. But I had retained option for BE and All as well which would be useful if date wise conversion takes place and some softwares give their own symbols based on symbol and series(incidentally symbols are not unique but symbol+series is uniqueThis creates file naming problem as data for N1,P1 and EQ/BE would go to same file).I don't know if we need to omit all series except EQ and BE . Your comments will add to clarity.

In the current logic there was some minor flaw which has been rectified.

Before releasing the next upgrade I will go through conversion process with dates and scrips you mentioned and see if this happens again after rectification.

Release date was today but by Sunday I will release so as to take care of this issue.

pankaj

 

[pkjha30]

pkjha30,

I am using metastock version 8.0 and EOD DLC version 1.25.2.

I always used BOTH Option while converting the data.I did same for the TIL scrip also.so there is no possibility of omission.It may be due to some other reason.I faced the same problem for some other scrips also.

As per my observation, It looks like If the csv file contains with a same symbol and different series, all series data goes to the one single txt file,Like what happened in titan.

Metastock looks symbol and series.series of scrips are changed quite often by the NSE.In that case If we select EQ AND BE separately we will loose the continuation of data. Datas will be created separately for each series of a particular scrip.so the datas should be created irrespective of series.it may create error, with same symbol different series in a given particular day, as in the case of titan

These are my views,may be I am wrong.Thank you very much for considering my points.

With Regards

Rajesh

Hi
May be EQ and BE series data should go to same file if series is changed frequently, but N1 and P1 are different series and should not be mingled with EQ/BE as prices are different and it will give rise to discontinuous charts.
EQ and BE problem as earlier pointed out by other user has been corrected. it will be in new upgrade. And I will surely see conversion with your point in mind.

Thanks
pankaj

 

[easydls]

Dear PK

I have this MS manual, pl see if this helps.

http://www.spytrdr.com/MetaStockProManual.pdf

this link is old, i don't know if still works

 

[easydls]

dear PK
having problem in installing EODDownloadConvert 12.25.0.2

"unzip32.dll was loaded,but the DllRegisterServer entry point was not found. This file can not be registered." one is this, i put the dll in system32 folder and tried to register from run command

another is "LoadLibrary("C\Windows\System32\MSINET.OCX") failed - The specified module could not be found." when trying to register msinet.ocx

what should be the cause ?

 

[easydls]

r u online ?