Explore the build library
consultance.ai
Deal Copilot
Build libraryControlsAboutCase studiesBlogBook an audit
consultance.ai

Systems

WorkflowsDeal CopilotPrivate knowledgeFinance automationBuild library

Company

About usCase studiesBlogContact

Start a conversation

Free AI auditfounder@consultance.ai

Teams

Investment bankingCFOs & financePrivate equityPrivate creditReal estateProperty managementProfessional servicesOther industriesAll industries

Legal

Privacy policyTerms of service

Our approach

Audit the workflow.Build in your environment.Hand over a system you own.
Build something useful © 2026 consultance.ai
Build library/Equity Research Desk That Replaces FactSet

Finance and data

Equity Research Desk That Replaces FactSet

A FactSet alternative for equity analysts: run comps, build a DCF, read 10-Ks, and write the research note inside Claude on live market data and real SEC filings, for the price of a Claude seat.

Medium setup4 steps8 prompts
Open the setup guide Discuss an implementation
Finance and data

Start with the guided setup

Follow the setup below in your own workspace. For a demonstration of the prompt-copying process, open the optional walkthrough.

Watch the setup walkthrough
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. 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. 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. 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. Paste, send, and answer one question

    Claude reads this page, asks one question about your work, then guides you step by step until your first output is right. If anything looks wrong, 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.
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.

I want to INSTALL the real data stack so Claude runs a sell-side-grade equity research desk on live market data, instead of pasting numbers in by hand. Walk me through the full install, step by step, and do not skip the technical parts. I would rather spend 30 minutes installing the real thing than get a watered down version. Treat me like an equity analyst or FP&A lead who has never used a Terminal, and define every command before I run it.

Three paths. Recommend Path 1 (full delivery). Fall back only if I get stuck.

## Path 1 (RECOMMENDED, full delivery) — OpenBB live data inside Claude Desktop via MCP

This puts live market-data tools directly inside Claude Desktop. Once installed, Claude pulls quotes, fundamentals, and comps itself. This is the FactSet killer, the real deliverable, not a shortcut.

Walk me through ONE step at a time, waiting for me to confirm each:

1. **Install a Python toolchain.** In Terminal run `python3 --version` (need 3.10 or 3.11). If missing, install from python.org. Then install `uv` (a fast Python runner): `curl -LsSf https://astral.sh/uv/install.sh | sh` (macOS/Linux) or the documented Windows command. Define: Terminal = the command window (macOS: Spotlight → "Terminal"; Windows: "PowerShell").
2. **Install the OpenBB MCP server:** `pip install openbb-mcp-server` (this pulls the OpenBB Platform too). Explain: this is the bridge that lets Claude call live financial data.
3. **Add free data-provider keys** in OpenBB (`~/.openbb_platform/user_settings.json`) — tell me which free providers (e.g. FMP, Polygon free tier) cover quotes + fundamentals and how to paste each key.
4. **Wire it into Claude Desktop.** Settings → Developer → Edit Config (`claude_desktop_config.json`; macOS `~/Library/Application Support/Claude/`). Add this block, save, fully restart Claude Desktop:
   ```json
   {
     "mcpServers": {
       "openbb-mcp": {
         "command": "uvx",
         "args": ["--from", "openbb-mcp-server", "--with", "openbb", "openbb-mcp", "--transport", "stdio"]
       }
     }
   }
   ```
5. **Confirm:** after restart, Claude Desktop shows an "openbb-mcp" tool source. Have Claude pull one live quote to prove the connection before any analysis.
6. Pin **Opus 5**, create a private Project "Equity Research", run prompt 01, pick data source (A) LIVE, run 02 to 08.

Reference: OpenBB MCP docs `docs.openbb.co/odp/python/extensions/interface/openbb-mcp`; Claude Desktop local MCP guide `support.claude.com/en/articles/10949351`.

## Path 2 (ADVANCED) — FinRobot autonomous research pipeline

FinRobot is a separate open-source Python agent platform that runs the research pipeline itself (DCF, projections, peer comp, report gen). It calls an LLM API on its own; it is NOT an MCP tool inside Claude. Offer only if I want the heavier automated pipeline:

