Stock Analysis Worksheet V4.0 - GETMONEYRICH (2024)

Stock Analysis Worksheet V4.0

Updated: Stock's Engine

What makes this product unique is its capability to analyze stocks. How it does it? By estimating intrinsic valueusing multiple valuation models. It also renders an overall score,in a scale of 100. Its utility is further enhanced as it can prepare a list indicating intrinsic values and overall scores for all its stocks for.

Kindly read the) of the worksheet and watch the How to use – video guide.

INTRINSIC VALUE

The worksheet can estimate intrinsic value of India's top 850+ number stocks. The analysis is done based on the company's 10-Year financial data.

OVERALL SCORE

The worksheet rates a company, and renders an overall score based on six parameters like price valuation, management, financial health, moat, growth, and profitability.

10-YEAR SNAPSHOT

The worksheet will present the last 10-year financial data and ratios that can be viewed in one glance. It helps the user to establish a trend (like growing sales, profit, profitability etc.).

STOCK SCREENER

It is Web App based stock screener. Read more about it in the Screener Page. Click on the header or icon to access the page.

FAQ (T&C)

Stock Analysis Worksheet’s (SAW) algorithm is now implemented in the WebApp (Stock Screener). The intrinsic value and overall score calculation is done based on the SAW’s algo. The worksheet has been superseded by the WebApp from Mar’22 and onwards

  • #1. Works for 850+ Indian Stocks (see list).
  • #2. Includes only those stocks that have 10-Y financial & price data.
  • #3. Runs only on laptops with “MS EXCEL.”
  • #4. Only for NON-Banking stocks.
  • #5. Macros enabled Excel required.
  • #6. Internet connection is required.
  • #7. Disclaimer: Gives no investment advice.
  • #8. Editing rights not provided to users.
  • #9. Subscription renewal is required.

Please check the user video guide for details

How get the worksheet after payment?

Check your Inbox/Spam box for the email. The download link is provided in the email. The downloadable file is zipped. Use the link to download the file into your laptop or desktop device.

Download link in the email not working.

The Download link will work only for the first 24 hours from the point of payment. Do not worry, all users with a valid subscription will get a copy of the product any time. Just email me at contact@getmoneyrich.com

Password protected helps to maintain the singularity of the worksheet. As the editing rights are protected, it helps to keep its internal algorithm intact. This way, the user can use the worksheet in a carefree way. The chances of worksheet getting corrupt during usage is minimal.

This product gives investment advice.None of the articles or products of this Blog offers any investment advice.

Please make sure to read the disclaimer before use.

We selectively add stocks to our list. One of the criteria is, the stock must have at least 10 years of financial and price data. Hence you will not find any IPO’s or new stocks in the list.

We continue adding good new stocks to this list. The list is dynamic.

Your worksheet will automatically get updated for the newly added stock. Check the user video guide.

Why there are no banking stocks in the list?

The worksheet has been designed to analysis only non-banking stocks. In case you want to know about how to analyze banking stocks, kindly visit the list.

Wha to do if my Excel’s macros is not working?

Macros not running is a local device problem. I’ll not be able to help in enabling the Macros of your Excel Program. You can please take technical support available nearby.

Every MS Excel has Macros enabled by default.

If the worksheet is online and it is still not fetching data from our database, it is a macros problem. It is not a worksheet issue.

You can change your device and try using the worksheet in a new laptop. In most cases, it works this way.

You can also try using the worksheet using your home-wifi or mobile hotspot.

In case the product does not work, due to Macros, the user will not be eligible for a refund (read the FAQ).

It works with which version of Excel?

Macros enabled MS Excel will work, though we strongly recommend you to migrate to the latest version of Microsoft Visual Basic for Applications (VBA)

Does the product work on a Macbook?

Yes. Macbooks having MS Excel installed will work. It has been tested for both Windows and Macbook laptops.

Whom to contact in case of problem?

Please contact me (contact@getmoneyrich.com) by sending me an email from your registered email ID.

What Our Users Say

"Someone like me who has no experience of the Stock market and does not know anything, its a great tool to understand nuances. Ofcourse I am also learning some jargons for stock market but this tool is very effective"

Stock Analysis Worksheet V4.0 - GETMONEYRICH (1)

RAVI KUMAR

SEP 21, 2021 AT 10:27 AM

"Very good product of hard work of a guru with deep knowledge of the subject and heart to share the wisdom. No words to appreciate adequately and of course the charges are peanuts to the utility it provide a person seeking the intrinsic value of stocks. Heartfelt thanks and good wishes to GMR for continued success and support to the needy."

Stock Analysis Worksheet V4.0 - GETMONEYRICH (2)

CINELS

MAY 18, 2021 AT 1:11 PM

"Thank you Mani for a great product, its indeed become one of the greatest weapon in my arsenal, All thanks to you and SAW, which I use regularly to analyse all my stocks, with all humility I am happy to say that after so many years of burning my fingers in the stock market today my portfolio has touched 81.39% in one year of investing using SAW, also through your articles, I have gained a lot of insight and knowledge about analysing and investing in good companies. Thank you once again for sharing your knowledge and a great set of tools and resources on GetMoneyRich.com"

Stock Analysis Worksheet V4.0 - GETMONEYRICH (3)

TERRENCE D'SOUZA

APR 28, 2021 AT 10:02 PM

"I am using your product most .This recent update is a good one .Don't want to miss that..."

Stock Analysis Worksheet V4.0 - GETMONEYRICH (4)

KAMAL PRASATH P

APR 27, 2021 AT 1:14 AM

USER VIDEO GUIDE

