My Latest May 2026 Stock Market Data Bank in an Excel Sheet

 Dear Readers, Namaskar

I am happy to provide you my latest May 2026 stock market data bank in an Excel sheet.

This is my personal data bank, and I personally use this data bank in my own research. 

I hope this database is useful in your stock market research.

Link for download May 2026 Indian stock market data bank:-

https://docs.google.com/spreadsheets/d/1bLhQHhHQY4Te_H_4HqembE7wPFTlFAZ9/edit?usp=sharing&ouid=111573829003502969131&rtpof=true&sd=true

Link of my best-selling books:- 

https://amzn.to/3ypVYpi

How to use this data bank?           

Please watch this video to understand how you find the best stocks with the help of this data bank:-

1. https://youtu.be/BYm-rppAHSc?si=9rvWdjaiCWQi7h2z

अपना खुद का डाटा बैंक कैसे बनाएं?

How you make your own data bank like this:- Many followers ask how they make their own data bank like this. if you are also interested in knowing how this type of data will be collected, you will watch this video to learn more:-

1. https://youtu.be/1z-xatk8LKg?si=oB08hoVvGC-EzdZX

Please remember to share your view in the comments because your comments give me more energy for my hard work.

Regards

Mahesh Kaushik

सावधान मेरी कोई पेड सर्विस नहीं है यदि कोई मेरी फोटो फेसबुक टेलीग्राम या इन्स्टाग्राम या व्हाटसअप पर लगाकर आपसे पैसे मांग कर कोई प्लान बेचता है तो वो मैं नहीं हूं आप उसकी रिर्पोट करें तथा हमेंशा याद रखें मैं ना तो फोलोवर्स से फोन पर बात करता हूं ना ही उन्हे कोई प्लान बेचता हूं ना ही किसी से कोई पैसा मांगता हूं। मेरा अधिकृत व्हाटसअप चैनल इस लिंक से ज्वाईन कर लेवें :- https://whatsapp.com/channel/0029VaAhVMU5kg78k93n662x व वर्तमान में मेरी कोई एप भी नहीं है सिर्फ व्हाटसअप चैनल पर ही मैं ऐप की तरह मेरे ब्लाॅगस व यूटयूब चैनल के अपडेट शेयर करता हूं इसके अलावा कोई प्लान वगैरा कभी भी व्हाटसएप पर भी नहीं देता तथा ना ही कोई टीप देता हूं। मुझसे सीखने का एक ही तरीका है मेरी किताबें पढें व मेरे वीडियोज देखकर खुद सीखें।

Follow me on X here:-

https://x.com/mahesh_kaushik

I have no any paid service, do not provide any tips, do not sell any plan, and never ask for money from followers, so please do not pay money to anyone. If anyone uses my profile picture and sells any plan on Telegram, Facebook, Instagram or WhatsApp, then please report them and protect yourself from spammers, hackers, and cyber fraudsters.

Disclaimer: - Please remember that I collect all data of this data bank from my own credible source. Some of the data like stock price year high-low ,net sales etc., are subject to change regularly.
 So It is possible some data are not correct or may be modified when you download this sheet so please always confirm data from the stock exchange website or company website, No liability is accepted for this purpose.

Keywords:- Indian stock market data bank, stock market data download, stock market data in Excel.

Stocks Historical Data Download in Excel किसी स्टाॅक के हिस्टोरीकल डाटा को ऐक्सेल फाईल के रूप में कैसे डाउनलोड करें।

 साथियो नमस्कार,

Namaskar Friends

किसी स्टाॅक के डाटा पर रिसर्च करने के लिये हमें उस स्टाॅक के डाटा को ऐक्सेल में डाउनलोड करने की आवश्यकता होती है।

To research a stock's data, we need to download that stock's data into Excel.

हालांकि एनएसई की वेबसाईट के नये डिजाईन में अभी भी स्टाॅक के हिस्टोरीकल डाटा को डाउनलोड करने का लिंक दिया है जिसको यह लिंक नहीं मिल रहा है वो निम्न वीडियो से देखकर सीख सकते हैं कि किसी स्टाॅक के हिस्टोरीकल डाटा को डाउनलोड करने के लिये लिंक एनएसई की साईट पर कहां मिलता है-

https://youtu.be/XRZAYcHT2EQ

However, the new design of the NSE website still provides the link to download the historical data of a stock. Those who are unable to find this link can watch the following video to learn where the link to download a stock's historical data is located on the NSE site.:-

Video Link:-

https://youtu.be/XRZAYcHT2EQ

