Updating bhavcopy until issue resolved

[neerajkrpal]

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]

Check out this comment

[bubbu64]

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]

Hi,

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

[neerajkrpal]

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]

Thanks for your valuable contribution.

[JITHUJT]

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

[neerajkrpal]

I am using excel as I am good in that. Copying two files (one for Indices and other for scrip from NSE website) and pasting in excel in which I put some simple functions. I paste excel output in text file.

It only take time enough for three time copy-paste, hardly 2 minutes.

On Thu, 13 Apr, 2023, 3:33 pm JITHUJT, @.***> wrote:

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

— Reply to this email directly, view it on GitHub https://github.com/hemenkapadia/getbhavcopy/issues/224#issuecomment-1506694707, or unsubscribe https://github.com/notifications/unsubscribe-auth/A7DS57YUHTV2A5NDFI3OR2DXA7FOTANCNFSM6AAAAAAW2SITUQ . You are receiving this because you authored the thread.Message ID: @.***>

[RS-NDIND]

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]

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]

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.

[lokeshbharadia]

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]

Thank you Neeraj for sharing the files..

[desood78]

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]

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

[binay222singh]

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]

2023-04-13-NSE-EQ.txt

[binay222singh]

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: @.***>

[neerajkrpal]

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]

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]

Thanks for quick response!!Sent from my iPhoneOn 15-Apr-2023, at 9:48 AM, neerajkrpal @.***> wrote:

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: @.>

updated. please download again.

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you commented.Message ID: @.***>

[neerajkrpal]

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]

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]

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]

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]

But order has no significance while uploading data in AB. AmiBroker will read data itself from respective ticker code.

[JITHUJT]

2023-04-17-NSE-EQ.txt

[ar23a]

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]

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

[sahaveer]

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

[sheetal020]

need it for metastoke