gabrielwang.ai ← All demos
Edition 001 · Interactive demo

Run a Singapore boutique's NAV close. Break it. Watch it defend investors.

A lean SG fund's daily book — priced off Yahoo / Google Finance and reconciled to a broker statement. Run the close, then break it — and watch the control that catches it, the hit to investors, and a Claude-drafted memo update live.

Synthetic data
Seven controls · ~2s
…or break it — each failure trips a different control (or edit the book below):
What this is

Automated daily NAV close & reconciliation

Live sources
Prices · Yahoo / Google
Broker · IBKR / Saxo
Custody · private bank
The book · Google Sheet
The daily close
S$75.89M
struck · reconciled · gated
The controls, in order
1Completenessevery position marked
2Price sanitybound every mark
3FX sanityUSD/SGD in band
4Reconcilebook ↔ broker
5Concentrationwithin mandate limit
6NAV moveday-over-day
7Release / Holdgo / no-go
Ingest
Value
Reconcile
Gate
Investors
Released

Impact on the number & on investors

Exception memo drafted by Claude

Works with the Singapore stack — Yahoo/Google Finance · IBKR/Saxo · Bloomberg · private-bank custody (illustrative)

A lean MAS-registered manager (RFMC, AUM < S$250M) prices off Yahoo / Google Finance and reconciles a broker CSV; a larger EAM plugs into Bloomberg and a private-bank custody feed. The close reads either. Logos are illustrative source systems — synthetic data, not integrations.

The lean stack · what most boutiques actually run
Prices & FXGOOGLEFINANCE · IMPORTHTML · CSV
Y!Yahoo Finance
GGoogle Finance
SGXSGX
Execution & holdings · brokersCSV / statement export · broker API
IBInteractive Brokers
SSaxo
iFiFAST · FSMOne
TTiger Brokers
mmmoomoo
PPhillip · POEMS
The book · fund accountingSheets API · Graph API · CSV
Google Sheets
Microsoft Excel
Scales to institutional · larger EAMs & family offices
Market & pricing dataAPI · B-PIPE · DataScope
BBloomberg
LSEGLSEG · Refinitiv
FFactSet
Custody · private banksSWIFT MT535/536 · SFTP · API
BOSBank of Singapore
DBSDBS
UBSUBS
JBJulius Baer
OMS · PMS · accountingAPI · scheduled export
CRDCharles River
EEnfusion
SS&CSS&C Geneva
The book · Fri 3 Jul 2026 · base SGD

Change any highlighted number

Yellow-bordered cells are editable — book qty, broker qty, the mark (SGX in S$, US in US$), and the one USD/SGD rate. Break the book-vs-broker tie, mis-key a price, oversize a name, or bump the FX rate — then hit Run the close or just watch the controls react.

TickerNameCcy Book qty editBroker qty edit Mark edit→SGDPriorMV (S$)Recon
Today's trades · the blotter

Every trade has to reconcile too

The broker executed these fills today; the book has to record each one. Toggle "Booked" off to simulate a trade that filled at the broker but never made it into the sheet — and watch the position, the cash, and the reconciliation break. Note the NAV can look perfectly normal.

TimeTickerSideQtyPriceValue (S$) Booked toggleBrokerRecon

Everything recomputes from the numbers you type. The seven controls here are exactly what MAS expects an FMC to run — NAV-calculation and valuation controls, independent custody reconciliation. Detection is deterministic; the memo is the one thing an AI writes. Fictional Singapore fund, synthetic data — a number is guilty until every source ties out.