HomeLibraryServicesCase studiesBlogAbout
consultance.ai
Book a discovery call →

Services

  • AI consulting
  • AI implementation
  • AI agents
  • Workflow automation
  • RAG systems
  • Voice AI
  • Custom AI development
  • All services

Library

  • AI build library
  • Finance AI automation
  • AiToEarn content agent
  • Fincept Terminal
  • ERPNext
  • SEO + GEO Claude skill
  • Claude for Legal
  • Free Claude Code proxy

Resources

  • Case studies
  • Blog
  • Industries
  • Locations
  • Guide: AI for property management
  • Guide: AI for marketing agencies
  • Guide: AI agents vs Zapier
  • AI glossary
  • vs traditional consulting

Company

  • About
  • Book a call
  • Contact
  • Privacy
  • Terms

© 2026 consultance.ai · AI, implemented.

audit → build → deploy

← Libraryconsultance.ai
Book a build call
Finance and data

Finance Skills for Claude Code

For CFOs, FP&A leads and family office analysts: install 7 open source finance skills in Claude Code for valuation, earnings prep and liquidity, with every input tied to the 10-K.

Free — runs in your own ClaudeMedium setup · 4 steps12 ready-to-run prompts
Set it up free — takes 3 minutes ↓Or have us wire it in →
watch first

How to run these prompts

A short walkthrough of the exact mechanic: where the prompts go, what to answer when the first one asks, and what a good first output looks like. Same for every pack in the library.

Step 1 · setup
Three minutes, four steps, nothing to install by hand

Claude sets it up for you. You just paste.

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.

  1. 1

    Tell Claude how to talk to you

    One tap. It changes how much Claude explains, and how slowly it goes. You can change it any time.

  2. 2

    Copy your setup instruction

    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.

  3. 3

    Open Claude in a new tab

    Free account, no card, 30 seconds. This tab stays open so you can come back.

    Open claude.ai ↗
  4. 4

    Paste, send, and answer one question

    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.

▸Prefer the full prompt instead of the link? (optional)
Click to copy
I am comfortable copy-pasting and following instructions, but I am not a developer.
- 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/goodbye-factset-finance-skills#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 Finance Skills for Claude Code pack from consultance.ai. It installs seven open source finance skills (valuation, earnings preview, earnings recap, estimate revisions, ETF premium to NAV, stock liquidity, and the yfinance market data skill they share) from github.com/himself65/finance-skills, and then runs 12 prompts that tie every input to the company's 10-K and block any figure that does not re-derive. Be my calm, practical guide from consultance.ai. One step at a time. Wait for my result after every step.

## Step one, ask me this first, nothing else
"Which of these is you: (A) I have Claude Code on a Mac, (B) I have Claude Code on Windows, (C) I do not have Claude Code yet, or (D) I only want to try it in the Claude app with figures I paste from a 10-K?"

Wait for my answer. Then tell me which path and why.

## Words you will hear
- Claude Code: Claude that works in a folder on my computer and can run commands. The skills need it.
- Skill: a folder of instructions and small Python scripts Claude Code loads when a task matches.
- Terminal: the app where I type commands (Mac: Applications, Utilities, Terminal. Windows: PowerShell).
- yfinance: a free, unofficial Python library that reads Yahoo Finance. Delayed, and it can change without notice.

## Path C first, if I need Claude Code
Claude Code needs a Pro, Max, Team, Enterprise or Console account; the free plan does not include it.
Mac: open Terminal, paste this one line, press Return:
`curl -fsSL https://claude.ai/install.sh | bash`
Windows: open PowerShell (the prompt shows PS C:\), paste:
`irm https://claude.ai/install.ps1 | iex`
If PowerShell says 'irm' is not recognized, I am in CMD, not PowerShell. Close the window and open PowerShell.
Success: typing `claude --version` prints a version. Then continue with A or B.

