Sunday, December 13, 2020

Mahesh Kaushik Automated Google Finance Sheet For Turtle Trading with Advanced Filter

 Rule of Turtle Trading:- 

1. Buy on 55 Days High.

2. Book Profit or Loss on 20 Days Low.

Watch this You Tube Video for more details:-

https://www.youtube.com/watch?v=fv48GXn-e9o


(इस पोस्ट के नीचे के भाग में हिन्दी में बगैर स्टाॅप लाॅस की टर्टल ट्रेडिंग का वर्णन किया है।)

My Automated google finance sheet link for turtle trading:- ( Raw Sheet with formulas but slow loading):-

https://docs.google.com/spreadsheets/d/1668Tn8Z0BVssBj-2fcubvYF1ZwLZo7Ugu7kY0_YYGIE/edit?usp=sharing

( for copy this sheet click on file menu then click "make a copy", save it with a new name, this will copy this sheet in your google drive and you can able to open it and edit it).


Fast Loading Web Page View Link of turtle trading automated sheet:- ( Web page view load fast but you can unable to edit and copy formulas in web page view).

https://docs.google.com/spreadsheets/d/1XBJg5xwpuTuEQXYJZWbL-pAzN_IM3A1kOTXC_iW0S0c/edit?usp=sharing

Video about daily recommendation automated sheets:-

Part 1

Part 2

Turtle Trading Without Stop Loss

I personally do not believe in putting a stop loss. In my video of Turtle Trading, I told about the stop loss because turtle trading is not my invention and in its original form, the stop loss is put on 20 days low and there is no harm in it.

Because we knew that in any trading method with stop loss it is normal that some stocks hit stop loss. 

But, personally, I am not a supporter of stop loss. Why? Because you may have read such reports from brokerage houses that "our highest account holder investors hold this  XYZ share". 

This means that I understand that where our demat account, they know at which price our stop loss is. They also know that the maximum number of people on which price put there stop loss. Now I do not want to explain further, but the wise people have enough to understand what I want to say?. I would not like to play cards by showing my cards while playing cards (by the way I did not play cards but played in my childhood). That's why my wife (who does turtle trading,)  do not put a stop loss at 20 days low because I have advised her to only trade turtles in ETF and Nifty 100 shares and invest a maximum of 10000 rupees in one share at a time. 

After that, if she gets a profit above 10 percent, which has been found in many shares in the past, then she goes out of her hands by booking a profit and we can rotate this money. 

Those who are my old follower's know-how in 2017 we used to put a stop loss below 5 percent of the 200 DMA, and every time the stock broke our stop loss. 

If any share of the holding has fallen by more than 10 percent, after that it is back in the list of feeding the price for Turtle Trading, then we will start filling GTT order back in it to avail it, no matter that we invest more 10,000 in average out, we should keep such a backup amount that if we have to take shares for 3 times from this method, then we can take it. 

It is necessary to mention here that I had invested a maximum of 100000 in 185 shares of UPL by putting 10,000 at once from Darvas Box Theory. I had a maximum limit of 1 lakh in a share and I had averaged 10 times from Darvas Box Theory after that, at one time, I had a loss of more than 25000 in UPL but I kept it on hold and took a dividend of 1111 rupees and today ( 18 Jan 2021) all 185 shares I  have sold with 3600 rupees profit.

  That is why my wife takes shares of ETF and Nifty 100 from Turtle Trading but sells them by herself, we do not sell with the help of any stop loss. 

You have to decide for yourself whether you have a stop loss or not, but we only invest 10000 in stock and keep so much backup for an average out of 2 to 3 times ( after falling off more than 10 percent in any share.) 

If we get between 10 and 15 percent profits in Turtle Trading, then we take it peacefully and rotate the original money. Overall, we use it in such a way that if the price of stock is reduced from 10 percent to 20 percent from the 55-day high, then we start placing GTT orders daily, updating it according to the latest 55-day high after the order is triggered. If you get 10 to 15 percent profit, then book if the stock falls, and if the stock falls more than 10 percent from our purchase price, you will do an average of 3 times at a high price of 55 days and it is necessary to have at least 10-10 percent difference in each average. 

And we do not keep a low 20-day stop loss and only do Turtle trading in ETF and Nifty 100 stocks. 

This whole story has been told because many e-mails and comments were coming on this subject that when the followers are doing backtest then in some stocks like Hindustan Unilever and ONGC, sometimes the stop loss is getting hit at 20 days low. 

बगैर स्टाॅप लाॅस की टर्टल ट्रेडिंग

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