इसमें एनएसई से डाटा डाउनलोड करने में बहुत सी समस्याएं सामने आती है जैसे एनएसई 1 साल से ज्यादा के डाटा को ऐक्सेल में डाउनलोड नहीं करने देती। इसमें हमें यदि 7 साल के डाटा चाहिए तो 7 अलग अलग ऐक्सेल फाईलें डाउनलोड करके फिर एक फाईल में डाटा काॅपी पेस्ट करना पड़ता है इस पूरी प्रक्रिया में लगभग 2 घंटें लग जाते है जो बहुत ही श्रमसाध्य कार्य है।

In this process, several issues arise when downloading data from the NSE; for instance, the NSE does not allow downloading more than one year of data into Excel at once. If we need seven years of data, we have to download seven separate Excel files and then copy-paste the data into a single file. This entire process takes about two hours and is a very laborious task.

इसके विकल्प के रूप में याहू फायनेंस से एक साथ हिस्टोरीकल डाटा ऐक्सेल फाईल में मैक्रो फार्मूला लगाकर कर सकते हैं। इसके लिये मैने ऐक्सेल की मैक्रो वाली फाईल बनायी है ऐसा दावा मैं नहीं करूंगा क्यो कि ईमानदारी सबसे अच्छी पाॅलिसी है मैं झूठा क्रेडिट नहीं लूगा मैने जो ऐक्सेल फाईल उक्त वीडियो में प्रयोग की है वो मैने इस वेबसाईट से डाउनलोड की हैः-

https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html

As an alternative, historical data can be pulled from Yahoo Finance all at once by using a Macro formula in an Excel file. I will not claim that I created this Excel Macro file myself, because honesty is the best policy and I won't take false credit. The Excel file I used in the aforementioned video was downloaded from this website:-

https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html

ध्यान रहे उक्त वेबसाईट से मेरा कोई काॅलोबरेशन नहीं है। मैं इन्टरनेट से सर्च करके ही इस वेबसाईट तक पहुंचा हूं अतः कोई भी फाईल अपनी रिस्क पर उक्त वेबसाईट से डाउनलोड करें मुझे तो कोई समस्या नहीं आयी है।

Please note that I have no collaboration with the said website. I reached this site simply by searching the internet; therefore, download any file from there at your own risk. I personally did not encounter any issues.

ज्यादा जानकारी के लिये निफ्टी की दुकान के वीडियो पहले भाग से देखें इसके पूरे कोर्स की प्लेलिस्ट का लिंक निम्न हैः-

https://www.youtube.com/playlist?list=PL-X8WTMcEbY9PwIlpUbaMtp1JNNtdcWyM

For more information, watch the 'Nifty Ki Dukaan' videos starting from the first part. The link to the full course playlist is below:-

https://www.youtube.com/playlist?list=PL-X8WTMcEbY9PwIlpUbaMtp1JNNtdcWyM

Annual audit report in respect of compliance in terms of regulation 25(3) of the SEBI (Research analysts) Regulations,2014

 Respected Readers,

As a part of the compliance Annual Audit Report in respect of compliance in terms of regulation 25(3) of the SEBI (Research Analysts) Regulations,2014, is published here.

Here are the links of the Annual Audit Report of my activities as a research analyst:-

Annual Audit Report 2024-25

                                                                                                      Mahesh Chander Kaushik

                                                                                                                   Research Analyst

Grievance Redressal/ Escalation Matrix to be displayed by Investment Advisers and Research Analysts

 प्रिय पाठको

जैसा कि आपको विदित है मैं 2009 से स्टाॅक मार्केट की फ्री शिक्षा अपने ब्लाॅग व यूटयूब चैनल से उपलब्ध करवा रहा हूं। मेरी कोई फीस नहीं है तथा यद्पि मैं खुद पंजीकृत रिसर्च एनालिस्ट हूं फिर भी सभी को मैं यही सलाह देता हूं कि मेरे सभी वीडियो व पोस्ट सिर्फ एजुकेशनल पपर्ज के लिये हैं इन्हे किसी भी तरीके से निवेश सलाह नहीं माना जावे तथा कोई भी निवेश संबधि निर्णय अपने निवेश सलाहाकार की सलाह से ही करें।

चूंकि मैं निस्वार्थ भाव से जानकारी के उद्देश्य से बगैर निवेश सलाह के वीडियो बनाता हूं तथा मैं अपना अनुभव मात्र व मेरी बनायी हुयी गुगल शीटें व मेरा ज्ञान पुस्तकों के माध्यम से आपके साथ शेयर करता हूं इसलिये मुझसे आपको कोई शिकायत होनी तो नहीं चाहिये फिर भी आपको कोई शिकायत हो तो आपके लिये मेरा सम्पर्क सूत्र निम्न प्रकार से हैः-

