CRESCO Platform — Market-Data & AI

CRESCO

MARKET-DATA & AI

CQG LIVE

{{ clock }} GST

VIEWER ROLE — read-only. Trade capture, marks and extraction confirmations are disabled.

Trader desk

Live view of the book, the market and the AI — trade capture one click away.

NET EXPOSURE

{{ kpiNet }}

UNREALIZED P&L

{{ kpiUnreal }}

VaR 95% · 1-DAY

{{ kpiVar }}

ALERTS TODAY

{{ alertCount }}

OPEN POSITIONS — LIVE MtM

{{ p.sym }}
{{ p.qty }}
{{ p.mark }}
{{ p.pnl }}
{{ p.flag }}

KEY PRICES

{{ w.sym }}

{{ w.lastStr }}

{{ w.chgStr }}

QUICK ACTIONS

OPEN CHARTS

CAPTURE TRADE

SUBMIT MARK

ASK THE DATA

TOP AI SIGNALS

Analyst workspace

Cross-source studies, divergence monitoring and PRA curation — no trade capture.

DIVERGENCE MATRIX — THE PARTY-LINE TEST

PAIR

SPREAD %

STATUS

{{ d.pair }}
{{ d.a }}
{{ d.b }}
{{ d.pct }}
{{ d.status }}

30-DAY CORRELATION — DAILY RETURNS

{{ c.name }}
{{ c.v1 }}
{{ c.v2 }}
{{ c.v3 }}
{{ c.v4 }}

columns: FEF M09 · RB M10 · HC M10 · IOPI62 — computed nightly in Python against the read-only role

PRA CURATION

PDFs processed today
3
assessment rows written
22
pending review
{{ queueCount }}
extraction accuracy (M3 target)
96.8%

OPEN REVIEW QUEUE

RUN A STUDY — ASK THE DATA

Market intelligence digest

Read-only view for domain advisors — sanity-check sources, no actions.

TODAY IN ONE PARAGRAPH

Iron ore firmer: SGX FEF Sep-26 up on Chinese steel-margin strength while SHFE rebar eased. The stand-out is Mysteel's 62% index printing 1.4% above screen — the widest gap in a month and the third session of party-line-flavoured strength. Broker flow (FIS/SSY/GFI) leans better bid on FEF, offered on rebar. Desk marks side with the exchange.

condensed from the 06:30 daily briefing · all figures grounded & cited

KEY PRICES — ALL SOURCES

{{ w.sym }}

{{ w.lastStr }}

{{ w.chgStr }}

SOURCE DISAGREEMENTS WORTH A LOOK

{{ s.title }} — {{ s.detail }}

Admin console

Users, entitlements, environments and the licensing register.

USERS — ENTRA ID APP ROLES

SSO + MFA enforced · conditional access on · 2–3 launch users, headroom to ~25 (re-check per-user data fees before scaling)

LICENSING & COMPLIANCE REGISTER (§14)

ENVIRONMENT — AZURE UAE NORTH

prod · Container Apps
healthy · 6 apps
dev
healthy
PostgreSQL + Timescale
GP D4ds_v5 · PITR on
Key Vault · secrets
private endpoint · rotation 90d
IaC drift (Bicep)
none · last apply 07:12
Event Hubs · SignalR
nominal
Azure OpenAI region
confirm content flow (§14.5)

COST SNAPSHOT — MONTH TO DATE

Azure infra (2–3 users)
$412
Azure OpenAI + Doc Intelligence
$118
CQG real-time professional
quote-only
SGX / SHFE entitlements
quote-only
Mysteel multi-user feed
quote-only

Market-data licensing dominates the budget, not the software — commercial conversations started in M1 (long lead).

WATCHLIST — ALL SOURCES

{{ w.sym }}

{{ w.lastStr }}

{{ w.chgStr }}

exchange · PRA · broker · manual —
one normalized store, full provenance

{{ activeSym }}

            O {{ ohlcO }}
            H {{ ohlcH }}
            L {{ ohlcL }}
            C {{ ohlcC }}
            {{ ohlcChg }}
          

◈ AI READ

LAYOUT ▾

◈ AI READ {{ aiReadSym }} ✕

analyzing 140 bars, 4 sources, signal history…▍

⌕ {{ ac.label }}

grounded · cited · logged to audit — advisory only, you decide

        tick→chart 0.9s
        last tick {{ lastTick }}
        KLineChart Pro · datafeed WS/SignalR
        
        Azure UAE North · Entra ID SSO
      

AI SIGNALS — DIVERGENCE & TREND

BROKER BLASTS Telegram · Telethon

{{ b.raw }}

ALERTS

Ask your data

Natural-language assistant over the normalized store · text-to-SQL + RAG · read-only, cited, logged. No trade actions.

{{ row.c1 }}
{{ row.c2 }}
{{ row.c3 }}
{{ row.c4 }}

