Agent skill

Update

by daloopa in daloopa/investing

Refresh existing research note and Excel model with latest data

Apache-2.0Auto-check passedDocuments & Office

Install Update

skills CLI
$ npx skills add daloopa/investing --skill update -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install daloopa/investing update --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/daloopa/investing.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.claude/skills/update .claude/skills/update && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
update
GitHub stars
489
Token cost
~1.1k tokens
SKILL.md length
460 words
Files
1
Skills in repo
22
Repo updated
First seen
Licence
Apache-2.0

At a glance

Refresh existing research note and Excel model with latest data

  • Works in 9 steps: Load Existing Context → Identify New Data → Pull Fresh Data → …
  • Tasks that involve Excel spreadsheets
  • SKILL.md covers Phase 1 — Load Existing Context, Phase 2 — Identify New Data, Phase 3 — Pull Fresh Data and Phase 4 — Market Data Refresh, plus 5 more sections
  • Calls python

What it does

Update is an agent skill from daloopa/investing. Refresh existing research note and Excel model with latest data

Its SKILL.md is about 1.1k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Documents & Office, covering Excel spreadsheets. The licence is Apache-2.0.

When your agent uses it

  • Tasks that involve Excel spreadsheets

Example prompts

  • “/update”

Requirements

  • Python 3

Workflow steps

9 steps, taken from the step headings in SKILL.md.

  1. Load Existing Context
  2. Identify New Data
  3. Pull Fresh Data
  4. Market Data Refresh
  5. Re-run Projections
  6. Diff Analysis
  7. Update Qualitative Sections
  8. Re-render Outputs
  9. Change Summary

What it can do on your machine

Read from SKILL.md and the folder at commit f46f350. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • python

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    Links to these hosts (documentation or services it may open):

    • daloopa.com

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Update loads about 1.1k tokens when it runs. Until then it costs about 18 tokens; SKILL.md has 460 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~18
When it runs · the whole SKILL.md, loaded when a task matches
~1.1k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from daloopa/investing at commit f46f350, republished under its Apache-2.0 licence (© daloopa). 460 words, ~1,145 tokens.

