When Beginning Investing Journey It is really difficult to choose from the best stocks which can grow the investment and give good returns in the future thereby grow the wealth.
As a solution to this problem, I have compiled a list of stocks from the Nifty 500 Index. And Tried to cover various aspects Which can be checked to filter the best stocks which are both safe and can give good returns. I have tried to cover mostly all stocks from the Nifty 500 Index which consists of various indexes.
In the Excel Sheet you will be able to see the following:
Key Terms | Meaning |
Indice Name | It is the Stock Indice Name for Reference |
Risk Level | It is nature of Stock |
Risk Ratio | It shows the nature of volatility of the stock comparison with Nifty Index. |
PE Ratio | Price to Earning |
PB Ratio | Price to Book |
ROE Ratio | Return on Equity |
EPS | Earnings per Share |
Dividend Yield | Percentage of Dividend |
Sector | Sector to which the stock belongs |
Sector Specific | Business done by stock |
Market Rank | Market cap Rank |
Cap | Market Cap Type |
CapValue | Market Cap value as of 7th August 2020 |
52High | 52Week High Value |
52Low | 52Week Low Value |
IND PE | Industry/Sector PE |
IND PB | Industry/Sector PB |
IND Div Yield | Industry/Sector Dividend Yield Percentage |
1 Day | Last Trading Day Return |
1 Week | 1 Week Return of the Stock |
1 Month | 1 Month Return of the Stock |
1 Year | 1 Year Return of the Stock |
5 Year | 5 Years Return of the Stock |
Max | Max Return given by Stock as of Date |
SIP | Return if Stock SIP was done |
Screenshot is Shown Below:-
Last Updated on : 8th August 2020.
Important Note: This Spreadsheet is for Reference Purpose Only. Please do your own research before investing.
The Excel Sheet can be Accessed from the below:-
Use this Excel Sheet for Reference Purpose and Explore the Stocks.
In case you have any suggestions or feedback. Please leave a comment.
I'll mostly try to update this Spreadsheet every week. So that everyone can get benefited from it.
Happy Investing !!
Comments
Post a Comment