⌕ {{ c.label }}

querying market_series…▍

Daily AI Briefing

Monday 13 July 2026 · generated 06:30 GST

grounded on 4,182 rows · all figures cited

SEABORNE IRON-ORE FLOWS — CARGO ON THE WATER

ON THE WATER — ALL LANES

133.2 Mt

+3.4 Mt w/w · loadings rising

{{ fs.val }}

PRODUCTION vs ARRIVALS

CN hot-metal 2.41 Mt/d vs arrivals implied 2.28 Mt/d — port stocks drawing. Supports the FEF long until the loading wave lands (2–4 wks). India run-rate and Turkey scrap bid add demand-side support.

Mysteel SFTP · Navigate satellite · vessel positions simulated for demo

⛏ PRODUCERS — MINES & LOADINGS

27.0 Mt/wk

{{ sg2.total }}

{{ mn.val }}

{{ mn.chg }}

Loadings +3.4 Mt w/w — the supply wave is on the water, arriving in 2–4 weeks.

🏭 CONSUMERS — MILLS & ORE BURN

burn 75.5 Mt/mo · output 47.3 Mt/mo

{{ dg.total }}

{{ ml.burn }}

{{ ml.util }}%

{{ ml.dd }}

burn = ore/scrap consumed, Mt/moutil = capacity utilizationΔ = w/w satellite thermal

SGX FEF FORWARD CURVE

vs prior settle

{{ cr.tenor }}

{{ cr.px }}

{{ cr.chg }}

Backwardation steepened 0.20 overnight — spot strength not yet believed by the curve. Cal-27 bid only via FIS.

SPREADS & MARGINS

{{ sp.val }}

{{ sp.chg }}

Mill margin expansion is the session's key driver — supports ore and HRC over rebar.

FREIGHT & FX

{{ fx.name }}

{{ fx.val }}

{{ fx.chg }}

TODAY — GST

{{ cal.time }}

OVERNIGHT MOVES

SGX FEF Sep-26 settled 102.35 (+0.85) on firmer Chinese steel margins; Oct-26 followed at 101.10. SHFE rebar closed night session 3,142 (−0.4%) with HRC outperforming at 3,298. The FEF curve steepened slightly; Cal-27 broker interest at 99.50/100.25 (FIS).

NEW PRA PRINTS

Mysteel 62% port index 103.75 (+1.10) — 06:05 GST.
Platts IODEX 62% 103.15 (+0.65) — prior day print.
Mysteel coking coal & port-stock file received via SFTP 06:00.

NOTABLE BLASTS

FIS: FEF Sep 102.30/102.55, 10kt clip — tightest market of the morning.
SSY: RB Oct offered 3,150, screen better bid.
GFI: IO 62 Oct–Nov spread 0.85/1.05 — low-confidence, in review queue.

DIVERGENCE FLAGS

Mysteel 62% is +1.4% above SGX FEF front — widest gap in 30 days. Party-line test: Mysteel rebar assessment sits 1.1% above SHFE settle-implied. Watch for convergence trades; physical marks corroborate the exchange side.

DESK POSITION SNAPSHOT

Net long 2,000 t FEF Sep-26 (hedge) vs short 3,000 t Oct-26 (spec). Unrealized {{ kpiUnreal }}. VaR (95%, hist-sim) {{ kpiVar }}. Full detail in Ledger.

Generated by the briefing job (Azure OpenAI, GPT-4o-class) · every figure grounded on market_series with provenance · logged to audit_log · AI advises, people decide.

Alert rules

User-defined and AI-suggested · delivered in-app, email, outbound Telegram

{{ ar.cond }}

NEW ALERT RULE

Fired alerts

Today · most recent first

NET EXPOSURE

{{ kpiNet }}

across FEF curve

UNREALIZED P&L

{{ kpiUnreal }}

MtM vs latest store marks

REALIZED P&L (YTD)

+$184,250

audited trail · QFZP-ready

VaR 95% · 1-DAY

{{ kpiVar }}

hist-sim, open-source Python

POSITIONS — MARK-TO-MARKET

INSTRUMENT

NET (t)

AVG PX

MARK

UNREAL P&L

FLAG

{{ p.sym }}
{{ p.qty }}
{{ p.avg }}
{{ p.mark }}
{{ p.pnl }}
{{ p.flag }}

TRADES

SIDE

INSTRUMENT

QTY (t)

PRICE

COUNTERPARTY

FLAG

TIME

{{ tr.side }}
{{ tr.sym }}
{{ tr.qty }}
{{ tr.price }}
{{ tr.cpty }}
{{ tr.flag }}
{{ tr.time }}

CAPTURE TRADE

TAX FLAG

HEDGE · 0% QFZP

SPECULATIVE · 9%

