NSE Equity Performance Dashboard

This template is an efficient tool for tracking National Stock Exchange (NSE) stocks using Microsoft Excel. It provides a detailed presentation of various metrics about different stocks, aiding in informed decision-making for investors and stock market enthusiasts.

The key columns include the stock Symbol, Name, Sector, and Industry to identify the stock. Furthermore, it lists the Last Traded Price (LTP), Open, High, Low, and Volume of stocks, providing a snapshot of the day's trading activities. The template provides further information about the stock's performance, including details like the 1-Month (1M) High and Low, 52-Week (52W) High and Low, and percentage off the 52W High and Low. Moreover, it outlines technical indicators such as the 20-Day Simple Moving Average (SMA 20D), Exponential Moving Average (EMA 20D), Average Directional Index (ADX), and Relative Strength Index (RSI).

The template also provides specialized volume data (Vol 30D, 7D, 15D), and historical performance details over different periods. The performance data includes 1-week (1W), 1-month (1M), 3-month (3M), 6-month (6M), and year to date (YTD), as well as 1-year (1YR), 3-year (3YR), and 5-year (5YR) returns.

Key fundamentals such as Market Capacity, Quarter on Quarter (QoQ) Revenue Growth, Year over Year (YoY) Revenue Growth, Net Margin, and Current Ratio are provided to assist in stock evaluation.

The template provides an example of how each field should be populated, for instance: for the stock of Tata Consultancy Services Limited (TCS.IN) in the Technology/Information Technology Services sector, and for the stock of HDFC Life Insurance Company Limited (HDFCLIFE.IN) in the Financial Services/Insurance-Life sector.

In its entirety, this template serves as a comprehensive guide providing essential stock information for tracking NSE stocks effectively.