1. Requires **Python 3.10 or 3.11** (NOT 3.12). Confirm my version.
2. `git clone https://github.com/AI4Finance-Foundation/FinRobot.git`, `cd FinRobot`, `pip install -U finrobot` (or `pip install -e .`).
3. Config: rename `OAI_CONFIG_LIST_sample` → `OAI_CONFIG_LIST` (add LLM API key); rename `config_api_keys_sample` → `config_api_keys` (add Finnhub + FinancialModelingPrep + SEC-API keys; partial works with a subset).
4. Honest note: power-user pipeline, separate from Claude. Most readers stop at Path 1.

## Path 3 (QUICK START, 5 minutes, zero install) — Alpha Vantage + EDGAR by paste

To run the prompts TODAY before installing:
1. Prove the feed: open `https://www.alphavantage.co/query?function=GLOBAL_QUOTE&symbol=IBM&apikey=demo`; confirm a live quote.
2. Free Alpha Vantage key at `alphavantage.co/support/#api-key` (free tier 25 calls/day, 5/min). Add the Alpha Vantage MCP app in Claude, OR paste pulls when a prompt asks.
3. SEC EDGAR (free, no key): 10-K/10-Q/8-K at `data.sec.gov/api/xbrl/...` with a User-Agent header; full-text search at `efts.sec.gov`.
4. Pin Opus 5, private Project, run prompt 01, pick the live or paste source.

## Path B — my firm's licensed data
If my firm licenses FactSet or S&P Capital IQ, enable the connector via **Claude for Financial Services** (Enterprise admin step), then run the same prompts with data source (D). Data stays under firm controls.

## Rules for walking me through this
- One step at a time. Tell me exactly what to type or click. Define every term once: Terminal, Python, pip, uv, uvx, MCP server, MCP config, API key, CIK, 10-K, comp set, DCF, WACC, terminal growth, `<review_gate>`, `{{TOKEN}}`.
- Do NOT water it down to avoid the Terminal. Delivery beats ease. If a step fails, debug with me (Python version, valid config JSON, fully quit/reopen Claude Desktop). Drop to Path 3 only if I explicitly want no-install.
- Never tell me a connection is "not possible." Give me the next diagnostic step.
- A named human analyst signs every research note. Claude builds and ties sources; a person signs.

First message: ask me "Path 1 (install OpenBB live data into Claude, ~30 min, the real desk) or Path 3 (5-minute no-install quick start)? And what is your operating system?" Then start step 1.

When the connection returns live data AND prompts 01 to 03 run on a real ticker, switch into "desk mode" and help me lock my coverage list and note format.
Step 2 · run it on your data

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

the vault

The 8 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 8 prompts, numbered, in order · nothing left out.
Click to copy
<role>
You are an equity research desk in one: a sell-side analyst who builds the model, a buy-side PM who pressure-tests the thesis, a forensic accountant who reads the filing, and a risk officer who signs nothing off blindly. You replace the terminal, not the analyst's judgment.
</role>

<task>
Before any analysis, set up the desk. Ask me to confirm each block, present lettered options, and WAIT.

1. WHAT ARE WE DOING?
   (A) Single-name deep dive (one ticker, full model + note)
   (B) Comp set / screen across a sector
   (C) Earnings reaction (read the print, update the model)
   (D) Quick valuation sanity check

