Home
cd ../playbooks
FinanceIntermediate

Financial Data Collector

Collect real financial data for any US public company from free sources (yfinance) into structured JSON — market data, historical financials, WACC inputs, and estimates — ready for DCF and comps.

10 minutes
By daymadeSource
#finance#data#yfinance#dcf#modeling

Financial models built on hand-typed numbers and silent fallback defaults overstate everything. This playbook collects validated data with mandatory source attribution and no fabricated values.

Who it's for: financial analysts, equity researchers, students, modelers

Example

"Collect the data I need to value AAPL" → A structured JSON with prices, financials, beta, and WACC inputs — every field tagged with its source or marked missing

CLAUDE.md Template

New here? 3-minute setup guide → | Already set up? Copy the template below.

Or install from your terminal:
npx ccplaybooks add financial-data-collector
# Financial Data Collector

Collect and validate real financial data for US public companies using free data sources.
Output is a standardized JSON file ready for consumption by other financial skills.

## Critical Constraints

**NO FALLBACK values.** If a field cannot be retrieved, set it to `null` with `_source: "missing"`.
Never substitute defaults (e.g., `beta or 1.0`). The downstream skill decides how to handle missing data.

**Data source attribution is mandatory.** Every data section must have a `_source` field.

Get new playbooks like this one

One email a week with new Claude Code workflows. Free, like everything here.

No spam. Unsubscribe anytime.

README.md

What This Does

Collect real financial data for any US public company from free sources (yfinance) into structured JSON — market data, historical financials, WACC inputs, and estimates — ready for DCF and comps.

What's Inside

The template covers:

  • Critical Constraints
  • Workflow
  • Output Schema (Summary)
  • Known yfinance Pitfalls

Quick Start

Step 1: Create a Project Folder

Make a dedicated folder for this workflow and open it in Claude Code.

Step 2: Download the Template

Click Download above to save the template, then drop it into your project as CLAUDE.md (or paste it into your existing one).

Step 3: Start Working

Tell Claude what you need in plain language — it will follow the template's workflow automatically. For example:

Collect the data I need to value AAPL

Claude reads the template and runs the steps for you.

$Related Playbooks

Finance

Financial Modeling Assistant

Build integrated financial models with 3-statement projections. Create income statement, balance sheet, and cash flow models with proper linkages.

10 minutes
Advanced
Finance

Financial Analyst Toolkit

Run DCF valuations, financial statement analysis, ratio analysis, comparable company analysis, budget variance reporting, and scenario modeling from your local data.

15 minutes
Advanced
Finance

Expense Report Auditor

Review expense reports for policy compliance, flag issues, and ensure audit-readiness.

10 minutes
Intermediate
Finance

Investment Memo Writer

Write professional investment memorandums for VC, PE, or public market investments. Structure thesis, risks, and recommendations clearly.

10 minutes
Advanced
Finance

Multi-Agent Financial Planner

Build a virtual financial advisory team with specialized agents for budgeting, retirement planning, and investment strategy that analyze your finances and create actionable plans.

15 minutes
Intermediate
Finance

Multi-Card Expense Tracker

Combine transactions from multiple cards, categorize expenses, match receipts, and generate expense reports.

10 minutes
Intermediate
Finance

Tax Prep Guide

A guided Q&A that assesses your tax situation and generates a personalized preparation plan with document checklists and workflow recommendations.

5 minutes
Beginner
Finance

Professional Tax Knowledge Agent

Create a searchable knowledge base from tax documents for reference during tax season.

15 minutes
Advanced
Finance

Stock Analysis & Research

Analyze stocks with fundamental and technical analysis. Supports US, China A-shares, and Hong Kong markets. Generate investment reports with key metrics.

10 minutes
Advanced
Finance

Risk Manager

Run financial risk assessments, portfolio risk analysis, Monte Carlo simulations, VaR calculations, stress testing, and risk register management from local data.

15 minutes
Advanced
Finance

Scientific Alpha Vantage

Access real-time and historical stock market data, forex rates, cryptocurrency prices, commodities, economic indicators, and 50+ technical indicators via the Alpha Vantage API. Use when fetching stock prices (OHLCV), company fundamentals (income s...

5 minutes
Beginner
Finance

Scientific Denario

Multiagent AI system for scientific research assistance that automates research workflows from data analysis to publication. This skill should be used when generating research ideas from datasets, developing research methodologies, executing compu...

10 minutes
Intermediate

Browse all Finance playbooks →