Stockchart
Generates a visual stock price chart that can be displayed in Excel. Returns an image URL or embedded chart showing price history.
Notes
- Returns a chart/image, not numeric data
- Useful for visual dashboards
- Chart period may vary by default settings
Syntax
=mxls.Stockchart(Symbol)Examples
=mxls.Stockchart("AAPL")=mxls.Stockchart("MSFT")When to Use
Visual dashboards, quick price history view, reports
When NOT to Use
| Need numeric data | Use price history functions |
| Need specific dates | Close_Historical() |
Common Issues & FAQ
Why am I getting "NA"?
Check that the symbol is valid and has sufficient trading history for the requested period.
Are returns price-only or total return?
These are typically price returns. Dividend-adjusted returns may differ.
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?