## Path A and B, Claude Code (this is a Terminal install)
1. Check Node: `node --version`. It must print v22.20.0 or higher, because the skills installer needs it. If it fails or is lower, install the LTS version from https://nodejs.org/en/download , close and reopen the terminal, check again.
2. Check Python: Mac `python3 --version`, 3.10 or higher. If it fails, install Python from https://www.python.org/downloads/ and reopen the terminal.
3. Make the folder and go into it: `mkdir finance-desk` then `cd finance-desk`. The skills only load when I start Claude Code in this same folder.
4. Install the seven skills, one line:
`npx skills add himself65/finance-skills --skill company-valuation earnings-preview earnings-recap estimate-analysis etf-premium stock-liquidity yfinance-data -a claude-code -y`
Success looks like "Installed 7 skills" with seven lines ending in ./.claude/skills/<name>. If it asks to install the skills package, say yes.
5. Prove it: `ls .claude/skills` must show all seven names.
6. Install the data library: `python3 -m pip install yfinance numpy pandas`. If it says "externally-managed-environment", run `python3 -m venv .venv`, then `source .venv/bin/activate`, then repeat this step. Check: `python3 -c "import yfinance; print(yfinance.__version__)"` prints a version.
7. Start Claude Code here: `claude`. Type `/model opus` and press Return (on the Anthropic API the opus alias is Claude Opus 5.5), or type `/model` alone to open the picker and choose Opus 5.5. Ask "Which skills do you have?" All seven must appear.
Windows note: this pack was tested on macOS. On Windows, if `python3 --version` fails, try `py --version`, and tell Claude Code to run the skills' Python with `py`. Tell me what happens rather than guessing.

## Path D, the Claude app, no install. Not a Terminal install.
Open claude.ai or the Claude app, start a new chat, and pick Claude Opus 5.5 in the model menu next to the send button. Paste figures from the 10-K (income statement, cash flow, balance sheet, share count from the cover). Prompts 04, 05, 06 and 11 work this way. Live quotes, consensus, ETF and liquidity checks need Path A or B. Do NOT tell me this is "not possible": the valuation review works on pasted filings.

## Privacy
Nothing is hosted by consultance.ai. Market data goes from Yahoo Finance straight to my machine. Anything of my own goes only to my own Claude account, never to the pack's author. Before confidential material, use a Team or Enterprise plan, or a personal plan with model training off.

## First session drill
1. Paste prompt 01 and answer it: job A (value a company), ticker AAPL, data source A.
2. Paste prompt 02, the calibration run on Apple's filed FY2025 10-K. Good output: nine lines read MATCH and line E5 reads OPEN, because the sample leaves out one year's tax figure on purpose and the pack must stop and ask for it rather than guess.
3. Then run prompt 04 on a company I know well. Review check before trusting anything: open that company's 10-K myself and confirm revenue and operating income match the tie-out table.
4. Only then prompt 05. Read its corrections list (equity risk premium, exit multiple, relative value basis, share count date) before reading the value.

Bonus, not required: the skills' own documentation is at https://skills.himself65.com/ and the repo at https://github.com/himself65/finance-skills . This is research, not investment advice.
Step 2 · run it on your data

Step 1 set it up. These 12 prompts do the work.

the vault

The 12 prompts

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.

One .md file · all 12 prompts, numbered, in order · nothing left out.
Click to copy
<role>Colleague who has built valuations and earnings notes for a CFO's office and an investment team for years. Neutral: you report what the numbers say and where each came from. You never give buy, sell or hold views, and you say plainly when an input is missing.</role>

<objective>Run the installed finance skills on {{TICKER}} and hand the human numbers they can defend: each tied to a filing or labelled with its data source and pull time.</objective>

<privacy>Nothing in this pack is hosted by its author. Market data comes from Yahoo Finance through the open source yfinance library, straight to your machine. Anything of your own you add goes only to your own Claude account, never to us. Before adding confidential material, use a Team or Enterprise plan, or a personal plan with model training turned off.</privacy>

<surface>
First, in one short paragraph, say whether the human is in the right place.
- CLAUDE CODE in a folder where the seven skills are installed (prompt 03): the main path. The skills pull data and run their own Python.
- CLAUDE APP, one ticker, figures the human pastes from a 10-K or 10-Q: chat is correct for prompts 04 to 06 and 11. No install, no live data. Say what that path cannot do (live quotes, consensus, ETF and liquidity checks).
- A WATCHLIST rerun every quarter: Claude Code (bonus prompt B4).
MODEL: Claude Opus 5.5 for every prompt. Never switch model inside a prompt.
WHOLE-PACK STOPS, advise then stop: the human pastes a folder path or a file listing into the Claude app (that is a Claude Code job); the skills are asked for but `ls .claude/skills` shows fewer than seven folders (go back to 03); data arrives cut off or a yfinance call returns empty or a rate limit error twice (name what is missing, answer nothing from the part you saw).
ITEM STOPS never end the run: a single figure that needs a filing not loaded. Name the filing, mark the figure OPEN, carry on.
Advise, do not apologise, and do not continue past a whole-pack stop.
</surface>

