Time Series Forecast
Returns a time series forecast value for portfolio analysis. This function provides predictive analytics based on historical data patterns.
Notes
- This function operates on portfolio data
- Uses time series analysis techniques for forecasting
- Best used in conjunction with other portfolio analytics functions
Syntax
=TimeSeriesForecast()Examples
Get time series forecast
When to Use
- Forecasting future portfolio values
- Time series analysis
- Predictive modeling in spreadsheets
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Current stock price | Last() |
| Historical prices | Close_Historical() |
| Technical analysis | Technical indicator functions |
Common Issues & FAQ
How does the forecast work?
The function uses time series analysis techniques on historical data to project future values.
What data does it use?
It operates on portfolio data configured in your MarketXLS setup.
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?