hemenkapadia / getbhavcopy

Free NSE and BSE data downloader
http://www.getbhavcopy.com
112 stars 49 forks source link

could not dowload data since 29.3.23 #219

Open mehul-bosamia opened 1 year ago

mehul-bosamia commented 1 year ago

whie downloading data it is showing -

Message Starting Getbhavcopy Message Downloading Data for 31-03-2023 Message Downloading NSE Equity Bhavcopy Error Could not extract NSE zip file. Error Cannot find central directory Message Downloading index data for NSENIFTY

Request to sort the issue.

niteshmurti commented 1 year ago

I went into options and switched to the new nse website and I'm getting this - Message Downloading Data for 29-03-2023 Message Downloading NSE Equity Bhavcopy Error Error downloading NSE Equity Bhavcopy file Error The request was aborted: The connection was closed unexpectedly. Message Downloading index data for NSENIFTY

I think it's a mess up from nse side as they've permanently deleted their old website and the new website is not able to give bhavcopy data to getbhavcopy for some reason. Can someone please give me 27-3-23 data in txt format as I'm missing that as well and also the F&O data for whole week 27/3 to 31/3. Thanks!

alferns15 commented 1 year ago

2023-03-28-NSE-EQ.txt 2023-03-28-NSE-FO.txt 2023-03-29-NSE-EQ.txt 2023-03-29-NSE-FO.txt 2023-03-31-NSE-EQ.txt 2023-03-27-NSE-EQ.txt 2023-03-27-NSE-FO.txt

alferns15 commented 1 year ago

I too could not get 31.03.2023 FO.txt file. Hope this issue will be resolved soon for the benefit of all who were doing analysis through GetBhavcopy free software.

niteshmurti commented 1 year ago

2023-03-28-NSE-EQ.txt 2023-03-28-NSE-FO.txt 2023-03-29-NSE-EQ.txt 2023-03-29-NSE-FO.txt 2023-03-31-NSE-EQ.txt 2023-03-27-NSE-EQ.txt 2023-03-27-NSE-FO.txt

Wow! Thanks a lot buddy! Where do you get this data from? Please teach me, so that I can become atmahnirbhar

alferns15 commented 1 year ago

Till 29.03.23 I used to download these Equity & FO txt files from Himen Kapadia's GETBHAVCOPY software which is free to use. Problems started from 31st March and I could not download from GetBhavcopy. Presume GetBhavcopy will be updated to get data from the NSE new website. Hope this problem will be resolved soon. Glad that I could be of help to you.

niteshmurti commented 1 year ago

Ah! I see, thanks!

alferns15 commented 1 year ago

Mr. Mehul Bosamia, Is it possible to download EQUITY & FO txt files directly from NSE new website? As you know now we can not download using GETBHAVCOPY software. Kindly advise. Thank you.

alferns15 commented 1 year ago

I used to update my MetaStock data using GetBhavcopy software till 29.03.2023. Could not do the same since 31.03.2023. That is why seeking your assistance.

morphu77 commented 1 year ago

Any updates or workaround ?

image

rajbrs commented 1 year ago

Same problem here today.

madhanji commented 1 year ago

dear heman. please look into this matter, resolve as soon as possible with your kind...

madhanji commented 1 year ago

2023-03-28-NSE-EQ.txt 2023-03-28-NSE-FO.txt 2023-03-29-NSE-EQ.txt 2023-03-29-NSE-FO.txt 2023-03-31-NSE-EQ.txt 2023-03-27-NSE-EQ.txt 2023-03-27-NSE-FO.txt

31.03.2023 data not have index data

madhanji commented 1 year ago

2023-03-28-NSE-EQ.txt 2023-03-28-NSE-FO.txt 2023-03-29-NSE-EQ.txt 2023-03-29-NSE-FO.txt 2023-03-31-NSE-EQ.txt 2023-03-27-NSE-EQ.txt 2023-03-27-NSE-FO.txt

31.03.2023 data not have index data

RS-NDIND commented 1 year ago

EQ_2023APR03.txt

Index data not included

niravshah74 commented 1 year ago

facing same problem......... todays data is downloading

Rvgandhi commented 1 year ago

same issue ; unable to download NSE data

bubbu64 commented 1 year ago

NSE has changed their website address and I guess Hemen ji needs to update the parsing script in the exe file

