No results for ""
Market Movers
Find the top gainers, losers and most active instruments across OI, indices, industries and segments using the Market Movers formulas from the toolbar. Choose the columns you need and load the results straight into your sheet.
How to Fetch Market Movers
- Open Market Movers from the toolbar.
- Select the mover type you need.
- Fill in the required inputs (Series, Exchange, Index, Industry, Segment, Top N).
- Choose Auto-Refresh and select the Fields / Columns to load.
- Enter the Start Cell, or tick New Sheet? to load into a new sheet.
- Click Fetch Data to load results into the sheet.
OI Gainers
Futures and options contracts with the biggest rise in open interest.
Inputs: Series, Top N, Auto-Refresh, Fields / Columns, Start Cell, New Sheet
OI Losers
Contracts with the biggest fall in open interest.
Inputs: Series, Top N, Auto-Refresh, Fields / Columns, Start Cell, New Sheet
Index Gainers
Top gaining constituents of a selected index.
Inputs: Exchange, Index Name, Segment, Top N, Auto-Refresh, Fields / Columns, Start Cell, New Sheet
Index Losers
Top losing constituents of a selected index.
Inputs: Exchange, Index Name, Segment, Top N, Auto-Refresh, Fields / Columns, Start Cell, New Sheet
Industry Gainers
Top gaining stocks within a selected industry.
Inputs: Industry, Segment, Top N, Auto-Refresh, Fields / Columns, Start Cell, New Sheet
Industry Losers
Top losing stocks within a selected industry.
Inputs: Industry, Segment, Top N, Auto-Refresh, Fields / Columns, Start Cell, New Sheet
Most Active By Turnover
Instruments with the highest traded value.
Inputs: Exchange, Index Name, Segment, Top N, Auto-Refresh, Fields / Columns, Start Cell, New Sheet
Most Active By Volume
Instruments with the highest traded quantity.
Inputs: Exchange, Index Name, Segment, Top N, Auto-Refresh, Fields / Columns, Start Cell, New Sheet
Common Options
These options are available in every Market Movers dialog.
- Top N: number of results to fetch (default
20). - Auto-Refresh: keep No Refresh for a one-time load, or pick an interval to update the data automatically.
- Fields / Columns: tick the columns you want. Symbol is always included and cannot be unchecked. Use Select All or Clear All to change every field at once.
- Start Cell: the cell where the table begins (default
A2). - New Sheet?: tick to load the results into a new sheet instead of the current one.
Available Fields
OI Gainers & OI Losers
Always included: Symbol
Selected by default: OI, POI, Chg OI, Chg OI %, LTP, PrevClose
Optional: Expiry, Strike, Volume, Timestamp
Index, Industry & Most Active
Always included: Symbol
Selected by default: LTP, PrevClose, Change, ChangePer, Volume (Turnover is also selected for Most Active By Turnover and By Volume)
Optional: Turnover, Bid, Bid Qty, Ask, Ask Qty, Timestamp
Sheets by Truedata
Empowering traders and analysts with high-performance real-time market data directly within their spreadsheets.
Resources
Support
© 2026 TrueData Market Data Services LLP. All rights reserved.