Monday, February 18, 2019

Indian Stock Market Data Download in Excel Sheet February 2019

Respected Readers,
Sorry for my long absence from blogging.
Actually, I promised to Prabhat Prakashan that I complete "Trading Tips" book on 20 Feb 2019 deadline, So I stopped all of my other works and focused my time on writing this book.
Now this book is near about complete, and I will give it to the publisher ( It will take near 1 month to final publishing from the publisher).
Now I provide you "Indin stock market data bank" which you download in Excel sheet from this link:-
Link To Download Indian Stock Market Data

How to use this data bank?:- If you are a new reader, then please read my research terms to understand how you use this data bank:-
Research Terms of Mahesh Kaushik
or Watch this video to learn how you find out value stocks with the help of this data bank:-

This Excel Sheet Contains all Indian listed companies EPS, P/E, NSPS, historical year high/ low data of NSE BSE stocks.
This sheet also provides the ROE ratio of Indian companies in the Excel sheet and provides enterprises value of all Indian listed stocks.
Link of My Books:-
Link to download earlier data bank:-
Free Stock Market Books Link:- Awaiting Your Comments

Tags:-data bank, India stock market data download, nse historical data, EPS, PE, ROE, ROCE, in excel sheet, download nse bse data in excel sheet.

Saturday, November 3, 2018

Data Bank of 4000+ Listed Indian Companies Nov 2018 ( Indian Stock Market Data Bank PE, EPS, BOOK VALUE ETC) Excel Sheet

Respected Readers,
Today I Provide you my updated data bank of Nov 2018.
In this databank, you can download all the data in the Excel Sheet.
You can find EPS, PE, Net Sale Per Share, Book Value, Promoters Holding, 52 Week High/ Low, ROE of Indian stocks in this Excel Sheet.
Data Bank of Indian Stocks In Excel Sheet Mahesh Kaushik Nov 2018

From the help of this databank and my research rules, you can find any good stocks for investment in my research style.
So Simply Download this Excel Sheet and Read my Research Rule and find your stock for investment. 
However, I want my follower will be self-depended.
Do not worry after publishing this data bank my next step is updated my blog with fresh recommendations.
So If you find difficult to locate a stock by yourself then do not worry I will update new stock recommendation soon
Thank you for your love and faith.
Link of  Excel Sheet Data Bank:-
Data Bank Mahesh Kaushik Nov 2018
Link of My Research Rules:-
Research Rules of Mahesh Kaushik
Link of My Books:-
Mahesh Kaushik Books
Visit My Youtube Channel:-
Mahesh Kaushik Youtube
I am happy when I see your loving comments, so do not forget to leave your comment Regards
Mahesh Kaushik
Recent Update:-
शेयर मार्केट की वर्तमान हालात पर कबीरदास जी की शैली में प्रेरणास्पद कविता

Tuesday, June 26, 2018

How to get Data Bank of 4000+ listed companies ( Free) Updated 26 June 2018

Respected Readers,
I am Happy to announce this free gift for my blog readers.
Detail of Gift:- Free data bank of 4000+ listed companies on BSE, in this data bank you get the latest data of CMP, Face Value, Book value, Net sale per share of last year, Year high/low ratio, Shareholding, pledged share, etc., click on picture to see how this data bank look like.

All of these, you get in an excel sheet.

On Demand of my blog followers,  I give data bank of stock in an alphabetical manner.
How to get this databank:- 
 You can download data bank from this link:-

Data Bank of Indian Companies Last Updated 26 June 2018

It is recommended that every of my follower must be read my 3 books ( Book Available in English or Hindi) for the more profound understanding of my theory.
You can buy my books paperback edition or buy an e-book of Kindle.
I am the author of the book and not sold my book directly.
If you do not buy yet then buy it from Amazon from these link: - 
Amazon Link Of My Books
You can also download my free sharegenius app from google play app here:-

iPhone Apple App link:-

Latest Update:-

वर्ष 2017-18 के लिये टाॅप 100 अन्डरवैल्यूड स्टोक्स की पिछले एक साल की पुरी प्रफोर्मेंस

Read past performance of Mahesh Kaushik blog here:-
Read past performance of Sharegenius blog here:-
Read past performance of My Penny Share blog here:-

Disclaimer: - Please remember I collect all data of this data bank by my own credible source and these data like stock price year high-low net sale etc. 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 stock exchange website or company website, No liability is accepted for this purpose.
Mahesh Kaushik 