niteshmurti commented 1 year ago

Mr. Mehul Bosamia, Is it possible to download EQUITY & FO txt files directly from NSE new website? As you know now we can not download using GETBHAVCOPY software. Kindly advise. Thank you.

Go to nse website, then hover on resources, then click on daily market reports then click on archives (next to monthly reports), then select a date, then scroll down to the end and download full bhavcopy and security deliverable data.

This you will get in excel sheet. In order to make it compatible with Metastock, you will need to filter EQ/BE data, change the date format into yyyymmdd, and remove all columns except symbol,date,open,high,low,close,totaltradedvol,totaldeliveryqty, then you have to somehow make it into txt or ascii format, then convert it into metastock format and voila you're done! I'm unable to convert it into txt format, so if you figure that part out then please help me also!!

shyam027 commented 1 year ago

I am also facing the same issue:

Message Starting Getbhavcopy Message Downloading Data for 03-04-2023 Message Downloading NSE Equity Bhavcopy Error Could not extract NSE zip file. Error Cannot find central directory Message Downloading index data for NSENIFTY

Kindly resolve it.

Thanks

MSurenBabu commented 1 year ago

Yes, same error for NSE equity segment. Request to kindly provide some solution to this issue.

bijoy2526 commented 1 year ago

I have sent mail to hemantji let us see what happens.

bijoy2526 commented 1 year ago

from nse india website it can be downloaded.but date dd/april/yyyy for mat is there,and amibroker needs month in no form. and instead of ticker it is symbol is there.

Shivkumar2023 commented 1 year ago

Anyone know about this application source code. Is it possible to work on the codes and change the settings?

alferns15 commented 1 year ago

Mr. Mehul Bosamia, Is it possible to download EQUITY & FO txt files directly from NSE new website? As you know now we can not download using GETBHAVCOPY software. Kindly advise. Thank you.

Go to nse website, then hover on resources, then click on daily market reports then click on archives (next to monthly reports), then select a date, then scroll down to the end and download full bhavcopy and security deliverable data.

This you will get in excel sheet. In order to make it compatible with Metastock, you will need to filter EQ/BE data, change the date format into yyyymmdd, and remove all columns except symbol,date,open,high,low,close,totaltradedvol,totaldeliveryqty, then you have to somehow make it into txt or ascii format, then convert it into metastock format and voila you're done! I'm unable to convert it into txt format, so if you figure that part out then please help me also!!

Tried but no success. The NSE file is in Excel Format which I am unable to convert to the data type, date format and removal of unecessary data columns. Thank you for your response and advice.

niteshmurti commented 1 year ago

I have sent mail to hemantji let us see what happens.

Please provide Hemenjis email. Everyone should send email to Hemenji.

shyam027 commented 1 year ago

NSE Website says the following:

Effective 01-April-2023, our old website (www1.nseindia.com) shall not be available.

All the information which was accessible on old website has been advanced to the new website for our esteemed patrons convenience.

To visit the new NSE website

This might be the reason, Hemen Kapadia Ji should help his followers to deal with this problem. It is really a very cute utility, looking forward to seeing some solution very soon.

Thanks

morphu77 commented 1 year ago

EQ_2023APR03.txt

Index data not included

Thanks , Much appreciated .How did you download this version of the feed?

morphu77 commented 1 year ago

The files on nse have been moved to https://archives.nseindia.com/content/equities/eq_band_changes_06042023.csv . the bhavcopy should have an option to change to this address . i hope Hemant can make this quick change , His application has many loyal users using it for years , Hopefully he won't leave them in lurch :(

image

niravshah74 commented 1 year ago

shall we get todays file?

kbs7010 commented 1 year ago

cm05APR2023bhav.txt Index data not included

imcandlestick commented 1 year ago

cm05APR2023bhav.txt Index data not included

Thank you very much... can you tell us how did you get this file??

RS-NDIND commented 1 year ago

cm05APR2023bhav.txt Index data not included Hi

Are you converting this manually in excel?

Thanks

shyam027 commented 1 year ago

Here are indices data from the following link: https://www.niftyindices.com/reports/daily-reports

ind_close_all_03042023.csv ind_close_all_05042023.csv

kbs7010 commented 1 year ago

cm05APR2023bhav.txt Index data not included Hi

