Calculations › Market: Forecasts
Get the 7-day forecast price for a specific stock (edit the symbol)
The query
-- Reads the persisted forecast (refreshed automatically, no live model-fitting cost)
SELECT (payload->>'price')::float AS forecast_price,
(payload->>'pct')::float AS forecast_change_pct,
payload->>'method' AS forecast_method,
computed_at
FROM ticker_analysis
WHERE ticket = 'AAPL' AND analysis_type = 'forecast_7d'
Runs against Cryptobi's market tables — ticketname (symbols),
ticketprice (daily prices and volume) and symbolmetadata
(sector, exchange, market cap and other reference fields).
Current output
| Forecast price | Forecast change % | Forecast method | Computed at |
|---|---|---|---|
| 334.76 | 0.52 | holt_damped | 2026-09-30 21:02:08.316218 |
Live output, first 1 rows, refreshed periodically. Model estimates are trend projections from recent prices, not financial advice.
Run this on your own holdings, change it, or write your own in SQL or Python — then put it on a dashboard or have it emailed on a schedule. Free, no credit card.
Sign Up Free