Family office AI prompt

Entity and account ranking

Every entity ranked by return, with the reason behind the best and worst.

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

Rank our investment vehicles and accounts by [quarter-to-date] TWR, best to worst, and tell me what drove the top and bottom three.

Example output · Claude with Masttro connected
Example answer from Claude connected to Masttro MCP: every entity ranked by return, with the reason behind the best and worst

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

What to look for
1
Best to worst

Every investment vehicle or account ranked by time-weighted return for the period.

2
The top and bottom three

The entities at each end of the list get a short explanation of what drove them.

3
Position-level reasons

The explanation points to the holdings and P&L behind each result.

Before you run it

Replace [quarter-to-date] with the period you want, such as year to date or the last 12 months.

Ask next

Follow-up prompts

Do the same at the account level.

Copy

Show year to date instead.

Copy

Which positions explain [Dharma Trust]’s result?

Copy
Why it's useful

Why rank entities against each other?

Families rarely run one portfolio. Trusts, foundations and holding companies are often managed with different mandates, and their results drift apart without anyone noticing until year-end.

Ranking every vehicle on the same return measure, then explaining the extremes, turns a list of numbers into a short agenda: which entities to praise, which to question and which positions to look at.

01
One measure for every entity

TWR puts trusts, companies and accounts on the same footing.

02
Reasons, not just ranks

The best and worst results come with the positions that caused them.

03
Account-level option

A follow-up repeats the ranking for individual accounts.

FAQ

Questions about this prompt

Does it rank entities or accounts?

Investment vehicles by default. The first follow-up runs the same ranking at the bank account level.

How are the drivers explained?

With position-level P&L, so the explanation names the holdings that made or lost the most inside each entity.

Can I change the period?

Yes. Replace [quarter-to-date] with year to date, the last 12 months or any period you report on.

Does it include entities I can't see?

No. Your Masttro permissions apply, so only the entities you can see are ranked.

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