Calculations › Market: Forecasts
Get the 30-day forecast price for a specific fund (edit the symbol)
The query
SELECT (payload->>'price')::float AS forecast_price_30d,
(payload->>'pct')::float AS forecast_change_pct
FROM ticker_analysis
WHERE ticket = 'QQQ' AND analysis_type = 'forecast_30d'
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 30d | Forecast change % |
|---|---|
| 754.10 | 1.41 |
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