Thanks for he prompt and such a detailed response
Thanks for putting such a detailed and pictorial method to look for the stocks, can you please share how can I make all these charts in excel sorry for asking such a naive question as I’ve very less exposure to the excel.
Just adding to the above question, if I may - am guessing you would be using macros to make the charts once you have all downlaoded all the data into excel as there would be around 120k charts (3k*40) or do these come as part of the standard template in excel from the database
Thanks a lot for the detailed reply @Yogesh_s. Can you please guide the process to get this data for all the companies in one shot from screener.in.
Such a displined approach need patience and great deals of experience.I have strong belief that acquiring knowledge takes a great amount of man hours but after learning make in to use and sharing knowledge is the best part thanks
Could you please share the data source that you are using .Analysis is based on wrong data may leads to various biases and ultimately you enter in the right company at wrong times or missed some excellent companies even sometimes it happen you choose wrong company.
can I ask you to share your Exiting checklist if any from a stock thanks a lot .Your journey is motivated me and I am sure others also .It help to sharpen the tools thanks again
I am planning to have below portfolio in long term along with expected price. I will not wait for below price to come. Instead I will buy these stocks as soon as they are 25-30% down from current price.
Bharat Electronics - 100-120
Exide Industries - 100-120
Amaraja Batteries - 400
Maruti Suzuki - 5000
M&M - 450
ITC - 120
HDFC Bank and/or ICICI Bank - 1200/150
Yes Bank - 250
HDFC - 1200
Jindal Steel and Power - Already below book value
Asian Paints - 500
Kajaria ceramics - 250
Eicher motors - 12000
Escorts - 400
Apart from these, I am thinking of small cap like Deep Industries, Nitin spinners, Kitex garment. Currently I have allocated 25% of my planned invetsment. I am waiting for some stock correction(25-30%) so that I can allocate 25-30% more to my portfolio. My horizon is long term(5-10 years or more) depending on how business perform
Presuming that u hv given prices on right side, it seems difficult such a price level would come.u HV to b realistic
You are right…Most of them are nifty components…If these prices comes true then nifty will be somewhere in 6 to 7k range!
I will not for exact price to come. e.g. I already started buying Bharat electronics @167(average price) , ITC(250) etc. My plan is to buy more of these shares on dip. But is there any suggestion on portfolio?
Thanks for sharing such a good method.
Amazing peice of work.40 charts in which nothing can be missed out.which site you have subscribed for data.is it possible for you to share the Excel sheet.
@yogesh @hitesh while going thru old conversation of 2012 and 2013, I find some of he learned members had identified potential multi baggers and members must HV definitely benefited from those deliberations.The year 2018 is going to b a tough year to identify those kind of stocks by most of us except a few of u, who have been bestowed upon an excellent skill.
May I suggest that we start a discussion afresh inviting views on future potential stocks along with the justification and analysis of Q4results.I m of the opinion that it would be highly rewarding for the members, would raise the level/quality of discussion on the forum.
Guys, purpose of my previous post was to present an approach that use charts instead of tables to quickly analyze a large set of numbers. You are welcome to comment on this approach and suggest improvements. Underlying data can be sourced from screener.in or from annual reports of companies. This is all public data anyway. I use a corporate database because it saves me some time but you will appreciate that licencing agreement will prevent me from freely sharing this data.
There are companies that provide data for a fee e.g. CMIE Prowess, Capitaline and ACE Equity etc.
Disclosure: Not a buy or a sell recommendation. Strictly for discussion purpose only.
Thanks for sharing valuable information.
Yes, I agree with you. Charts are the best way. Visualizing data is much easier than reading data. Great work. Having worked in Analytics for so many years I have experienced how the story changes as soon as we start visualizing data
while checking your stock ideas from Feb 18’ ppt attached above, I came across Nov. 17 news article about the promoters of the the company mentioned by you - Associated Alcohol
Would like to hear your thoughts about this?
BTW Dolly Khanna invested in this stock in Jan-Mar quarter and it is on upmove in last 2 weeks
Yes, I read about the Income tax raid. However there are no charges filed, no arrests made and certainly no conviction in a court of law. In stock markets we treat anyone accused as guilty until proven innocent and it is understandable because it’s our own hard earned money at risk. But an IT raid on a company in an industry that does does a lot of business in cash due to high incidence of taxes isn’t a lot to worry about.
In case of corporate governance issues, I am more worried about cases where interest of minority investors are not protected and promoters takes minority investors for a ride using its majority holding. That does not appear to be a case going just by the article. Under-reporting of sales and income is very common in industries that are doing a lot of business in cash. It hurts government in unpaid taxes and lower reported profits for investors while promoters siphon money through other means. Over the last few years I think lot of business is being reported on paper looking at the numbers. This is purely my hypothesis based on observations and nothing else.
I also look at other corporate government indicators like debt reduction, tax payments , promoter salaries, asset write-offs, (lack of) clean surplus accounting etc and I didn’t see any red flags. company’s numbers reported over last several years are also internally consistent. Usually any company that is ‘managing’ numbers will have some red flags somewhere and so far I haven’t seen any. There is always a chance that something will be overlooked though.
Finally, this is what the company says about ethics.
Source: Annual Report 2016-17
Ofcourse no company will ever admit any wrongdoing in an annual report so this glossy page is not worth much but the fact they chose to say it out loud could mean they want to stand out on this aspect? Take it for what it’s worth.
Thanks for sharing your learnings @Yogesh_s.
A query on charts you shared- seems you download data from a source (Capitaline) and feed them in your excel to generate these graphs, or graphs are also generated by source like Capitaline? I am curious to know this to understand affordability of such software/source for individual investor like many of us. Cheers!
Datasources I use do not generate charts but they give you an overview screen for each company including major data points. This screen can be exported to (or copied and pasted into) Excel to draw charts.
Any recent changes/additions to your SME portfolio?