Family office AI prompt

Custodian and manager ranking

Every custodian and manager ranked, with the ones to review named.

For
COO, MFO/advisor
Topic
Performance
The prompt
Copy

Rank our custodians and managers by [three-year] annualized TWR, show how much each made or lost for the family in dollars, and tell me which relationships we should review this year.

Example output · Claude with Masttro connected
Example answer from Claude connected to Masttro MCP: every custodian and manager ranked, with the ones to review named

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

What to look for
1
Every relationship ranked

Custodians and managers ordered by annualized time-weighted return.

2
Dollars, not just percentages

How much each relationship made or lost for the family.

3
Who to review

The answer names the relationships worth reviewing this year.

Before you run it

Replace [three-year] with the period you judge managers on.

Ask next

Follow-up prompts

Show the same ranking for this quarter only.

Copy

Which positions explain [Marvin Bruning]’s result?

Copy

Compare each manager against a relevant market index.

Copy
Why it's useful

Why rank custodians and managers in dollars as well as returns?

A manager with a strong percentage return on a small mandate can matter less than an average manager running a large one. Looking at returns alone tends to send attention to the wrong relationship.

This prompt puts annualized TWR next to assets and dollar P&L for each custodian and manager, so the review list reflects both skill and scale.

01
Skill and scale together

Percentage returns sit next to dollars made or lost.

02
Annualized for fairness

Longer periods are compared on the same yearly basis.

03
A review list

The answer ends with the relationships to discuss.

FAQ

Questions about this prompt

What is ranked, custodians or managers?

Both. Results are grouped by bank account and by asset manager, depending on how your accounts are set up in Masttro.

Why annualized TWR?

It compares managers on the same yearly basis and removes the effect of money moving in and out.

Can I compare managers with an index?

Yes. A follow-up asks the AI to compare each manager against a relevant market index. Index data comes from the AI tool, not Masttro.

Can I look at one manager in detail?

Yes. Use the follow-up that explains one manager's result and replace the bracketed name.

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