Researching Stocks

by cv

workflowdata

Workflow for multi-step financial research requiring multiple data sources. Use for company comparisons, due diligence, comprehensive analysis, or complex financial questions.

Skill Details

Repository Files

1 file in this skill directory


name: researching-stocks description: Workflow for multi-step financial research requiring multiple data sources. Use for company comparisons, due diligence, comprehensive analysis, or complex financial questions.

Researching Stocks

Use this workflow for complex queries requiring multiple tools or analysis steps.

Workflow Checklist

Copy and track progress:

Research Progress:
- [ ] Step 1: Parse query (tickers, metrics, time period)
- [ ] Step 2: Plan tool calls (parallelize independent fetches)
- [ ] Step 3: Execute and gather data
- [ ] Step 4: Validate completeness
- [ ] Step 5: Synthesize answer with numbers and sources

Step 1: Parse Query

Extract:

  • Tickers: Normalize names → symbols (Apple → AAPL)
  • Metrics: What's being asked (margins, growth, valuation)
  • Period: Time range or comparison period

Step 2: Plan Tool Calls

Simple query → Single tool, answer directly Data query → Identify tools, call in parallel Complex query → Break into dependent steps

Parallelize independent fetches:

# These can run together:
get_income_statements(ticker: "AAPL", ...)
get_income_statements(ticker: "MSFT", ...)

# This depends on results above:
Compare and analyze margins

Step 3: Execute

Call tools. Related skills:

  • analyzing-financials - Statements, metrics, estimates
  • reading-sec-filings - 10-K, 10-Q, 8-K content
  • fetching-prices - Stock and crypto prices
  • tracking-signals - Insider trades, news

Step 4: Validate

Before answering, check:

Complete if:

  • Can answer the core question
  • Have data for all mentioned entities
  • For comparisons: have all sides

Incomplete only if:

  • Missing data for a PRIMARY entity
  • Comparison but only have one side
  • Tool calls failed completely

Do NOT fetch more data for "nice-to-have" enrichment.

Step 5: Synthesize

Structure your response:

  1. Key finding first - Answer in the first sentence
  2. Specific numbers - Cite actual data
  3. Brief analysis - What the numbers mean
  4. Sources - List API URLs used

Examples

Input: "Compare profitability of AAPL, MSFT, and GOOGL"

Research Progress:
- [x] Step 1: Tickers: AAPL, MSFT, GOOGL. Metric: profitability (margins). Period: latest.
- [x] Step 2: Three parallel income statement fetches, then compare.
- [x] Step 3: Fetched all three.
- [x] Step 4: Have data for all three. Complete.
- [x] Step 5: Synthesizing...

Output: "Microsoft leads in operating margin (44%), followed by Apple (30%) and Google (27%).

Company Revenue Op. Income Op. Margin
MSFT $245B $108B 44.1%
AAPL $383B $114B 29.8%
GOOGL $350B $94B 26.9%

Microsoft's margin advantage comes from high-margin cloud and software licensing.

Sources:


Input: "Quick overview of Amazon"

Research Progress:
- [x] Step 1: Ticker: AMZN. Metric: general overview. Period: current.
- [x] Step 2: Single call to get_all_financial_statements + metrics snapshot.
- [x] Step 3: Fetched.
- [x] Step 4: Have comprehensive data. Complete.
- [x] Step 5: Synthesizing...

Related Skills

Xlsx

Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas

data

Clickhouse Io

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

datacli

Clickhouse Io

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

datacli

Analyzing Financial Statements

This skill calculates key financial ratios and metrics from financial statement data for investment analysis

data

Data Storytelling

Transform data into compelling narratives using visualization, context, and persuasive structure. Use when presenting analytics to stakeholders, creating data reports, or building executive presentations.

data

Kpi Dashboard Design

Design effective KPI dashboards with metrics selection, visualization best practices, and real-time monitoring patterns. Use when building business dashboards, selecting metrics, or designing data visualization layouts.

designdata

Dbt Transformation Patterns

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.

testingdocumenttool

Sql Optimization Patterns

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.

designdata

Anndata

This skill should be used when working with annotated data matrices in Python, particularly for single-cell genomics analysis, managing experimental measurements with metadata, or handling large-scale biological datasets. Use when tasks involve AnnData objects, h5ad files, single-cell RNA-seq data, or integration with scanpy/scverse tools.

arttooldata

Xlsx

Spreadsheet toolkit (.xlsx/.csv). Create/edit with formulas/formatting, analyze data, visualization, recalculate formulas, for spreadsheet processing and analysis.

tooldata

Skill Information

Category:Data
Last Updated:1/11/2026