No results for ""
Historical Data
Fetch historical market data using built-in formulas from the toolbar. Historical data is available for all supported segments up to the current date.
How to Fetch Historical Data
- Open Historical from the toolbar.
- Select the formula type you need.
- Fill in the required input details.
- Click Fetch Data to load results into the sheet.
Get Ticks Data
Tick-by-tick trade data with price and timestamp.
Inputs: Symbol, From/To Date, Bid/Ask
Get Bars Data
OHLC candlestick data for a selected interval.
Inputs: Symbol, Dates, Interval (1m, 2m, 3m, 5m, 10m, 15m, 30m, 60m, 1d)
Last N Ticks
Fetch the most recent N ticks for a symbol.
Inputs: Symbol, Number of ticks, Bid/Ask
Last N Bars
Fetch the most recent N candles at a chosen interval.
Inputs: Symbol, Number of candles, Interval
Top Gainers
Stocks with the highest percentage gains in a segment.
Inputs: Segment, Top N, Auto Refresh
Top Losers
Stocks with the largest price declines in a segment.
Inputs: Segment, Top N, Auto Refresh
Top Volume
Most actively traded stocks by volume.
Inputs: Segment, Top N
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.