2023 India Stock Market Tracker in Google Sheets – LIVE Updates

Description
Template Features


This template can be used to view the India. stock market performance.
i. Automatically shows the major indices – NIFTY 50 and BSE SENSEX
ii. 1621 stocks are tracked for performance – 57 are currently not available
iii. New stocks can be added easily
iv. View the top gainers (stocks which increased in price, ranked by Change %)
v. View the top decliners (stocks which decreased in price, ranked by Change %)
vi. View the most actives (stocks which traded most in volume, ranked by Volume)
vii. See more details on the top gainers, top decliners and most actives


The foundation of this template is by using the “googlefinance” function available in Google sheets.
Indices
Two of the most used indices in the Indian stock market are NIFTY 50 and BSE SENSEX.
The dashboard shows the indices’ current price, change in price and change %.


Top Gainers

The dashboard shows the Top gainers of the day.

In the Gainers sheet, you can see more details about the top gainers. You can also see top 20 stocks that gained.



Top Decliners
The dashboard also shows the top decliners of the day.

You can see more details of these stocks and also top 20 stocks that declined in price, in the DECLINERS sheet.



Top Actives
Finally, the dashboard also shows the top 10 stocks that are active (by trading volume) on the day.

To see top 20 stocks that were active and also see more details such as 52 week price range, please see the ACTIVES sheet.