EOD Download/ Convert from NSE and BSE

[pkjha30]

Hi Pk,
I downloaded your software today.I could not make use of it.First I decided to test your software by downloading data from 01/05/2008 to 28/05/2008 and converted the downloaded data then view the "C:\Program Files\EODDownloadConvert\DATA\NSE\EQUITIES\Converted\ " directory to test the output.I found that the output is not in proper manner.First one is when I view date wise output it is showing the files from 01/11/2007 to 27/05/2008 and when I view stock wise output there is only one entry for the date 02/05/2008.I am wondering why are you continuously posting revised software not even without checking these kind of simple errors.

http://i276.photobucket.com/albums/kk10/rajuwaste/Converter3.jpg

Hi Rajuwaste

Thanks for pointing out that. I am not sure why you will get data for 2007 if you don't downloaded it. At 4.30 PM you will not get data for 28.5.2008 so it has not come. Did you check if datewise files are correct in respect of data?

As regards stockwise files , if only one entry is there then you should have posted error log file that would have been most helpful.

In any case you should wait till everybody who wants to use this says that now it is working as it should.

When I post it works in respect of functions I check. Its only after individual errors are pointed out that one can pinpoint the issue and rectify it.

Patches are posted when something is rectified This process will continue till we get all functions vetted by users . Till such time you might like to sit back and devote your attention somewhere else else you will get confused till no end.

Also you should get some excellent converters available in forum or may be a paid one, if you don't really want to tell errors in a matter of fact ways rather than being sarcastic.

pk

 

[rajuwaste]

Hi Rajuwaste

Thanks for pointing out that. I am not sure why you will get data for 2007 if you don't downloaded it. At 4.30 PM you will not get data for 28.5.2008 so it has not come. Did you check if datewise files are correct in respect of data?

As regards stockwise files , if only one entry is there then you should have posted error log file that would have been most helpful.

In any case you should wait till everybody who wants to use this says that now it is working as it should.

When I post it works in respect of functions I check. Its only after individual errors are pointed out that one can pinpoint the issue and rectify it.

Patches are posted when something is rectified This process will continue till we get all functions vetted by users . Till such time you might like to sit back and devote your attention somewhere else else you will get confused till no end.

Also you should get some excellent converters available in forum or may be a paid one, if you don't really want to tell errors in a matter of fact ways rather than being sarcastic.

pk

Hi Pkjha,
Download part of your software is working correctly.But conversion part is creating problem.

Download part

What do u mean by error log file I could not find anything like that.The conversion part creating unnecessary files.Downloader create files from 02/05/2008 to 27/05/2008.But When I use converter part it is creating files from 01/11/2007 to 27/05/2008.Files from 02/05/2008 to 27/05/2008 have valid entries other than these have invalid entries.

 

[pkjha30]

Hi Pkjha,
Download part of your software is working correctly.But conversion part is creating problem.

Download part

What do u mean by error log file I could not find anything like that.The conversion part creating unnecessary files.Downloader create files from 02/05/2008 to 27/05/2008.But When I use converter part it is creating files from 01/11/2007 to 27/05/2008.Files from 02/05/2008 to 27/05/2008 have valid entries other than these have invalid entries.

Hi Raju

I understood your problem.Let me explain like this.

You have downloaded IndiaVix data also, which is a separate download but data goes to same EOD_NSE table.You would have downlaoded data since November for IndiaVix alone as it cones as a single file.

Now when software converts from Database it looks for date form which no conversion has taken place irrespective of number of records for that date. So you will get a single entry for those dates where you have only IndiaVix and not EOD data as EOD Data was only from 2.5.2008.
This will happen also if you download indices for a period different from EOD date Range. Then you will get all Indices data for that particular date but without EOD data as that was not downloaded.

The remedy is to download all data for a particular date range for NSE EOD, Delivery Data , Indices data and then IndiaVix, in this order if You download data then the software will calculate delivery details for indices also from the constituent stocks ( else you will get 0 volume for Indices) and the same will be in output file if deliveryVolume is selected. Since you have all data for same date range you will not get any single record files.

As regards stockwise file with single entry, that I have tracked and when I post new patch it will be alright.

Rest assured I always check, but different computers different way of behaving, that's why users need to go through their desired functions to see if that works alright. I get a full picture and need to check what is pointed out before everyone else is satisfied. that's a difficult job is one doesn't have enough time.

by the way Error.log file is in BIN folder. It will record start and end time of programme and errors if any with details of where it occurred .
pk

 

[rajuwaste]

Error log file attached

 

[umesh_ladha]

Hi,

i tried downloading mcx and ncdex data, the message dialog says that downloaded, but when I try to convert it says data not found. When I tried to look into the downloaded folder, files where not downloaded. Also while downloading, when I say show advanced views, no file is getting downloaded. I have version 2.0.4 The auto updater says that this is the latest version.

Kindly help

 

[pkjha30]

Hi,

i tried downloading mcx and ncdex data, the message dialog says that downloaded, but when I try to convert it says data not found. When I tried to look into the downloaded folder, files where not downloaded. Also while downloading, when I say show advanced views, no file is getting downloaded. I have version 2.0.4 The auto updater says that this is the latest version.

