---
name: update
description: Refresh existing research note and Excel model with latest data
argument-hint: TICKER
---

Update existing coverage for the company specified by the user: $ARGUMENTS

**Before starting, read `../data-access.md` for data access methods and `../design-system.md` for formatting conventions.** Follow the data access detection logic and design system throughout this skill.

This skill refreshes existing deliverables with the latest quarterly data, highlights what changed, and re-renders both outputs.

## Phase 1 — Load Existing Context
Check for existing context files in `reports/.tmp/`:
- `reports/.tmp/{TICKER}_context.json` (research note context)
- `reports/.tmp/{TICKER}_model_context.json` (model context)

If neither exists, tell the user: "No existing coverage found for {TICKER}. Run `/initiate {TICKER}` first to create initial coverage." and stop.

Read the existing context(s) to understand what periods and data were previously gathered.

## Phase 2 — Identify New Data
Look up the company using `discover_companies`. Capture `company_id`, `latest_calendar_quarter` (anchor for all period calculations — see `../data-access.md` Section 1.5), and `latest_fiscal_quarter`. Note the firm name for report attribution (default: "Daloopa") — see `../data-access.md` Section 4.5.
Compare to the periods in existing context. Determine which new quarters need to be pulled.

If no new quarters are available, tell the user: "Coverage is already current through {latest_period}. No new data to update." and stop.

## Phase 3 — Pull Fresh Data
Pull data for ALL periods (not just new ones) to ensure consistency:
- Full Income Statement, Balance Sheet, Cash Flow
- Segments, KPIs, Guidance
- Share count, buyback activity

This refreshes the entire dataset, catching any Daloopa revisions to prior quarters.

## Phase 4 — Market Data Refresh
Get current prices, trading multiples, and risk-free rate (see ../data-access.md Section 2).

Also refresh peer multiples if comps data exists in context.

## Phase 5 — Re-run Projections
With updated historical data, re-run projections. If a projection engine is available (see ../data-access.md Section 5), use it. Otherwise project manually.

## Phase 6 — Diff Analysis
Save the new context alongside the old:
- Write new context to `reports/.tmp/{TICKER}_context_new.json`
- Run: `python infra/report_differ.py --old reports/.tmp/{TICKER}_context.json --new reports/.tmp/{TICKER}_context_new.json --output reports/.tmp/{TICKER}_diff.json`
- Read the diff to understand what changed

Key changes to highlight:
- Revenue/EPS beats or misses vs prior estimates
- Margin changes (expansion or compression)
- Guidance changes (raised, lowered, maintained)
- New KPI data points
- Share count changes (buyback acceleration/deceleration)
- Valuation changes (price moved, multiples shifted)

## Phase 7 — Update Qualitative Sections
Search filings for the new quarter(s):
- Earnings highlights and management commentary
- Updated guidance language
- New risk factors or strategic shifts
- Update investment thesis if data warrants it

Revise the executive summary and key findings to reflect the latest quarter.

## Phase 8 — Re-render Outputs
Update charts with new data points, then re-render:

**Research Note:**
1. Overwrite context: `reports/.tmp/{TICKER}_context.json`
2. Re-generate charts with updated data
3. Run: `python infra/docx_renderer.py --template templates/research_note.docx --context reports/.tmp/{TICKER}_context.json --output reports/{TICKER}_research_note.docx`

**Excel Model:**
1. Overwrite context: `reports/.tmp/{TICKER}_model_context.json`
2. Run: `python infra/excel_builder.py --context reports/.tmp/{TICKER}_model_context.json --output reports/{TICKER}_model.xlsx`

## Phase 9 — Change Summary
Present a clear summary of changes to the user:

```
## {TICKER} Coverage Update — {new_quarter} Added

### Key Changes
- Revenue: $XX.XB vs $XX.XB prior quarter (+X.X% QoQ, +X.X% YoY)
- EPS: $X.XX vs $X.XX guidance (beat/miss by X.X%)
- Gross Margin: XX.X% vs XX.X% prior quarter (+/- XXbps)
- {other notable changes}

### Projection Updates
- {what changed in forward estimates and why}

### Valuation Impact
- DCF implied price: $XXX (was $XXX, change of +/-X%)
- Comps implied range: $XXX - $XXX

### Files Updated
- Research note: reports/{TICKER}_research_note.docx
- Excel model: reports/{TICKER}_model.xlsx
- Diff report: reports/.tmp/{TICKER}_diff.json
```

All financial figures must use Daloopa citation format: [$X.XX million](https://daloopa.com/src/{fundamental_id})