Calculations › Market: Forecasts
Top 10 stocks by 7-day forecasted % gain, market-wide
The query
SELECT tn.ticket AS symbol, (ta.payload->>'pct')::float AS forecast_change_pct
FROM ticker_analysis ta
JOIN ticketname tn ON tn.ticket = ta.ticket
WHERE ta.analysis_type = 'forecast_7d' AND tn.tickettype = 'stock'
ORDER BY forecast_change_pct DESC
LIMIT 10
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
| Symbol | Forecast change % |
|---|---|
| NANEXA.ST | 12.55 |
| ONCO.ST | 12.20 |
| HAV-B.ST | 6.83 |
| STAR-B.ST | 5.72 |
| AMC | 5.53 |
| QUBT | 5.17 |
| RKLB | 4.57 |
| MARA | 4.51 |
| IMMNOV.ST | 4.44 |
| MILDEF.ST | 4.03 |
Live output, first 10 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