StockChart
Inserts a MarketXLS chart image beside the formula cell. It supports stock-price history, multi-symbol price comparisons, and current U.S. option volatility skew.
Supported chart codes
| ChartCode | Result |
|---|---|
history |
Price-history chart; this is the default |
history90 or 90 |
Price-history chart for approximately 90 days |
mountain90 |
Mountain-style price chart for approximately 90 days |
volskew |
Current implied-volatility skew for the nearest liquid listed expiration |
volskew-YYYYMMDD |
Current skew for a specific expiration still present in the latest option-chain snapshot |
For a price comparison, pass a range of symbols and a history chart code. A volatility-skew chart accepts exactly one symbol.
Volatility-skew coverage
The skew is calculated from the latest available U.S. option-chain snapshot. It plots implied volatility across strikes and automatically selects the nearest liquid expiration when no expiration is supplied.
Historical option-chain snapshots are not available through this chart. That means it cannot recreate the skew for an expired monthly option, including last month's expired monthly contract. India option skew is not supported.
Syntax
=Stockchart(Symbol, [ChartCode])Parameters
A US stock or index symbol. Price comparisons accept a range; volatility skew requires exactly one symbol.
Chart type: history, history plus a day count (for example history90), mountain plus an optional day count, volskew, or volskew-YYYYMMDD for a currently listed expiration.
Returns
Inserts a PNG chart beside the formula cell and returns StockChart in the cell.
Examples
=Stockchart("AAPL")=Stockchart("AAPL", "history90")=Stockchart(A2:A4, "history90")=Stockchart("AAPL", "volskew")When to Use
- Add a price-history chart to an Excel dashboard
- Compare recent price performance for several symbols
- Inspect the current implied-volatility smile or skew for a U.S. stock or index
- Request the current skew for a specific expiration that is still listed
When NOT to Use
- You need numeric data in cells instead of an image; use the relevant historical-price or option-data formulas
- You need the skew from a past option-chain snapshot or an expired monthly option; historical skew is not supported
- You need India option volatility skew; this chart currently supports U.S. option data only
- You need several skew charts from one formula; use one symbol per volatility-skew formula
Common Issues & FAQ
Why does the cell say that no option-chain data is available?
Confirm that the symbol has listed U.S. options. For volskew-YYYYMMDD, the expiration must still be present in the latest option-chain snapshot.
Why can't I pass a range to volskew?
Each volatility-skew image represents one underlying and one expiration. Create one formula per symbol.
Can I request last month's monthly-option skew?
No. StockChart uses the latest option-chain snapshot and does not reconstruct expired or historical skew.
Why did no image appear?
Make sure the symbol and chart code are valid, allow the MarketXLS add-in to finish loading, and place the formula where there is room for the inserted image.
Related Formulas
More MarketXLS MarketXLS Analytics formulas you can use in the same worksheet:
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today