Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Updating bhavcopy until issue resolved #224

Open
neerajkrpal opened this issue Apr 11, 2023 · 76 comments
Open

Updating bhavcopy until issue resolved #224

neerajkrpal opened this issue Apr 11, 2023 · 76 comments

Comments

@neerajkrpal
Copy link

neerajkrpal commented Apr 11, 2023 •
edited
Loading

Hi I am going to update daily bhavcopy in same format as getbhavcopy.
2023-03-27-NSE-EQ.txt
2023-03-28-NSE-EQ.txt
2023-03-29-NSE-EQ.txt
2023-03-31-NSE-EQ.txt
2023-04-03-NSE-EQ.txt
2023-04-05-NSE-EQ.txt
2023-04-06-NSE-EQ.txt
2023-04-10-NSE-EQ.txt
2023-04-11-NSE-EQ.txt
2023-04-12-NSE-EQ.txt
2023-04-13-NSE-EQ.txt
@touchofevil-dev
Copy link

Check out this comment

@bubbu64
Copy link

bubbu64 commented Apr 11, 2023

Hi I am going to update daily bhavcopy in same format as getbhavcopy. 2023-04-10-NSE-EQ.txt 2023-04-11-NSE-EQ .txt

thanks

@amitingraham
Copy link

Hi,

Kindly provide bhavcopy in same format from 29-Mar-2023 to 10-Apr-2023

@neerajkrpal
Copy link
Author

neerajkrpal commented Apr 13, 2023 •
edited
Loading

2023-03-27-NSE-EQ.txt
2023-03-28-NSE-EQ.txt
2023-03-29-NSE-EQ.txt
2023-03-31-NSE-EQ.txt
2023-04-03-NSE-EQ.txt
2023-04-05-NSE-EQ.txt
2023-04-06-NSE-EQ.txt
2023-04-10-NSE-EQ.txt
2023-04-11-NSE-EQ.txt
2023-04-12-NSE-EQ.txt
2023-04-13-NSE-EQ.txt(data has been corrected)

@amitingraham
Copy link

Thanks for your valuable contribution.

@JITHUJT
Copy link

JITHUJT commented Apr 13, 2023

Thank you Neeraj for the files. Can you please let know how you are preparing these files and time taken to create them?

@neerajkrpal
Copy link
Author

neerajkrpal commented Apr 13, 2023 via email

@RS-NDIND
Copy link

Thanks for taking the trouble to help us all out.

Re the equity segment data, been using excel to dump bhavcopy data in to worksheet and then copy/manipulate eq and be data for AB compatible format. Rudimentary workaround as am not proficient with excel or coding.

How are you going about changing the index names to the format being used by GBC?

If you can help with showing how that is to be done, then most should be self sufficient and not needing to bother anyone.

Thanks.

@neerajkrpal
Copy link
Author

neerajkrpal commented Apr 13, 2023 •
edited
Loading

Hopefully this will help you. Go through the files.
I am using VLOOKUP to find the INDEX CODE in CSV file provided by NSE.
Data.convert.xlsx

@RS-NDIND
Copy link

Hopefully this will help you. Go through the files. I am using VLOOKUP to find the INDEX CODE in CSV file provided by NSE. Data convert.xlsx SOP.docx

Thanks very much.

Worked like a charm.

Hope everyone will implement this.

Even bloody ChatGPT did not think of this and was telling me to learn Python. So much for AI !

Once again, much obliged and thanks.

@RS-NDIND RS-NDIND mentioned this issue Apr 14, 2023
Open
@lokeshbharadia
Copy link

2023-03-29-NSE-EQ.txt 2023-03-31-NSE-EQ.txt 2023-04-03-NSE-EQ.txt 2023-04-05-NSE-EQ.txt 2023-04-06-NSE-EQ.txt 2023-04-10-NSE-EQ.txt 2023-04-11-NSE-EQ.txt 2023-04-12-NSE-EQ.txt 2023-04-13-NSE-EQ.txt

sir please send 27/3/23 and 28/3/23 bhavcopy
thanks

@JITHUJT
Copy link

JITHUJT commented Apr 14, 2023

Thank you Neeraj for sharing the files..

@desood78
Copy link

thanks a lot neeraj for sharimg the files but for those who are not very excel friendly all ur language is giberrish ... iwas really so upset as i came across this message of central directory not available ,...are we getting any near tearm solution for this ...also neeraj can you please share 27/03/2023 and 28/03/2023 files as well...guys is there any way we can connect to mr hemen kapadia

@desood78
Copy link

Also the 13th april file is only updated for indicies and not for individual stocks..can u please reshare updated one

@binay222singh
Copy link

