← Back to Templates
SPXW Options
Description
Builds a quote board for SPXW weekly options on the S&P 500 index, with last, bid, ask, volume, open interest and change pulled per contract and a streaming last price on the ones being watched closely.
Contracts are assembled with the option symbol formula, so a full strike ladder can be laid out by filling a column of strikes rather than typing symbols by hand. Open interest next to volume is the pairing that shows whether activity at a strike is new positioning or churn. Change the expiration in one cell and the board rebuilds.
Template Screenshots
Market data in your Excel sheets
1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.
See plans▶
How does MarketXLS work? Watch Demo
Similar Templates
No similar templates found