EOD Download/ Convert from NSE and BSE

DJ123143 · #**541** 12th June 2008, 04:56 PM

Hi Pankaj,
One more thing When i click for Update NSE Delivery Data
RUN TIME ERROR 76
PATH NOT FOUND

Please rectify this Problem

Thanks

Deepak

DJ123143 · #**542** 12th June 2008, 05:19 PM

Hi Pankaj,
Please Check This Image and see whats the Problem

Thanks
DJ

pkjha30 · #**543** 12th June 2008, 07:11 PM

Quote:

Originally Posted by DJ123143

Hi Pankaj,
Please Check This Image and see whats the Problem

Thanks
DJ

Hi DJ

I will reply to all three of your posts in one

1. Create a folder DATA\NSE\Equities\Delivery
Delivery data will be stored there.
2. This will solve Path not found error.

3.The error is due to the fact that data was not stored in Delivery Folder ( as none was there) This could also happen if you have downloaded EOD for 02-06-2008 , which happens to be first file in EOD folder , the program will search for corresponding Delivery file in Delivery folder. If not found this message will come. As indicated in message you click on the Menu above

Options>>StockFunctions>>DownloadDeliveryData for NSE . This will download all missing delivery data.

If you convert now, it should be alright.

This is all assuming if you want delivery data and included fields such as deliveryVolume and deliverPercent in conversion output file.Else you can safely ignore message and continue.

Regarding your request for BSe indices, It is already there in BSE EOD Daily data( second option for BSE download)

But I am including it as separately downloaded function. Just minor details which I will work out on this weekend, mainly adding delivery volumes for indices.

As for MCX and NCDEX I would like you to again go to
Options>>Delete Keys and then try Downloading again.

If it fails please upload your Error.log file from BIN folder to find out little more.

pk

kkseal · #**544** 12th June 2008, 07:45 PM

Hi Pankaj,

Just one small question. Would it be possible to view & modify the constituent stocks for an Index? And would the Index volume be calcuated on the basis of this modified list of constituent stocks? (In other words the volume fig. for the Index changes in accordance with the constituent stock list entered. This would allow me to get the correct volume values for past Index data).

However, if the stock list is internal (not user accessible) no need for a paradigm change at this stage. Finish with the other fixes first.

I also didn't like the idea of 1yr data being downloaded even if the From-To period entered is less than a year. Perhaps this can be changed.

Regards,
Kalyan.

pkjha30 · #**545** 12th June 2008, 09:05 PM

Quote:

Originally Posted by kkseal

Hi Pankaj,

Just one small question. Would it be possible to view & modify the constituent stocks for an Index? And would the Index volume be calcuated on the basis of this modified list of constituent stocks? (In other words the volume fig. for the Index changes in accordance with the constituent stock list entered. This would allow me to get the correct volume values for past Index data).

However, if the stock list is internal (not user accessible) no need for a paradigm change at this stage. Finish with the other fixes first.

I also didn't like the idea of 1yr data being downloaded even if the From-To period entered is less than a year. Perhaps this can be changed.

Regards,
Kalyan.

Hi kalyan
i think that changing Indices list will take some thinking for me. List is internally maintained as Master database, though it will be accessible to user by going though ODBC, but then only users knowing programming part may be able to it.

I will keep this as request and work out something later.

As for one year data being downloaded, that is not my doing. It is BSE website which gives data for one year or more. However as they use compression technique, so size is rather less to be of much concern.The only thing which I have done is to take data as given in from to date field so as to avoid repeated data access to tables.

pk

DJ123143 · #**546** 12th June 2008, 10:04 PM

Hi Pankaj,
Thanks For U R Reply,and Thank Full For U R Solution .....if Any Error I Will Give U Feedback Dear.

Thanks
Dj

kkseal · #**547** 12th June 2008, 10:07 PM

Ok Pankaj. I can try something on my own. If it's an mdb database can be done thru Access, else VB.

Please carry on with your good work.

Regards,
Kalyan.

DJ123143 · #**548** 12th June 2008, 10:14 PM

Hi Pankaj,
See i have did as per u r instruction but the same problem for u r Delivery Data .... i am uploading error.log file please check and tell yaar....i am zipping the error log file and please extract and see dear

Thanks

DJ

DJ123143 · #**549** 12th June 2008, 10:21 PM

Hi pankaj,
Still Facing Problem With Delivery Data and Delete Key for mcx i am uploading image check out dear

Thanks DJ

pkjha30 · #**550** 13th June 2008, 12:05 AM

Quote:

Originally Posted by DJ123143

Hi pankaj,
Still Facing Problem With Delivery Data and Delete Key for mcx i am uploading image check out dear

Thanks DJ

ok. Here is another way. goto BIN folder and delete MCX.txt and NCDEX.txt

Program will download new key. Hope that works.If it doesn't, I have to check with MCX website and find another way .

Secondly, for delivery data following is the folder structure
\DATA\NSE\EQUITIES\Delivery

D is with caps, if you have typed delivery or any other variant it will get into trouble

so Folder name has to be "Delivery" without quotes. This you can check.
It has to work as it is thoroughly tested.

To check you can manually Download EOD data and delivery Data for same day and place EOD data in \DATA\NSE\EQUITIES\
and DeliveryData in \DATA\NSE\EQUITIES\Delivery. Ensure that no other data file is present. Run converter with Database option unchecked. There should be no message.

pk

Similar Threads for: EOD Download/ Convert from NSE and BSE
Thread	Thread Starter	Forum	Replies	Last Post
Download EOD & Historical Data From Here ....	debdas	Data Feeds	139	17th November 2008 07:59 PM
Convert Yahoo .CSV file to Metastock format	saritguha	MetaStock	14	15th May 2008 08:38 PM
How to get realtime data and convert it to metastock format	alexonias	Data Feeds	21	15th April 2008 11:48 AM
How to convert NSE indices CSV files to MS format	saritguha	End of Day	2	21st March 2006 12:34 PM
data download	a_n_i_l	Software	9	25th May 2005 09:17 AM