build-model

Create end-to-end Excel financial models from a single ticker input.

482|113|Updated Feb 17, 2026
One-click install
npx skills add https://github.com/daloopa/investing --skill build-model
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: build-model
Source: https://github.com/daloopa/investing/tree/main/.claude/skills/build-model
Command: npx skills add https://github.com/daloopa/investing --skill build-model

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill automates the creation of end-to-end Excel financial models from a single ticker input, consolidating data gathering, modeling, and reporting into a single workflow.

Core Features & Use Cases

  • Gather company financials by ticker (income statement, balance sheet, cash flow) and populate a multi-tab Excel workbook.
  • Include projections, KPIs, and DCF inputs, with a structured design system and clearly labeled outputs for investment research.
  • Use Case: A hedge fund analyst wants an up-to-date model for AAPL that outputs a trailing model, a 4-quarter projection, and a DCF valuation all in one file.

Quick Start

Provide a ticker symbol to build the model; the tool will fetch data and generate the Excel workbook.

Frequently Asked Questions about build-model

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate building an Excel financial model from a stock ticker?

Automating Excel financial model creation from a stock ticker requires fetching financial statements and assembling them into a multi-tab workbook. This skill uses openpyxl to generate income statements, balance sheets, cash flows, KPIs, and DCF projections directly from a single ticker input.

What is included in a DCF valuation model generated from a ticker?

A DCF valuation model generated from a ticker includes comprehensive financial data covering income statements, balance sheets, cash flows, and KPIs. It also assembles 4-quarter projections and DCF inputs into a structured Excel workbook for investment research.

Do I need openpyxl to build Excel financial models with Python?

Yes, you need openpyxl installed to build Excel financial models with Python. This skill requires the openpyxl library to assemble the multi-tab workbook and populate it with gathered financial data and DCF projections.

Can I generate a full 4-quarter projection and DCF in one Excel workbook?

You can generate a full 4-quarter projection and DCF in one Excel workbook by providing a single ticker symbol. The tool automatically gathers company financials, builds trailing models, and structures the outputs with clearly labeled tabs for investment research.

How are financial model outputs saved when building Excel workbooks from tickers?

Financial model outputs are saved as a multi-tab Excel workbook when building from tickers. Additionally, the generated context is saved to reports/.tmp/{TICKER}_model_context.json to store the underlying data and modeling parameters.

What's the best way to create a multi-tab valuation workbook for investment research?

The best way to create a multi-tab valuation workbook for investment research is automating data gathering and modeling through a single ticker input. This approach consolidates income statements, balance sheets, cash flows, and DCF projections into one structured Excel file.