Stock Volatility Custom Dates
Calculates the historical volatility of a stock for a specific date range.
Syntax
=StockVolatilityCustomDates(symbol, startDate, endDate)Parameters
symbolstringRequired
startDatedateRequired
endDatedateRequired
Returns
number
Volatility for custom date range as decimal
Examples
=StockVolatilityCustomDates("AAPL", DATE(2023,1,1), DATE(2023,12,31))When to Use
- Specific event analysis
- Custom period research
- Historical comparison studies
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Standard periods | StockVolatilityOneYear() |
| Recent data | StockVolatilityThirtyDays() |
Common Issues & FAQ
What date format?
Use Excel DATE function or standard date format.
Related Formulas
More MarketXLS MarketXLS Analytics formulas you can use in the same worksheet:
- Stock Volatility Fifteen Days
- Stock Volatility Five Years
- Stock Volatility Nine Months
- Stock Volatility Seven Days
- Stock Volatility Six Months
- Stock Volatility Three Months
- Stock Volatility Three Years
- Stock Volatility Two Years
See StockVolatilityCustomDates used in a complete workbook: Excel Volatility Calculator by MarketXLS for Optimized Trading
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?