Click to copy
I am comfortable copy-pasting and following instructions, but I am not a developer.
There is nothing to install for this one and no commands to type: it all happens inside Claude. If any instruction below implies a Terminal, translate it into the equivalent click path for me instead.
- Plain English. Define jargon the first time it appears.
- One step at a time, then wait for me to confirm before the next one.
- Tell me what success looks like at each step, and diagnose any error before moving on.
Follow the instructions below with those rules applied.
If you can browse the web, open and read this page in full first, it has the complete guide and every prompt you will run (the vault is under the-vault anchor): https://consultance.ai/library/fund-nav-close-pack#the-vault . If you cannot open links, tell me and I will paste the page in, do not guess the prompts.
I want to set up the Fund NAV Close Pack so Claude runs the monthly close on my own fund books, and prices the book independently, not just a chat demo. Walk me through it one step at a time. Treat me like a fund controller or COO who has never built a Claude Project or used a terminal, and define every term once.
This is a HYBRID setup. Path 1 is a private Claude Project, with nothing to install. Path 2 is Claude Code on my own machine for the pricing engine (prompts 04, 05 and 17), which is a terminal install. Path 3, the Excel add-in, is optional. Tell me which path each step belongs to so I never guess.
## Path 1 (start here), a private Claude Project for the close
1. **What I need.** A Claude account. Files I load go to my own Claude account, never to consultance.ai. Before I load investor or position data, use a Team or Enterprise plan, or turn model training off. Select **Claude Opus 5.5** in the model picker. Nothing to install on this path.
2. **Create the workspace.** In Claude, create a new **Project** (a private workspace with its own files that other chats cannot see) named for the fund and the period. One Project per fund.
3. **Load the records.** Prime broker and custodian statements, the trade blotter, the GL or trial balance, the LP register, the fee terms from the LPA.
4. **Run prompt 01**, then **prompt 02**, the calibration run. Do not load fund data until prompt 02 prints MATCH on every line. If it prints MISMATCH, stop and tell me which figure.
5. **Run 03 to 16 in order**, or pick CONVERSATION mode in prompt 01 and run only what bears on my question. In chat, prompt 05 prices the book from inputs I paste, with the arithmetic shown.
## Path 2 (for the pricing engine), Claude Code on my machine
This IS a terminal install. A terminal is the text window where you type commands (on a Mac: Applications, Utilities, Terminal). Give me ONE command at a time, tell me what success looks like, and wait.
1. **Claude Code.** If `claude --version` does not print a version, install it with Anthropic's command for macOS, Linux or WSL:
`curl -fsSL https://claude.ai/install.sh | bash`
Success: `claude --version` prints a version. Windows users: follow https://code.claude.com/docs/en/setup instead.
2. **Python version check.** Run `python3 --version`, then `python3.13 --version`. The pricing library, FinancePy 1.1.2, works on Python 3.11 to 3.13 only. A stock Mac prints 3.9, a recent Homebrew can print 3.14, and 3.10 quietly installs an older FinancePy: all three fail. If none of `python3.13`, `python3.12` or `python3.11` prints a version, install Python 3.13 from https://www.python.org/downloads/ , then check `python3.13 --version`. Use whichever in range one you have below; the commands show 3.13.
3. **Make a folder** for the engine, open the terminal in it, and run `claude`. Select Claude Opus 5.5 with `/model`.
4. **Paste prompt 04.** Claude Code writes the files, creates the project venv (a private Python install for this folder only), and runs these for you, one at a time:
`python3.13 -m venv .venv`
`.venv/bin/pip install financepy`
`.venv/bin/pip show financepy`
`.venv/bin/pip install -U pytest`
`.venv/bin/python -m pytest -q`
Success: `pip show` prints `Version: 1.1.2`, the test passes and the anchor price prints 99.959620. The first import of FinancePy can take several seconds while it compiles; that is normal.
5. **Common errors.** "No matching distribution found for financepy", or `pip show` prints a version other than 1.1.2: wrong Python version, go back to step 2. "command not found: claude": re-open the terminal after the install. A price a few thousandths off the published one: the yield convention, see prompt 17.
6. **Run prompt 05** each month with the position file and the market inputs in `inputs/`.
## Path 3 (optional), Claude for Excel add-in
If I want the strike, reconciliation and fee schedule in real formulas:
1. Install it the way Anthropic documents it, and no other way: open the **Claude for Microsoft 365** listing on **Microsoft AppSource**, select **"Get it now"**, then open Excel, activate the add-in, and sign in with your Claude account. If your IT team deployed it for you instead, activate it from **Tools, Add-ins** on Mac or **Home, Add-ins** on Windows. It needs a Pro, Max, Team or Enterprise plan, and Excel on the web, Excel on Windows with Microsoft 365, or Excel on Mac 16.46 or later.
2. Anthropic's own guidance says the add-in is not recommended for audit critical calculations without verification, so prompts 11 and 12 still gate everything.
3. In prompt 01 choose data source (C) and ask for real formulas in prompts 06, 07 and 08.
## Rules for walking me through this
- One step at a time. Define once: Project, NAV, prime broker, custodian, administrator, IPV (independent price verification), venv, clean price, accrued interest, high water mark, waterfall, capital account, `{{TOKEN}}`, review gate.
- Do NOT tell me a step is "not possible". If the add-in is missing, try Excel on the web or AppSource. If the Python install fails, show me the exact error.
- This moves the labor of the close in house. It does not replace independent verification, the audit, or a named human signing the NAV. Not accounting or audit advice.
First session drill, after setup: run prompt 02 and show me the MATCH table; then prompt 05 on one month; a good output has a status and a source tier on every line and names any missing document. Check the aggregate difference against 0.10% of NAV before trusting it.
First message: ask me one thing only, "Is this a hedge fund with NAV per share, or a closed-end PE or VC vehicle with capital accounts?" Then start Path 1, step 1. Offer Path 2 when I reach prompt 04, and Path 3 only once Path 1 is standing.