Hi Hemen,
Thanks for the nice program. With its simple interface and automated conversion it really scores over the other programs available on this forum.
With reference to the previous posts about the data accuracy, I agree with you that there is absolutely nothing wrong with this program. What is happening is that the bhavcopy provided by NSE sometimes contains double entries for the same stock. These repeated entries show different series and different price and volume information. For example, if you look at the data for 30.03.07, BHARTI AIRTEL has two entries with EQ and IL as the series. During the process of conversion, the series column is omitted giving us two rows for the same stock name and date but with different price volume data.
The real problem comes when we convert this data into metastock format using Metastock Downloader. Downloader, while converting the data, will replace matching data if already available. What happens here is that since the series IL comes after EQ alphabetically, the data of IL series would have been placed below the data of EQ series in the data produced by this program( or any other convertor available on this forum), and Downloader will conveniently overwrite the already converted EQ series data with the IL series data.
This happens with five or six stocks everyday ( not necessarily the same stocks). The only solution available is that the raw nse bhavcopy has to be edited deleting all the data pertaining to any series other than EQ before conversion. While it can be edited even after conversion by GETBHAVCOPY, it is easier to do so in excel where one can sort the data series-wise.
While PKJha's EOD Downloadconvertor has problems in converting edited bhavcopies, Stocktools allows conversion of edited bhavecopies without any problem. Obviously this solution is not an ideal one because of the steps involved. One other solution I can think of is that if the series data is suffixed to the symbols during the process of conversion, then Downloader will treat them as different stocks and will not overwrite any data. ( e.g., BHARTIARTLEQ and BHARTIARTLIL).