2023-03-29-NSE-EQ.txt 2023-03-31-NSE-EQ.txt 2023-04-03-NSE-EQ.txt 2023-04-05-NSE-EQ.txt 2023-04-06-NSE-EQ.txt 2023-04-10-NSE-EQ.txt 2023-04-11-NSE-EQ.txt 2023-04-12-NSE-EQ.txt 2023-04-13-NSE-EQ.txt

sir there is data error in 13-04-2023 specially in stock price plz check

@neerajkrpal
Copy link
Author

neerajkrpal commented Apr 15, 2023 •
edited
Loading

2023-04-13-NSE-EQ.txt

@binay222singh
Copy link

binay222singh commented Apr 15, 2023 via email

@neerajkrpal
Copy link
Author

thanks a lot neeraj for sharimg the files but for those who are not very excel friendly all ur language is giberrish ... iwas really so upset as i came across this message of central directory not available ,...are we getting any near tearm solution for this ...also neeraj can you please share 27/03/2023 and 28/03/2023 files as well...guys is there any way we can connect to mr hemen kapadia

2023-03-27-NSE-EQ.txt
2023-03-28-NSE-EQ.txt

@neerajkrpal
Copy link
Author

neerajkrpal commented Apr 15, 2023 •
edited
Loading

Sir from ABB price is old date plz check Sent from Yahoo Mail on Android On Sat, 15 Apr 2023 at 9:37 AM, @.> wrote: 2023-04-13-NSE-EQ.txt — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you commented.Message ID: @.>
2023-04-13-NSE-EQ.txt
Updated. please download again.

@lokeshbharadia
Copy link

lokeshbharadia commented Apr 15, 2023 via email

@neerajkrpal
Copy link
Author

Also the 13th april file is only updated for indicies and not for individual stocks..can u please reshare updated one

Updated. Download from Initial comment of thread.

@aarki25
Copy link

aarki25 commented Apr 17, 2023

Hi @neerajkrpal , thanks for sharing the excel, in indices you have used vlookup, but for equity you have directly copied from row number, if there is any discrepancy from nse side in any single name being added or removed, whole data will be altered. i think it will be better if you use vlookup for equity list as well

@neerajkrpal
Copy link
Author

But how will VLOOKUP detect the descripency in ticker name?
There is rare chance of that descripency in NSE data, however if that happen and you detect the error after some days, you can merge the symbol in AB.

@aarki25
Copy link

aarki25 commented Apr 17, 2023

Hello, what i meant is, even if one new name gets added or removed from current list, your order in output scrip will be distorted since you have directly copied from rows in input scrip

@neerajkrpal
Copy link
Author

neerajkrpal commented Apr 17, 2023 via email •
edited
Loading

@JITHUJT
Copy link

JITHUJT commented Apr 17, 2023

2023-04-17-NSE-EQ.txt

@ar23a
Copy link

ar23a commented Apr 18, 2023

Could someone kindly provide bhavcopy in AB format from 14-Mar-2023 to 26-Mar-2023

There are many files here:
https://www.nseindia.com/all-reports#cr_equity_daily

Which one to download for daily snapshot of Equity and Indices ?

tia

@sheetal020
Copy link

I need data file from 10-03-2023 can you please send or upload the same. thanks in advance.

@sahaveer
Copy link

Thank you Neeraj for the files. Can you please let know how you are preparing these files and time taken to create them?

Hey, have created a telegram bot to download nse and bse files, been using since 2 months and working gud.
Pls do follow this @Sahav_bot in telegram for downloading equity bhavcopies from both nse and bse.
Created a group as well, https://t.me/bhavcopy_amibroker to get everyday bhavcopies

Hope this helps the EOD community

@neerajkrpal
Copy link
Author

2023-04-21-NSE-EQ .txt
2023-04-20-NSE-EQ .txt

@ashishk53
Copy link

2023-04-21-NSE-EQ .txt 2023-04-20-NSE-EQ .txt

Thanks Neeraj. can you pls provide the bhavcopy for dat 17th, 18th & 19th April as well. thanks

@bubbu64
Copy link

bubbu64 commented Apr 23, 2023

2023-04-21-NSE-EQ .txt 2023-04-20-NSE-EQ .txt

Thanks neeraj

@ravinifty
Copy link

ravinifty commented Apr 24, 2023 •
edited
Loading

hello I need data files from 29 nov to 31 dec 2022 and 1 jan 2023 to 9mar 2023. Please someone upload. Thanks. This data can be uploaded in zip file ?

@ravinifty
Copy link

2023-04-21-NSE-EQ .txt 2023-04-20-NSE-EQ .txt

Thanks Neeraj. can you pls provide the bhavcopy for dat 17th, 18th & 19th April as well. thanks

