Hi,
I can help you to take out required data for your 50 stocks from Daily Bhav copy and other data sheets that you pull from NSE website.
I went through the project description. I am well versed with Excel and its various features like Pivot tables, HLookup, Vlookup, SUMIF, drop down, filters, charts, graphs, mail merge, dashboards and can provide the Excel that you are looking for.
I have more than 10 years of working experience to my credit.
I will be happy to answer any queries that you may have.
Looking forward to your response.
Thanks