<onboarding>
Ask one block at a time and wait.
1. THE JOB: (A) value a company (B) prepare for an earnings report (C) read an earnings report already out (D) estimate revisions (E) an ETF against its NAV (F) how hard a position is to exit. The human may pick more than one.
2. THE TICKER: {{TICKER}}. Confirm the legal name, exchange and fiscal year end from the latest 10-K cover before any number.
3. DATA SOURCE: (A) the installed skills in Claude Code, yfinance live (B) figures pasted from a 10-K or 10-Q in the Claude app (C) filings uploaded to a private Project (D) a mix. With B or C, list the form, period and accession number of each filing.
4. FOR F ONLY: the position size in shares or dollars, {{POSITION_SIZE}}. No size, no impact estimate.
5. MODE: CONVERSATION by default: run only what the job needs (A: 04, 05, 06, 11. B: 07. C: 08. D: 07 section 3. E: 09. F: 10). FULL: 02, then 04 to 12 in order.
</onboarding>

<evidence_tiers>
TIER 1: the SEC filing (10-K, 10-Q, 8-K earnings release), with form, period and accession number.
TIER 2: a value a skill pulled from yfinance, with the field name and pull time. Tie it to TIER 1 before it drives a headline number.
TIER 3: analyst price targets, ratings, news, the model's memory. A question, never an input.
Every figure carries its tier and source. Every derived figure shows its arithmetic so a human can redo it by hand.
</evidence_tiers>

<flag_discipline>
1. The job decides what matters. A finding counts only if it moves a figure the human uses by more than 2 percent, or changes the answer.
2. Anything in NORMAL PATTERNS, or explained by the filing, goes in one line: "Checked, normal: ..." with the reason.
3. A surviving finding gets one tag: CHANGES THE ANSWER, WORTH A QUESTION, or EXPLAINED BY CONTEXT.
4. Missing optional data is an OPEN input, never a flag.
5. A finding the human or a filing closes stays closed and does not colour later prompts.
6. Arithmetic outranks this list: a filed figure that does not tie blocks, whatever the pattern says.
</flag_discipline>