Hedge-vs-speculative captured at entry · point-in-time mark source recorded · append-only audit. Execution stays manual.

EXCEL / PYTHON CONNECTIVITY

Governed read access to the same store — scenario, correlation and ad-hoc analytics stay in the desk's existing tools.

# Excel · Power Query
PostgreSQL · cresco-pg.postgres… · role: readonly_desk
# Python · pandas
pd.read_sql("select * from market_series …", eng)

COPY CONNECTION STRING

VaR METHODS ▸

AUDIT LOG (APPEND-ONLY)

          {{ au.time }} [{{ au.kind }}] {{ au.text }}

        

Executive brief

The whole business on one screen — money first, plain language, marked live.

{{ ck.val }}

NEEDS YOUR ATTENTION

the three items costing money today — everything else is running normally

{{ ca.money }}

DETAILS →

◈ TODAY IN PLAIN ENGLISH — 06:30 GST

written by the briefing engine from live data · every figure traceable to source

WHERE THE COMPANY'S MONEY IS

{{ cm.val }}

Green = money coming to us · red = money going out · blue/purple = tied up in cargo.

BUSINESS PULSE

{{ cp2.val }}

CFO — finance view

Paper trading and physical trading in one P&L · cash, credit and risk beneath it.

P&L BY BOOK — PAPER + PHYSICAL

{{ cb.val }}

TOTAL COMPANY P&L — MARKED LIVE

{{ cfoTotal }}

PAPER TRADING — DERIVATIVES DESK

OPEN LEDGER →

net futures exposure
{{ kpiNet }}
unrealized P&L (open)
{{ kpiUnreal }}
realized P&L (YTD)
+$184,250
VaR 95% · 1-day
{{ kpiVar }}
hedge vs speculative
tagged at entry
tax treatment (QFZP)
0% / 9% split

Every trade carries its hedge/spec flag and point-in-time mark source — the paper book reconciles to the audit log line by line.

CASH — NEXT 90 DAYS

{{ pc.when }}

{{ pc.amt }}

NET EXPECTED INFLOW

+$13.86M

receivables (LC-backed)
$26.9M
supplier payables (30d)
$14.3M
advances outstanding
$3.94M

FUNDING — TRADE FINANCE LINES

{{ fr2.drawn }} drawn

{{ fr2.head }} free

COUNTERPARTY CREDIT

{{ cr3.pct }}

RISK REGISTER — WHAT COULD HURT US

{{ rk.money }}

Paper VaR is computed nightly (historical simulation); physical exposures reprice against the live store.

{{ pk.val }}

NEEDS ATTENTION TODAY

ranked by money at stake

{{ pa.money }}

VIEW →

BUSINESS SNAPSHOT

marked live

{{ ps.val }}

◈ AI PHYSICAL DIGEST — 06:30 GST

Book is healthy: +$247k across open voyages with 88% of sales LC-backed. Two items cost money today — the Bosphorus doc hold gates $13.3M, and Gulf Horizon burns $12k/day on demurrage. Deliveries run on contract except Metinvest (33% of Q3, Aug parcel unconfirmed). Quality nets in our favour: +$37.5k CDRI claim vs −$56k IO price adjustment priced into P&L.

FLEET & CARGO POSITIONS — LIVE

● loading ▲ on water ● discharging ◆ cargo bought · awaiting vessel

VOYAGE BOARD

{{ pb.cargo }}

{{ pb.when }}

CARGO BOOK — OPEN DEALS

SIDE

CARGO · TERMS

QTY (t)

PRICE

COUNTERPARTY

STATUS

HEDGE

{{ pd.side }}
{{ pd.cargo }}
{{ pd.terms }}
{{ pd.qty }}
{{ pd.price }}
{{ pd.cpty }}
{{ pd.status }}
{{ pd.hedge }}

VESSEL OPERATIONS

{{ pv.route }}

{{ pv.cargo }}

{{ pv.eta }}

PHYSICAL POSITION & HEDGE

{{ pp.net }}

hedged {{ pp.cov }}

HEDGE GAP: 12,000 t scrap price risk unhedged — laycan before LC payment date.

HEDGE NOW →

LETTERS OF CREDIT

{{ lc.ref }}

EXPECTED CASH — NEXT 90 DAYS

{{ pc.when }}

{{ pc.amt }}

NET EXPECTED INFLOW

+$13.86M

Inflows on LC presentation · outflows on supplier payment terms — timing gap covered by the hedge book.

SHIPPING DOCUMENTS — CONTROL MATRIX

prepared by supplier · controlled by CRESCO ops · LC presentation gate

DOCUMENT

{{ ds.deal }} · docs {{ ds.pct }}

DISCREPANCY

MV Bosphorus Star — insurance certificate shows 110% CIF but LC-2606-CON requires 115%. Supplier notified 12 Jul; re-issue expected before Suez transit. LC presentation blocked until resolved.

