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 stock tips or offer any paid courses. Therefore, please do not make any payments to anyone in my name.
किसी स्टाॅक के डाटा पर रिसर्च करने के लिये हमें उस स्टाॅक के डाटा को ऐक्सेल में डाउनलोड करने की आवश्यकता होती है।
To research a stock's data, we need to download that stock's data into Excel.
हालांकि एनएसई की वेबसाईट के नये डिजाईन में अभी भी स्टाॅक के हिस्टोरीकल डाटा को डाउनलोड करने का लिंक दिया है जिसको यह लिंक नहीं मिल रहा है वो निम्न वीडियो से देखकर सीख सकते हैं कि किसी स्टाॅक के हिस्टोरीकल डाटा को डाउनलोड करने के लिये लिंक एनएसई की साईट पर कहां मिलता है-
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.:-
इसमें एनएसई से डाटा डाउनलोड करने में बहुत सी समस्याएं सामने आती है जैसे एनएसई 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.
इसके विकल्प के रूप में याहू फायनेंस से एक साथ हिस्टोरीकल डाटा ऐक्सेल फाईल में मैक्रो फार्मूला लगाकर कर सकते हैं। इसके लिये मैने ऐक्सेल की मैक्रो वाली फाईल बनायी है ऐसा दावा मैं नहीं करूंगा क्यो कि ईमानदारी सबसे अच्छी पाॅलिसी है मैं झूठा क्रेडिट नहीं लूगा मैने जो ऐक्सेल फाईल उक्त वीडियो में प्रयोग की है वो मैने इस वेबसाईट से डाउनलोड की हैः-
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:-
ध्यान रहे उक्त वेबसाईट से मेरा कोई काॅलोबरेशन नहीं है। मैं इन्टरनेट से सर्च करके ही इस वेबसाईट तक पहुंचा हूं अतः कोई भी फाईल अपनी रिस्क पर उक्त वेबसाईट से डाउनलोड करें मुझे तो कोई समस्या नहीं आयी है।
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.
ज्यादा जानकारी के लिये निफ्टी की दुकान के वीडियो पहले भाग से देखें इसके पूरे कोर्स की प्लेलिस्ट का लिंक निम्न हैः-
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:-
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
व वर्तमान में मेरी कोई एप भी नहीं है सिर्फ व्हाटसअप चैनल पर ही मैं ऐप की तरह मेरे ब्लाॅगस व यूटयूब चैनल के अपडेट शेयर करता हूं इसके अलावा कोई प्लान वगैरा कभी भी व्हाटसएप पर भी नहीं देता तथा ना ही कोई टीप देता हूं। मुझसे सीखने का एक ही तरीका है मेरी किताबें पढें व मेरे वीडियोज देखकर खुद सीखें।
I have no any paid service, do not provide any tips, not sell any plan and never ask 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 him 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.
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:-
जैसा कि आपको विदित है मैं 2009 से स्टाॅक मार्केट की फ्री शिक्षा अपने ब्लाॅग व यूटयूब चैनल से उपलब्ध करवा रहा हूं। मेरी कोई फीस नहीं है तथा यद्पि मैं खुद पंजीकृत रिसर्च एनालिस्ट हूं फिर भी सभी को मैं यही सलाह देता हूं कि मेरे सभी वीडियो व पोस्ट सिर्फ एजुकेशनल पपर्ज के लिये हैं इन्हे किसी भी तरीके से निवेश सलाह नहीं माना जावे तथा कोई भी निवेश संबधि निर्णय अपने निवेश सलाहाकार की सलाह से ही करें।
चूंकि मैं निस्वार्थ भाव से जानकारी के उद्देश्य से बगैर निवेश सलाह के वीडियो बनाता हूं तथा मैं अपना अनुभव मात्र व मेरी बनायी हुयी गुगल शीटें व मेरा ज्ञान पुस्तकों के माध्यम से आपके साथ शेयर करता हूं इसलिये मुझसे आपको कोई शिकायत होनी तो नहीं चाहिये फिर भी आपको कोई शिकायत हो तो आपके लिये मेरा सम्पर्क सूत्र निम्न प्रकार से हैः-
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____________
1. Sterlite Technologies Limited (formerly Sterlite Tech) is an Indian tech company based in Pune. The company has 636 patents and operates in over 150 countries. STLTECH Specializes in optical networking, including fiber optics, cables, and network software.
2. STL operates manufacturing facilities in 6 locations including Aurangabad, Pune, Silvassa, and Haridwar. Their Aurangabad plants specialize in producing single-mode optical fibers for internet communication standards.STL invested in the 5G assembling ecosystem as part of the Make in India initiative in 2020.
3. STL has 2 development centers and over 20 sales and marketing offices globally as of major presence in Australia, Brazil, China, Europe (Italy), the Middle East, and the United States.
4. Sterlite Technologies Limited is currently traded at 123.60.
5. Sterlite Technologies Limited is a 2 rupee face value company.
5. Sterlite Technologies Limited is a part of the CNX500 index.
6. The year high of Sterlite Technologies Limited is 179.05 and the Year low is 110.10 So the year high/low ratio is stable below 2. and the stock is entered in the green light zone ( watch this video for more details of the green light zone:-https://www.youtube.com/watch?v=3_7w4CqX1vM
7. The net sale per share of Sterlite Technologies Limited is 173.13 so, in net sale per share term, this stock is a value buy, if you not read my research terms earlier then read these research terms here:- Research Terms of Mahesh Kaushik
8. Do not underestimate the power of net sale per share watch this 1-minute short video to understand how net sale per share recommendations give multi-bagger returns in the long run:-https://www.youtube.com/shorts/qWbJZNlzLCM
9. Book value of Sterlite Technologies Limited is 45.85 and CMP is 123.60.
10. Base price ( 3 Years average price) of Sterlite Technologies Limited is 192.51 so CMP 123.60 is significantly lower than the base price.
11. To download 3-year price data, base price, and graph;- Click here
12. Sterlite Technologies Limited is a dividend-paying company in 2024 it pay 1.00 rupees par share dividend.
13. Promoters of Sterlite Technologies Limited hold 53.99% of shares and no any share pledged by promoters. 6.7% of stocks held by institutions.
15. I recommended buying it in STP method For more details of the STP method watch this video:-https://youtu.be/gREpTaV50bA
18. Disclaimer:- This is not an advisory service to buy or sell. The contents of “this research report” are only for educational purposes. No liability is accepted for any content in “this research report”. The author is neither a registered stockbroker nor a registered advisor and does not give investment advice. His comments are an expression of opinion only and should not be construed in any manner whatsoever as recommendations to buy or sell a stock, option, future, bond, commodity, index, or any other financial instrument at any time. The author recommends that you consult with a qualified investment advisor, one licensed by appropriate regulatory agencies in your legal jurisdiction, before making any investment decisions. Please read the full disclaimer at the bottom of my blog.
19. Discloser:- I Mahesh Chander Kaushik author of this research report is an existing research analyst and passed NISM certification for research analysts. I have also registered under SEBI(RESEARCH ANALYSTS) REGULATIONS, 2014 ( SEBI Registration Number INH 100000908 ) hereby disclose my financial interest in the subject company and the nature of such financial interest:- 1 My associates or relatives have not any shares of Sterlite Technologies Limited but 252 shares of Sterlite Technologies Limited is in my personal holding so my personal interest is included in this stock. 2. Me and my associates or relatives have not any actual/beneficial ownership of one percent or more securities of the subject company (Sterlite Technologies Limited). 3. Me and my associates or relatives have not any other material conflict of interest at the time of publication of the research report. 4. Me and my associates and relatives have not received any type of compensation from the subject company(Sterlite Technologies Limited) in the past twelve months. 5. I am not served as an officer, director, or employee of the subject company ( Sterlite Technologies Limited ). 6. I have been not engaged in the market-making activity for the subject company (Sterlite Technologies Limited).
1. DCB bank was created by merging two banks, Ismailia Co-operative Bank Limited and Masalawala Co-operative Bank. These two banks joined together to become Development Co-operative Bank.
2. Later, in May 1995, the Reserve Bank of India gave them a special license, and they changed their name to Development Credit Bank.
3. DCB Bank Ltd has 400 branches.
4. DCB Bank Ltd is currently traded at 114.80.
5. DCB Bank Ltd is a 10 rupee face value company.
5. DCB Bank Ltd (DCB) is a part of the Nifty Bank, DCB Bank Ltdtraded at P/E ratio of 7.36 and the Nifty Bank traded at P/E of 14.72, So the Company's P/E is less than INDEX P/E, this is a sign of cheap valuation.
6. The year high of DCB Bank Ltd is 141.20 and the Year low is 96.55 So the year high/low ratio is stable below 2.
7. The net sale per share of DCB Bank Ltd is 134.84 so, in net sale per share term, this stock is a value buy, if you are not read my research terms earlier then read these research terms here:- Research Terms of Mahesh Kaushik
8. Do not underestimate the power of net sale per share watch this 1-minute short video to understand how net sale per share recommendations give multi-bagger returns in the long run:-https://www.youtube.com/shorts/qWbJZNlzLCM
9. Book value of DCB Bank Ltd is 136.86 and CMP is 114.80.
10. Base price ( 3 Years average price) of DCB Bank Ltd is 102.48 and DCB crosses this base price from 96 to 114.80, CMP is 10.50 percent higher than the base price.
11. To download 3-year price data, base price, and graph;- Click here
12. DCB Bank Ltd is a dividend-paying company in 2023 it pay 1.25 rupees par share dividend.
13. Promoters of DCB Bank Ltd hold 14.83% of shares and no any share pledged by promoters. 52.16% of stocks held by institutions.
15. I recommended to buy it in STP method For more details of the STP method watch this video:-https://youtu.be/gREpTaV50bA
18. Disclaimer:- This is not an advisory service to buy or sell. The contents of “this research report” are only for educational purposes. No liability is accepted for any content in “this research report”. The author is neither a registered stockbroker nor a registered advisor and does not give investment advice. His comments are an expression of opinion only and should not be construed in any manner whatsoever as recommendations to buy or sell a stock, option, future, bond, commodity, index, or any other financial instrument at any time. The author recommends that you consult with a qualified investment advisor, one licensed by appropriate regulatory agencies in your legal jurisdiction, before making any investment decisions. Please read the full disclaimer at the bottom of my blog.
19. Discloser:- I Mahesh Chander Kaushik author of this research report is an existing research analyst and passed NISM certification for research analysts. I have also registered under SEBI(RESEARCH ANALYSTS) REGULATIONS, 2014 ( SEBI Registration Number INH 100000908 ) hereby disclose my financial interest in the subject company and the nature of such financial interest:- 1 My associates or relatives have not any shares of DCB bank but 130 sharesof DCB bank ltd is in my personal holding so my personal interest is included in this stock. 2. Me and my associates or relatives have not any actual/beneficial ownership of one percent or more securities of the subject company (DCB). 3. Me and my associates or relatives have not any other material conflict of interest at the time of publication of the research report. 4. Me and my associates and relatives have not received any type of compensation from the subject company(DCB) in the past twelve months. 5. I am not served as an officer, director, or employee of the subject company ( DCB ). 6. I have been not engaged in the market-making activity for the subject company (DCB).
1. Bank of India (BOI) is a bank in India. It was established in 1906.
The bank is owned by the government since 1969.
2. The headquarters of BOI is in Bandra Kurla Complex, Mumbai.
BOI is a member of SWIFT, which helps with financial processing and communication.
3. Bank of India (BOI) has 5,108 branches and 5,551 ATMs worldwide, including 24 overseas branches.
4. Bank of India is currently traded at 83.45.
5. Bank of India is a 10 rupee face value company.
5. Bank of India (BOI) is a part of the Nifty Bank, Bank of India (BOI)traded at P/E ratio of 6.84 and the Nifty Bank traded at P/E of 17.10, So the Company's P/E is less than INDEX P/E, this is a sign of cheap valuation.
6. Year high of Bank of India (BOI) is 103.50 and the Year low is 45.85 Although the year high/low ratio yet not stable below 2 but other indicators attract me to recommend this stock.
7. Net sale per share of Bank of India is 116.78 so, in net sale per share term, this stock is a value buy, if you are not read my research terms earlier than read these research terms here:- Research Terms of Mahesh Kaushik
8. Do not underestimate the power of net sale per share watch this 1-minute short video to understand how net sale per share recommendations give multi-bagger returns in the long run:-https://www.youtube.com/shorts/qWbJZNlzLCM
9. Book value of Bank of India is 126.90 and CMP is 83.45
10. Base price ( 3 Years average price) of Bank of India is 61.93.
11. To download 3-year price data, base price, and graph;- Click here
12. BOI is a dividend-paying company for the last 2 Years it pay 2 rupees par share dividend.
14. Promoters of BOI is the government of India and the government hold 81.41% of shares and no any share pledged by promoters.
18. Disclaimer:- This is not an advisory service to buy or sell. The contents of “this research report” are only for educational purposes. No liability is accepted for any content in “this research report”. The author is neither a registered stockbroker nor a registered advisor and does not give investment advice. His comments are an expression of opinion only and should not be construed in any manner whatsoever as recommendations to buy or sell a stock, option, future, bond, commodity, index, or any other financial instrument at any time. The author recommends that you consult with a qualified investment advisor, one licensed by appropriate regulatory agencies in your legal jurisdiction, before making any investment decisions. Please read the full disclaimer at the bottom of my blog.
19. Discloser:- I Mahesh Chander Kaushik author of this research report is an existing research analyst and passed NISM certification for research analysts. I have also registered under SEBI(RESEARCH ANALYSTS) REGULATIONS, 2014 ( SEBI Registration Number INH 100000908 ) hereby disclose my financial interest in the subject company and the nature of such financial interest:- 1 Me and my associates or relatives not hold any shares of BOI so my personal interest is not included in this stock. 2. Me and my associates or relatives have not any actual/beneficial ownership of one percent or more securities of the subject company (BOI). 3. Me and my associates or relatives have not any other material conflict of interest at the time of publication of the research report. 4. Me and my associates and relatives have not received any type of compensation from the subject company(BOI) in the past twelve months. 5. I am not served as an officer, director, or employee of the subject company ( BOI ). 6. I have been not engaged in the market-making activity for the subject company (BOI).
1. GSFC is a chemicals and fertilizers manufacturer owned by the Government of Gujarat, India.
2. It was founded in 1962 and is headquartered in Vadodara.
3. Fertilizers like diammonium phosphate, ammonium sulfate, and urea generate over 60% of the company's revenue. Industrial products like caprolactam, nylon 6, melamine, and MEK oxime contribute to the remaining revenue.
4. It set up a subsidiary called Gujarat Narmada Valley Fertilisers & Chemicals in Bharuch in 1976. In 2012, GSFC incorporated a wholly-owned subsidiary called GSFC AgroTech Limited (GATL).
4. Gujrat State Fertilizers & Chemicals Limited (GSFC) is currently traded at 123.35.
5. Gujrat State Fertilizers & Chemicals Limited (GSFC) is a 2 rupee face value company.
5. Gujrat State Fertilizers & Chemicals Limited (GSFC) is a part of the Nifty 500, Gujrat State Fertilizers & Chemicals Limited (GSFC) traded at P/E ratio of 3.62 and the Nifty500 traded at P/E 21.43, So the Company P/E is less than INDEX P/E, this is a sign of cheap valuation.
6. Year high of Gujrat State Fertilizers & Chemicals Limited (GSFC) is 183.40 and the Year low is 114.65 , Year high/low ratio is stable below 2.
7. Net sale per share of Gujrat State Fertilizers & Chemicals Limited (GSFC) is 225.74 so in net sale per share term, this stock is a value buy, if you are not read my research terms earlier than read these research terms here:- Research Terms of Mahesh Kaushik
8. Do not underestimate the power of net sale per share watch this 1-minute short video to understand how net sale per share recommendations give multi-bagger returns in the long run:-https://www.youtube.com/shorts/qWbJZNlzLCM
9. Book value of Gujrat State Fertilizers & Chemicals Limited (GSFC) is 293.17 and CMP is 123.35
10. Base price ( 3 Years average price) of Gujrat State Fertilizers & Chemicals Limited (GSFC) is 109.11 So CMP 123.35 is 13.05 % above from base price, so as per my book "How to make profit in share market" (Old name The winning theory in stock market both books are same) this is a good time to buy.
11. To download 3-year price data, base price, and graph;- Click here
12. Gujrat State Fertilizers & Chemicals Limited (GSFC) is a dividend-paying company see past dividend history here:-
13. I recommended buying it with my STP method and the STP price for 1 April 2023 to 15 April 2023 is 126.80, In the STP method buy, our target is 25% plus.
14. Promoters of Gujrat State Fertilizers & Chemicals Limited (GSFC) hold 37.84% of shares and no any share pledged by promoters.
18. Disclaimer:- This is not an advisory service to buy or sell. The contents of “this research report” are only for educational purposes. No liability is accepted for any content in “this research report”. The author is neither a registered stockbroker nor a registered advisor and does not give investment advice. His comments are an expression of opinion only and should not be construed in any manner whatsoever as recommendations to buy or sell a stock, option, future, bond, commodity, index, or any other financial instrument at any time. The author recommends that you consult with a qualified investment advisor, one licensed by appropriate regulatory agencies in your legal jurisdiction, before making any investment decisions. Please read the full disclaimer at the bottom of my blog.
19. Discloser:- I Mahesh Chander Kaushik author of this research report is an existing research analyst and passed NISM certification for research analysts. I have also registered under SEBI(RESEARCH ANALYSTS) REGULATIONS, 2014 ( SEBI Registration Number INH 100000908 ) hereby disclose my financial interest in the subject company and the nature of such financial interest:- 1 Me and my associates or relatives not hold any shares of GSFC so my personal interest is not included in this stock. 2. Me and my associates or relatives have not any actual/beneficial ownership of one percent or more securities of the subject company (GSFC). 3. Me and my associates or relatives have not any other material conflict of interest at the time of publication of the research report. 4. Me and my associates and relatives have not received any type of compensation from the subject company(GSFC) in the past twelve months. 5. I am not served as an officer, director, or employee of the subject company ( GSFC ). 6. I have been not engaged in the market-making activity for the subject company (GSFC).
1. Bharat Petroleum Corporation Ltd (BPCL) is an Indian central public sector undertaking under the ownership of the Government of India. It operates three refineries in Bina, Kochi and Mumbai.
2. BPCL is India's second-largest government-owned downstream oil producer, whose operations are overseen by the Ministry of Petroleum and Natural Gas. It was ranked 309th on the 2020 Fortune list of the world's biggest public sector undertakings.
3. Bharat Petroleum Corporation Ltd (BPCL) is currently traded at 341.45.
4. Bharat Petroleum Corporation Ltd (BPCL) is a 10 rupee face value company.
5. Bharat Petroleum Corporation Ltd (BPCL) is a part of the Nifty 500, Bharat Petroleum Corporation Ltd (BPCL) traded at P/E ratio of 8.26 and the Nifty500 traded at P/E 23.43, So the Company P/E is less than INDEX P/E, this is a sign of cheap valuation.
6. Year high of Bharat Petroleum Corporation Ltd (BPCL) is 406.90 and the Year low is 288.05 , Year high/low ratio is stable below 2.
7. Net sale per share of Bharat Petroleum Corporation Ltd (BPCL) is 2035.30 (very attractive) so in net sale per share term this stock is a value buy, if you are not read my research terms earlier then read these research terms here:- Research Terms of Mahesh Kaushik
8. Do not underestimate the power of net sale per share watch this 1-minute short video to understand how net sale per share recommendations give multi-bagger returns in the long run:-https://www.youtube.com/shorts/qWbJZNlzLCM
9. Book value of Bharat Petroleum Corporation Ltd (BPCL) is 201.89 and CMP is 341.45
10. Base price ( 3 Years average price) of Bharat Petroleum Corporation Ltd (BPCL) is 393.16 So CMP 341.45 is 13.15 % below from base price, so as per my book "How to make profit in share market" (Old name The winning theory in stock market both books are same) this is a good time to buy.
11. To download 3-year price data, base price, and graph;- Click here
12. Bharat Petroleum Corporation Ltd (BPCL) is a dividend-paying company see past dividend history here:-
13. I recommended buying it with my STP method and the STP price for 1 Dec 2022 to 15 Dec 2022 is 343.75, In the STP method buy, our target is 25% plus.
14. Promoters of Bharat Petroleum Corporation Ltd (BPCL) hold 52.98% of shares and no any share pledged by promoters.
18. Disclaimer:- This is not an advisory service to buy or sell. The contents of “this research report” are only for educational purposes. No liability is accepted for any content in “this research report”. The author is neither a registered stockbroker nor a registered advisor and does not give investment advice. His comments are an expression of opinion only and should not be construed in any manner whatsoever as recommendations to buy or sell a stock, option, future, bond, commodity, index, or any other financial instrument at any time. The author recommends that you consult with a qualified investment advisor, one licensed by appropriate regulatory agencies in your legal jurisdiction, before making any investment decisions. Please read the full disclaimer at the bottom of my blog.
19. Discloser:- I Mahesh Chander Kaushik author of this research report is an existing research analyst and passed NISM certification for research analysts. I have also registered under SEBI(RESEARCH ANALYSTS) REGULATIONS, 2014 ( SEBI Registration Number INH 100000908 ) hereby disclose my financial interest in the subject company and the nature of such financial interest:- 1 I personally hold 76 shares of BPCL and my wife hold 21 shares of BPCL so my personal interest is included in this stock. 2. Me and my associates or relatives have not any actual/beneficial ownership of one percent or more securities of the subject company (BPCL). 3. Me and my associates or relatives have not any other material conflict of interest at the time of publication of the research report. 4. Me and my associates and relatives have not received any type of compensation from the subject company(BPCL) in the past twelve months. 5. I am not served as an officer, director, or employee of the subject company ( BPCL ). 6. I have been not engaged in the market-making activity for the subject company (BPCL).
1. Petronet LNG Limited is a LPG/CNG/PNG/LNG Supplier PSU company currently traded at 215.50.
2. Petronet LNG Ltd is LPG/CNG/PNG/LNG Supplier company formed by the government of India to import liquefied natural gas (LNG) and set up LNG terminals in the country. Petronet LNG Ltd is a joint venture company promoted by the Gas Authority of India Limited (GAIL), Oil and Natural Gas Corporation Limited (ONGC), Indian Oil Corporation Limited (IOC) and Bharat Petroleum Corporation Limited (BPCL).
3. Adani Petronet (Dahej) Port Pvt Ltd is a subsidiary company of Petronet LNG, Adani Petronet (Dahej) Port Pvt Ltd is also a joint venture company formed by Adani port and Petronet LNG
4. Petronet LNG Limited is a 10 rupee face value company.
5. Petronet LNG Limited is a part of the Nifty 500, Petronet LNG Limited traded at P/E ratio of 9.45 and the Nifty500 traded at P/E 22.63, So Company P/E is less than INDEX P/E, this is a sign of cheap valuation.
6. Year high of Petronet LNG Limited is 243.55 and the Year low is 190.25, Year high/low ratio is stable below 2.
7. Net sale per share of Petronet LNG Limited Ltd is 287.79 so in net sale per share term this stock is a value buy, if you are not read my research terms earlier then read these research terms here:- Research Terms of Mahesh Kaushik
8. Do not underestimate the power of net sale per share watch this 1-minute short video to understand how net sale per share recommendations give multi-bagger returns in the long run:-https://www.youtube.com/shorts/qWbJZNlzLCM
9. Book value of Petronet LNG Limited is 94.18 and CMP is 215.50
10. Base price ( 3 Years average price) of Petronet LNG Limited is 236.02 So CMP 215.50 is 9.52 % below from base price, so as per my book "How to make profit in share market" (Old name The winning theory in stock market both books are same) this is a good time to buy.
11. To download 3-year price data, base price, and graph;- Click here
12. Petronet is a dividend paying comapny see past dividend history here:-
SERIES
FACE VALUE
PURPOSE
EX-DATE
RECORD DATE
BOOK CLOSURE START DATE
BOOK CLOSURE END DATE
EQ
10
Dividend - Rs 4.50 Per Share
04-Jul-2022
05-Jul-2022
-
-
EQ
10
Special Dividend - Rs 7 Per Share
17-Nov-2021
19-Nov-2021
-
-
EQ
10
Annual General Meeting
16-Sep-2021
-
18-Sep-2021
27-Sep-2021
EQ
10
Dividend - Rs 3.50 Per Share
01-Jul-2021
02-Jul-2021
-
-
EQ
10
Interim Dividend - Rs 8 Per Share
23-Nov-2020
24-Nov-2020
-
-
13. I recommended buying it with my STP method and the STP price for 16 Sep 2022 to 30 Se 2022 is 222, In the STP method buy our target is 25% plus.
14. Promoters of Petronet LNG Ltd hold 50 % shares and no any share pledged by promoters.
18. Disclaimer:- This is not an advisory service to buy or sell. The contents of “this research report” are only for educational purposes. No liability is accepted for any content in “this research report”. The author is neither a registered stockbroker nor a registered advisor and does not give investment advice. His comments are an expression of opinion only and should not be construed in any manner whatsoever as recommendations to buy or sell a stock, option, future, bond, commodity, index, or any other financial instrument at any time. The author recommends that you consult with a qualified investment advisor, one licensed by appropriate regulatory agencies in your legal jurisdiction, before making any investment decisions. Please read the full disclaimer at the bottom of my blog.
19. Discloser:- I Mahesh Chander Kaushik author of this research report is an existing research analyst and passed NISM certification for research analysts. I have also registered under SEBI(RESEARCH ANALYSTS) REGULATIONS, 2014 ( SEBI Registration Number INH 100000908 ) hereby disclose my financial interest in the subject company and the nature of such financial interest:- 1 I am personally hold 195 shares of Petronet LNG and my wife hold 77 shares of Petronet LNG so my personal interest is included in this stock. 2. Me and my associates or relatives have not any actual/beneficial ownership of one percent or more securities of the subject company (Petronet LNG Limited). 3. Me and my associates or relatives have not any other material conflict of interest at the time of publication of the research report. 4. Me and my associates and relatives have not received any type of compensation from the subject company(Petronet LNG Limited) in the past twelve months. 5. I am not served as an officer, director, or employee of the subject company ( Petronet LNG Limited ). 6. I have been not engaged in the market-making activity for the subject company (Petronet LNG Limited ).
disclaimer:-Trading in stock market is very risky. This website is not perfect. This is not an advisory service to buy or sell. The contents of “maheshkaushik.com” are only for educational purposes. No liability is accepted for any content in “www.maheshkaushik.com”. Subject to pindwara(india) jurisdiction only.The author is neither a registered stockbroker nor a registered advisor and does not give investment advice.. While he believes his statements to be true, they always depend on the reliability of his own credible sources. The author recommends that you consult with a qualified investment advisor, one licensed by appropriate regulatory agencies in your legal jurisdiction, author of this website is not a trend technical analyst.
