TrueData Sheets Market Movers Formulas

+ K

Searching...

functions Formulas

menu_book Pages

manage_search Content Match

search_off

No results for ""

Go to Platform open_in_new

Loading Content

functions

Formula Reference

Market Movers Formulas

Formula	Category	Description
â–¶ OIGAINERS	OI Movers	Strikes with the highest OI build-up
Summary Strikes with the highest OI build-up Parameters topN, series, startCell Pro Tip Syntax: =OIGAINERS(topN, series, startCell) Result Result: Top 10 CE strikes with highest OI increase
â–¶ OILOSERS	OI Movers	Strikes with the largest OI unwinding
Summary Strikes with the largest OI unwinding Parameters topN, series, startCell Pro Tip Syntax: =OILOSERS(topN, series, startCell) Result Result: Top 10 PE strikes with highest OI decrease
â–¶ INDEXGAINERS	Index Movers	Top gaining stocks within a specific index
Summary Top gaining stocks within a specific index Parameters indexName, segment, topN, startCell Pro Tip Syntax: =INDEXGAINERS(indexName, segment, topN, startCell) Result Result: EQ · FUT
â–¶ INDEXLOSERS	Index Movers	worst performing stocks within a specific index
Summary worst performing stocks within a specific index Parameters indexName, segment, topN, startCell Pro Tip Syntax: =INDEXLOSERS(indexName, segment, topN, startCell) Result Result: Bottom 20 in NIFTY 50 by price change
â–¶ INDUSTRYGAINERS	Industry Movers	Top performing stocks within a specific industry
Summary Top performing stocks within a specific industry Parameters industryName, segment, topN, startCell Pro Tip Syntax: =INDUSTRYGAINERS(industryName, segment, topN, startCell) Result Result: Top 5 gainers in Metals & Mining industry
â–¶ INDUSTRYLOSERS	Industry Movers	Worst performing stocks within a specific industry
Summary Worst performing stocks within a specific industry Parameters industryName, segment, topN, startCell Pro Tip Syntax: =INDUSTRYLOSERS(industryName, segment, topN, startCell) Result Result: Bottom 5 in Metals & Mining industry by price change
â–¶ MOSTACTIVEBYTURNOVER	Most Active	stocks with the highest total traded value
Summary stocks with the highest total traded value Parameters indexName, segment, topN Pro Tip Syntax: =MOSTACTIVEBYTURNOVER(indexName, segment, topN) Result Result: Total value traded = price × volume. Higher = more liquidity.
â–¶ MOSTACTIVEBYVOLUME	Most Active	stocks with the highest number of shares traded
Summary stocks with the highest number of shares traded Parameters indexName, segment, topN Pro Tip Syntax: =MOSTACTIVEBYVOLUME(indexName, segment, topN) Result Result: Volume = share count. Turnover = volume × price.

Sheets by Truedata

Empowering traders and analysts with high-performance real-time market data directly within their spreadsheets.

Formula Reference

Market Movers Formulas

Resources

Support