Compare stocks11/12/2022 All stocks are categorized into three types based on their trading volumes (High, Medium and Low). Ideally speaking, one should prefer investing in ‘high volume’ stocks. Trading Volume: Stocks which are traded more often in stock market has a high volume.Comparing ‘current price’ with ’52W High and Low’ gives an understanding about current price being high or low. These represents two extreme price movement in a time span of last one year. The next two data is ’52 Week High’ price and ’52 Week Low’ price. #4 Price: There are three kind of price data indicated here.This gives a sense to the users that the price data there are referring belongs to which time frame. #3 Date: The date indicated here show’s the day in which the database of the sheet has been last updated.Hence to get a general idea about it, looking into the sector in which it operates, helps. #2 Sector: Name of a company often does not speak about its nature of business.Categorisation gives a better sense of size to the users. Five types are: (a) Very Large, (b) Large, (c) Mid Size, (d) Small, and (e) Very Small. All those stocks has been categorized into five types based on their market cap. #1 Size: There are 1002 numbers stocks in the worksheet’s database.The tool also presents the selected five stock’s data-sheet in a simple and intuitive format. This worksheet has a dynamic database which can be refreshed once every week (on Saturday’s). Stock comparison tool can compare five stocks at a time. It is the most valuable product of our product basket. This is one of a unique excel based tool. Good stocks obtained from the ‘stock comparison tool’ is analysed using stock analysis worksheet. Stage #3 (Detail Analysis): A detailed analysis is done by my stock analysis worksheet.This is how I’ll pick my best stock out of the lot of five. I use the stock comparison to compare these 5 stocks based on 40+ parameters. Suppose, the above screener gave me five high quality stocks (high revenue/profit, high profitability etc). Stage #2 (Comparing): This is where my stock comparison tool comes into play.I generally focus on those profitable stocks (high ROE, RoCE) which are trading at low P/E, low P/b etc. We can use this screener to identify our stocks by applying several filters. It is a web application having database of 3,800+ number stocks. Stage #1 (Screening): Generally I start with my stock screener.But in direct stocks investing I follow a three stage approach: The Three Stages If choice is mutual fund, as-much self-research and involvement is not necessary. Once we’ve answered this basic question, we’ll have two types of investment options in front of us: mutual funds and stocks. While passive investing is done through a third party (outside expert) – like mutual funds, Exchange Traded Funds (ETFs) etc. While we are planning to invest in equity, we face a basic question, “ we would like to do an active or passive investing“? What is active investing? When investor has to self analyze shares and then invest in them directly it is active investing. My product basket also has other tools like Stock Analysis Worksheet, Mutual Fund Comparison Tool etc. One can buy it at as a package in product basket. Stock comparison tool is not sold as an independent product. This way you can also get a clue about its features, and usage for yourself. In this article I’ll explain how I use the stock comparison tool for myself. Even today, this is one of my first tools which I use in the process of researching my stocks. But as we get more conversant with database management, we will re-fresh its contents more frequently.Įven when this tool had a static database, I used to love it. New users can click a button to fresh the stock data from our database.Īt the moment, we are updating our database once every week (every Friday). But now the dependency on 3 updates are gone. I used to send three updates of it (once every 30 days) to its new users. The worksheet has a list of total 1002 nos stocks available for comparison.Įarlier this tool had a static database. To use it, one must have a decent internet connection. Now, this tool can fetch stock data automatically upon click of a button. In the last few days, we have made it more online savvy. The stock comparison tool was one of the first tools which I developed in excel.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |