Family office AI prompt

Top contributors and detractors

The five biggest gains and losses, with bookings separated from market moves.

For
Principal, COO, MFO/advisor
Topic
Performance
The prompt
Copy

Give me the top five contributors and detractors to [this month’s] performance, and explain anything that looks like a booking rather than a market move.

Example output · Claude with Masttro connected
Example answer from Claude connected to Masttro MCP: the five biggest gains and losses, with bookings separated from market moves

Illustrative output based on Masttro's demo family office data.

What to look for
1
Five up, five down

The positions that added and subtracted the most from the period's result.

2
Bookings separated

Anything that looks like an accounting entry rather than a market move is called out.

3
Realized, unrealized, income

Each figure is split so you see how the gain or loss arose.

Before you run it

Replace [this month's] with the period you want, such as this quarter.

Ask next

Follow-up prompts

Show me how each of these figures was derived, with the source positions and transactions.

Copy

Break the net result down by asset class.

Copy

Run the same list for the quarter.

Copy
Why it's useful

Why separate bookings from market moves?

A position can top the contributor list because of a revaluation, a corporate action or a booking error rather than a genuine market move. Presenting that to a principal as performance is a credibility risk.

This prompt ranks the biggest movers and then asks the AI to flag anything that looks like a booking. The COO gets a clean list to report and a short list of items to check with the custodian first.

01
A cleaner story

Market moves are kept apart from accounting entries.

02
Position-level P&L

Every figure ties back to a named holding.

03
Traceable

A follow-up shows how each figure was derived from positions and transactions.

FAQ

Questions about this prompt

What counts as a booking?

Entries that change value without a market move, such as revaluations, transfers or corrections. The prompt asks the AI to flag anything that looks like one so you can confirm it.

Can I see how each figure was built?

Yes. The first follow-up asks for the source positions and transactions behind every number.

Can I change the number of positions?

Yes. Change 'top five' to any number you want.

Is the result net of fees?

It reflects the P&L recorded in Masttro for each position. Ask the follow-up to confirm how fees are treated in your data.

Masttro MCP

Run this prompt on your own Masttro data

Connect Claude or ChatGPT to the data you consolidate in Masttro. Read-only, scoped to each person's permissions, and switched on by your Super Admin.

Claude or ChatGPT
You paste the prompt here
Your AI tool
Masttro MCP
Applies your Masttro permissions
Read-only
Your Masttro data
Holdings, transactions and performance across every entity