Are you converting this manually in excel?

Thanks

Coverted excel data into .txt , by opening xls file with notepad & save as txt

kbs7010 commented 1 year ago

cm05APR2023bhav.txt Index data not included

Thank you very much... can you tell us how did you get this file??

download csv file from NSE website, then remove column to match data with getbhavcopy file, save that csv, now open that csv file with notepad and save as txt. done

kbs7010 commented 1 year ago

Here are indices data 06-april

ind_close_all_06042023.csv

morphu77 commented 1 year ago

Here are indices data 06-april

ind_close_all_06042023.csv

can you share today's file?

niteshmurti commented 1 year ago

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 data includes indices as well. I manually made these files.

bubbu64 commented 1 year ago

Nitesh Thanks for making those files, i have sent a mail to hemen, he is yet to reply Regards Shailendra Bhide

On Thu, Apr 6, 2023 at 9:54 PM niteshmurti @.***> wrote:

2023-03-31-NSE-EQ.txt https://github.com/hemenkapadia/getbhavcopy/files/11172567/2023-03-31-NSE-EQ.txt 2023-04-03-NSE-EQ.txt https://github.com/hemenkapadia/getbhavcopy/files/11172568/2023-04-03-NSE-EQ.txt 2023-04-05-NSE-EQ.txt https://github.com/hemenkapadia/getbhavcopy/files/11172569/2023-04-05-NSE-EQ.txt 2023-04-06-NSE-EQ.txt https://github.com/hemenkapadia/getbhavcopy/files/11172570/2023-04-06-NSE-EQ.txt

This data includes indices as well. I manually made these files.

— Reply to this email directly, view it on GitHub https://github.com/hemenkapadia/getbhavcopy/issues/219#issuecomment-1499323185, or unsubscribe https://github.com/notifications/unsubscribe-auth/AG6IFPTR4OF6GY3UXSKKBJLW73U5BANCNFSM6AAAAAAWQ3B36I . You are receiving this because you commented.Message ID: @.***>

shyam027 commented 1 year ago

Thanks a lot for your effort in making these files and sharing them with all of us. Looks like there is an error with 5th April file, the dates for all the Index data is 3rd April. Kindly make these corrections.

Best regards

On Thu, Apr 6, 2023 at 9:54 PM niteshmurti @.***> wrote:

2023-03-31-NSE-EQ.txt https://github.com/hemenkapadia/getbhavcopy/files/11172567/2023-03-31-NSE-EQ.txt 2023-04-03-NSE-EQ.txt https://github.com/hemenkapadia/getbhavcopy/files/11172568/2023-04-03-NSE-EQ.txt 2023-04-05-NSE-EQ.txt https://github.com/hemenkapadia/getbhavcopy/files/11172569/2023-04-05-NSE-EQ.txt 2023-04-06-NSE-EQ.txt https://github.com/hemenkapadia/getbhavcopy/files/11172570/2023-04-06-NSE-EQ.txt

This data includes indices as well. I manually made these files.

— Reply to this email directly, view it on GitHub https://github.com/hemenkapadia/getbhavcopy/issues/219#issuecomment-1499323185, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOHIZSOGR4B7OR5KZ7N4RVLW73U5BANCNFSM6AAAAAAWQ3B36I . You are receiving this because you commented.Message ID: @.***>

shyam027 commented 1 year ago

Dear Nitesh Ji,

Thanks a lot for your effort in making these files and sharing them with all of us. Looks like there is an error with 5th April file, the date for all the Index data is 3rd April. Kindly make these corrections.

Best regards

The corrected file is attached herewith.

2023-04-06-NSE-EQ.txt 2023-04-05-NSE-EQ.txt 2023-04-03-NSE-EQ.txt

niteshmurti commented 1 year ago

indices format.xlsx

PFA excel file you can use to make your own indices data. You have to place the new data from nse website on 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.

shyam027 commented 1 year ago

Dear Nitesh Ji,

This is an excellent tool, thanks for sharing. What about the one for the cash market? Looks like you did something similar in another Excel sheet and combined that with index data. I suggest we can have just one Excel sheet, and it should load both the data sets (cash as well as index) and combine the two to have the final ".txt" file, similar to the one Getbhavcopy was giving. Also, if someone is good at Python, he/she can do this even more easily.

Thanks