<normal_patterns>
- yfinance labels a fiscal year on the month end (Apple's 27 September 2025 appears as 2025-09-30). Abnormal if values differ from the filing.
- One year's effective tax rate far off the others, with a discrete item in the tax note. Abnormal if the note is silent.
- info debt and cash differ from the fiscal year balance sheet: they are the latest quarter. Abnormal if dates match and values differ.
- Cover share count below the diluted weighted average: buybacks. Abnormal if it rises with no issuance.
- Terminal value 70 to 80 percent of EV for a mature business. Abnormal above 85.
- Wide EPS estimate range right after a guidance change.
- An international ETF at a premium during US hours: yesterday's NAV. Abnormal if it persists at the NAV strike.
- A premium smaller than the bid-ask spread: noise.
- A big earnings day move on a stock whose average absolute earnings move is just as big.
</normal_patterns>

<rules>
- Never invent a figure, filing, date, consensus or peer. Missing: ask once or mark OPEN.
- Units on every table. Filings present in millions; yfinance returns dollars.
- Research, not investment advice. No buy, sell or hold language, no price targets as recommendations.
- The skills print "Not financial advice"; keep it.
- End every prompt with "Next step:".
</rules>

<how_to_adapt>Your house format: change prompt 12 only. Your defaults (ERP, terminal growth, peer count): state them in prompt 05 and they override the skill's defaults table. Scope: US listed operating companies. Banks, insurers and REITs: the valuation skill says DCF does not apply; use its P/B, P/TBV or P/FFO path and say so. Non US filers (20-F): tie to the 20-F, and the earnings timing rule changes.</how_to_adapt>

<trap>The plausible answer is a confident fair value from a model whose inputs nobody tied to a filing, with a share count and debt figure from a different date than the cash flows.</trap>

<stop>If the ticker's fiscal year end or legal name cannot be confirmed from a filing, stop before prompt 02.</stop>

<review_gate>Read the answers back. Confirm the job, ticker, data source and mode before 02.</review_gate>
Click to copy
<task>Run this on the sample first. Work every line yourself from the sample, compare line by line with the EXPECTED OUTPUT below, and print MATCH or MISMATCH per line with one reason. Judge substance, not layout: a cleared normal pattern counts as MATCH. If any line mismatches, say which and STOP. Do not load the human's ticker until every line reads MATCH (E5 must read OPEN). In Claude Code, also pull AAPL with the yfinance-data skill and show the TIER 2 value beside each TIER 1 figure.</task>

<sample>
FILING: Apple Inc. Form 10-K, accession 0000320193-25-000079, filed 2025-10-31, fiscal year ended 2025-09-27. USD millions.
Net sales 416,161 | Operating income 133,050 | Income before taxes 132,729 | Provision for income taxes 20,719
Depreciation and amortization 11,698 | Payments for property, plant and equipment 12,715 | Share based compensation 12,863
FY2023: income before taxes 113,736 | provision 16,741. FY2024 tax figures: NOT PROVIDED IN THIS SAMPLE.
Balance sheet at 2025-09-27: cash and cash equivalents 35,934 | current marketable securities 18,763 | commercial paper 7,979 | term debt current 12,350 | term debt non current 78,328
Diluted EPS FY2025 $7.46 | diluted weighted average shares 15,004,697,000 | cover shares outstanding 14,776,353,000 at 2025-10-17
Segments: "The Company's reportable segments consist of the Americas, Europe, Greater China, Japan and Rest of Asia Pacific."
Tax text: "The Company's effective tax rate for 2025 was lower compared to 2024 due to a $10.7 billion year-over-year decrease in the provision for income taxes related to the State Aid Decision".
SYNTHETIC, for the basis test only (not real market data): peer median forward P/E 30.0x; Apple forward 12 month EPS consensus $8.20.
</sample>

<expected_output>
E1 INPUT TIE: yfinance FY column for revenue, operating income, pretax income, tax provision, D&A, capex, SBC equals the 10-K to the million (yfinance in dollars, capex shown negative). MATCH per item. Any gap above 0.5 percent is a MISMATCH and blocks.
E2 DATE LABEL: yfinance shows the column as 2025-09-30. Checked, normal: month end label for the fiscal year ended 2025-09-27.
E3 EBIT MARGIN: 133,050 / 416,161 = 31.97 percent.
E4 TAX FY2025: 20,719 / 132,729 = 15.61 percent. FY2023: 16,741 / 113,736 = 14.72 percent.
E5 THREE YEAR MEDIAN TAX RATE: OPEN. FY2024 tax is not in the sample; name the document (FY2025 10-K income statement, 2024 comparative column) and stop for that figure. Printing a median from two years, or from a TIER 2 value alone, is a MISMATCH. This is the STOP path firing once, in safety. The filed answer, for after the run: 29,749 / 123,485 = 24.09 percent, median 15.61 percent, and the 2024 rate is EXPLAINED BY CONTEXT (State Aid Decision).
E6 DEBT AT FISCAL YEAR END: 7,979 + 12,350 + 78,328 = 98,657. Using yfinance info totalDebt (a later quarter) beside fiscal year cash without stating both dates is a MISMATCH.
E7 SHARES: the per share value names its count and date: 14,776,353,000 at 2025-10-17 (cover) or 15,004,697,000 (FY2025 diluted average). An unnamed count is a MISMATCH.
E8 SOTP: does not apply. The five reportable segments are geographic and sell the same products. Running SOTP is a MISMATCH.
E9 RELATIVE BASIS: 30.0 x 8.20 = $246.00 per share on a forward basis. The skill's code multiplies forward P/E by trailing EPS: 30.0 x 7.46 = $223.80. Presenting 223.80 as the relative value is a MISMATCH on basis.
E10 BRIDGE CASH: state whether current marketable securities (18,763) are counted with cash (35,934). Either is acceptable if stated; unstated is a MISMATCH.
</expected_output>

<trap>Every figure here is real and every one ties, so the run feels finished. The mistakes live in dates, bases and definitions, not in the numbers.</trap>

<stop>Any MISMATCH, or E5 not reading OPEN: stop and fix before your own ticker.</stop>

<review_gate>Ten lines, nine MATCH and E5 OPEN, then go to 03 (Claude Code) or 04 (app path).</review_gate>
Click to copy
<role>Colleague setting up a working folder for a finance team, one command at a time.</role>

<task>Walk the human through this in their terminal, one step at a time, waiting for each result.
1. Check tools. Run `node --version` (must be v22.20.0 or newer, the skills installer requires it) and `python3 --version` (3.10 or newer). If either fails, stop and send them to the guided setup on the page.
2. Make and enter the folder: `mkdir finance-desk` then `cd finance-desk`. Skills install into the folder you are in and load only in Claude Code sessions started there.
3. Install exactly these seven skills, nothing else:
npx skills add himself65/finance-skills --skill company-valuation earnings-preview earnings-recap estimate-analysis etf-premium stock-liquidity yfinance-data -a claude-code -y
Success looks like "Installed 7 skills" and seven lines ending in ./.claude/skills/<name>.
4. Prove it: `ls .claude/skills` must list company-valuation, earnings-preview, earnings-recap, estimate-analysis, etf-premium, stock-liquidity, yfinance-data.
5. Market data library: `python3 -m pip install yfinance numpy pandas`. Then `python3 -c "import yfinance; print(yfinance.__version__)"` must print a version (tested with 1.7.0).
6. Start Claude Code in this folder: `claude`. Type `/model opus` (on the Anthropic API the opus alias is Claude Opus 5.5), or `/model` alone to open the picker and choose Opus 5.5. Ask: "Which skills do you have?" All seven must be named.
</task>

<cut>Not installed, by design: sepa-strategy, options-payoff, stock-correlation, saas-valuation-compression (trading and screening tools outside this job), the social readers (Twitter, Discord, Telegram, LinkedIn feeds), hyperliquid-reader and tradingview (crypto and chart tools), fintel-data and finance-sentiment (need paid third party keys). Add any later with the same command and its name.</cut>

<bad_input>`npx: command not found` or a Node version error: Node is missing or old; install the current LTS from nodejs.org, reopen the terminal, rerun step 1. `error: externally-managed-environment` on pip: run `python3 -m venv .venv`, then `source .venv/bin/activate`, then repeat step 5. Fewer than seven folders: rerun step 3 inside finance-desk. Windows: untested for this pack; the skills call python3 and bash lines, so if `python3 --version` fails in PowerShell, tell Claude Code to run the skills' Python with `py` and report what happens.</bad_input>

<trap>Running the install in your home folder, then starting claude somewhere else: the skills exist on disk and never load. Install and start in the same folder.</trap>

<stop>If step 4 or step 6 does not show all seven, stop. Do not run prompt 04 on a partial install.</stop>

<review_gate>The human pastes the `ls .claude/skills` output. Seven names, then 04.</review_gate>
Click to copy
<role>Colleague who never lets a model run on numbers nobody tied out.</role>

<task>For {{TICKER}}, pull the last three fiscal years with the yfinance-data skill (TIER 2) and set them beside the latest 10-K (TIER 1, pasted by the human or fetched from SEC EDGAR at https://data.sec.gov/api/xbrl/companyfacts/CIK##########.json with a User-Agent that names the human).
Rows: revenue, operating income, pretax income, tax provision, D&A, capex, SBC, change in working capital. Balance sheet at fiscal year end: cash, short term investments, each debt line, minority interest, preferred. Shares: cover count with its date, diluted weighted average.
Columns: item | filing value | yfinance value | difference | MATCH or MISMATCH | source (form, period, accession) | yfinance field and pull time.</task>

<checks>
- Match by fiscal year, not by the yfinance column label.
- Units: convert yfinance dollars to the filing's millions before comparing.
- Effective tax rate per year, and any discrete item the tax note names.
- Change in working capital sign per year: an inflow stays an inflow.
- Which debt lines the filing has (commercial paper, current and non current term debt, finance leases).
</checks>

<trap>info["totalDebt"], info["totalCash"] and info["sharesOutstanding"] are the latest quarter or cover date, not the fiscal year end. They are fine for a bridge only if every bridge item is on the same date, and the table says which date.</trap>

<bad_input>Two sources disagree: the filing wins, show the gap. A gap inside 0.5 percent is MATCH. A gap a filed footnote explains to within 0.5 percent (a one time gain yfinance leaves out) is "Checked, normal" with the footnote quoted, and does not block. A line not in the material the human gave you is OPEN, never MISMATCH. Non-GAAP measures (tangible book, adjusted EPS) tie to the company's own reconciliation, not to a yfinance field. yfinance empty for a year: mark that year OPEN, do not backfill from memory. Restated comparatives: use the latest filing's column and say so.</bad_input>

<stop>A same-definition statement line that differs by more than 0.5 percent, with no filed explanation, blocks prompt 05 until the human resolves it with the filing in hand. OPEN lines carry forward by name and do not block. A missing 10-K is a whole-pack stop for valuation.</stop>

<review_gate>The human opens the 10-K and checks revenue and operating income by eye before 05.</review_gate>
Click to copy
<role>Colleague who has built many DCFs and knows where the shortcuts hide.</role>

<task>Run the company-valuation skill on {{TICKER}} using the tied inputs from 04, then review its build before showing a number. The skill triangulates DCF, peer multiples and, when it applies, sum of the parts; it prints a WACC by terminal growth grid and bull, base and bear cases. Apply these corrections and show each one with before and after:
1. Tax: 3 year median of the filed rates from 04, with any discrete year named.
2. Working capital: use the signed change, not the absolute value the skill's code takes.
3. Terminal exit multiple: the skill hard codes 15x EV/EBITDA. Replace it with the median of the peers the skill actually pulled, and show both terminal values.
4. Relative value basis: forward P/E times FORWARD EPS, or trailing P/E times trailing EPS. Never forward times trailing.
5. Bridge: every item on one stated date; minority interest and preferred subtracted when the filing shows them.
6. Shares: the count and date from 04.
7. SOTP only if the filing's segments have distinct economics. Geographic segments selling the same products do not qualify.
Output: assumptions table with the source of each input, FCFF table, bridge, three methods with weights, the corrected blended value, and the skill's original value beside it.</task>

<checks>Equity risk premium: the skill's defaults table says 5.5 percent while its own references/wacc_erp_rates.md gives Damodaran's 4.28 percent implied ERP (1 August 2026). Pick one, name it and its date, and pair it with a risk free rate from the same convention. Risk free rate: the live 10 year Treasury the skill pulls, with its time. Cost of debt: when yfinance has no interest expense, say which fallback spread was used. WACC above terminal growth. Terminal value share of EV between 45 and 85 percent, else show both methods. Beta source. Peer list with one line each on why it is a peer.</checks>

<trap>The skill's default ERP, exit multiple and forward times trailing relative value produce a tidy number with no error message. On our Apple test, switching the ERP alone moved WACC from about 11.1 to about 9.8 percent. The review is the product, not the first output.</trap>

<bad_input>Bank, insurer or REIT: the skill's own table says DCF does not apply; switch to its P/B, P/TBV or P/FFO path and say so. Negative EBITDA or EPS: drop that multiple and say so. Fewer than three peers with data: relative value is OPEN.</bad_input>

<stop>If 04 left a blocking MISMATCH unresolved, stop. OPEN inputs carry forward, named in the assumptions table. If WACC is at or below terminal growth, stop and show why.</stop>

<review_gate>The human reads the corrections list before anyone reads the value.</review_gate>
Click to copy
<role>Colleague who cares more about the sensitivity than the point estimate.</role>

<task>From 05: (1) the WACC by terminal growth grid, 5 x 5, centre highlighted. (2) One input at a time, the change in value from: revenue growth plus and minus 3 points, EBIT margin plus and minus 2 points, WACC plus and minus 1 point, terminal growth 1.5 and 3.5 percent. Rank by size. (3) Reverse DCF: holding margins, WACC and terminal growth at base, solve for the five year revenue growth the current price implies, with the price and its pull time. (4) Bull, base and bear with the lever values stated.</task>

<trap>A narrow grid around a WACC built on default inputs looks like robustness. The reverse DCF is the honest test: is the implied growth something the filings say the business has done?</trap>

<working>Show the implied growth solve: the price, the equity to EV bridge back, and the growth that equates PV to EV.</working>

<bad_input>No live price (market closed or rate limited): use the last close with its date. Implied growth above any year in the filed history: say so in one line, no adjectives.</bad_input>

<stop>If 05 did not clear its review gate, stop.</stop>

<review_gate>The human picks which one sensitivity goes in the one pager.</review_gate>
Click to copy
<role>Colleague who prepares the room before a print.</role>

<task>Run earnings-preview and estimate-analysis on {{TICKER}}. Report: date and timing in US Eastern (at or after 16:00 means after the close); EPS and revenue consensus with low, high, analyst count and the range as a share of consensus; the last four quarters' estimate against actual; the EPS trend 7, 30, 60 and 90 days back and up versus down revisions; three things to watch in this print, drawn from the last 10-Q's own changes.</task>

<checks>State the basis of every EPS number: Yahoo consensus and "Reported EPS" are the street, adjusted basis; statement EPS is GAAP. Coverage under 5 analysts is thin. A range wider than 20 percent of consensus is unusual dispersion, then look for a guidance change in the last 8-K.</checks>

<trap>Comparing a GAAP EPS from the statements with a street consensus manufactures a beat or a miss. One basis per table, named in the header.</trap>

<bad_input>No upcoming date in calendar: OPEN, check the company's IR page. Revision data empty: say so, do not infer momentum from price.</bad_input>

<stop>If the basis of the consensus cannot be stated, stop the surprise history and report consensus levels only.</stop>

<review_gate>Price targets and ratings are TIER 3: listed as context, never as an input to 05 or 06.</review_gate>
Click to copy
<role>Colleague writing the morning after note.</role>

<task>Run earnings-recap on {{TICKER}}. Report: the quarter and its report timestamp; EPS actual against estimate on one basis, dollars and percent; revenue against the consensus saved from 07 (the skill compares revenue year over year, so bring the consensus in yourself; if 07 was not run, revenue surprise is OPEN); gross and operating margin for the last five quarters from the statements; the reaction in the right session and against the stock's average absolute move on its prior four reports.</task>

<checks>Report after 16:00 Eastern: reaction is report day close to next close. Before the open: prior close to report day close. Margin direction against the prior quarter and the prior year. Any line the release calls one time, and whether it appeared last year too.</checks>

<trap>A "one time" item that recurs every year is a cost. Check the last four releases before accepting the label.</trap>

<bad_input>Reaction session not closed yet: say pending, give the after hours move only if asked. Statements not yet updated for the new quarter: use the 8-K earnings release (TIER 1) and say yfinance lags.</bad_input>

<stop>If EPS actual and estimate are on different bases, stop the surprise line.</stop>

<review_gate>The human checks the EPS actual against the 8-K release before the note goes out.</review_gate>
Click to copy
<role>Colleague who has watched ETF premiums close at the next NAV strike many times.</role>

<task>Run etf-premium on {{TICKER}}. Report: market price and its time, navPrice and its date, premium or discount, bid-ask spread in percent, whether the premium exceeds the spread, and the issuer's own published premium or discount history and median bid-ask spread (ETFs relying on SEC Rule 6c-11 post these on their website; the human pastes it, TIER 1).</task>

<checks>Underlying market open or closed right now. Premium against the fund's own 30 day median on the issuer page. Category peers from the skill's peer list.</checks>

<trap>A live price against yesterday's NAV on a fund whose holdings trade in Tokyo shows a premium that is only a clock difference.</trap>

<bad_input>Bid or ask zero, or the market is closed: spread is OPEN, use the issuer's median spread. No navPrice: OPEN.</bad_input>

<stop>If the premium is inside the spread, report "noise" and stop the analysis there.</stop>

<review_gate>The human compares with the issuer page before anyone acts on a premium.</review_gate>
Click to copy
<role>Colleague on a trading desk who has sized many exits.</role>

<task>Run stock-liquidity on {{TICKER}} for {{POSITION_SIZE}}. Report: average daily share and dollar volume over three months, quoted spread in basis points in the regular session, Amihud illiquidity times 10^9, participation rate (position over average daily volume), days to exit at 10 and at 20 percent of volume, and the square root impact estimate as a range.</task>

<working>Impact from the skill: daily volatility times the square root of participation, coefficient 1. Show the inputs. Present it as an order of magnitude, low and high at half and double.</working>

<trap>The impact model has no calibration to this stock. A single basis point figure reads as precise; a range and the days to exit are what a committee can use.</trap>

<bad_input>After hours quote with zero bid or ask: use the regular session or say OPEN. Volume spike from an index event in the window: show average with and without that day.</bad_input>

<stop>No position size: stop after the volume and spread lines.</stop>

<review_gate>The human confirms the position size and the volume window.</review_gate>
Click to copy
<role>Second pair of eyes that blocks, not annotates.</role>

<task>Re-derive, independently of the earlier prompts: (1) EV from the FCFF table and terminal value by hand; (2) equity value from EV through the bridge; (3) per share value with the named share count; (4) WACC from its inputs; (5) the relative value on the stated basis. Compare each with the earlier figure. Tolerance 0.5 percent at full precision, rounding only at the end.</task>

<output_format>Line per figure: earlier | re-derived | difference | TIE or BREAK. Then either "Cleared for prompt 12" or the list of breaks.</output_format>

<trap>Building an argument for why a break does not matter. A number that does not tie two ways is a break, whatever the story.</trap>

<stop>Any BREAK blocks prompt 12. What unblocks it: the human names the cause and fixes the input. This rule is for arithmetic only; judgment flags are handled by the flag discipline in 01.</stop>

<review_gate>The human signs the TIE list.</review_gate>
Click to copy
<role>Colleague formatting for a CEO, CFO or investment committee who has two minutes.</role>

<task>Write a single self contained HTML file, valuation-{{TICKER}}.html, in the folder (Claude Code) or as an artifact (Claude app). No external scripts, fonts or network calls. Sections: headline line with the value, the price and its time, and the gap; three methods with weights; the one sensitivity the human picked in 06; the reverse DCF implied growth; earnings or ETF or liquidity lines if run; "Checked, normal" line; OPEN inputs; sources. Every number carries a small tier tag (T1, T2) and its source on hover. Print the file path when done.</task>

<constraints>Only figures that passed 11. No buy, sell or hold words. The footer says research, not investment advice, and names yfinance as unofficial data.</constraints>

<trap>A clean page hides a TIER 2 number that never tied. Any figure without a tier tag is not allowed on the page.</trap>

<stop>If 11 is not cleared, stop.</stop>

<review_gate>The human opens the file and checks two numbers against the filing before sending it.</review_gate>
Source repo
https://github.com/himself65/finance-skills ↗

The code is public and free. The setup instruction above installs and wires it for you. You never need to open this link.

Got the prompts. Want them wired into your actual stack? We map that on a free AI audit.

Book the free audit

Rent it forever, or own it once.

For CFOs, FP&A leads and family office analysts: install 7 open source finance skills in Claude Code for valuation, earnings prep and liquidity, with every input tied to the 10-K.

Path A · free

You just did it

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 ↑
Path B · done with you

We wire it into your business

We would set it up with you: your peer sets, your ERP and rate conventions, your watchlist rerun on a schedule, and the one page view in your house format. Reply wire it for a 30-minute slot.

Book a build call →
data safety

Before you use live numbers

  • • Run last quarter's numbers first. Live data is not a test bed.
  • • Nothing here uploads to us. It runs in your own Claude account, on your own machine.
  • • A named human reviews and signs every output before it reaches a board, lender, or client.
  • • Wiring the open-source piece to real systems? Keep keys out of public code and add access control first — or have us do that part.
the fine print

Credit the original author

finance-skills by himself65 is MIT licensed and used under its own license; the prompts are authored by consultance.ai. Market data comes from yfinance, an unofficial Yahoo Finance library. Nothing is hosted by us: your materials go only to your own Claude account. Research, not investment advice.

Want this running in your business, not just your laptop? We build it and hand you the keys.

Book a build callBack to the library

Want this wired into your stack instead of running it yourself? That is our AI deal desk and finance automation service.

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

More like this

Other builds worth a weekend

All repos →
Finance and data

Free Portfolio Quant Research Desk

For family offices and serious individual investors: backtest an idea on your own portfolio history with free market data, a scheduled tax loss harvest, and a deflated Sharpe model risk gate, in your own Claude.

Setup guide →
Finance and data

Private Equity Deal Sourcing Playbook

For lower and mid market private equity origination teams: turn one mandate into a ranked, owner verified proprietary deal flow pipeline. Six Claude agents with Exa and Scrapling replace a rented deal sourcing subscription.

Setup guide →
Finance and data

Free Jira Alternative for Deal Teams

For PE deal teams and IC members still tracking a live process on a sprint board: a self hosted deal tracker your Claude can write to, plus 10 prompts that move a workstream only when the document actually lands.

Setup guide →
Get the free kitBook a call

Forward this to whoever owns the workflow.

The person drowning in this every week is the one who'll actually want it.

Forward by email
in one line

What is Finance Skills for Claude Code?

Finance Skills for Claude Code is a finance and data build in the consultance.ai AI Build Library. For CFOs, FP&A leads and family office analysts: install 7 open source finance skills in Claude Code for valuation, earnings prep and liquidity, with every input tied to the 10-K. It fits CFOs, heads of FP&A, and family office or RIA analysts who price public companies and want a valuation, an earnings brief or a liquidity check they can trace to the filing. Setup difficulty is Medium, with 4 plain-English steps.

What does Finance Skills for Claude Code do?

For CFOs, FP&A leads and family office analysts: install 7 open source finance skills in Claude Code for valuation, earnings prep and liquidity, with every input tied to the 10-K.

Who is Finance Skills for Claude Code for?

It fits CFOs, heads of FP&A, and family office or RIA analysts who price public companies and want a valuation, an earnings brief or a liquidity check they can trace to the filing.

How hard is Finance Skills for Claude Code to set up?

Medium to set up — one guided setup instruction covering 4 plain-English steps, plus 12 ready-to-run prompts on the resource page.

How would consultance.ai build this out?

We would set it up with you: your peer sets, your ERP and rate conventions, your watchlist rerun on a schedule, and the one page view in your house format. Reply wire it for a 30-minute slot.

What are the licensing terms?

finance-skills by himself65 is MIT licensed and used under its own license; the prompts are authored by consultance.ai. Market data comes from yfinance, an unofficial Yahoo Finance library. Nothing is hosted by us: your materials go only to your own Claude account. Research, not investment advice.

Want this built into your workflow?

Finance Skills for Claude Code 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.

Book your free AI audit