Nifty 100 Top Gainers and Top Losers
Video Help Link: How to Use Top Gainers and Top Losers Spreadsheets?
Note: Read the Guidelines sheet (inside the file) on how to use the sheet.
With this spreadsheet (Spreadsheet Link above) you can sort and filter stocks in the Nifty100 index based on NSE Stock Symbol, Industry, Market Cap, Recent Price, 1 Day Return, 1 Week Return, 1 Month Return, 3 Months Return, 6 Months Return, 1 Year Return, 2 Years Return and 3 Years Return.
Also you can sort and filter stocks based on % down from 52 week high and % up from 52 week low.
For example, you can sort the last 6 months return % (change %) from highest to lowest in value. You can filter stocks whose Recent Price is under Rs. 100, Rs. 300, etc. Or you can filter stocks whose Market Cap is greater than Rs. 8,000 crore, Rs. 25,000 crore, etc.
The file contains a Nifty 100 stocks list. You can sort the companies in the Nifty100 index like Nifty 100 top gainers and Nifty 100 top losers.
You can also see Nifty 100 top gainers today, last week, last month, last 3 months, last 6 months, and last year.
Similarly, you can sort Nifty 100 top losers today, last week, last month, last 3 months, last 6 months, and last year.
It’s a live auto updating spreadsheet. The spreadsheet automatically fetches the recent price from NSE with the help of google finance.
Also you can download the spreadsheet as MS Excel for further analysis.
Note: View the sheet in Laptop or Desktop for Sort, Filter views, Download, and other spreadsheet features.
Disclaimer: Quotes may be delayed up to 20 minutes. Information is provided 'as is' and solely for informational purposes, not for trading purposes or advice. Quote source: Google Finance.