Valuation Tracking Tool for Nifty Stocks

It is very  easy for a professional trader with their sophisticated  trading tools to track the valuations of various stocks in their portfolio. However, tracking of valuations of various stocks is not a simple exercise for the retail investor. To help the retail investor a simple tool using Google Docs has been created to track the valuations of each of the fifty stocks in the Nifty.


The valuation tracker for all the Nifty stocks is available at the this link. If this link does not work you can copy and past the following link in the address bar in your browser.

https://spreadsheets.google.com/ccc?key=0Apr6wDMoV1fVdFpGYmV5SzczZmstN3lGZW80cDN1MWc&hl=en

The valuation tracker contains information under the following columns

• Company Name = Name of the company which is to be tracked.
• Google Finance Symbol = The symbol by which the company is tracked in Google Finance.
• Price = market price of the stock.
• PE = the Price-to-Earnings ratio for this stock
• EPS = the earnings-per-share for this stock.
• high52 = the 52-week high for this stock.
• low52 =  the 52-week low for this stock.

The valuation tracker can be modified to track you individual stocks be it from the Indian stock market or any other stock market of the world. I have modified this tracker to contain stocks in my portfolio along with the stocks I am tracking. I track the valuations using visual filters, for e.g. in this valuation tracker, stocks with an EPS of more than 25 are colored in red while stocks with EPS less 12 are marked in green

You can build a tool for filtering stocks based on your specific filtering criteria by referring to the information provided by Google Docs on how to use the Google Finance functionality in a spreadsheet. Additionally you can view this video to understand how to use Google Docs to carry out stock market research

If you need any help on this tool, please feel free to reach out to me and I would be glad to help you out on this.