Features
Find opportunities
Real-time quotes in Excel
Options pricing
Option Profit Calculator
Historical data
Screener
Stock Ranks
Analyze and optimise portfolios
Economic Indicators
Perform technical analysis
Quotes in Google Sheets
Cryptodata in Excel
1000+ Functions
Portfolio Report Builder
Templates
Guru screens
Track & manage
Real-time quotes in Excel
Analyze and optimise portfolios
Historical data
Perform technical analysis
Quotes in Google Sheets
Cryptodata in Excel
Option Profit Calculator
Options pricing
Collaborate
Spreadsheet Builder
Share watchlists
Share Screens
Share Templates
Learn
Blog
Videos
Templates
Public screens
Functions
Templates
Pricing
Help
Questions? Call us Toll-Free
Knowledge Library
Functions
Templates
Frequently Asked Questions
Video Tutorials
Discord
Blog
Contact Us
Blog
1-877-778-8358
Login
Book Demo
← Back to Templates
SPXW Options
Created by Nikita
Last updated: 6/30/2022
Description
Template Screenshots
Get Access to
1 Billion
Usable Market data points
IN YOUR EXCEL SHEETS
WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work? Watch Demo
Similar Templates
^SPX Real time Option Chain with SPXW
Unusual Options Activity Scanner
Options Rollover Strategy Example Template
E-Mini S&P 500 Options Template
Calculating Expected Stock Movement with MarketXLS: A Comprehensive Guide
Related Formulas
ƒ(x)
Option Chain (With Filtering)
Returns all trading or recently expired contracts of a stock...
ƒ(x)
Expirations
Returns all expiration dates for the underlying symbol.
ƒ(x)
Options Volume Leaders
Returns a list of options that have the highest traded volum...
ƒ(x)
Call Options Volume
Returns the traded volume for call options.
ƒ(x)
OI Ratio (Options)
Returns the put-call open interest ratio.
ƒ(x)
Put Options Volume (Specific Expiry)
Returns the volume for put options for a specific expiry.
ƒ(x)
Total Volume (Options)
Returns the total volume of options traded for the underlyin...
ƒ(x)
Volume (Specific Expiry) (Options)
Returns the volume for options for a specific expiry.
ƒ(x)
Front Month's Volitility
Returns the volatility of the nearest expiration date for fu...
ƒ(x)
Next Expiry Date
Returns the next expiration date for options.