CHASE SUPPLIER

CARGO ECONOMICS — VOYAGE P&L

FOB buy → costs → CFR sell · marked live vs store

CARGO

BUY

FREIGHT

INS+FIN

HEDGE Δ

SELL

MARGIN /t

TOTAL P&L

{{ cp.name }}
{{ cp.sub }}
{{ cp.buy }}
−{{ cp.freight }}
−{{ cp.costs }}
{{ cp.hedge }}
{{ cp.sell }}
{{ cp.margin }}
{{ cp.total }}

BOOK TOTAL — open voyages, marked to latest store prices

+$247,100

DEMURRAGE & LAYTIME

{{ lt.used }}

{{ lt.money }}

COUNTERPARTY CREDIT

{{ cr2.used }} / {{ cr2.limit }}

{{ cr2.pct }}

Exposure = open deliveries + unpaid invoices − LC cover. Tosyalı near limit — next fixture needs LC at sight or limit increase.

TRADE FINANCE LINES

{{ fr.drawn }} drawn

{{ fr.head }} free

HEADROOM CHECK: Hedland IO nomination (≈$3.1M margin + freight) fits ENBD headroom; Aug scrap restock will need the HSBC line.

SUPPLY CONTRACTS

fulfillment & payables

{{ sc.fulfilled }}

                adv paid {{ sc.adv }}
                payable {{ sc.payable }}
                due {{ sc.due }}
                {{ sc.note }}
              

TOTAL SUPPLIER PAYABLES — NEXT 30D

$14.31M

YARD OPERATIONS — TRUCKS

today, live

gate open {{ yo.hours }}

{{ yo.trucks }}

trucks unloaded

{{ yo.tons }}

tonnes in

{{ yo.rejects }}

rejected at gate

MonTueWedThuFriSattoday

QUALITY — SGS & PENALTIES

spec vs certificate, both directions

                {{ qr.cert }}
                spec {{ qr.spec }}
                actual {{ qr.actual }}
              

⬢ DRI SAFETY — MV DELTA SPONGE · IMSBC GROUP B

COMPLIANT

{{ dg2.val }}

N₂ blanket holds all holds inert · O₂ alarm at 3.0% · hourly readings logged to voyage file — surveyor countersigns at discharge.

Manual trader mark

Prices the desk simply knows — timestamped, attributed, versioned.

Writes a mark row with ts_event, user attribution, unit & currency. Edits create new versioned rows — nothing is overwritten. Navigate figures use interim manual capture (no API yet).

RECENT MARKS

SYMBOL

VALUE

UNIT

TENOR

USER

TIME

{{ mk.sym }}
{{ mk.val }}
{{ mk.unit }}
{{ mk.tenor }}
{{ mk.user }}
{{ mk.time }}

Extraction review queue

Human-in-the-loop — low-confidence extractions need one-click confirmation before they reach the store. High-confidence rows flow straight through.

Queue clear — all extractions confirmed. New low-confidence blasts will appear here.

RAW MESSAGE

{{ q.raw }}

EXTRACTED → market_series

                {{ f.k }}: {{ f.v }}

              

CONFIDENCE

{{ q.conf }}

Navigate Commodities — satellite ferrous intelligence

Physical reality from orbit: hot-metal output, port stocks, shipments and mill activity — the ground truth we test Chinese party-line figures against. Dashboard-only today (no API), captured by interim manual entry; every figure still lands in market_series and drives the divergence engine.

{{ nm.value }}

{{ nm.delta }}

8-week trend · {{ nm.captured }}

HOW THE DESK EXPLOITS IT — SATELLITE CROSS-CHECKS

Navigate rows carry source=navigate provenance and feed the same divergence engine as PRA and exchange series — intelligence only, never a tax benchmark (not MD 230).

ROADMAP — FROM SCREENSHOTS TO A FEED

PHASE 1 · NOW

Interim manual/screenshot entry — key figures typed into the validated form, provenance tagged, on the charts same-day.

POST-PHASE 1

Contractual machine-readable feed pursued with Navigate — swaps in behind the same connector interface, manual entry retired.

INTERIM CAPTURE

From the Navigate dashboard → into the store, ~30 seconds.

Writes an assessment row with ts_event, user attribution and source=navigate provenance — instantly available to charts, the divergence engine and the NL assistant.

RECENT NAVIGATE ENTRIES

{{ nr.time }}{{ nr.sym }}{{ nr.val }}{{ nr.user }}

Source & connector health

One connector per source · failures isolated · idempotent writes · everything lands in market_series with provenance

last event
{{ src.last }}
today
{{ src.today }}
latency p95
{{ src.lat }}

LICENCE · {{ src.lic }}

CONFIGURE

INGEST AUDIT — TAIL

      {{ ig.time }} {{ ig.src }} → {{ ig.text }}

    