परन्तु मैं व्यक्तिगत रूप से स्टाॅप लाॅस का समर्थक नहीं हूं। क्यों? क्यों कि आपने ब्रोकरेज हाउसों की ऐसी रिर्पोटें पढ़ी होगी कि इस शेयर को हमारे सबसे ज्यादा खाताधारक निवेशक होल्ड करते हैं। इसका मतलब मैं यह समझता हूं कि जहां अपना डी मैट खाता है उनको पता होता है कि हमारा स्टाॅप लाॅस किस प्राईस पर है। उनको यह भी पता होता है कि अमुक शेयर में इस प्राईस पर अधिकतम लोगों का स्टाॅप लोस है। 

अब मैं आगे ज्यादा व्याख्या नहीं करना चाहता पर समझदार लोगों को ईशारा काफी होता है। मैं ताश खेलते समय पते दिखाकर ताश खेलना नहीं चाहुंगा ( वैसे में ताश नहीं खेलता पर बचपन में खेले थे)। 

इसलिये मेरी पत्नी जो टर्टल ट्रेडिंग करती है उसमें मैं 20 दिन के लो पर स्टाॅप लाॅस नहीं लगवाता क्यों कि मैने उसको सिर्फ ईटीएफ व निफटी 100 के शेयरों में टर्टल ट्रेडिंग करने की राय दी है तथा एक बार में एक शेयर में अधिकतम 10000 का निवेश करती है उसके बाद उसको यदि 10 प्रतिशत से उपर मुनाफा मिल जाता है जो पिछले दिनों में बहुत से शेयरों में मिला भी है तो वो अपने हाथों से प्रोफिट बुक करके निकल जाती है तथा इस पैसे को हम रोटेट कर सकते हैं। 

जो मेरे पुराने फाॅलोवर है वों जानते हैं कि 2017 में कैसे हम 200 डीएमए के 5 प्रतिशत नीचे स्टाॅप लोस लगाते थे तब हर बार स्टाॅक हमारा स्टाॅप लाॅस तोड़कर उपर निकल जाता था। यदि सीमा का कोई शेयर 10 प्रतिशत से ज्यादा गिर गया उसके बाद वो वापस टर्टल ट्रेडिंग के लिये प्राईस फीड करने की सूची में आ गया तो हम उसको ऐवरेज करने के लिये उसमें वापस जीटीटी Order भरना प्रारंभ कर देगें क्या फर्क पड़ेगा ज्यादा से ज्यादा 10000 की जगह 20000 के शेयर हो जायेगें हमें इतना बैकअप रखना चाहिये की हमें इस विधी से 3 बार तक शेयर लेना पड़े तो हम ले सकें । अब 3 बार शेयर उसके 55 दिन के उच्चतम स्तर को पार करके 10 प्रतिशत से ज्यादा गिरेगा फिर हम तब ऐवरेज करेगें जब वो फिर से अपने 55 दिन के उच्चतम स्तर पर होगा ऐसा करते करते वो ही शेयर ऐवरेज होगा जिसमें कुछ दमखम होगा। 

यहां यह बताना जरूरी है कि मैनें डारवस बाॅक्स थ्यौरी से एक बार में 10000 लगाकर यूपीएल के 185 शेयरों में अधिकतम 100000 का निवेश किया था। एक शेयर में 1 लाख मेरी  अधिकतम सीमा थी तथा मैं डारवस बाॅक्स थ्यौरी से 10 बार ऐवरेज कर चुका था उसके बाद एक समय यूपीएल में मेरे 25000 से अधिक का घाटा था पर मैने उसे होल्ड रखा उन पर 1111 रूपये डिवीडेंड लिया तथा आज सभी 185 शेयर एक साथ 3600 रूपये के लगभग मुनाफे के साथ बेच लिये अब इसमें स्टाॅप लाॅस होता तो मेरे तो 25000 पानी में चले गये होते। 

इसलिये मेरी पत्नी टर्टल ट्रेडिंग से ईटीएफ व निफटी 100 के शेयर लेती जरूर है पर बेचती खुद है किसी भी स्टाॅप लाॅस के सहारे हम नहीं बेचते। आपको खुद निर्णय करना है आपको स्टाॅप लाॅस ठीक है या नहीं पर हम तो एक शेयर में मात्र 10000 का निवेश ही करते हैं तथा इतना बैकअप रखते हैं कि 2 से 3 बार तक 10 प्रतिशत से ज्यादा ऐवरेज प्राईस से  गिरने के बाद किसी किसी शेयर में ऐवरेज भी हो सके व हम 10 से 15 प्रतिशत के बीच मुनाफा टर्टल ट्रेडिंग में मिल जाये तो शांति से ले लेते हैं व मूल पैसा रोटेट कर लेते हैं। कुल मिलाकर हम इसे ऐसे यूज करते हैं कि 55 दिन के हाई से 10 प्रतिशत से 20 प्रतिशत स्टाॅक का प्राईस कम हो तो हम जीटीटी आर्डर लगाना प्रारंभ कर देते हैं रोज उसे ताजा 55 दिन के हाई के अनुसार अपडेट करते हैं आर्डर ट्रिगर होने के बाद यदि 10 से 15 प्रतिशत मुनाफा मिल जाता है तो बुक कर लेते हैं यदि स्टाॅक गिर जाता है व यदि हमारे खरीद मूल्य से 10 प्रतिशत से ज्यादा गिरकर स्टाॅक फिर से उसके 55 डे के हाई से 10 से 20 प्रतिशत कम की रेंज में आ जाता है तो उसमें फिर से जीटीटी आर्डर अपडेट करते रहेगें व जब भी वो फिर से 55 डे के हाई पर आयेगा तब ऐवरेज हो जायेगा। 

