TrueData Sheets Historical Formulas | Historical Market Data

+ 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

Historical Market Data Formulas

Formula	Category	Description
â–¶ TICKS	Tick Data	Tick by Tick data for a date and time range
Summary Tick by Tick data for a date and time range Parameters symbol, from, to, bidask, startCell Pro Tip Syntax: =TICKS(symbol, from, to, 1(with bid/ask) or 0(without bid/ask), startCell) Result Result: Tick table from 09:15 : 09:20
â–¶ BARS	Bar Data	OHLCV candlestick bars for a date/time range
Summary OHLCV candlestick bars for a date/time range Parameters symbol, from, to, interval Pro Tip Syntax: =BARS(symbol, from, to, interval) Result Available intervals : 1min · 2min · 3min · 5min · 10min · 15min · 30min · 60min · EOD
â–¶ LASTNTICKS	Tick Data	Most recent N ticks without needing a date range
Summary Most recent N ticks without needing a date range Parameters symbol, nticks, bidask Pro Tip Syntax: =LASTNTICKS(symbol, nticks, 0(without bid/ask) or 1(with bid/ask)) Result Result: Last 10 ticks for RELIANCE with bid/ask
â–¶ LASTNBARS	Bar Data	Most recent N completed candles at any interval
Summary Most recent N completed candles at any interval Parameters symbol, nbars, interval, startCell Pro Tip Syntax: =LASTNBARS(symbol, nbars, interval, startCell) Result Result: Last 10 × 5-min bars for RELIANCE
â–¶ TOPNGAINERS	Market Movers	Top N gainers in a segment with auto-refresh
Summary Top N gainers in a segment with auto-refresh Parameters segment, topN, startCell, refreshInterval Pro Tip Syntax: =TOPNGAINERS(segment, topN, startCell, refreshInterval) Result Result: Top 10 gainers in NSE Equity, refresh every 1 min
â–¶ TOPNLOSERS	Market Movers	Top N losers in a segment with auto-refresh
Summary Top N losers in a segment with auto-refresh Parameters segment, topN, startCell, refreshInterval Pro Tip Syntax: =TOPNLOSERS(segment, topN, startCell, refreshInterval) Result Result: Top 10 losers in NSE Equity, refresh every 1 min
â–¶ TOPNVOLUMEGAINERS	Market Movers	Most actively traded stocks by volume
Summary Most actively traded stocks by volume Parameters segment, topN, startCell, refreshInterval Pro Tip Syntax: =TOPNVOLUMEGAINERS(segment, topN, startCell, refreshInterval) Result Result: Top 10 volume leaders in NSE Equity

Sheets by Truedata

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

Formula Reference

Historical Market Data Formulas

Resources

Support