search
Searching...
functions
Formulas
menu_book
Pages
manage_search
Content Match
search_off
No results for ""
OI Bar
Draws an in-cell bar sized relative to the cell's value — the standard way to visualize open interest (OI) distribution across a strike ladder without leaving the grid.
Setting Up the Rule — 4 Steps
1
Apply to Range
Set the range, e.g. A1:A10.
2
Select the Type
Set Format rules type to OI Bar.
3
Choose Direction & Color
Set the bar's direction and color (below).
4
Click Done
The bar renders immediately across the range.
Options
Direction
Which way the bar fills: Right to Left or Left to Right.
Bar color
Color of the fill bar.
On a Call/Put OI ladder, set the Call-side OI column to Right to Left and the Put-side OI column to Left to Right so both bars grow outward from the strike column in the center, mirroring a standard option chain layout.
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.