Open tusharmdave opened 1 year ago
Hi Friends, just download Bhav Copy from NSE Website. Then Open the CSV file, use excel to sort out EQ. Rest you can delete it. Add a row for date. Save it as txt file. But the only issue is you will not get deliverable data as well as Indices data
I converted this using Libre 2023-04-03-NSE-EQ.txt 2023-04-05-NSE-EQ.txt Office. You can try with MS Office also.
Sorry Guys. Forgive me. Just prior updated file has problem with volumes. It was my mistake.
Now corrected it. Is is fine now. Since Delivery quantity is not available in NSE BHAV copy, we cant get.
But OHLC with volume is available.
2023-04-03-NSE-EQ.txt
2023-04-05-NSE-EQ.txt
Tool stopped download probably due to shutdown of www1.nseindia.com site as the content no longer available there. This probably require a code fix to point things to new site.
I think the application it is in Github, means open source. If anyone can guide to me to recruit a programmer, we can solve this problem.
2023-03-31-NSE-EQ.txt 2023-04-03-NSE-EQ.txt 2023-04-05-NSE-EQ.txt 2023-04-06-NSE-EQ.txt
This includes indices data as well. I have manually created these files.
2023-03-31-NSE-EQ.txt 2023-04-03-NSE-EQ.txt 2023-04-05-NSE-EQ.txt 2023-04-06-NSE-EQ.txt
This includes indices data as well. I have manually created these files.
Thanks a ton Sir.. I will be highly obliged if you write down the steps how to create the files manually.. Thanks & Regards
Hi @imcandlestick.
search nse bhav copy.
you will find full Bhav copy and security deliverable data.
download load it in csv format.
Just keep the required data as in getbhavcopy txt file.
sort it out. keep only stocks in EQ series.
rest delete it.
save and close it.
then open the same csv file in notepad.
save it txt format with a name of your choice.
It will be ready .
Thanks to @niteshmurti who have manually compiled which includes Indices data aswell.
thanks @niteshmurti for the files. while making index data file, there is an error in names provided by nse website and one used by getbhavcopy, for ex, nifty is written as nsenifty on getbhavcopy and as nifty 50 as given by nse. did you manually change names of all indices to match the previous format?
thanks @niteshmurti for the files. while making index data file, there is an error in names provided by nse website and one used by getbhavcopy, for ex, nifty is written as nsenifty on getbhavcopy and as nifty 50 as given by nse. did you manually change names of all indices to match the previous format? indices format.xlsx
Yes, I manually changed the names. It was a painstaking process. I have attached the excel file here to make the job easier for whoever wishes to use it. You have to place the new data in the right hand side in the place I have indicated and the VLOOKUP function will automatically arrange the data on the left-hand side. Make sure you paste the data correctly otherwise it'll mess up your charts. And change the date on the left-hand side manually everyday. You need only change one date in cell C2 and rest will update automatically. Any other doubts you can ask me here.
Thank you @niteshmurti sir.. trying to download bhavcopy from nse site, however, indices details are not provided. can you please let me know the bhavcopy file to download from nse site which has indices details.
Hi @imcandlestick. search nse bhav copy. you will find full Bhav copy and security deliverable data. download load it in csv format. Just keep the required data as in getbhavcopy txt file. sort it out. keep only stocks in EQ series. rest delete it. save and close it. then open the same csv file in notepad. save it txt format with a name of your choice. It will be ready .
Thanks to @niteshmurti who have manually compiled which includes Indices data aswell.
Thanks a ton Sir!!!
thanks @niteshmurti for the files. while making index data file, there is an error in names provided by nse website and one used by getbhavcopy, for ex, nifty is written as nsenifty on getbhavcopy and as nifty 50 as given by nse. did you manually change names of all indices to match the previous format? indices format.xlsx
Yes, I manually changed the names. It was a painstaking process. I have attached the excel file here to make the job easier for whoever wishes to use it. You have to place the new data in the right hand side in the place I have indicated and the VLOOKUP function will automatically arrange the data on the left-hand side. Make sure you paste the data correctly otherwise it'll mess up your charts. And change the date on the left-hand side manually everyday. You need only change one date in cell C2 and rest will update automatically. Any other doubts you can ask me here.
thank you so much for providing this excel file, really must have taken quite some time and effort for making this. thanks a lot
Thank you @niteshmurti sir.. trying to download bhavcopy from nse site, however, indices details are not provided. can you please let me know the bhavcopy file to download from nse site which has indices details.
You have to go to Resources > Daily Market Reports then on the left hand side you'll see Current Reports, Equities & SME, below that you'll see Indices. Click on Indices, then click on Archives, then choose a date, then download Daily Snapshot
thanks @niteshmurti for the files. while making index data file, there is an error in names provided by nse website and one used by getbhavcopy, for ex, nifty is written as nsenifty on getbhavcopy and as nifty 50 as given by nse. did you manually change names of all indices to match the previous format? indices format.xlsx
Yes, I manually changed the names. It was a painstaking process. I have attached the excel file here to make the job easier for whoever wishes to use it. You have to place the new data in the right hand side in the place I have indicated and the VLOOKUP function will automatically arrange the data on the left-hand side. Make sure you paste the data correctly otherwise it'll mess up your charts. And change the date on the left-hand side manually everyday. You need only change one date in cell C2 and rest will update automatically. Any other doubts you can ask me here.
thank you so much for providing this excel file, really must have taken quite some time and effort for making this. thanks a lot
You're welcome. Yeah it took about two and a half hours lol..
Guys, Can any one help me with bhavcopy txt for date 27,28,29,30 March. thanks.
Thanks JITHUJT
I'm also not able to download the EOD files from the GetBHavcopy. Some error is coming due to the change in nse website. How this issue can be solved permanently.
2023-03-27-NSE-EQ.txt 2023-03-28-NSE-EQ.txt 2023-03-29-NSE-EQ.txt 2023-03-31-NSE-EQ.txt
JITHUJT, thanks. Can you kindly inform how to make these files from bhavcopy ?
equity + index data, made with help from @niteshmurti 's excel 2023-04-05.txt 2023-04-10.txt
NSE DOwnload is stopped since few days.
If you have updated, then pl provide here
This Python program is a perfect alternative to the Getbhavcopy software. It generates the same text file as the one obtained by Getbhavcopy software. The generated file includes symbol, date, open, high, low, close and volume data arranged in columns and date format matches that of Getbhavcopy software. Additionally, all NSE index names have been changed to match the names used in Getbhavcopy's old files. This ensures compatibility with the old database of Amibroker or data import format without requiring any modifications.
A New version released which includes Open Interest and Series Filter. You can download from the link https://drive.google.com/drive/folders/1QYUXC-GJQRV5zRnC_SPLJ70Mq5yQY7UP?usp=share_link
I have shifted the BID discussion. You can down load the update from here. https://github.com/iMakeBid/BID/issues/1#issuecomment-1579134275
NSE DOwnload is stopped since few days.
If you have updated, then pl provide here