19 is above. 17/18 uploaded by JITHUJT.

@madhanji
Copy link

futuresbhavcopy.xlsx

With some inspiration from @neerajkrpal sheet I have made this sheet for futures bhavcopy. It's a little tricky to use as a few things need to be kept in mind while using it. You can improve it however you see fit. Please spend some time going through the formulas I have placed in the sheet to understand how it works. Few things to keep in mind are:

  1. You'll have to manually update cells B1, B2 and B3 after every expiry. This is extremely important!!!!
  2. Date in cell S5 must be manually updated everyday.
  3. This sheet is made for the MetaStock format.
  4. FINNIFTY expires every last Tuesday instead of Thursday so don't mess with what I've typed in cells Q8, Q9 and Q10.
  5. Same goes for MIDCPNIFTY, it has weekly expiries so don't mess with cells Q11 to Q17.
    Rest will update automatically. You have to download the futures complete bhavcopy filter only Index and Stock Futures then sort them A to Z, then click "Add Level" in the top-left of the Sort dialog box and sort by expiry "Oldest to Newest". Then copy/paste the data into this sheet.
    Any doubts you can ask.

even you can simplify it via current month is -I and Next month is -II and for month is -III via formula, so that you eliminate every month date updating in cell B1 B2 B3 and also update automatically FINNIFTY and MIDCPNIFTY and if any others..
hope you can understand..

@niteshmurti
Copy link

futuresbhavcopy.xlsx
With some inspiration from @neerajkrpal sheet I have made this sheet for futures bhavcopy. It's a little tricky to use as a few things need to be kept in mind while using it. You can improve it however you see fit. Please spend some time going through the formulas I have placed in the sheet to understand how it works. Few things to keep in mind are:

  1. You'll have to manually update cells B1, B2 and B3 after every expiry. This is extremely important!!!!
  2. Date in cell S5 must be manually updated everyday.
  3. This sheet is made for the MetaStock format.
  4. FINNIFTY expires every last Tuesday instead of Thursday so don't mess with what I've typed in cells Q8, Q9 and Q10.
  5. Same goes for MIDCPNIFTY, it has weekly expiries so don't mess with cells Q11 to Q17.
    Rest will update automatically. You have to download the futures complete bhavcopy filter only Index and Stock Futures then sort them A to Z, then click "Add Level" in the top-left of the Sort dialog box and sort by expiry "Oldest to Newest". Then copy/paste the data into this sheet.
    Any doubts you can ask.

even you can simplify it via current month is -I and Next month is -II and for month is -III via formula, so that you eliminate every month date updating in cell B1 B2 B3 and also update automatically FINNIFTY and MIDCPNIFTY and if any others.. hope you can understand..

You can simplify and improve it however you see fit. I have just made a basic sheet for compiling futures data and provided it here for everyone's perusal.

@sonjoejoseph
Copy link

2023-04-24-NSE-EQ.txt
2023-04-25-NSE-EQ.txt

@desood78
Copy link

has any =body contacted mr hemant kapadia ...its a hell of a task for someone who is not proficient with exccel ...can u please suggest how he can be contacted

@sahaveer
Copy link

hello I need data files from 29 nov to 31 dec 2022 and 1 jan 2023 to 9mar 2023. Please someone upload. Thanks. This data can be uploaded in zip file ?

Here we got these as zipped files already in telegram

Dec 2022 - https://t.me/bhavcopy_amibroker/943

This group will lead u to several other bhavcopies as well from 2019

@sahaveer
Copy link

I need data file from 10-03-2023 can you please send or upload the same. thanks in advance.

Try this link entire March 2023, has both NSE and BSE
https://t.me/bhavcopy_amibroker/1358

1 similar comment
@sahaveer
Copy link

I need data file from 10-03-2023 can you please send or upload the same. thanks in advance.

Try this link entire March 2023, has both NSE and BSE
https://t.me/bhavcopy_amibroker/1358

@lokeshbharadia
Copy link

lokeshbharadia commented Apr 29, 2023 via email

@ashishk53
Copy link

2023-04-21-NSE-EQ .txt 2023-04-20-NSE-EQ .txt

Hi Neeraj,

Can you pls help with 26,27 & 28th April bhavcopy. thanks.

@neerajkrpal
Copy link
Author

2023-04-28-NSE-EQ.txt
2023-04-26-NSE-EQ.txt
2023-04-27-NSE-EQ.txt
2023-04-25-NSE-EQ.txt
2023-04-24-NSE-EQ.txt

@neerajkrpal
Copy link
Author

2023-04-21-NSE-EQ .txt 2023-04-20-NSE-EQ .txt

Hi Neeraj,

Can you pls help with 26,27 & 28th April bhavcopy. thanks.

done

