Finance and data
CFA Level III AI Test
Real investment judgment built inside Claude on your own mandate, for the price of a Claude seat instead of a $300-an-hour portfolio manager. 9 prompts write the policy statement, set the strategic allocation, run the liquidity and constraint check that breaks most allocations, rebalance with the tax lots in mind, decide the currency hedge, screen the brief for behavioral bias, tie every number out, and draft the client-ready memo. Not definitions. The calls a Level III essay demands.
Rent it forever, or own it once.
Real investment judgment built inside Claude on your own mandate, for the price of a Claude seat instead of a $300-an-hour portfolio manager
Path A
Set it up yourself
The setup prompt and 9 task prompts are below — free. The cost is your time, and the risk of wiring it wrong on live data.
Jump to the prompts ↓Path B
We wire it into your business
We would deliver a private mandate workspace: the 9 prompts loaded into your Claude tenant, your capital-market assumptions and house view wired in, the IPS and memo built to your firm's format, and an advisor review gate so nothing reaches a client unchecked. Done with you, then handed over so you own it.
Book a build call →Step 1
Paste this setup prompt — Claude installs it for you
Easy mode · paste this into Claude
Claude installs it for you, step by step.
Never used Claude before? It is free to start. Open it in a new tab, copy the prompt, paste it in. It asks one question, then walks you through everything.
- Step 1Open claude.ai ↗
Sign up free. No card. Takes 30 seconds.
- Step 2
One click. Lands on your clipboard.
- Step 3Paste + send
Claude asks what you need + guides you the rest of the way.
▸Tune the prompt for your level (optional)
▸Preview the prompt (you do not need to read it)
I want to INSTALL the real setup so Claude runs the policy statement, allocation, and rebalance on my actual mandate, not just a chat demo. Walk me through it step by step, do not skip the install. Treat me like an advisor or PM who has never built a Claude Project or installed an Office add-in, and define every term once.
This is NOT a Terminal or coding install. There is nothing to compile. It is two paths: a Claude Project for the client documents (recommended) and an optional Excel add-in for the allocation and rebalance math.
## Path 1 (RECOMMENDED) — a private Claude Project for the mandate
This is where the client brief, holdings, and statements live so every prompt reads from one governed place.
Walk me through ONE step at a time, waiting for me to confirm each:
1. **What I need.** A Claude account. Pin **Opus 4.8**. Nothing to install for this path.
2. **Create the mandate workspace.** In Claude, create a new **Project** named for the client or model. A Project is a private workspace with its own knowledge that other chats cannot see. Your client data stays in your own tenant.
3. **Load the data.** Drop the client brief, current holdings with tax lots, and statements into the Project knowledge. Strip names to initials if you want an extra layer of privacy.
4. **Run the vault.** Run prompt 01, pick the mandate type and data source (A) upload. Run 02 to 09 in order: IPS, strategic allocation, liquidity and constraint check, tax-aware rebalance, currency hedge, behavioral screen, the tie-out, the client memo.
5. **Gate it.** Run prompt 08 (reconciliation self-check) before the memo. Weights must sum, the expected return must tie to the required return, every constraint must read PASS. Any FAIL is a number to fix.
6. A named licensed advisor signs before anything reaches the client. This is a working tool, not investment advice.
## Path 2 (OPTIONAL) — Claude for Excel add-in for the allocation math
If I want the allocation and rebalance to live in real formulas:
1. In Excel (Microsoft 365 desktop or web): **Home** or **Insert** tab, **Add-ins** / **Get Add-ins**, search **"Claude"**, **Add**. Tell me where the button is in my version.
2. Sign in to the docked Claude side panel.
3. In vault prompt 01 choose data source (C) Excel add-in. For prompt 03 (allocation) and prompt 05 (rebalance) say "build this into my workbook as real formulas," so weights, expected return, and the trade list recompute and the tie-out in prompt 08 runs on live cells.
4. Pin **Opus 4.8** for the IPS, allocation, and memo.
## Rules for walking me through this
- One step at a time. Define every term once: Project, knowledge, IPS, binding constraint, capital-market assumption, hedge ratio, tax lot, wash sale, `<review_gate>`, `{{TOKEN}}`.
- Do NOT tell me a step is "not possible." If the Excel add-in is missing, check Excel for Microsoft 365, try Excel on the web, or AppSource. For the Project path there is nothing to install.
- Never paste live client PII into a public Claude window outside a Project. Use a Project with your tenant controls.
- A named licensed human signs the advice. Claude does the analysis and the tie-out; a person owns the recommendation.
First message: ask me "Path 1 (Claude Project for the mandate, recommended) and do you also want Path 2 (Excel add-in for the allocation math)? And what mandate type is this: individual, foundation, pension, insurance, or model portfolio?" Then start step 1.Step 2
Step 1 installed it. Now run these 9 prompts on your own data.
the vault
The 9 prompts
Tap a prompt to jump to it. Hit copy. Replace the tokens. Paste into Claude Opus 4.7.
where it breaks
Before you connect live data
- • Run dummy data first. Real client data is not a test bed.
- • API keys never go in a public repo. Use env vars and a secrets manager.
- • Add logging, access control, monitoring, and a rollback path before launch.
- • Read the license. Forking a repo without checking is how lawsuits start.
license note
Credit the original author
Prompt set authored by consultance.ai. The CFA Program is referenced as the standard of rigor the pack matches; no affiliation with or endorsement by CFA Institute is implied. Your client data stays in your own Claude tenant; we never see it. This is not investment advice; a named licensed human signs every recommendation before it reaches a client.
the newsletter
AI news worth opening.
The AI tools, launches, and shifts that actually matter, in plain English. New library drops the moment they land.
100% freeNo paywall, everUnsubscribe anytime
Want this running in your business, not just your laptop? We build it and hand you the keys.
More like this
Other builds worth a weekend
Finance and data
Setup guide →Fincept Terminal
Kill your Bloomberg envy with a free download. Live stocks, bonds, crypto, and 37 AI agents that pick like Buffett, Munger, and Lynch.
Finance and data
Setup guide →Finance Reporting Pack — Claude vs the BI stack
AI now builds financial reporting that rivals JPMorgan analysts, packaged as 12 prompts your finance team runs on its own data. Board P&L packs, 3-statement models, variance commentary, KPI scorecards, cash forecasts, and consolidations, for the price of a Claude seat instead of Power BI plus Tableau plus a BI hire. Plus a live Reporting Stack Spend Calculator.
Finance and data
Setup guide →Firefly CFO Trust Ladder
No CFO trusts AI with company books on day one. Firefly III plus Claude is the trust ladder. Personal books first. Real reps. Then the company.