Download SKILL.mdSave it as .claude/skills/update/SKILL.md (or your agent's skills folder).
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.

Show full SKILL.md (183 more words)Show less

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

© daloopa, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in .claude/skills/update of daloopa/investing.

Open the folder on GitHubat commit f46f350

Compare with similar skills

Update next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Update compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Update this skilldaloopa/investing489—~1.1kAutomated safety check: PassApache-2.0
Anti Gambling Tradermars-tw/anti-gambling-trader-tw716—~1.8kAutomated safety check: PassMIT
Data UpdateSixian-Li/plain-backtest150—~1.6kAutomated safety check: PassMIT
Cn Ib Diligence WorkpaperQiushenZou/cn-investment-banking-skills102—~1.4kAutomated safety check: PassApache-2.0
Officecli Commonly TemplatesTeam-Commonly/commonly1.4k—~1.7kAutomated safety check: PassApache-2.0
Brigade Spreadsheet Builderspinabot/brigade11k—~1.4kAutomated safety check: PassMIT

Similar skills

  • Anti Gambling Trader

    mars-tw/anti-gambling-trader-tw

    分析台股 / 台股ETF / 台指期選擇權 / 美股 / 加密貨幣 / 外匯的交易紀錄 (CSV / JSON / Excel),用統計學判斷使用者的獲利是「可重複的優勢」還是 「運氣 + 倖存者偏差(賭博)」,不適合長期投資會明確勸退。內建反詐工具: 掃描群組對話的詐騙話術(scan-text)、檢驗老師宣稱的績效(guru-check)、…

    716 GitHub stars~1.8k tokensUpdated 2 mo ago
    Documents & OfficeAuto-check passed
  • Data Update

    Sixian-Li/plain-backtest

    Operate and assess the Quant workspace market-data layer through the tested data-update CLI.

    150 GitHub stars~1.6k tokensUpdated 10 days ago
    Documents & OfficeAuto-check passed
  • Cn Ib Diligence Workpaper

    QiushenZou/cn-investment-banking-skills

    Structure Chinese investment-banking due-diligence materials into traceable schedules, testing workpapers, exception logs, and closure records.

    102 GitHub stars~1.4k tokensUpdated 1 mo ago
    Documents & OfficeAuto-check passed
  • Officecli Commonly Templates

    Team-Commonly/commonly

    A skill your agent uses when producing a polished, Commonly-branded deliverable (.docx brief / memo, .xlsx data matrix, .pptx deck) and you do not have specific brand guidance from the user.

    1.4k GitHub stars~1.7k tokensUpdated today
    Documents & OfficeAuto-check passed
  • Builds and edits Excel workbooks for the Brigade agent, with live formulas, formatting, dropdowns and multiple sheets, plus an optional recalculation check.

    11k GitHub stars~1.4k tokensUpdated 4 days ago
    Documents & OfficeAuto-check passed
  • Financial Report

    monarchjuno/vibe-investing

    Package investing analysis into a publishable financial-report style with institutional section flow, thesis framing, valuation context, catalysts, risks, tables, and financial charts.

    299 GitHub stars~1.3k tokensUpdated 5 mo ago
    Documents & OfficeAuto-check passed

More from daloopa/investing

All 22 skills in this repo
  • Capital Allocation

    daloopa/investing

    Deep dive into capital deployment, buybacks, dividends, and shareholder yield

    489 GitHub stars~2.3k tokensUpdated 2 mo ago
    Auto-check passed
  • Comp Sheet

    daloopa/investing

    Build an industry comp sheet Excel model with deep operational KPIs

    489 GitHub stars~2k tokensUpdated 2 mo ago
    Auto-check passed
  • Comps

    daloopa/investing

    Trading comparables analysis with peer multiples and implied valuation

    489 GitHub stars~2.5k tokensUpdated 2 mo ago
    Auto-check passed
  • Dcf

    daloopa/investing

    Discounted cash flow valuation with sensitivity analysis. An agent skill from daloopa/investing.

    489 GitHub stars~2.5k tokensUpdated 2 mo ago
    Auto-check passed
  • Earnings Flash

    daloopa/investing

    Rapid first-read earnings flash for a given company. An agent skill from daloopa/investing.

    489 GitHub stars~1.9k tokensUpdated 2 mo ago
    Auto-check passed
  • Guidance Tracker

    daloopa/investing

    Track management guidance accuracy over time for a given company

    489 GitHub stars~2.5k tokensUpdated 2 mo ago
    Auto-check passed

Questions about Update

What does Update do?

Refresh existing research note and Excel model with latest data. Update is an agent skill from daloopa/investing.

When should I use Update?

Update fits situations like: tasks that involve Excel spreadsheets.

How do I install Update in Claude Code?

Run `npx skills add daloopa/investing --skill update -a claude-code`. Or copy the skill folder (.claude/skills/update in daloopa/investing) into .claude/skills/update in your project. Claude Code loads it when a task matches its description.

How do I install Update in Codex?

Run `npx skills add daloopa/investing --skill update -a codex`. Or copy the skill folder (.claude/skills/update in daloopa/investing) into .agents/skills/update in your project. Codex loads it when a task matches its description.

Can I use Update in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add daloopa/investing --skill update -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/update, .gemini/skills/update, .github/skills/update and .opencode/skills/update in your project.

What does Update need to run?

Going by SKILL.md and its folder, Update needs the command-line tools its instructions call (python). Our summary lists: Python 3.

Does Update access the network?

SKILL.md names 1 domain. As links in the text: daloopa.com. This is read from the text; nothing was executed.

Is Update safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Update use?

Update is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Update use?

About 1.1k tokens (SKILL.md is roughly 4.6k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Update?

Skills that share tags, products or a category with Update: Anti Gambling Trader (mars-tw/anti-gambling-trader-tw, 716 stars), Data Update (Sixian-Li/plain-backtest, 150 stars), Cn Ib Diligence Workpaper (QiushenZou/cn-investment-banking-skills, 102 stars) and Officecli Commonly Templates (Team-Commonly/commonly, 1.4k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Update?

daloopa (a GitHub organization) maintains it in daloopa/investing, which has 489 GitHub stars. The repository holds 22 skills in this directory. The repository was last updated on July 22, 2026.

Source: daloopa/investing on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.