No results for ""
Formula Reference
Live Market Data Formulas
Real-time WebSocket Data
These formulas are powered by a live WebSocket connection, ensuring your spreadsheet data updates instantly as the market moves.
Unique identifier for the symbol
| A | B | |
|---|---|---|
| 1 | TCS | 100001528 |
Time of last trade
| A | B | |
|---|---|---|
| 1 | TCS | 3:27:32 PM |
Return the last traded price
| A | B | |
|---|---|---|
| 1 | TCS | 2520.56 |
Return last traded quantity
| A | B | |
|---|---|---|
| 1 | TCS | 226 |
Returns average traded price
| A | B | |
|---|---|---|
| 1 | TCS | 2341.36 |
Returns total traded volume
| A | B | |
|---|---|---|
| 1 | TCS | 225180 |
Return opening price of the day
| A | B | |
|---|---|---|
| 1 | TCS | 2349.7 |
Return highest price of the day
| A | B | |
|---|---|---|
| 1 | TCS | 2354.5 |
Return lowest price of the day
| A | B | |
|---|---|---|
| 1 | TCS | 2332.3 |
Return previous closing price
| A | B | |
|---|---|---|
| 1 | TCS | 2349.7 |
Return current open interest
| A | B | |
|---|---|---|
| 1 | CRUDEOIL-I | 8528 |
Return previous open interest
| A | B | |
|---|---|---|
| 1 | CRUDEOIL-I | 8807 |
Return total traded value
| A | B | |
|---|---|---|
| 1 | TCS | 899700285 |
Return sequence number of tick
| A | B | |
|---|---|---|
| 1 | TCS | 1285 |
Return highest bid price
| A | B | |
|---|---|---|
| 1 | TCS | 2344.2 |
Return quantity at best bid
| A | B | |
|---|---|---|
| 1 | TCS | 31 |
Return lowest ask price
| A | B | |
|---|---|---|
| 1 | TCS | 2345 |
Return quantity at best ask
| A | B | |
|---|---|---|
| 1 | TCS | 322 |
Return price change from previous close
| A | B | |
|---|---|---|
| 1 | TCS | -5.2 |
Return percentage price change
| A | B | |
|---|---|---|
| 1 | TCS | -0.0019 |
Return change in open interest
| A | B | |
|---|---|---|
| 1 | CRUDEOIL-I | -329 |
Return percentage change in OI
| A | B | |
|---|---|---|
| 1 | CRUDEOIL-I | -3.78% |
Return option's sensitivity to a 1% change in interest rate
| A | B | |
|---|---|---|
| 1 | NIFTY26092922800CE | 2.1215 |
Return option's sensitivity to a 1% change in implied volatility
| A | B | |
|---|---|---|
| 1 | NIFTY26092922800CE | 11.65 |
Return option's daily time decay in premium value
| A | B | |
|---|---|---|
| 1 | NIFTY26092922800CE | -12.8103 |
Return rate of change of Delta for a 1 point move in underlying
| A | B | |
|---|---|---|
| 1 | NIFTY26092922800CE | 0.0012 |
Return option's sensitivity to a 1 point change in underlying price
| A | B | |
|---|---|---|
| 1 | NIFTY26092922800CE | 0.5977 |
Return the market-implied volatility of an option contract
| A | B | |
|---|---|---|
| 1 | NIFTY26092922800CE | 11.2 |
Return the indicative close price
| A | B | |
|---|---|---|
| 1 | RELIANCE | 2520.56 |
Return the indicative quantity
| A | B | |
|---|---|---|
| 1 | RELIANCE | 1500 |
Return the reference price
| A | B | |
|---|---|---|
| 1 | RELIANCE | 2518.30 |
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.