Kindly help

Hi
Sorry for late reply.

Go to Options>>DeleteKeys>>Delete MCX Key and click it.
Make sure you are connected to Internet.

Similarly do it for NCDEX

After that try download again.

Be careful in date range as current files are not available till 11.30 PM I think but not quite sure. So default is previous day as from date and current date as to date. You can not download current day's data before 11.30Pm

Current version is 2.0.10. You can download patch from the address mentioned previously. There are two files : EODDonloadConvert.exe and LISTEDEQUITY_BSE.txt files

exe file you can put in your programme folder where EODDlc is installed. LISTEDEQUITY_BSE.txt file should be placed in BIN folder.

This will make one menu visible in Options
Options>>Stock Functions>>Update Listed Company Details(BSE).

Just click that ,it will update BSE master table.
This is essential step as it will insert 271 extra BSE symbols for Newly released stocks such as RPower, GMRINFRA and many more.

So it is a must if you want data files for these stocks.


pk

 

[pkjha30]

Version 2.0.10 is released.

Existing installation needs only patch files.

There are two files : EODDonloadConvert.exe and LISTEDEQUITY_BSE.txt files

exe file you can put in your programme folder where EODDlc is installed. LISTEDEQUITY_BSE.txt file should be placed in BIN folder.

This will make one menu visible in Options
Options>>Stock Functions>>Update Listed Company Details(BSE).

Just click that ,it will update BSE master table.
This is essential step as it will insert 271 extra BSE symbols for Newly released stocks such as RPower, GMRINFRA and many more.

So it is a must if you want data files for these stocks.

It will also update NSE USER Header Sequence (default one) to correct order.


Setup files at Rediffmail has same address.

Setup files at skydrive (includes MDAC_TYP.exe) have following address.

Main Setup
http://qba17q.bay.livefilestore.com...2Wri_jSFpneaJpAGFfLLhVq40/EODDlc.exe?download

Patch
http://qba17q.bay.livefilestore.com...LvZg_tO/EODDownloadConvert_patch.zip?download


This addresses various issues raised by users. I have tried to solve as much as possible It works fine here.

Single entry for Stockwise file is now corrected.

If you go for files Conversion(as against Database Conversion) you can include Delivery Details and Delivery Percent in converted files.



I would request users to go through various menus in options . It has several functions included such as if you download files for different dat ranges and miss moe data files in between that can be downloaded by one click without bothering to check missing dates.

Delivery files also can be downloaded.(NSE)

You can clear all data on EOD tables and then update database with files already downloaded.Thereafter is you use rebuild from DB , it will create all files with updated database.


I need to write some sort of help file to explain all functions but may be I will do as and when I get feedback.

Again I have to thank those who gave feedback especially casoni,rajuwaste,rajesh, avinash. Ranjitsingh for request to include delivery percent as well.I hope they continue to give feedback so as to make it function as intended.

pk

 

[RANJITSINGH66]

Pankaj bhai namaskar,
thanks for keeping my request .I have three more request-
1) you should provide nse indices data in nse symbol format.i think presently your utility downloads indices data from y a h o o site whereas all NSEEOD AND BSEEOD are downloaded from nse and bse site . so i think it would be wise to get indices data in nse and bse symbol format also.for this i think you would need to download indices data from nse and bse site(we need bse indices data also)
2) you have already provided % of delivery as well as delivery volume data for shares listed in NSE. Will it be possible for shares listed in BSE also.
3) you should provide a help file as soon as possible so that we can use this utility to its maximum capacity.
i know i am demanding a bit more.
Thanks and regards.
RANJITSINGH66

 

[kuriako]

Version 2.0.10 is released.

.............

pk

Many Many thanks

 

[pkjha30]

Pankaj bhai namaskar,
thanks for keeping my request .I have three more request-
1) you should provide nse indices data in nse symbol format.i think presently your utility downloads indices data from y a h o o site whereas all NSEEOD AND BSEEOD are downloaded from nse and bse site . so i think it would be wise to get indices data in nse and bse symbol format also.for this i think you would need to download indices data from nse and bse site(we need bse indices data also)
2) you have already provided % of delivery as well as delivery volume data for shares listed in NSE. Will it be possible for shares listed in BSE also.
3) you should provide a help file as soon as possible so that we can use this utility to its maximum capacity.
i know i am demanding a bit more.
Thanks and regards.
RANJITSINGH66

Hi Ranjit


1. I am not downloading anything from Ya who Everything is from respective exchange sites.
2. If you give me the nse symbols for indices I will give you details how to update database so that you can have your choice of indices names.
3.BSE Downloads of delivery data/% delivery are not easily available as csv file as in NSE.IF someone can post URL of this data or any desired data from BSE , I would be able to include it. Else one needs to write HTML parser to scrape data from webpages which ,I think , is very inefficient and unreliable way of getting data.
4.I think this is something I should do now on priority basis. May be over next weekend.

I hope new version is stable.


pk