Wednesday, December 20, 2017

Rallis India Ltd @ 251.05 ( Breakout Stock )

In Announcement tab of my multibagger stocks app, I publish breakout stocks, stocks which closed above his 30;50;150; and 200 DMA.
These stocks are known as breakout stocks and good for short-term trading.
I already tell that followers can buy breakout stocks for 10% target with 10% stop loss read details of breakout stocks here:-
I do not publish research reports for breakout stocks, but my new followers still confused and ask where they see details of breakout stocks?
So  I decided to give some short brief of breakout stocks on my winningthoery blog, so today breakout stock is Rallis India Ltd CMP 251.05 here is short detail of this stock:-
1.Rallis India Ltd is a 1 rupee face value PESTICIDES & AGRO CHEMICALS stock.
Rallis India is a Tata group company visit company website here:-
2. Rallis India Ltd Year High 264.60 and Year Low 188.45 year high/low ratio is below 2.
3.The base price of Rallis India Ltd is 217.34, and Stock recently cross his base price from lower side to upper side but do not run 20% above from base price.
 So as per my book " The Winning Theory In Stock Market" we buy stock in a range of 20% up or 20 % down from a base price.
4. Promoters hold 50.09% with no any pledged stocks this is good.
5. Book Value=57.16
6. Net Sale Per Share=77.39
7. Dividend:-Rallis India is a dividend paying stock to see past dividend history here:-

Dividend Declared (  )
EX DateAmount ()
09 Jun 20172.5000
09 Jun 20171.2500
10 Jun 20162.5000
12 Jun 20151.5000
29 Oct 20141.0000
13 Jun 20141.4000
30 Oct 20131.0000
07 Jun 20131.3000
29 Oct 20121.0000
11 Jun 20121.2000
01 Nov 20111.0000
08 Jun 201111.0000
28 Oct 20109.0000
03 May 201010.0000
29 Oct 20098.0000
12 May 200916.0000
13 May 200816.0000
8.At the price of 230 we see a bulk deal of 40.97 cr value, generally I do not like stock with bulk deal but in this case, bulk deal is in buying side, and FRANKLIN TEMPLETON MUTUAL FUND buy this stock so this is a good sign see here:-
9. So I think This is a pure technical call because stock is another wise good in promoters holding term, year high/low term  and stock crossed his base price from lower side to upper side and closed above his 30,50,150,200 DMA, In Sept 2017 stock post good results earning and profits both are increased see here:-
(in Cr.)Sep-17Jun-17FY16-17
Net Profit81.971.13266.03
Cash EPS4.790.5815.83
OPM %23.314.3926.66
NPM %14.940.4317.67
But due to low book value and low NSPS, we consider this stock in breakout stocks for 10%  short-term gain instead of fundamentals stocks and trading stocks.
10. Target:-above 270 after 270 book your profit according to this video:-

11. Stop loss:-If stock closed below 220 and you hold a large quantity then use this stop-loss those who want to use reverse trade use closing  5% below from 200 DMA as stop loss and If you invest a small amount and able to hold for long term then no need to use stop loss in good companies.
Good News:- Due to my follower's huge demand, my multibagger stocks sharegenius app now relisted on Apple iTunes store you can download it from here:-
12. Link to last 3-year closing price and graph:- Click Here To Download 3 Year Price And Graph
11. 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. 