Stock Analysis Worksheet V4.0 - GETMONEYRICH (2024)

FAQs

Where can I get data for stock analysis? ›

Internet Sources for Historical Market & Stock Data
  • Yahoo! Finance - Historical Prices. ...
  • Dow Jones Industrial Averages. Historical and current performance data. ...
  • S&P Indices. Historical performance data.
  • IPL Newspaper Collection. ...
  • Securities Industry and Financial Markets Association. ...
  • FINRA: Market Data Center.
Apr 15, 2024

How to use Excel for stock analysis? ›

Excel has built-in algorithms for calculating a number of financial measures that are essential for stock analysis. Use the calculation ((Closing Price – Opening Price) / Opening Price) * 100 to determine daily or periodic returns. Calculate volatility as well by determining the returns' standard deviation.

Where can I find stock analysis? ›

A quick look at the best stock research websites
Our pickBest forPricing
TradingViewCharts and technical analysisPrimarily paid
Motley FoolPaid stock recommendationsPaid
MorningstarMutual fundsPrimarily free
KoyfinBloomberg terminal alternativePaid
3 more rows
Mar 6, 2024

How to do your own stock analysis? ›

A very, very basic example of stock analysis would include looking at a stock's share price, comparing it to its historical averages and moving averages, overall market conditions, and looking at the company's financial statements to try and gauge where it might move next.

Which site is best for stock analysis? ›

Here is a list of the best sites for stock market analysis:
  • Morningstar, Inc. ...
  • Seeking Alpha. ...
  • Zacks Investment Research, Inc. ...
  • Bloomberg. ...
  • WallStreetZen. ...
  • The Motley Fool. ...
  • TradingView. ...
  • Finviz.
Mar 28, 2024

What is the best stock screener website? ›

Best Stock Screeners for June 2024
  • Best for Day Trading: Trade Ideas.
  • Best for Swing Traders: FINVIZ.
  • Best Free Option: ZACKS (NASDAQ)
  • Best for Buy-and-Hold Investors: Stock Rover.
  • Best for Interactive Charting: TC2000.
  • Best for Global Investing: TradingView.

What is the best free stock analysis app? ›

  • 10 Best Stock Analysis Apps of 2024. Seeking Alpha. Yahoo Finance. TradingView. Simply Wall St. TipRanks. MarketWatch. Investing.com. Apple Stocks App. Stocks+
  • FAQ.
Apr 2, 2024

What is the best free stock advice website? ›

To help you get started with some quality sources, here are five stock advisor websites for investors:
  • Morningstar Investor. SmartAsset: Stock Advisor Websites for Investors. ...
  • The Motley Fool. SmartAsset: Stock Advisor Websites for Investors. ...
  • Dividend.com. ...
  • SeekingAlpha. ...
  • ValueInvesting.io.
Jan 6, 2024

What is the best stock fundamental analysis tool? ›

For the fundamental investor, WallStreetZen is the best stock analysis software because its suite of tools can help guide your investing process from start to finish. Zen Score, Top Analysts, Stock Screener and other ancillary features make this the best stock analysis software in 2024 for fundamental investors.

Where can I learn stock analysis? ›

  • Overview.
  • B.Com in Banking and Capital Markets.
  • B.Com in Financial Analytics.
  • BBA in FM by NSE Academy & GITAM, Telangana.
  • BBA in FM by NSE Academy & GITAM, Visakhapatnam.
  • BBA in FM by NSE Academy & GITAM, Bangaluru.
  • BBA in FM by NSE Academy & St Joseph's College.
  • B.Com (Hons) Capital Markets.

What is a good PE ratio? ›

Typically, the average P/E ratio is around 20 to 25. Anything below that would be considered a good price-to-earnings ratio, whereas anything above that would be a worse P/E ratio.

What is the simplest way to evaluate a stock? ›

Price-to-earnings ratio (P/E): Calculated by dividing the current price of a stock by its EPS, the P/E ratio is a commonly quoted measure of stock value. In a nutshell, P/E tells you how much investors are paying for a dollar of a company's earnings.

Where can I find stock data? ›

Online brokerage sites such as eTrade and TD Ameritrade or apps like Robinhood will have both real-time and historical quote data for customers and usually limited access for non-customers as well. Financial websites like Motley Fool or Google Finance will also provide quote information for both stocks and indices.

Where can I get data for market analysis? ›

Statista - The Statistics Portal for Market Data, Market Research and Market Studies. And get full access to all statistics.

How to do data analysis for stock market? ›

Understanding Data Analytics in the Stock Market
  1. Price Data: This includes Open, High, Low, and Close prices, offering snapshots of stock prices at specific times. ...
  2. Volume Data: The quantity of shares traded within a given period indicates market interest.
Apr 22, 2024

Where can I get fundamental stock data? ›

There are numerous financial data APIs out there that can give you access to a stock's fundamental data. Personally, I have found and use one website which is able to provide more than just fundamental data and it is free to sign up called — EODHD APIs.

Top Articles
Latest Posts
Article information

Author: Eusebia Nader

Last Updated:

Views: 6651

Rating: 5 / 5 (80 voted)

Reviews: 87% of readers found this page helpful

Author information

Name: Eusebia Nader

Birthday: 1994-11-11

Address: Apt. 721 977 Ebert Meadows, Jereville, GA 73618-6603

Phone: +2316203969400

Job: International Farming Consultant

Hobby: Reading, Photography, Shooting, Singing, Magic, Kayaking, Mushroom hunting

Introduction: My name is Eusebia Nader, I am a encouraging, brainy, lively, nice, famous, healthy, clever person who loves writing and wants to share my knowledge and understanding with you.