9 Claude prompts that write the investment policy statement, set the asset allocation, run the liquidity check, and rebalance: the portfolio manager work you'd usually pay an advisor $300 an hour for.
Never used Claude? It is free and takes 30 seconds to open. Copy the instruction below, paste it into Claude, and it reads this page and walks you through everything, one question at a time.
A short instruction plus a link to this page lands on your clipboard. First copy asks for your email once. That unlocks every button across the whole library.
Free account, no card, 30 seconds. This tab stays open so you can come back.
Open claude.ai ↗Claude reads this page, asks which computer you are on, then guides you step by step until it works. If anything errors, tell Claude what you see, and it fixes it with you.
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.Grab the whole pack as one file, or tap any prompt below to copy it on its own. Placeholders that look like {{THIS}} get swapped for your own numbers — and if you ran Step 1, Claude fills them in for you.
9 Claude prompts that write the investment policy statement, set the asset allocation, run the liquidity check, and rebalance: the portfolio manager work you'd usually pay an advisor $300 an hour for.
The setup rail and every prompt above are free and stay free. The cost is your time, and the risk of wiring it wrong on live data.
Back to the prompts ↑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 →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.
Want this wired into your stack instead of running it yourself? That is our AI deal desk and finance automation service.
The AI tools, launches, and shifts that actually matter, in plain English. New library drops the moment they land.
More like this
For founders, CFOs, and deal teams: 9 Claude prompts that rebuild the cap table from the signed documents instead of the spreadsheet, run the waterfall clause by clause against the actual LPA or charter, and recompute fee and carry independently, so a stale sheet gets caught before a round closes on it.
For CFOs and finance leaders: the map of seven finance desks, deal, diligence, close, tax, underwriting, family office, and market, each one a free prompt vault that runs inside your own Claude, plus the order to install them in so a team actually adopts them.
For CFOs and controllers: 11 Claude prompts that run the month end close reconciliation itself, match bank and subledgers both directions, catch the account that will not foot, and draft the flux memo, so a 6 day close lands in 2.
The person drowning in this every week is the one who'll actually want it.
AI Portfolio Manager Prompt Pack is a finance and data build in the consultance.ai AI Build Library. 9 Claude prompts that write the investment policy statement, set the asset allocation, run the liquidity check, and rebalance: the portfolio manager work you'd usually pay an advisor $300 an hour for. It fits advisors, portfolio managers, and finance leaders who want IPS-and-allocation work done with Level III rigor, on their own mandate, without a $300-an-hour outside analyst. Setup difficulty is Medium, with 4 plain-English steps.
9 Claude prompts that write the investment policy statement, set the asset allocation, run the liquidity check, and rebalance: the portfolio manager work you'd usually pay an advisor $300 an hour for.
It fits advisors, portfolio managers, and finance leaders who want IPS-and-allocation work done with Level III rigor, on their own mandate, without a $300-an-hour outside analyst.
Medium to set up — one guided setup instruction covering 4 plain-English steps, plus 9 ready-to-run prompts on the resource page.
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.
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.
AI Portfolio Manager Prompt Pack is the starting point. On a free AI audit we map where it fits your stack and what consultance.ai would build around it.
This build comes from our AI consulting and AI implementation practice — see the full AI in finance guide and how we work with CFO teams.