27 Commits

Author SHA1 Message Date
e36ef3fe47 feat: add ?years= param to underlying-only chart endpoint
Endpoint standalone /api/chart/underlying/{id} caricava un TOP 350
fisso; ora accetta ?years= (default 5, clamp 1-20) e la SP filtra per
data invece che per numero di righe.

Il prezzo usato resta Px_close/Px_closeadj in base ad
AdjustedPrices, senza fallback incrociato tra i due campi: quando
Px_closeadj non è backfillato prima di uno split (es. Apple, valorizzato
solo da inizio 2019), un fallback avrebbe mischiato dati adjusted/raw
creando un gradino artificiale nel grafico. La SP ora taglia lo storico
dove il campo scelto non è popolato.

Fix collaterale: skip righe con prezzo NULL prima del cast a decimal,
evitava un InvalidCastException con storici lunghi.

Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com>
2026-07-21 17:54:25 +02:00
d59f5a0faa Aggiornamento docs 2026-07-21 11:02:32 +02:00
fdbf16ad0b fix: use CONCAT for NULL-safe underlying name in cedlab_Chart_UnderlyingOnly 2026-07-21 10:31:15 +02:00
d6f781e34d docs: add cedlab_Chart_UnderlyingOnly SP script 2026-07-21 10:29:03 +02:00
a03a437f1a docs: add implementation plan for standalone underlying chart endpoint
Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com>
2026-07-21 10:25:36 +02:00
d15af22a2a docs: fix underlying name/ticker column in chart spec
Underlyings.Name + Underlyings.Ticker_bbg, composed as "{Name} (Ticker)".

Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com>
2026-07-21 10:23:14 +02:00
27784bcb4f docs: add design spec for standalone underlying-only chart endpoint
Spec for a new /api/chart/underlying/{idUnderlyings} endpoint that
renders a single price-history line for one underlying, independent
of any certificate context (no strike/barriers/legend).

Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com>
2026-07-21 10:17:39 +02:00
d90212c206 docs: add fund report implementation plan (10 tasks, FundAnagraficaRenderer + FundSkiaChartRenderer + orchestrator)
Co-Authored-By: Claude Sonnet 4.6 (1M context) <noreply@anthropic.com>
2026-06-08 17:29:41 +02:00
f1825a1b13 docs: add sfih_GetChartPrices SP details to fund report spec
Co-Authored-By: Claude Sonnet 4.6 (1M context) <noreply@anthropic.com>
2026-06-08 17:20:43 +02:00
86c8c8b3f3 docs: add fund/ETF report design spec (layout C, endpoints, models)
Co-Authored-By: Claude Sonnet 4.6 (1M context) <noreply@anthropic.com>
2026-06-08 17:10:47 +02:00
679f9e4528 fix: rewrite cedlab_Chart_AllSeriesV2 with correct schema from cedlab_Chart_UL1 (CertificatesUnderlyings.Strike, StartDate=MIN(Prices.Px_date), deleted/sospeso filters) 2026-05-27 17:17:32 +02:00
e4728cf79e fix: revert to cedlab_Chart_UL1 (already has all V2 fields); remove cedlab_Chart_UL2; fix AllSeriesV2 SQL with DailyUL1 logic 2026-05-27 16:35:48 +02:00
a866a2f7d5 fix: use cedlab_Chart_UL2 (new SP, don't modify UL1); add correct SQL scripts with Prices table 2026-05-27 16:28:26 +02:00
de9d235703 docs: add implementation plan for Memoria field and Natixis parameter 2026-03-26 11:56:01 +01:00
1bf99a917c docs: fix DrawTitolo -> DrawTitle method name in spec 2026-03-26 11:14:02 +01:00
2a10a058b3 docs: fix spec issues - DrawTitolo signature strategy, cache key expired path, showTip guard 2026-03-26 11:03:25 +01:00
998c24da31 docs: add design spec for Memoria field and Natixis parameter 2026-03-26 10:54:35 +01:00
1a4e3538b5 docs: add implementation plan for greyed-out unreachable event rows 2026-03-24 16:21:48 +01:00
5e90446cbe docs: add design spec for greyed-out unreachable events in expired certificates 2026-03-24 16:13:29 +01:00
cc3d3695fe docs: fix spec review issues in dividend section design 2026-03-23 12:01:03 +01:00
001fbd90d9 docs: add dividend section design spec 2026-03-23 11:58:56 +01:00
16d06340fc docs: add all superpowers plans and specs 2026-03-21 11:54:39 +01:00
26ebd320e5 docs: add expired certificate report implementation plan 2026-03-21 10:27:51 +01:00
cdbdfeede1 docs: update expired report spec after review (cache keys, orchestrator logic, chart signature) 2026-03-21 10:21:20 +01:00
71d6a4c32d docs: add expired certificate report design spec 2026-03-21 10:17:53 +01:00
3636676dbc docs: add implementation plan for page1 header restyle 2026-03-20 16:39:26 +01:00
c72670edee docs: add spec for page1 header restyle and label fixes 2026-03-20 16:30:22 +01:00