Family office AI prompt

Missing data

Each type of missing data, sized by value, with the report it breaks.

For
COO, MFO/advisor
Topic
Data quality
The prompt
Copy

Which of our holdings are missing data we need for reporting? Check every position for a missing country, sector, cost basis or quantity, size each gap by value, and tell me what each one breaks.

Example output · Claude with Masttro connected
Example answer from Claude connected to Masttro MCP: each type of missing data, sized by value, with the report it breaks

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

What to look for
1
Gaps by type

Missing country, sector, cost basis or quantity across every position.

2
Sized by value

Each type of gap weighted by the value affected.

3
What it breaks

The report or analysis each gap undermines.

Before you run it

Run as written. Use the follow-ups to list the positions to fix.

Ask next

Follow-up prompts

List every position with no country so I can fill them in.

Copy

Which gaps would change our geographic exposure the most?

Copy

Group the fixes by custodian.

Copy
Why it's useful

Why look for missing data before it shows up in a report?

A position with no country drops out of the geographic view. One with no cost basis breaks tax reporting. These gaps are invisible until a principal asks a question the report can't answer.

This prompt checks every position for the fields reporting depends on, sizes each gap and says what it affects, so the team fixes the ones that matter first.

01
Find gaps early

Before they surface in a client report.

02
Impact explained

Each gap tied to the report it breaks.

03
Organized fixes

Follow-ups group fixes by custodian.

FAQ

Questions about this prompt

Which fields are checked?

Country, sector, cost basis and quantity for every position, sized by market value.

Can it fill in the missing data?

No. The connection is read-only. It lists gaps so your team can complete them in Masttro.

Can I get a list of positions to fix?

Yes. The first follow-up lists every position with no country.

Can I group fixes by custodian?

Yes. The last follow-up groups them by custodian.

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