12.Discloser: - I Mahesh Chander Kaushik author of this research report is an existing research analyst and passed NISM certification for research analysts. I am also registered with 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 Rallis 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 ( Rallis 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(Rallis India Ltd) in the past twelve months. 5. I am not served as an officer, director or employee of the subject company ( Rallis India Ltd). 6. I have been not engaged in market making activity for the subject company (Rallis India Ltd).

Thursday, December 14, 2017

Real Story Of My Wife Portfolio Building 14 Sept 2017 to 11 Oct 2017 (Part 3)

In this part of the story we will see the story from 13th to 16th week of Seema's Share portfolio building story. If you are reading this for the first time, I would request you to start it from the beginning. The link has been provided below:-
This week, i.e. on 20th September we did not had to put in much efforts as share ranked 3rd .i.e. Andhra Bank was trading at 12.60 % above its 200 DMA of 55.95. Therefore Seema invested a sum of 6400 and got 102 shares of Andhra Bank priced at 63.00. It may be seen in the Trade-book below:-

Another important feature of this week was that we got dividends of our 3 shares we have invested into. Getting dividends from 3 shares, all within the same week is very pleasing and it may be noted that not much time has elapsed since Seema started purchasing the shares using the methodologies provided in the book.
I remembered to mention another thing; In the previous edition of this blog on 14th August 2017 Chennai Petro had declared a dividend of Rs. 21 per share for which I had added a sum of 378 in the Balance Sheet. One of my Followers had emailed me to check whether the dividend amount was credited to Seema's Account or not, as the same was not deposited in his account. I forgot to reply the email then due to numerous emails I received after that.
I would like to clarify that dividend is not deposited into the account on the record date but is transferred to the shareholders account through ECS. Seema's account was credited with the dividend amount on 30th Aug'17 i.e. the dividend is credited around 15 days after record date.
If the follower is reading this story then please write in the comments that he has got his / her dividend, because that will relieve me from the regret of not able to reply to the earlier comment.
So this week the record date of dividends of the following three shares in the balance sheet are as follows: -
1. National Fertilizer has declared 85 paise per share, whose record date was 19 September 2017, so that we get 78 rupees 20 paise dividend on our 92 shares.
2. BASF has declared a dividend of Rupees one rupee, whose record date was 20 September 2017, so that we get 5 rupees dividend on our 5 shares.
1. Jain Irrigation has declared 75 paise per share, whose record date was 14 September 2017, so that we get 44 rupees 25 paise for our 59 shares.
So, this week we earned dividends of 127. 45 . Rome was not built in a day. Till now we have earned Rs. 505.45 from dividends and at least it takes care of the brokerage.
The balance sheet at 6 p.m. on 20th Sep'17 is shown below:-

In this part of the story we will see the story from 21st to 27th September of Seema's Share portfolio building story. If you are reading this for the first time, I would request you to start it from the beginning. The link has been provided below:-
This week, on 25th Sep' 2017, we had to sell the National Fertilizer in the reverse trading system.
I also know here that a lot of my followers don't not like this reverse trading system at all because I am receiving e-mails every day that Mahesh Sir, The Shopkeeper approach suggested in the first book was a better one and we want to follow that, we don't want to sell our shares at loss, Reverse trading is just leading to losses. Before I say something in my defense, I will re-state some facts about the reverse trading system from the previous part of this series, for them who haven't read or have forgotten may refresh the facts.
As per the rule, the shares trading 5% lower than its 200 DMA have to we reverse traded i.e. we will share this share and book a loss on it. Remember, this is not an actual loss as we will watch these shares regularly and as soon as it rises more than 5% of its 200 DMA, we will buy it back again.
By doing it, we can buy most of the shares at a lower price to what we had sold them at. If our estimate goes wrong and shares gain value very quickly, we may have to buy them at a higher price.
Normally such a mis-calculation happens in 5 out of 20 shares that they gain more than 5 % of its 200 DMA after going down 5 % . I had sold the shares of Pratibha industries a year ago, using the reverse trading system and it has not gained 5% more than its 200 DMA since. The share has fallen from Rs. 26 to 7.90 as of today and its 200 DMA is 11.11. If Pratibha Ind. closes as 5% above its 200 DMA, it will close at Rs. 13 So, if i buy it now I will be gaining rather than losing as I will be able to buy the same shares at half the cost compared to when I sold at 26.
So, you may have understood that in the reverse trading system, in about 5 out of 20 shares, we will lose 600-700 if we withdraw those shares, the other 15 shares have a long phase of low price and we have 4 benefits in this :-
1.    We don’t cringe on a daily basis seeing the value of our shares go down.
2.    If we keep the money received after selling the shares in a bank  we get an interest of 3.5 % on a savings bank account, banks like ICICI offer a monthly Fixed deposit scheme at 6.75 %, and we can get a monthly interest of 280 on a Fixed deposit of 50,000. Therefore, instead of holding the loss making shares we must hold the cash received after reverse trading them. In some cases as of Pratibha Ind.  The loss is covered by the bank interest itself.
3.     Once the shares rise, we can buy the shares at a much lower price.
4.    The biggest benefit that we have is if we sell our shares in less than 1 year from purchase then we have to pay an income tax of 15 %. And the fictitious loss we incur in the reverse trading system, we can less that in the profit and only pay 15% income tax on the profit.

So these were the important points of the reverse trading system that you had read in the eighth part. Now talking about the email,
Actually, during last 14 weeks market has been steady and has not fallen substantially , the decline that was there wasn't actual and thus we had to buy back reverse traded shares of Jain irrigation which created an impression that reverse trading is  a loss making method and let's better stick to Shopkeeper Approach.
If you feel Shopkeeper Approach as the safe one, you may continue with that
For those who haven’t read the Shopkeeper’s Approach in my Book may see this video.
But if there has been a huge downturn in the market and this decline lasted for two to three months, then you will understand the real importance of the reverse trading system. In such a situation the 200 DMA of the shares will come down sharply as well and when we will buy back the shares when they are 5 % above its 200 DMA, we will get a profit of 20 % soon and our losses shall be covered at a lower price where as those who held back their shares at the earlier price will be yet to recover the principle amount.
I don't use reverse trading on stocks held by me as I have faith in my research and even if a particular share is not performing for 2-3 years I don't worry. Normally I sell the shares after holding it back for an year. You may be surprised to know that Compucom and Basant Agro shares are still in my portfolio as it is yet to complete 12 months of holding back.
In seema's story all the shares are from the Book written by me as all are Blue Chp Large Cap shares , even if we don't reverse trade in these , there is nothing to worry about but I have  to be honest to the rules laid down in my book for small investors , and thus I follow Reverse trading here.
Take a look at this trade book: Reverse Trading in National Fertilizer-

For the shares to be purchased this week there was a confusion , as the share ranked 4th of Jaiprakash Associate as on 20th Sep' was at 16.40 i.e. 5.20 % above its 200 DMA of 15.59 but during the time of purchase the share was at 16.20 which was just 3.91 % above its 200 DMA,  and thus not to break the rules laid down in the Book Seema did not purchase those and checking 200 DMA of the next shares the share ranked 28 of Supreme Petrochem was trading at 12.97 % above its 200 DMA, and therefore this week 18 shares at 367.14 were purchased by Seema, you can see the trade-book:-

No new money was invested this week as the cash recovered from the National Fertilizer's reverse trading was put to use, after the market closure on September 27, 2017, the balance sheet of Seema was as follows:

In this part of the story we will see the story from 28th Sept’ to 04th October of Seema's Share portfolio building story. If you are reading this for the first time, I would request you to start it from the beginning. The link has been provided below:-
This time, on September 29, we had to reverse trade on the shares of both Steel Authority and India Limited and Jain Irrigation, with them closing 5% below their 200 DMA .
Recently, my followers are annoyed with this reverse trading system because I keep getting comments and e-mails from them about their resentment. They are also right; If they keep reverse trading for small fluctuations where will they earn from?
You may simply Hold the shares instead of Reverse trading if you please. But to be true to to the rules suggested in the Book, we will continue with Reverse trading system and after the end of an year its importance will be clear. As of now the market has not suffered a huge downfall thus this process may appear to be not worthy as of now.
In yesterday's Research report regarding improvement in Reverse trading methods is about the shares mentioned in my research reports as we mention only those shares whose ratio between higher or lower level is less than 2 or 2.5. These don't apply to the shares mentioned in my Book as here the ration between the highest and lowest value is more than 2 or 2.5. Again, the reverse trading in Jain Irrigation is not wrong, because you can see that the promoter's holdings have also decreased, which is risky.
Trade Book for this week:-

This week, in the list of new shares; the share ranked 4 of Jaiprakash Associates was trading between 5 to 15 % of its 200 DMA,  and thus we purchased 357 shares of it priced at 18.5. At the end of market closure at 4th October 2017, the balance sheet is as follows:-

In this part of the story we will see the story from 05th October to 11th October of Seema's Share portfolio building story. If you are reading this for the first time, I would request you to start it from the beginning. The link has been provided below:-
This week we booked profit in 2 shares as the target price was 20% higher than purchase price. The two shares are as follows:
1.    BASF India Ltd, which we purchased on August 23, 2017, we had purchased it at the price of Rs. 1420, which you have read in the previous parts. On October 9,  We earned a profit of 352.50 per share after selling it at a price of 1772.50. We had 5 shares of BASF thus we had a profit of 1762.50 but after deducting the brokerage charges we had a net profit of 1640.87.
2.     We made a profit on HSIL shares , we had purchased 17 shares at a price of 381.95 per share and sold it at 468.90, thus making a profit of 1317.21 after deducting brokerage charges.
Overall Seema Kaushik earned 2958.08 from the share market. Some of you may say that she will have to pay a  short term capital gain tax of 15 % on this profit of 2958.08 amounting to 600 approximately. This means that you have not read though the previous part of this series and you need to refresh it.  Profit booked in short term can be adjusted with short term capital loss booked in reverse trading system. The profit earned after the adjustment is liable to be taxed under short term capital gain tax.
This is the reason why we are not afraid to use the reverse trading system, If we see that the shares sold through reverse trading have some potential we will buy them back as soon as its 200 DMA rises.
A snapshot of the trade-book for the complete week is provided below:-

After a lot of efforts, we found a share ranked 32 of Balrampur Sugar , which was trading 14.32% above its 200 DMA. We purchased 39 shares of Balrampur at 165.80, the same may be seen in the trade-book snapshot provided above.
You may see in the link to my Blog provided below that I had recommended Dhunseri Petro at a price of 89.40 on 8th Nov 2014.
Seema purchased 32 shares at the time on November 10, 2014 at a price of 91 Rupees, Since at that time Seema invested in shares from a sum of 50,000 borrowed from me the investments were smaller and she invested a maximum of 2900 in a share.
In 2014 I used to believe in fundamental factors only and did not place the technical dynamics like 200 DMA in its research report, but when the strong recommendation like Dhuniseri Petro  failed, I realised that 200 DMA should be considered along with the fundamentals. I am providing an excel sheet where you can see the price and 200 DMA of Dhunseri Petro from 2014 till date.
You will see that when the stock was recommended at 89.50 on November 8, 2014, its 200 DMA was 122.37 i.e. the stock was already trading much below its 200 DMA , Reverse trading was not started by us at that time, the share's value failed up to 43 and the invested capital of 2900 was reduced to less than its half. She had full faith on my research and she held the shares based on Shopkeeper's approach.
Look in the Sheet above on June 30, 2015, when the stock's 200 DMA was 77.89 and the stock was closed at 82.15, then it was the right time to buy it, after that the stock also went to Rs 113 on August 10, 2015,  I didn't let Seema sell it even then saying her not to hurry , I told her to wait more and not to earn a meager profit , I expected the share to go higher.
And as it happened, Seema had to bear the consequences of having supreme faith in my research, share started on a downfall and its value on 27th Jan 2016 was 5 % below its 200 DMA, it had fallen upto 77. Seema didn’t reverse trade as it becomes difficult to track all the shares as they are many in number.
The roller coaster ride of Dhunseri Petro continued and it gained and reached 121.50, Seema got it off her back after getting 32 % of profit after holding it for 3 years. I didn’t have guts to say her to hold it any longer.
Those who complain that they can't purchase shares recommended by me as their prices shoot up should take a note of it.
Soon after the market closure on 11th of this week, the balance sheet of Seema was as follows:

It doesn't cost anything to comment.  I really appreciate your comments and the critical comments help me to improve, So keep commenting.
Before concluding, here is an advertisement of My Wife's cooking App, of Seema Ki rasoi. Lovers of home cooked food can install it, It will make Seema very Happy

Monday, October 2, 2017

Real Story Of My Wife Portfolio Building From 17 Aug 2017 To 13 Sept 2017 (Part 2)

Ninth week of Seema Kaushik’s Portfolio Building
In this part of the blog, we will see what happened between 17th August 2017 to 23rd August 2017.
If you are new here and haven’t read the first part of this story, I would suggest and request you to go to the first part for the better understanding of the story. Link is provided below:-
This week, on August 23, 2017, the share ranked 25;  BASF India Ltd was trading 9.47% above of its 200 DMA, See in the picture below: -

We have already purchased the stocks which are marked in green; those marked red are being entered in the reverse trading system. Those who are interested in knowing more about the reverse trading system may read the eighth-week story, link is given below
So on August 23, we invested 7153.84 rupees by purchasing 7 shares of the BASF India Ltd which was ranked at 25. A snapshot of the trade book is provided below:-

Post closure of the market on 23rd Aug 2017, Seema's Balance sheet was as follows:-

Although we have sold Chennai Petroleum shares on August 24, at 419.50, we have booked profits of around Rs. 1200, but according to the rules, they will be shown in next week's story. This week my mutual fund blog has also been updated that you can read from the following link: -
Links of Data Bank and Multibagger Stokes 2018 will also be updated in a couple of days. You can understand my situation that I am not a company where many personnel are working, All the work has to be done by myself and it requires time for accuracy and presentation
Today I would also like to tell you what activities keep me busy:-
1. I am a Revenue Accountant, and it requires full-time services
2. After going home from Tahsil, I check 20-30 shares per day so that I can find new shares, Sometimes I am fatigued and can't-do it.
3. I am working on my coming Hindi Book “Kese Pahunch Abdul Stock Market Ke Shunya Se Shikar Tak," currently I have completed 62 pages and estimated the length of this book is around 250 pages.( Of course after publishing in Hindi, English translation of this 4th book will also be provided.)
4. I also work to update my data bank.
5. I also try to read the e-mails and answer to blog and YouTube comments.
6. I am an avid reader as well. I keep looking for new books to read. I have finished a new book "Jivatma Jagat ke niyam" in Hindi. It is a good read where souls are explaining what happens after death.
The Link to the book is given below:-
7. I watch  "Tenalirama," " Tarak Mehta ka Ulta Chashma," and "Sajjan Re, Jhooth mat Bolo" in the evening, Even while watching TV, I am busy on my laptop for researching new share and replying to comments.
8. I also help seema in her Seema’s Rasoi blog in the uploading of his videos etc.

Tenth week of Seema Kaushik’s Portfolio Building

In this section, you will be told the story from August 24 to August 30. Actually, we have scheduled to buy stock on every Wednesday.
If you are new here and haven’t read the first part of this story, I would suggest and request you to go to the first part for a better understanding of the story. Link is provided below:-
This week, on August 24, 2017, our portfolio had shares of Chennai petroleum which we had purchased on 28th June 2017 at a price of 349, and we were making a profit of 20% on it which is Rs. 69.80 profit and in that case, we had to sell our shares at 418.80, but on 25th August the market price was 419.15 so Seema sold 18 shares and made a net profit of 1157.07 after brokerage and other charges. If you have gone through previous week's stories, you would be aware of the dividend of 378 which Seema got on these shares.
This week, after selling the shares of Chennai Petro, we got Rs 7486.56 after reducing brokerage and tax, so there was no need to invest any new funds to buy shares this week.
Trade Book of Chennai Petro:-

Some readers may say that Chennai Petro rose more than 419 after we sold it. I would say don't regret it as we have fixed a 20% profit cap and after getting it, we invested the amount in Shopper's Stop Ltd. which also increased.
Shoppers Stop Ltd's stock was trading 8% above its 200 DMA this week: -

Therefore, we bought 18 shares of Shoppers Stop at 355.25 and invested 6442.99 including brokerage and tax, Look in this trade book: -

After the closure of the market at - 30th August 2017 at 6.00 p.m. the balance sheet of Seema was as follows: 

If you have not seen my new video, then see this link:

Eleventh week of Seema Kaushik’s Portfolio Building
In this section, you will be told the story from August 31 to September 6th. Actually, we have scheduled to buy stock on every Wednesday.
If you are new here and haven’t read the first part of this story, I would suggest and request you to go to the first part for better understanding of the story. Link is provided below:-
On September 5 this week, the stock of Jain Irrigation closed at 104.10, which closed above 5% of its 200 DMA 97.27.You remember, Seema Kaushik bought 59 shares of Jain Irrigation at the price of 108.10 on July 23, 2017.
If you have forgotten, then read the fourth part of the series by visiting this link:
But unfortunately, the stock of Jain Irrigation closed on August 10, 2017, below 5 percent of its 200 DMA, so Seema Kaushik had sold her 59 shares at 91.95 and booked a loss of Rs 1048.37, but it was actually loss booking but trading with the reverse trading system. I have explained it in detail in the 8th week. Read it again to refresh.
Link to 8th week
Now the time has come that we should buy back shares of Jain Irrigation sold by the reverse trading system, So on September 6, Seema bought back 59 shares of Jain Irrigation at 104.10 rupees, this time only Rs 6190.29 had to be invested. Check the trade book:

This does not mean that we will not buy new shares this week. Buying shares of Jain Irrigation are not same as buying new shares. In a way, we had held in indirectly in our portfolio.
Selling in reverse trading, i.e., holding indirectly.
If you did not understand clearly, then I will narrate a story.
This story is written by the famous writer Robert Kiyosaki. In his book, Robert Kiyosaki writes that if there are 20 shares in my portfolio, only 2 -3 shares act as hunter dogs and get me the prey, i.e., at a time in a portfolio of 20-30 shares only 2-3 shares will gain, rest will be like lazy dogs, i.e. showing bound movement, going up and down by Rs. 10 alternatively. But when these lazy dogs start biting, that means the shares go down too much, then I take them out.You can see Roberts Kiyosky's books on the following link:

Similarly, Jain Irrigation was like a lazy dog to us, but we see it is again turning out to be a hunter again, so we take it back.
What should be our target now?
Earlier, we had taken 59 shares of Jain Irrigation with the price of 108.10, then our target would be to sell them at 20% above the price, ie, 129.72, but what will be our target now, will this new purchase price be 104.10 to 20% above?
Why Not?
Because what will be the meaning of Reverse trading system, the loss we booked has to be added to the target, i.e. 1048.37 will be divided by 59 and thus the loss of 17.77 booked per share will have to be added to the target.
Now, we sell 59 shares of Jain Irrigation from 104.10 to 20% above the price of Rs. 124.92 and 17.77 for 142.69 per share, we will get 20 percent profit from this trade and will cover up the loss of 1048.37 for the reverse trading system.So the reverse trading system has made it 142.69 per share by increasing our previous target of129.72 by 13 Rupees.
See what happens ahead
This week's shares ranked at 26 was HSIL, and it was trading at 14.98% above its 200 DMA, we purchased 17 shares of HSIL at a price of 381.95 an investment of 6573.15 including brokerage and taxes. See it in the trade book below:-

So this week 6 September 2017 the balance sheet of Seema was as follows:-

Twelfth week of Seema Kaushik’s Portfolio Building

In this section, you will be told the story from September 7th to 13th September. Actually, we have scheduled to buy stock on every Wednesday
If you are new here and haven’t read the first part of this story, I would suggest and request you to go to the first part for the better understanding of the story. Link is provided below:-
This week on 11th September, our Shoppers Stop shares which we had purchased on 30th August gained 20% profit in mere 12 days. Seema sold and booked a profit of 1187.68 and the same may be seen in the trade book:-

As you can see, 41 Shares of HT Media has been sold at   101.75, you may think that when did we purchase these shares as nothing was told about this in the Book, so when did I purchase and sell it
My regular followers here use my App and they may have it in mind that I had recommended HT Media shares priced at 82, and I am also following my own recommendations, so my wife and I both invest in those shares which we recommend to you.
Therefore, my wife also bought HT Media shares and earned profits with Shoppers Stop.
When my stated shares are recommended for one year or three to six months and they do not gain for two months then I get comments like this; Have a look!
Comment: - Sir, this time you’re told shares did not gain as fast as they used to run before, you have looted me sir.
The response of the another follower on this comment: - Brother, Mahesh Kaushik has earned money from us by selling his books, and he has left us in the middle of the lurch, most of his recommendation has failed, and he has run away from the stock market. So do not make anyone a guru, Use your brains
My reply to that comment: - I have not fled (run away) from the share market and am pretty much alive, neither have I looted you. Why do you invest huge capital for short duration, also why don’t you use reverse trading system. And also, my recommendation hasn’t failed and I am holding all the shares recommended by me. For the followers who have little patience and are in habit of investing larger capital amount, I have suggested Reverse Trading; Also I don't even put Stop loss. Regarding the Books, It’s the publishers selling the book and I earn some royalty from that, I am not writing books to earn royalty but to help small investors and to educate them. Keep patience, everything will be okay.
And you can see, HT media shares everything turned out to be good.
Enough of the comments story, This Wednesday we didn't have to invest in share market as after selling Shoppers Stop shares were-invested that money in purchasing shares this week. Upon checking the 200 DMA in the book this was seen:-

Yellow colored shares indicate that Profit has been booked and after July 2018, in the new edition of the book it will be analysed if they make in the ranking list.
Green ones are on Hold with us.
Red ones are under reverse trading system and hypothetically they are on a hold. Whenever they will close on 5 % above 200 DMA, we will buy them back.
You must have seen, share ranked 15 of JK Tyres was trading 7.50 % above 200 DMA, Thus we bought 41 shares of JK Tyres priced at 154.50. It may be seen in the Trade Book:-

After the market closure on September 13, 2017, see the balance sheet:

If you have not seen my new videos then go to this link and see:

Your comments increase my enthusiasm and negative comments will improve me, so irrespective of wether I reply or not, there should be no laxity in commenting from your end.

Matched Content