On Fri, Apr 7, 2023 at 10:30 PM niteshmurti @.***> wrote:

indices format.xlsx https://github.com/hemenkapadia/getbhavcopy/files/11180272/indices.format.xlsx

PFA excel file you can use to make your own indices data. You have to place the new data from nse website on 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.

— Reply to this email directly, view it on GitHub https://github.com/hemenkapadia/getbhavcopy/issues/219#issuecomment-1500464837, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOHIZSNDJLYMHBKYUU5KDCTXABB4HANCNFSM6AAAAAAWQ3B36I . You are receiving this because you commented.Message ID: @.***>

niteshmurti commented 1 year ago

Dear Nitesh Ji, This is an excellent tool, thanks for sharing. What about the one for the cash market? Looks like you did something similar in another Excel sheet and combined that with index data. I suggest we can have just one Excel sheet, and it should load both the data sets (cash as well as index) and combine the two to have the final ".txt" file, similar to the one Getbhavcopy was giving. Also, if someone is good at Python, he/she can do this even more easily. Thanks On Fri, Apr 7, 2023 at 10:30 PM niteshmurti @.> wrote: indices format.xlsx https://github.com/hemenkapadia/getbhavcopy/files/11180272/indices.format.xlsx PFA excel file you can use to make your own indices data. You have to place the new data from nse website on 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. — Reply to this email directly, view it on GitHub <#219 (comment)>, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOHIZSNDJLYMHBKYUU5KDCTXABB4HANCNFSM6AAAAAAWQ3B36I . You are receiving this because you commented.Message ID: @.>

Cash market is simple, you just download the CSV file from the website and delete all columns you don't need, save it, then open it in notepad and save it as .txt the indices data is the tricky bit because you have to manually match the names of the indices (my sheet which I have provided here will do that for you automatically you just have to paste the new data on the right-hand side). Then, you have to combine both datas in a single .txt file. If you can make a single excel sheet to make the process easier then go for it (pls share with rest of us also if you do). Yeah, someone will programming knowledge should make a getbhavcopy replacement software for all of us.

MSurenBabu commented 1 year ago

Dear Nitesh Ji, This is an excellent tool, thanks for sharing. What about the one for the cash market? Looks like you did something similar in another Excel sheet and combined that with index data. I suggest we can have just one Excel sheet, and it should load both the data sets (cash as well as index) and combine the two to have the final ".txt" file, similar to the one Getbhavcopy was giving. Also, if someone is good at Python, he/she can do this even more easily. Thanks On Fri, Apr 7, 2023 at 10:30 PM niteshmurti @.**> wrote: indices format.xlsx https://github.com/hemenkapadia/getbhavcopy/files/11180272/indices.format.xlsx PFA excel file you can use to make your own indices data. You have to place the new data from nse website on 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. — Reply to this email directly, view it on GitHub <#219 (comment)>, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOHIZSNDJLYMHBKYUU5KDCTXABB4HANCNFSM6AAAAAAWQ3B36I . You are receiving this because you commented.Message ID: @.**>

Cash market is simple, you just download the CSV file from the website and delete all columns you don't need, save it, then open it in notepad and save it as .txt the indices data is the tricky bit because you have to manually match the names of the indices (my sheet which I have provided here will do that for you automatically you just have to paste the new data on the right-hand side). Then, you have to combine both datas in a single .txt file. If you can make a single excel sheet to make the process easier then go for it (pls share with rest of us also if you do). Yeah, someone will programming knowledge should make a getbhavcopy replacement software for all of us.

Thanks for letting us know. Also, for cash market, we need to select only EQ series from the bhavcopy. Other series data is not required.

bijoy2526 commented 1 year ago

can any one please provide today's data?

bijoy2526 commented 1 year ago

2023-04-10 NSE-Cash+Indices.csv this is the csv file,how to convert to text file which can be imported in to amibroker

niteshmurti commented 1 year ago

2023-04-10 NSE-Cash+Indices.csv this is the csv file,how to convert to text file which can be imported in to amibroker

Open your CSV file in Notepad, then Save it as .txt under a different name.

bijoy2526 commented 1 year ago

there are additional columna are there.what to do with them?delete them?

niteshmurti commented 1 year ago

there are additional columna are there.what to do with them?delete them?

Yes. 2023-04-10-NSE-EQ.txt