AXW

BTIC Confirmation Suite build 2026-10-09.4

served live by confirm_server.py
SPTR — not fetched Open SPTR page ↗
Manage data
SPREAD
OUTRIGHT
FINALS
HISTORY
DAYS
MORE
DIV FUT
DIV OPTS
BLOOMBERG

Trade Setup

Client Allocations — fill in any of the 6 slots below

Trade Setup

Client Allocations — fill in any of the 6 slots below

Trade Setup

Client Allocations — fill in any of the 6 slots below

Trade Setup

CALL
PUT
CALL
PUT
Fill in Delta, Ref Level and Underlying Expiry to auto-add a delta-hedge line on the future. Leave any blank to skip it.

Client Allocations — fill in any of the 6 slots below

Products

CodeMultiplierDay count basisDescription
Products defined here populate the Product / Multiplier fields on the SPREAD and OUTRIGHT tabs.

Div Fut Products

CodeDescription
Products defined here populate the Product field on the DIV FUT tab. No multiplier — dividend future brokerage is flat $ per lot.

Brokers

NameEmail
Read-only view of public.broker: BrokerGroupID 1, enabled, not exited, Status 10. Brokers are managed outside this app.

Futures Expiries (from reports.btic_suites_expiries)

Read-only view of reports.btic_suites_expiries (expiries and expiry codes in one table). Edit the table and click Reload data on the DAYS tab. Every day count in the suite (DAYS, FINALS, outright/spread brokerage) comes from these dates, with the 3rd-Friday rule for months not listed.
CodeDate

Settlement Holidays (from reports.btic_suites_settlement_holidays)

Read-only view of reports.btic_suites_settlement_holidays. Settlement = WORKDAY(date, T+, holidays) for today and for each expiry, and the day count is the difference between the two settlement dates — the same on every page.
Date

Clients

0 clients
Firm / ClientAccount IDBTIC RateDiv RateEmail DL
This list drives the Client dropdowns on SPREAD. Import merges by firm name (case-insensitive) unless you choose "replace all".

Confirmation History

0 sent
SentSent byClientTradeSideSizeNotionalBrokerageBrokerage RateBrokerage TypeMonth
A row is logged every time an Email button is clicked on the SPREAD tab. Saved to reports.btic_suites_history.

Finals — Today's Trade Legs

CME — AXW contract reference ↗
ProductExpirySpread (bps)Day CountFSAFinal
Legs come from today's SPREAD and OUTRIGHT confirmations in History (one roll per distinct trade, oldest first) — delete a confirmation in History to remove it here. Manual legs are kept in this browser and can be deleted here. Only today's legs are shown. Final = Final SPTR − Accrued Financing + FSA, where FSA = Final SPTR × (Spread/10000) × Day Count/360. Day Count auto-computes from each leg's expiry date vs today (adjusted to the nearest business day using the holiday calendar) — click into the Day Count field to type your own value instead; clear it to go back to auto.

Days to settlement

—
—
—
—
—
—
Month colours: H Mar M Jun U Sep Z Dec
CodeExpirySettlementDays to TodayDays to Trade Date
Same table as the Levels sheet of AXW ROLLS. Expiry = the date in reports.btic_suites_expiries when the month is listed there, otherwise the 3rd Friday (previous day if it is a regular holiday). Settlement = WORKDAY(date, T+, Settlement Holidays). Days = DAYS(expiry settlement, today's settlement), and the same against the trade date's settlement. 96 months from the current month. Tables: reports.btic_suites_expiries, reports.btic_suites_holidays (used for the 3rd-Friday rule) and reports.btic_suites_settlement_holidays (used for settlement) — edit those tables and click Reload data. Nothing is hard-coded in this page.
Recap — paste into chat

          
Custom expiries
Customs are merged into the recap by date (past ones are hidden) and saved in reports.btic_suites_custom_expiries. Days = settlement of the date minus today's settlement, same as the table. A weekly that falls on a monthly expiry shows as the month only.
Bloomberg printsBlock trades from your Terminal — load any print straight into a ticket.
checking…
Looks back across as many days as needed to find the latest prints for each contract.
Recap is ready to paste and can be re-pulled any time during the day. After 3:55 PM NY the heading drops "(SO FAR ON THE DAY)".
Products, clients, history and custom expiries are saved to the database (reports.btic_suites_*); brokers come from public.broker (read-only).