इसके बाद तो 10 से 15 प्रतिशत प्रोफिट मिल ही जायेगा इस प्रकार अधिकतम 3 बार ऐवरेज 55 डे के हाई प्राईस पर ही करेगें व प्रत्येक ऐवरेज के प्राईस में कम से कम 10-10 प्रतिशत से ज्यादा का अतंर होना आवश्यक है। 

व हम 20 दिन के लो का स्टाॅप लोस नहीं रखते तथा सिर्फ ईटीएफ व निफटी 100 के शेयरों में ही टर्टल ट्रेडिंग करते हैं। 

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

Monday, November 30, 2020

LIC Housing Finance Ltd, Dec 2020 Recommendation Mahesh Kaushik, STP Method

1. LIC Housing Finance Ltd is a 2 rupee face value housing finance company.

2. LIC Housing Finance Limited (LIC HFL) is one of the largest Housing Finance Mortgage loan companies in India. LIC Housing Finance Limited is a subsidiary company of LIC.

LIC Housing Fin

3. In FY-2019, LIC Housing Finance Limited  has 9 regional offices plus 23 back-offices and 273 marketing Offices across India. It also has 2 foreign offices in Kuwait and Dubai to cater to the Non-Resident Indians in the Persian Gulf countries covering the residents of Bahrain, Dubai, Kuwait, Qatar and Saudi Arabia. 

4. LIC Housing Finance Limited  has more than 450 center's across India. Company also has more than 12000 marketing intermediaries or agents to guide through the loan processes..

5. Book Value of LIC Housing Finance Ltd is 360.50 so in book value term it is a value buy at CMP 330 ( But do not buy it at CMP, please use STP method to buy all of my recommendations, in last part of this research report I give a link of STP method video).

6. Net sale par share 390.29 so in it is also a value buy in NSPS term. New readers, please read my research terms here:-Research Reports Terms

7.DMA's of LIC Housing Finance Ltd:-

SIMPLE MOVING AVERAGES

DaysNSE
5324.62
10324.30
20316.49
50299.51
100289.49
200282.45

8. Promoters Holding 40.31%, No any pledged stocks. Institutional holding is 47.07 % which is also good because after promoters and institutional holding only 12.61% stocks left for general public it means stock have potential to rise fast.

9. Year High=486.75 Year Low=185.25 this ratio is above 2, if you read research terms is point 6 then you understand that I like stocks which year high/low ratio is below 2. this time I choose this stock where this ratio is above 2, I knew this is not fair but year high date is 21 Jan 2020 and after Jan 2021 this ratio will fall below 2.

10. LIC Housing Finance Ltd is a dividend-paying company last Dividend 8 rupees per share.

11. Base Price =431.91, download the last 3 years historical data and graph from this link:-https://drive.google.com/file/d/18zczg8SmWkJhj7oEO9WLNaAc-QHWr_kg/view?usp=sharing

12. Link of my daily swing trading recommendations Mahesh Kaushik Daily Swing Trading Recommendations watch this video to knew how to use these recommendations:-https://www.youtube.com/watch?v=mdD8w_TR73k&t=7s

13. If we use the STP method in this stock then we can easily get a target of 25%+, STP price for this stock is 345.70,  new readers please watch this video for a full understanding of the STP method buy https://www.youtube.com/watch?v=gREpTaV50bA


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. 
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 have not held any share of LIC Housing Finance Ltd, 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 (LIC Housing Finance Ltd). 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 or relatives have not received any type of compensation from the subject company(LIC Housing Finance Ltd) in the past twelve months. 5. I am not served as an officer, director, or employee of the subject company (LIC Housing Finance Ltd). 6. I have been not engaged in the market-making activity for the subject company (LIC Housing Finance Ltd).

Sunday, November 1, 2020