@neerajkrpal
Copy link
Author

please send file of 26,27,28 april 2023 thanks
…
On Wed, Apr 26, 2023 at 9:39 AM sonjoejoseph @.> wrote: 2023-04-24-NSE-EQ.txt https://github.com/hemenkapadia/getbhavcopy/files/11328892/2023-04-24-NSE-EQ.txt 2023-04-25-NSE-EQ.txt https://github.com/hemenkapadia/getbhavcopy/files/11328893/2023-04-25-NSE-EQ.txt — Reply to this email directly, view it on GitHub <#224 (comment)>, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALHAGTPS6OBCGDTIH6W7XKDXDCNYNANCNFSM6AAAAAAW2SITUQ . You are receiving this because you commented.Message ID: @.>

done

@lokeshbharadia
Copy link

lokeshbharadia commented Apr 30, 2023 via email

@ashishk53
Copy link

please send file of 26,27,28 april 2023 thanks
…
On Wed, Apr 26, 2023 at 9:39 AM sonjoejoseph @.> wrote: 2023-04-24-NSE-EQ.txt https://github.com/hemenkapadia/getbhavcopy/files/11328892/2023-04-24-NSE-EQ.txt 2023-04-25-NSE-EQ.txt https://github.com/hemenkapadia/getbhavcopy/files/11328893/2023-04-25-NSE-EQ.txt — Reply to this email directly, view it on GitHub <#224 (comment)>, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALHAGTPS6OBCGDTIH6W7XKDXDCNYNANCNFSM6AAAAAAW2SITUQ . You are receiving this because you commented.Message ID: _@**.**_>

done

@neerajkrpal
Can you pls help with bhavcopy for last week - 2nd to 5th May. thanks

@dadkaryogesh
Copy link

@neerajkrpal
i want full dec 22 to april 23 EOD data , can you please help

@amitpathak25
Copy link

Hi Neeraj,

Will be gratefull if you can upload bhavcopy files from 1st May to 8th May. Thanks.

@amitpathak25
Copy link

@neerajkrpal
Will be grateful if you can upload bhavcopy files from 1st May to 8th May.

@neerajkrpal
Copy link
Author

neerajkrpal commented May 10, 2023 via email

@iMakeBid
Copy link

Hi.. I have designed and developed a application to download the Bhavcopy for NSE Cash segment. It should be live in a day. Hope this will help. Take care.

@iMakeBid
Copy link

iMakeBid commented May 12, 2023 •
edited
Loading

HI. I have designed and developed this application. You all can check it. Hope this helps
https://drive.google.com/drive/folders/1QYUXC-GJQRV5zRnC_SPLJ70Mq5yQY7UP?usp=share_link

@iMakeBid
Copy link

iMakeBid commented May 12, 2023 •
edited
Loading

image

@ashishk53
Copy link

Download from the links given in SOP and use the attached excel file.
…
On Tue, May 9, 2023 at 6:27 PM ydadkar @.> wrote: @neerajkrpal https://github.com/neerajkrpal i have downloaded the CM bhavcopy files per day basis , but getting wrong columns and need to modify 2 - 3 columns and also not getting the volume data. how to do that ? example file cm23DEC2022bhav.csv.zip — Reply to this email directly, view it on GitHub <#224 (comment)>, or unsubscribe https://github.com/notifications/unsubscribe-auth/A7DS573GXZ6OZUS3NQJHYK3XFI5NNANCNFSM6AAAAAAW2SITUQ . You are receiving this because you were mentioned.Message ID: @.>

Hi Neeraj,

Need small help. which daily bhavcopy file have the all indices data... that can be used in the excel (Data convert) you have provided.

@ashishk53
Copy link

Download from the links given in SOP and use the attached excel file.
…
On Tue, May 9, 2023 at 6:27 PM ydadkar @.> wrote: @neerajkrpal https://github.com/neerajkrpal i have downloaded the CM bhavcopy files per day basis , but getting wrong columns and need to modify 2 - 3 columns and also not getting the volume data. how to do that ? example file cm23DEC2022bhav.csv.zip — Reply to this email directly, view it on GitHub <#224 (comment)>, or unsubscribe https://github.com/notifications/unsubscribe-auth/A7DS573GXZ6OZUS3NQJHYK3XFI5NNANCNFSM6AAAAAAW2SITUQ . You are receiving this because you were mentioned.Message ID: @.>

Thanks Niraj for excel sheet. figured out my issues.

@iMakeBid
Copy link

iMakeBid commented Jun 4, 2023

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

@iMakeBid
Copy link

iMakeBid commented Jun 6, 2023

I have shifted the BID discussion. You can down load the update from here.
iMakeBid/BID#1 (comment)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests