Downloads

The following files are available for download at www.drvijaymalik.com:
  1. Stock Analysis Excel Template (compatible with Screener.in) (Premium Download)
  2. E-book: “Peaceful Investing – A Simple Guide to Hassle-free Stock Investing” (Premium Download)
Details of each of these downloadable files is provided below:


1) Stock Analysis Excel Template (compatible with Screener.in):


I use a customized excel template to analyse stocks as per my preferred parameters by using the data downloaded from screener.in website. The template acts as a dashboard of key analysis parameters, which help me make an opinion about any stock within a short amount of time (sometimes within a few minutes). I have used this excel template and the analysis output in many stock analysis articles published on this website.

You may read about various stock analysis articles written by analyzing companies using the excel template in the "Author's Response" segments on the following link: Stock Analysis Articles

In the past, many readers/investors have asked me to provide the copy of this excel file. However, until now, I have not put the excel template in the public domain for download. I have always advised investors to customize the standard screener excel template as per their own preferences and their learning about stock analysis from different sources. Customization of excel template on her own can be a very good learning exercise for any investor.

However, due to repeated requests for sharing the excel template, I have decided to make the customized excel stock analysis template, which is compatible with screener.in and provides stock data as a dashboard, as a paid download feature.

Investors who wish to get the customized excel stock analysis template may download it by paying ₹1,500 (incl. all taxes) from the following link:

Dr Vijay Malik premium paid services workshops, guest lectures, Stock Analysis Excel Template compatible with Screener.in


The structure and sample screenshots of the stock analysis excel template file are as below:



1) Analysis sheet: This sheet presents values of more than 40 key parameters in the form of a dashboard. These parameters cover analysis of profitability, capital structure, valuation, margin of safety, cash flow, creation of wealth, sources of funds, growth rates, return ratios, operating efficiency etc.

Having a quick look at these parameters in the form of the dashboard helps in quick assessment about the company, its historical performance and its current state of affairs.



Screenshot of large resolution output of the Analysis Sheet: Click Here

2) Description sheet: This sheet contains details about description and interpretation of about each of the more than 40 parameters. It is advised that investors should read this sheet in detail before starting with the analysis of companies by using this template.

Screenshot of the Description Sheet: Click Here

3) Instructions sheet: This sheet contains details about the steps by step apporach to get started with this sheet on screener.in website, change in settings for Microsoft Excel to resolve common issues and other instructions for the buyers.

Screenshot of the Instructions Sheet: Click Here

4) Version history: This sheet contains details about the changes/updates made in each of the new versions of the sheet.

You may read about various stock analysis articles and see the screenshots of the excel template in the "Author's Response" segments on the following link: Stock Analysis Articles

Users'/Investors' Feedback about this Stock Analysis Excel Template:


The stock analysis excel template was initially made available for download on July 11, 2016. More than hundred investors have downloaded the same and quite a few of them have provided their inputs about the excel template. Here are some of the responses sent by the users of this template:

“This is a great tool for getting down to the heart of a company's financials.
When I was doing my MBA at NYU I had a valuation professor who encouraged everyone in the class of 60 to make their own customized sheet similar to what you've made. I was a fan of Buffett so I remember keeping some of his metrics in view and creating a sheet! Of course yours is head and shoulders above anything else I've seen - kudos!”
- Uday (via email)

The excel template is quite useful. It makes things easy for us in not doing the hard labor and calculating all vital data for each company separately.
- Ashish (in comments on the article at drvijaymalik.com)

“Thank you Dr. Malik.  The tool is indeed very useful and super-fast to use. God bless you for creating it! Please use this as part of ur training to perform financial analyses of different types of companies in different performance contexts across industries. I am sure others will also love it.”
- Harsh (via email)

"Dear Sir, I have downloaded the excel. It's simply AMAZING, EFFORTLESS and AWESOME. Kudos to you and your team for wonderful creation.."
- Vikram (via email)

“Very good tool created for Stock analysis. Very helpful. Thank you sir”
- Jiten (via email)


For further details please read this article: Dr Vijay Malik's Stock Analysis Excel Template (compatible with Screener.in)

P.S: Please read all the instructions on the payment page, carefully before making the purchase of the excel template.



Dr Vijay Malik premium paid services workshops, guest lectures, Stock Analysis Excel Template compatible with Screener.in


2) e-book: “Peaceful Investing – A Simple Guide to Hassle-free Stock Investing"

www.drvijaymalik.com has a huge collections of articles, which are focused on simplifying the stock market investing for common investors. These articles cover different aspects of stock investing like:
  1. Deciding the suitable approach to stock market investing
  2. Shortlisting companies for analysis
  3. Detailed guidelines for conducting in-depth stock analysis covering: financial analysis, valuation analysis, business & industry analysis, management analysis, operating efficiency analysis etc.
  4. Ready checklists as a ready reference while doing stock selection
  5. Deciding about the price to pay for any stock
  6. Deciding when to sell the stocks in the portfolio
  7. Methods to check accounting juggleries by companies
  8. Guidelines for creation a portfolio of stocks with ideal number of stocks
  9. Guidelines for monitoring stocks in the portfolio
and many more.

All these articles are separate write-ups, which are available to all the readers at www.drvijaymalik.com.

A lot of readers have asked whether there exists an e-book compiling all these articles, which could be downloaded by the readers so that the articles could be read in a sequence even when the reader is offline.

The key stock investing articles were collected as a book and offered as a key study material guide to each of the participants of all the “Peaceful Investing” workshops being conducted by us. 

Peaceful Investing book, Value investing book, Dr Vijay Malik book, Dr Stock book, ebook, e-book, Stock Investing Guide book

The feedback from the workshop participants about the book has been very good. The readers have found the book very useful to learn stock analysis.

Peaceful Investing book, Value investing book, Dr Vijay Malik book, Dr Stock book, ebook, e-book, Stock Investing Guide book

Many other readers of www.drvijaymalik.com have asked for this book to be made available even for the members who have not be able to attend the “Peaceful Investing” workshop.

As a result, the book “Peaceful Investing – A Simple Guide to Hassle-free Stock Investing” has been made available as a premium download to the investors. Investors who wish to get the book may download it by paying 375/- (incl. all taxes) from the following link:

Peaceful Investing book, Value investing book, Dr Vijay Malik book, Dr Stock book, ebook, e-book, Stock Investing Guide book

For details of all the articles contained in the book, please read this article.