NLC India Limited Nov 2020 Research Report Mahesh Kaushik STP Recommendation Nov 2020

1. NLC India Limited is a 10 rupee face value lignite coal company.

2. NLC India Limited (NLC) (formerly Neyveli Lignite Corporation Limited) is a 'Navratna' government of India company in the lignite coal mining sector and thermal power generation.

3. Neyveli Lignite Corporation Limited annually produces about 30 million tonnes of Lignite from opencast mines at Neyveli (Tamil Nadu) and at Barsingsar (Bikaner Rajasthan). 

4. The lignite is used at pithead thermal power stations of 3640 MW installed capacity to produce electricity. NLC India joint venture has a 1000 MW thermal power station using coal. So, NLCIL has diversified into renewable energy production and installed a 1404 MW solar power plant to produce electricity from photovoltaic cells and 51 MW electricity from wind power mills.

5. Book Value of NLC India Ltd is 91.15 so in book value term it is a value buy at CMP 48.85 ( But do not buy it at CMP, please use STP method to buy all of my recommendations, in last part of this research report I give a link of STP method video).

6. Net sale par share 57.09 so in it is also a value buy in NSPS term. New readers, please read my research terms here:-Research Reports Terms

7.NLCIL has also forayed into the renewable energy sector with the commissioning of a 141 MW Solar Photo Voltaic Power Plant including a 1 MW Roof-top Project at Neyveli and a 51 MW Wind Energy Plant at Kazhuneerkulam Village of Tirunelveli district in Tamilnadu. The Company is also setting up 1209 MW Solar Power Projects at Tirunelveli, Virudhunagar, and Ramanathapuram districts of Tamil Nadu, of which, 300 MW have been commissioned. NLC is aiming to achieve a total Renewable energy capacity of 4251 MW. NLCIL has big dreams to become a 20000+ MW company by 2025. 

8. Promoters Holding 79.20%, No any pledged stocks.

9. Year High=62.80 Year Low=34.95 this ratio is below 2, if you read research terms is point 6 then you understand that I like stocks which year high/low ratio is below 2.

10. NLC India Ltd is a dividend-paying company last Dividend 7.06 rupees per share and dividend yield 14.58 percent, which is very nice.

11. Base Price =68.06, download the last 3 years historical data and graph from this link:-https://drive.google.com/file/d/1gZelOh8Yc22m-YnmbYKNCpkqCn_0bEYK/view?usp=sharing

12. Link of my daily swing trading recommendations Mahesh Kaushik Daily Swing Trading Recommendations watch this video to knew how to use these recommendations:-https://www.youtube.com/watch?v=mdD8w_TR73k&t=7s

13. If we use the STP method in this stock then we can easily get a target of 25%+, STP price for this stock is 51.10,  new readers please watch this video for a full understanding of the STP method buy https://www.youtube.com/watch?v=gREpTaV50bA


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. 
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 have not held any share of NLC India Ltd, 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 (NLC India Ltd). 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 or relatives have not received any type of compensation from the subject company(NLC India Ltd) in the past twelve months. 5. I am not served as an officer, director, or employee of the subject company (NLC India Ltd). 6. I have been not engaged in the market-making activity for the subject company (NLC India Ltd).

Tuesday, September 15, 2020

CEAT Limited 2nd Recommendation of September 2020

 Respected Readers,

Here is the STP method recommendation for 16 Sept 2020 tp 30 Sept 2020

Stock Code500878
Company NameCeat Ltd.
SectorTyres & Tubes
Research Report Date15 Sep 2020
Face Value10
Total Eqity Cr.40.45
Total Share Cr.4.05
Book Value723.71
Net Sales Cr.6581.11
NSPS or Net Sale Per Share1626.97
Market Price of Stock in 15 September 2020941.00
Net Profit Cr.270.76
EPS66.94
Dividend Rs.12
D/E0.44
RONW (%)9.24
Promoters Holding (%)46.68
Pledged Share Percentage (%)0
Institutinal Holding Percent (%)37.23
Market Cap Cr.3606.33
52 Week High/ Low Ratio1101/602
52 Week High1101
52 Week Low602
Entprise Value4763.62
STP968.25
I Recommended to buy only in STP method, New Readers Watch this youtube video to learn what is STP MethodSTP Method Video Link
Last 5 Year Chart View:-

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 about my financial interest in the subject company and the nature of such financial interest:- 1 Me and my associates or relatives have not held any share of Ceat Ltd 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 ( Ceat Ltd). 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 or relatives have not received any type of compensation from the subject company( Ceat Ltd) in the past twelve months. 5. I am not served as an officer, director, or employee of the subject company(  Ceat Ltd). 6. I have been not engaged in market making activity for the subject company( Ceat Ltd).

Blog Archive