Details of designation	Contact Person Name	Address where the physical address location	Contact No.	Email-ID	Working hours when the complainant can call
Customer Care	Mahesh Chander Kaushik	JJ Colony Pindwara Sirohi Rajasthan 307022	N.A	mahesh2073@yahoo.com	N.A
Head of Customer Care	Mahesh Chander Kaushik	JJ Colony Pindwara Sirohi Rajasthan 30702	N.A	mahesh2073@yahoo.com	N.A
Compliance Officer	Mahesh Chander Kaushik	JJ Colony Pindwara Sirohi Rajasthan 30702	N.A	mahesh2073@yahoo.com	N.A
CEO	Mahesh Chander Kaushik	JJ Colony Pindwara Sirohi Rajasthan 30702	N.A	mahesh2073@yahoo.com	N.A
Principal Officer	Mahesh Chander Kaushik	JJ Colony Pindwara Sirohi Rajasthan 30702	N.A	mahesh2073@yahoo.com	N.A

 

Investor Charter

 Investor Charter in respect of Research Analyst (RA) 

I, Mahesh Chander Kaushik, am a NISM Certified SEBI Registered Research Analyst (Reg. No. INH 100000908). I provide free stock market education through my blog, YouTube channel, and books. I do not give any paid stock tips or offer any paid courses. Do not give any paid or free buy hold sell recommendation. I only spread my knowledge through my books blog and YouTube channel which is only for educational purposes. Therefore, please do not make any payments to anyone in my name.

Please do not make any investment decisions on behalf of my videos and my books always take proper advice from a registered investment advisor.

A. Vision and Mission Statements for investors. 

 Vision Invest with knowledge & safety. 

 Mission Every investor should be able to invest in right investment products based on their needs, manage and monitor them to meet their goals, access reports and enjoy financial wellness. 

B. Details of business transacted by the Research Analyst with respect to the investors. 

 To publish research report based on the research activities of the RA. 

 To provide an independent unbiased view on securities. 

 To offer unbiased recommendations, disclosing the financial interests in recommended securities. 

 To provide research recommendation, based on analysis of publicly available information and known observations. 

 To conduct audit annually. 

C. Details of services provided to investors (No Indicative Timelines)

  Onboarding of Clients. 

 Disclosure to Clients o To distribute research reports and recommendations to the clients without discrimination. 

  To maintain confidentiality w.r.t publication of the research report until made available in the public domain. 

D. Details of grievance redressal mechanism and how to access it In case of any grievance / complaint, an investor should approach the concerned research analyst and shall ensure that the grievance is resolved within 30 days. If the investor’s complaint is not redressed satisfactorily, one may lodge a complaint with SEBI on SEBI’s SCORES portal which is a centralized web based complaints redressal system. SEBI takes up the complaints registered via SCORES with the concerned intermediary for timely redressal. SCORES facilitates tracking the status of the complaint. With regard to physical complaints, investors may send their complaints to: the Office of Investor Assistance and Education, Securities and Exchange Board of India, SEBI Bhavan. Plot No. C4-A, ‘G’ Block, Bandra-Kurla Complex, Bandra (E), Mumbai - 400 051. E. Expectations from the investors (Responsibilities of investors).

  Do’s 

i. Always deal with SEBI registered Research Analyst.

 ii. Ensure that the Research Analyst has a valid registration certificate. 

iii. Check for SEBI registration number. 

iv. Please refer to the list of all SEBI registered Research Analysts which is available on the SEBI website in the following link: (https://www.sebi.gov.in/sebiweb/other/OtherAction.do?doRecognisedFpi=yes &intmId=14 ) 

v. Always pay attention to disclosures made in the research reports before investing. vi. Pay your Research Analyst through banking channels only and maintain duly signed receipts mentioning the details of your payments. 

vii. Before buying securities or applying for a public offer, check for the research recommendation provided by your research Analyst. 

viii. Ask all relevant questions and clear your doubts with your Research Analyst before acting on the recommendation. ix. Inform SEBI about Research Analyst offering assured or guaranteed returns. 

 Don’ts i. Do not provide funds for investment to the Research Analyst. 

ii. Don’t fall prey to luring advertisements or market rumors. 

iii. Do not get attracted to limited-period discounts or other incentives, gifts, etc. offered by the Research Analyst. 

iv. Do not share login credentials and passwords of your trading and demat accounts with the Research Analyst.  

Annexure- B Complaint Data to be displayed by RAs Formats for investors complaints data to be disclosed monthly by RAs on their website/mobile application: 

Data for the month ending -_March 2025____________ 

No complaints were received.

Earlier Pending Complaint :- Nil