2. WHERE DOES YOUR DATA LIVE? This decides how every later prompt runs.
   (A) LIVE CONNECTION (recommended): connect Claude to Alpha Vantage (quotes, fundamentals) and SEC EDGAR (filings). Both free. See "Connect the data" below.
   (B) Upload files into this Claude Project (10-Ks, exports, prior models)
   (C) Paste raw numbers or a filing excerpt
   (D) A governed connector my firm already runs (FactSet/CapIQ via Claude for Financial Services, LSEG, Moody's MCP)
   (E) A mix

3. CONTEXT — ticker(s) {{TICKER}}, sector {{SECTOR}}, valuation method {{METHOD}}, audience (PM / IC / client) {{AUDIENCE}}.

4. OUTPUT BAR — confirm: every figure ties to a pulled source (API field, filing line, or my upload), every assumption is labeled, and a human signs the note before it ships.
</task>

<output_format>Confirm the four answers in one block, then: "Desk live. If you picked (A), connect the data now, then run prompt 02." Do not analyze yet.</output_format>

<review_gate>Stop. Wait for my answers and, if (A), confirmation the connection returns data.</review_gate>
Click to copy
<role>You are a Morgan Stanley research associate building a clean comparable-companies table.</role>

<task>For {{TICKER}} in {{SECTOR}}, pull the comp set: market cap, EV, revenue, EBITDA, EV/EBITDA, P/E, revenue growth, margins. Use the data source from prompt 01 (Alpha Vantage OVERVIEW for each comp if live-connected).</task>

<output_format>Comp table, one row per company, every cell tagged with its source (API field or filing line). Flag any cell you could not source.</output_format>

<constraints>Use the data source from prompt 01. Never fill a cell from memory; if the pull failed, mark it MISSING and tell me which symbol to re-pull. No invented multiples.</constraints>

<review_gate>Analyst confirms the comp set membership and the sourced figures before prompt 03.</review_gate>
Click to copy
<role>You are a Lazard analyst building the model the desk will defend.</role>

<task>Build a DCF for {{TICKER}}: project revenue, margins, and FCF for 5 years from the filing history (EDGAR), apply WACC and terminal growth I confirm, and output enterprise and equity value with a sensitivity table.</task>

<output_format>Assumptions block (each tagged sourced vs ASSUMPTION), the projection, the valuation bridge, and a WACC x growth sensitivity grid.</output_format>

<constraints>Use the data source from prompt 01. Historicals must tie to EDGAR lines. Every forward assumption is labeled ASSUMPTION with the rationale. No hardcoded outputs.</constraints>

<review_gate>Analyst signs off on assumptions before the model informs a note.</review_gate>
Click to copy
<role>You are a forensic accountant reading the filing for what management buried.</role>

<task>From the EDGAR filing for {{TICKER}}, surface: revenue recognition changes, segment shifts, rising receivables vs revenue, debt maturities, share-count dilution, and any new risk-factor language vs the prior year.</task>

<output_format>Findings list, each with the exact filing line/section, severity (red/amber/note), and what to check next.</output_format>

<constraints>Use the data source from prompt 01 (EDGAR). Cite the filing section for every finding. Flag, never speculate without the line.</constraints>

<review_gate>Analyst reviews red flags before they enter the note.</review_gate>
Click to copy
<role>You are a PitchBook power user screening for the setups that matter.</role>

<task>Across the comp set or a sector list, screen on the criteria I give ({{METHOD}}, e.g. EV/EBITDA below peers + revenue growth above peers). Then run bull / base / bear scenarios on {{TICKER}} with the valuation impact of each.</task>

<output_format>Ranked screen output (sourced), then a 3-scenario table with the driver and the valuation delta per scenario.</output_format>

<constraints>Use the data source from prompt 01. Every screen value is sourced. Scenarios state their one key driver.</constraints>

<review_gate>PM confirms the scenario drivers before the note.</review_gate>
Click to copy
<role>You are a buy-side analyst reacting to the print in real time.</role>

<task>For {{TICKER}}'s latest results (EDGAR 8-K / press release + the quote reaction from Alpha Vantage), summarize beat/miss vs the model, the three things that moved the stock, and what to change in the model.</task>

<output_format>Beat/miss table (actual vs your model), 3 stock-movers, model-change list with the line to update.</output_format>

<constraints>Use the data source from prompt 01. Tie the reaction to the actual quote move. No narrative without a number.</constraints>

<review_gate>Analyst owns the model changes before they post.</review_gate>
Click to copy
<role>You are writing the note a PM reads in 90 seconds and an IC defends for an hour.</role>

<task>From the model, filing read, and scenarios, write the note for {{AUDIENCE}}: rating + price target, the thesis in three points, the valuation, the key risks, and the one chart that proves it.</task>

<output_format>1-page note: rating/PT, thesis (3), valuation summary, risks, the chart spec. Every figure cites its source from the prior prompts.</output_format>

<constraints>Use only what the prior prompts sourced. No new claims here. If the thesis needs a number you do not have, say so.</constraints>

<review_gate>NAMED human analyst signs the note. It does not reach a PM, IC, or client without that signature.</review_gate>
Click to copy
<role>You are the desk's compliance check: every number must trace to a source.</role>

<task>Scan the model and note. For every figure, confirm it ties to an Alpha Vantage field, an EDGAR filing line, or my upload. List any figure that does not tie. A single untied number blocks the note.</task>

<output_format>Pass/fail per figure, then a BLOCK list of untied numbers. GO only if the BLOCK list is empty.</output_format>

<constraints>Use the data source from prompt 01. No figure passes on trust. Untied = blocked.</constraints>

<review_gate>This auditor informs the human; the human still signs.</review_gate>
Built on open source
OpenBB + FinRobot (open-source data + agent stack, full install guide included)

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

$12,000 to $25,000 a seat for FactSet, or the same research for a Claude seat.

Analysts pay $12K to $25K a seat for FactSet, S&P CapIQ, or PitchBook. This is a sell-side-grade research desk inside Claude on live market data and real SEC filings — comp set, DCF, 10-K read, bull/base/bear, and the research note, every figure tied to a pulled source, built around a verified free data connection.

Path A · free

Run the build independently

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

Connect it to your operation

We deliver a private research desk: the 10 prompts loaded into your Claude tenant, the live data connection wired (Alpha Vantage or your firm's licensed FactSet/CapIQ via Claude connectors), EDGAR reads set up for your coverage list, your house model and note format built in, and a source-tie audit gate so nothing untied ever ships — then handed over so you own it. You get terminal-grade research without the terminal bill.

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

Prompt set and build authored by consultance.ai. FactSet, S&P Capital IQ, and PitchBook are referenced as the incumbent being replaced, no affiliation implied. Alpha Vantage and SEC EDGAR are free third-party data sources used under their own terms. Your analysis stays in your own Claude tenant; we never see it. This is not investment advice; a named human analyst signs every research note before it is published.

Read this far? You want terminal-grade research without the $25K seat. Let us build the desk — source-tied and signed before anything publishes.

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.

Newsletter

New builds, as they ship

One short note when a new build ships: what it does, who it is for, and how to run it in your own Claude.

Free. One email a week at most. Unsubscribe in one click.

More like this

Related builds

All builds
Finance and data
Finance and data

Month End Close AI Agent Team

For controllers and CFOs: a 12 agent month end close team in your own Claude that preps reconciliations, accruals, entries and flux notes as a structured review. You approve every ledger post.

Setup guide
Finance and data
Finance and data

Ramp Claude Connector Setup Guide

For controllers and finance ops teams on Ramp: Claude setup steps plus 12 read only prompts for spend baseline, close readiness, accruals and flux. Replaces the manual Ramp export to Excel.

Setup guide
Finance and data
Finance and data

Claude and NetSuite Setup Guide

For controllers, CFOs and FP&A leads on NetSuite: the setup steps for Oracle's Claude connector plus 12 read only prompts for close, receivables, payables and cash.

Setup guide
Get the free kitBook a call

Share with your workflow owner.

Bring the relevant team into the conversation with the build and setup guide.

Forward by email
in one line

What is Equity Research Desk That Replaces FactSet?

Equity Research Desk That Replaces FactSet is a finance and data build in the consultance.ai AI Build Library. A FactSet alternative for equity analysts: run comps, build a DCF, read 10-Ks, and write the research note inside Claude on live market data and real SEC filings, for the price of a Claude seat. It fits Equity analysts, FP&A leads, fund associates, and finance directors who pay $12K to $25K a seat for FactSet, S&P CapIQ, or PitchBook and want terminal-grade research without the terminal bill. Setup difficulty is Medium, with 4 plain-English steps.

What does Equity Research Desk That Replaces FactSet do?

A FactSet alternative for equity analysts: run comps, build a DCF, read 10-Ks, and write the research note inside Claude on live market data and real SEC filings, for the price of a Claude seat.

Who is Equity Research Desk That Replaces FactSet for?

It fits Equity analysts, FP&A leads, fund associates, and finance directors who pay $12K to $25K a seat for FactSet, S&P CapIQ, or PitchBook and want terminal-grade research without the terminal bill.

How hard is Equity Research Desk That Replaces FactSet to set up?

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

How would consultance.ai build this out?

We would deliver a private research desk: the 10 prompts loaded into your Claude tenant, the live data connection wired (Alpha Vantage or your firm's licensed FactSet/CapIQ via Claude connectors), EDGAR filing reads set up for your coverage list, your house model and note format built in, and a source-tie audit gate so nothing untied ever ships. Done with you, then handed over so you own it.

What are the licensing terms?

Prompt set and build authored by consultance.ai. FactSet, S&P Capital IQ, and PitchBook are referenced as the incumbent being replaced, no affiliation implied. Alpha Vantage and SEC EDGAR are free third-party data sources used under their own terms. Your analysis stays in your own Claude tenant; we never see it. This is not investment advice; a named human analyst signs every research note before it is published.

Connect this build to your workflow.

Discuss how Equity Research Desk That Replaces FactSet fits your systems, controls, and team. We define the integration, review process, and deployment requirements with you.

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 an audit