DownloadBhavCopy Utility in excel

chachi

Active Member
#1
Download BhavCopy (EOD) Utility in excel

Dear friends,

Please find an excel utility attached for downloading EOD data (BhavCopy), suitable for F-Chart and other chart applications, from NSE site.

Save file in a convinient location. It is handy to have a back up file also for future use. Upon opening the file pressing the "Download Bhavcopy/Stock data", the utility throws a form which is very userfriendly. Just play with it and learn the features.

Any comments about the file may please be posted here for the improvement.

The features about the utility file may be found in the Help Sheet of the file.

Regards
Chachi

____________________________________________________________________________________


A. Version 1.0 dated 02-Aug-2008:-

Please refer to Helpsheet in the downloaded excel file.

B. Version 1.1 dated 10-Aug-2008:-

Additional Features in this version (V1.1)

• Destination folder remains in memory When the worksheet is saved.

• Folder browse button is added. However it works only on Excel 2003 and above. In below versions, you can change the folder in the text box.

• End date for downloading - box is put up and is adjusted based on start date and no. of days of eod data downloading.

• Quick Download - Today, 3-day and 7-day data downloading facility is added as a special feature for quick download.

Hope to see a good response this time :)

C. Version 1.2 dated 17-Aug-2008:-

Additional Features in this version (V1.2)

• Dropdown facility with all the active stocks are made for stock specific Historic data downloading.

• Select the stock from the dropdown, arrange the start date and no. of days, downloading of stock data is required, press "Download Stock Data".

• Stock data will be downloaded from ***** site.

Please provide your feedback.:D

D. Version 1.3 dated 31-Aug-2008:-

Some more Features in this version (V1.3)

• Destination folder remains in memory if the worksheet is saved or on pressing "Save & Exit" buton.

• "Show Help sheet" button added on the form

• Stock Data can be downloaded from the NSE site. However it works slow due to complexity of downloading from NSE site.

• As an option, same Stock data can be downloaded from ***** site also.

• Stock Data can now be downloaded from BSE site also. Intraday quote also can be downloaded from BSE site.

Lemme wait for your valuable response

Download :-
................................................................................................................................

Link for the Version 1.3, dated 31-08-2008 (Revised on 02-09.2008)... Version 1.3 (Revised)

02.09.2008: File is revised and uploaded and it is now capable of downloading the Intraday files in required format.

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

Type '4sha red. com' in place of **********, of course without any spaces

________________________________________________________________________________________________

E. Version 1.4 dated 09-Sep-2008:-

Friends the utility prepred to satisfy a simple need of bhavcopy has seen tremendous changes with the help of few nice members who were willing to share their experiences using this utility and I am thankful to them.

The utility is capable of downloading large chunk of data with a very less downloading time. Now we need not worry about loss of data, which can be downloaded at any time.

Intraday data downloaded from bse is realtime and is can be made to put in to FChart and other softwares.

The utility is highly portable and I always carry this in Flash Drive. As it is excel driven it has some advantages and few disadvantages also. I am always concerned about the corruption and hence given lot of test before releasing.

Effort has been made to make this a very stable utility, additional features always threaten this stability and hence I have put lot of efforts backtesting.

Further improvements if required and feasible will be incorporated upon receipt of good comments.

more and more Features in this version (V1.4) :)

• Indices Historical data from ***** site can be downloaded. ***** at present provides historic data of 3 indices only.

• Indices Historic/Intraday data from BSE site can also be downloaded.

• Upon selecting Intraday options, non-relevent fields will be disabled.

• Intraday data downloaded can be linked to Fchart and other softwares.

• Indices details for reference if required can be downloaded from BSE site. Quick link is provided on the form.

How nice I feel, if you just say thanks. :/)

Download :-
................................................................................................................................

Link for the Version 1.4, dated 06-09-2008... Version 1.4

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

Type '4sha red. com' in place of ***********, without any spaces

Regards
Chachi
 
Last edited:

chintan786

Well-Known Member
#2
thanks chachi..... nice to see u after very long time... hope u remember me.

chintan
 

chachi

Active Member
#3
thanks chachi..... nice to see u after very long time... hope u remember me.

chintan
Thanks Chintan and I remember you very well. Hope you have downloaded the utility. Please provide your feedback/comments in order to improve the utility.

Regards
Chachi
 

ARMHM

Active Member
#5
Dear friends,

Please find an excel utility attached for downloading EOD data (BhavCopy), suitable for F-Chart, from NSE site.

Any comments about the file may please be posted here for the improvement.

The features about the utility file may be found in the Help Sheet of the file.

Regards
Chachi

____________________________________________________________________________________

The file uploaded seems to be OK. Please comeback if any problem is found......

Version 1.0 dated 02-Aug-2008:-

Version 1.1 dated 10-Aug-2008:-

Additional Features in this version

Destination folder remains in memory When the worksheet is saved.
Folder browse button is added. However it works only on Excel 2003 and above. In below versions, you can change the folder in the text box.
End date for downloading - box is put up and is adjusted based on start date and no. of days of eod data downloading
Quick Download - Today, 3-day and 7-day data downloading facility is added as a special feature for quick download

Hope to see a good response this time :).

Regards
Chachi
Thank you for this useful and good utility. Can you develope a similar utility to download historical data for stocks from NSE?
 

chachi

Active Member
#6
Dear ARMHM,

Thanks for your comments.

Regarding historical data for stocks from NSE - I wanted to incorporate the same in the present version itself, but could not succeed. I am still trying for the same and hopeful to put up with next version (atleast from yhoo).

Regards
Chachi
 

columbus

Well-Known Member
#8
Dear friends,

Please find an excel utility attached for downloading EOD data (BhavCopy), suitable for F-Chart, from NSE site.

Chachi
Chachi,Thanks for this small and lovely utility.
 

Similar threads