SPXW Options

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.