Complete AI Training
Sign inGet my AI kit

Your job's AI kit

Get your AI kit

Tell us who you are and what you do. We show you your kit right away and email you the link: skills, prompts, AI agents, MCP servers and courses for your job.

500+ jobs ready, and we make a kit for any other job. No payment needed to look.

Share

AI agent for portfolio managers

Performance Attribution Reporting Agent

Tied-out attribution and draft commentary for each portfolio

Performance Attribution Reporting Agent: what goes in, what the agent does and what you get

What it does

Clients want to know why a portfolio beat or lagged its benchmark, and attribution that does not add up undermines the answer. After month-end, this agent runs performance attribution for each portfolio. It pulls returns, holdings and benchmark data, splits relative return into allocation, selection and currency effects, and lists the top and bottom contributors. It checks that the effects add up to the total relative return within a small residual and that portfolio returns match the official record. When they do not, it looks for missing trades, pricing differences or large cash flows and reruns. It drafts the commentary. The manager edits and approves it before it goes to clients. Edge case: a large client withdrawal mid-month distorts the return, so the agent uses the time-weighted figure.

How it works

Follow the arrows from top to bottom. The orange dashed arrow is the loop: when a check fails, the agent goes back and tries again.

Start and resultWhat it doesA check on its own workWaits for your OKGoes back and retries
Yes, continueApprovedNo 1 STARTS WHEN Month-end data final 2 USES A TOOL Pull returns, holdings and benchmark 3 DOES Run attribution by effect 4 CHECKS THE RESULT Do effects tie to relative return within residual? If not: find missing trades or pricing differences andrerun. Back to step 2. 5 DOES List top and bottom contributors 6 USES A TOOL Draft commentary 7 YOU APPROVE Manager approves commentary 8 RESULT Performance report ready for clients
Read the steps as a list
  1. Month-end data final
  2. Pull returns, holdings and benchmark
  3. Run attribution by effect
  4. Do effects tie to relative return within residual?If not: find missing trades or pricing differences and rerun. Back to step 2.
  5. List top and bottom contributors
  6. Draft commentary
  7. Manager approves commentaryThe agent waits here for your OK.
  8. Performance report ready for clients

How it decides

It accepts results only when effects sum to relative return within a small residual.

  • Residual over 5 basis points: investigate
  • Return differs from official record: use official, find cause
  • Cash flow over 10% of assets: check time weighting

Make it yours

Every agent is a starting point. You choose these settings for your own situation.

  • Attribution model
  • Residual threshold
  • Commentary length
  • Benchmarks used

What keeps you in control

It always asks you first

  • Releasing reports to clients

Hard limits

  • Never changes official returns
  • Never sends to clients

It stops when

  • Done: report approved
  • Stop: official returns not published

Set it up

We guide you through the set-up, step by step

Members get the full set-up guide for this agent. No technical skills needed: you copy, paste and upload.

10 minto set it up in your AI
5 AIsChatGPT, Claude, Copilot, Gemini, Grok
  • One set of instructions to paste into your AI, with the clicks for ChatGPT, Claude, Microsoft 365 Copilot, Gemini and Grok
  • The agent then walks you through connecting your own data, one source at a time
  • A downloadable copy with the flow chart, the rules and the full guide
Get access to this agent

An example run

What happensFor the March attribution of a US equity fund, the effects left a 22 basis point residual, above the 5 point limit. The agent found one bond priced from two different sources. After using the official price, the residual fell to 2 basis points. It drafted commentary showing health care selection added 40 basis points, and the manager approved it.

More agents for portfolio managers