本文へ移動
cccskills
無料GitHub で公開

comps-valuation

Produce Public Equity Investing comparable-company valuation in report or workbook mode. Use for peer selection, multiple analysis, valuation read-throughs, implied prices, comps dashboards, Excel or Sheets comps, refreshable peer tables, model updates, and comps workbook QA. Do not use for DCF-only, credit-security, or generic market commentary requests.

インストール方法を見る

含まれるファイル(20)

  • SKILL.md7.6 KB
  • agents/openai.yaml298 B
  • references/DASHBOARD_PACK.md4.3 KB
  • references/module-rules.md3.9 KB
  • references/output-templates.md5.0 KB
  • references/p0-integrations.md3.3 KB
  • references/peer-selection.md4.2 KB
  • references/source-and-staleness-rules.md4.8 KB
  • references/valuation-readthrough.md5.3 KB
  • references/workbook-mode.md1.2 KB
  • references/workbook/comps-framework.md8.5 KB
  • references/workbook/dashboard-map.md1.6 KB
  • references/workbook/data-sourcing-and-connectors.md5.5 KB
  • references/workbook/model-workbook-spec.md7.2 KB
  • references/workbook/qa-and-pressure-testing.md4.9 KB
  • references/workbook/review-memo-template.md2.6 KB
  • scripts/audit_comps_workbook.py17.8 KB
  • scripts/create_comps_template.py39.8 KB
  • scripts/materialize_screening_comps.py21.6 KB
  • scripts/requirements.txt35 B

SKILL.md(原文)

インストールする前に、エージェントに与えられる指示の中身を確認できます。

Comps Valuation

Skill Configuration

Common Skill Instructions

MANDATORY: Before searching connectors, retrieving evidence, or drafting output, read and apply the shared runtime contract in ../public-equity-investing/SKILL.md## Cross-Skill Runtime Contract. Then check the router skill map and ../../shared/plugin-routing-playbook.md for adjacent skills that should be sequenced with this workflow. Do not run user-context setup or inspection during ordinary workflow work; route only explicit saved-context, source-setup, onboarding, or automation-setup requests to ../user-context/SKILL.md.

Source Resolution

Load ../../shared/workflow-source-resolution.md. Resolve only the categories needed for this workflow: company_filings_ir, market_data_estimates, and portfolio_models_trackers. Use the shared runtime contract to map each attempted category to an available app, connector, file, export, or user-provided input.

Relevant Dependency Categories

These are the source categories most likely to matter for this workflow. Use the router contract to resolve only the categories the task actually needs, prefer user-named sources first, and state any material source limitation.

  • Market Data & Estimates
  • Company Filings & IR
  • Portfolio Models & Trackers

Deliverable Intake And Judgment Standard

Before source gathering or analysis for a new substantive hero deliverable, load ../../shared/deliverable-intake-policy.md and use its adaptive request_user_input preflight for materially unresolved format, depth, audience/use, or focus choices. Reuse resolved preferences downstream. For substantive investment judgment, apply ../../shared/final-deliverable-framework.md.

Equity Valuation PM Standard

Load ../../shared/equity-valuation-pm-standard.md and ../../shared/pm-judgment-heuristics.md for substantial model, valuation, scenario, model-update, or audit work.

The output must state what the current stock price implies, the variant estimate path, whether upside is driven by fundamentals, multiple expansion, mix, capital return, sentiment, or event probability, what breaks first in downside, the valuation posture and next underwriting step, and what evidence is missing. State what changes target, rating, sizing, hedge, trim, exit, or watchlist status only when the user requests portfolio action or provides the relevant holding, benchmark, mandate, and liquidity context.

Keep equity valuation as the center of gravity. Debt is allowed only as an input to common-equity value through net debt, cost of debt, leverage, liquidity, refinancing risk, or downside equity impairment. Use Credit Markets for bond comps, loan comps, CDS, spread/yield relative value, covenant-package analysis, debt-security valuation, recovery waterfall, restructuring valuation, creditworthiness, private-credit or public-credit instrument underwriting, or distressed claim valuation.

Mode Selection

Select the mode from the request and available context; do not ask merely because both modes exist.

  • report mode: peer framing, multiple interpretation, implied valuation or price read-through, peer-set review, PM-facing comps argument, or a standalone HTML report or explicitly requested standardized dashboard without an editable model.
  • workbook mode: Excel, Sheets, CSV/XLSX export, refreshable data, formulas, EV bridges, peer-table templates, workbook/model updates, structured sensitivities, or auditing an existing comps workbook.
  • If an existing workbook is supplied and the requested output changes or validates it, choose workbook.
  • Ask one focused question only when either mode is equally plausible and choosing incorrectly would materially change the user's intended artifact or decision workflow. Prefer proceeding with a stated inferred default when reliance is not impaired.

Common Workflow

  1. Establish security, issuer or target, audience mode, valuation date, fiscal basis, currency, and thesis question.
  2. Source and label price, shares, EV bridge, reported/adjusted/consensus denominators, forward estimates, and peer rationale.
  3. Build Core, Secondary, Excluded, and optional Watchlist peer roles.
  4. Test metric comparability, stale data, outliers, valuation range, premium/discount logic, and PM action implications.
  5. State what is priced in, what would change the thesis, and what evidence is missing.
  6. Render or materialize the selected mode.

Report Mode

Read references/peer-selection.md, references/module-rules.md, references/source-and-staleness-rules.md, references/valuation-readthrough.md, references/output-templates.md, and references/p0-integrations.md only when relevant. For a substantial reusable or HTML comps report, produce a polished standalone HTML comps report following ../../shared/html-artifact-standard.md; let the valuation question and supported evidence determine the hierarchy. Use dashboard-builder only when the user explicitly asks for a standardized dashboard, reusable dashboard template, PM cockpit, or structured payload-driven render; in that case, load references/DASHBOARD_PACK.md and hand over a public_equity_investing_dashboard.v1 payload.

For a standalone HTML comps report, keep the first read compact:

  1. Valuation read: whether the premium or discount is supported and the key unresolved proof point.
  2. Four or five high-signal metrics: current price, primary trading multiple, premium or discount to core peers, implied value range only when supportable, and the key operating proof point.
  3. Peer-set rationale: Core, Secondary, and Excluded peers with concise inclusion or exclusion reasons.
  4. Core trading-comps table.
  5. Premium or discount bridge grounded in growth, margin, business-model fit, and data quality.
  6. Valuation posture, material evidence gaps, and concise source ledger.

Express a valuation posture such as premium partly supported, screening-only, or not sufficiently supported for a new-money decision. Do not issue add, trim, hedge, sizing, or exit instructions unless the user requests portfolio action or supplies relevant holding and mandate context.

When HTML is delivered, keep citations traceable but readable: do not fragment tickers, prices, multiples, percentages, dates, numeric ranges, metric names, or peer labels into separately linked tokens. Visually inspect local HTML via local headless-browser screenshots, not the in-app Browser plugin, and iterate on hierarchy, density, clipping, citation rendering, and whitespace before delivery.

Workbook Mode

Read references/workbook/comps-framework.md, references/workbook/data-sourcing-and-connectors.md, references/workbook/model-workbook-spec.md, references/workbook/qa-and-pressure-testing.md, references/workbook/review-memo-template.md, and references/workbook/dashboard-map.md only when relevant. Use scripts/create_comps_template.py, scripts/materialize_screening_comps.py, and scripts/audit_comps_workbook.py as appropriate. Preserve an existing workbook before rebuilding it.

When To Invoke Support

Load ../../shared/support-layer-routing-contract.md when source/data/QC support is needed. Use financials-normalizer for messy issuer or peer inputs, model-audit-tieout for standalone workbook audit, and deck-report-qc before circulation. Route credit-first conclusions to Credit Markets.

レビュー

まだレビューはありません。使ってみた感想をお寄せください。

同じリポジトリのスキル

概要と使いどころ

Make data visualizations accessible and inclusive. Use when the user needs chart or diagram accessibility guidance, text alternatives for complex visuals, color and contrast review, keyboard support, reduced-motion behavior for animation or parallax, or an accessibility QA workflow for exported figures, UML-like diagrams, and dashboards.

日本語の概要は準備中です。原文の説明を表示しています。

openai/plugins7,3852026年10月8日 更新

Apply consistent photo adjustments across a set of images so they look like they were edited together. Use this skill whenever the user says "make my photos look cohesive", "give all these the same style", "apply a warm and golden feel to all of these", "make this cinematic", "match the look across my photos", "edit all my travel photos the same way", "batch edit these", "make these consistent", "fix my phone photos", or uploads a folder of photos and wants a unified, polished result. Also triggers for requests like "apply a preset to all of these", "make these look professional", or "they were shot in mixed lighting — can you fix them all". Outputs direct final image URLs plus an in-chat preview grid and optional Firefly Board link. Access: 🔐 Signed-In required | Gen AI: ❌

日本語の概要は準備中です。原文の説明を表示しています。

openai/plugins7,3852026年10月8日 更新

Use when a user wants to see their logo, design, or sketch on a product or scene mockup — mugs, t-shirts, business cards, hats, phone screens, posters, billboards, or similar. Triggers on "create mockups", "show my logo on products", or any logo upload with a request to visualize it on items. Access: 🔐 Signed-In required | Gen AI: ✅ Adobe Firefly via `image_generate` used for design creation, sketch polishing, and mockup scene generation

日本語の概要は準備中です。原文の説明を表示しています。

openai/plugins7,3852026年10月8日 更新

Resize, crop, or export any image or video into platform-ready social media assets using Adobe Creative Cloud tools. Use this skill when a user wants to prepare a photo, image, or video for one or more social platforms — Instagram, TikTok, LinkedIn, Facebook, YouTube, Snapchat, Pinterest, Threads, or X/Twitter. Triggers on: "prepare my image for Instagram", "resize for TikTok", "get this ready to post", "make versions for all platforms", "social media sizes", "crop for stories", "export for LinkedIn", "resize my video for social", "make social media assets", or any request to adapt a photo or video for specific platforms. Handles subject-aware cropping, AI canvas expansion, test previews before full runs, and same-ratio video resizing.

日本語の概要は準備中です。原文の説明を表示しています。

openai/plugins7,3852026年10月8日 更新

Create any visual design using Adobe Express templates — flyers, posters, social media posts (Instagram, Facebook, LinkedIn), business cards, invitations, greeting cards, resumes, cover letters, brochures, newsletters, certificates, presentations, YouTube thumbnails, email headers, logos, menus, and labels. Use this skill whenever the user wants to make, design, or build any visual — even if they just say "make me a flyer", "design a poster", "I need something for Instagram", "create an event invite", or "make a business card". Also handles browsing templates, editing text, replacing images, changing backgrounds, animating, and exporting designs. Access: 🔐 Signed-In required | Gen AI: ❌ by default — image replacement only where the surface permits generative AI (e.g. Codex); none on Claude

日本語の概要は準備中です。原文の説明を表示しています。

openai/plugins7,3852026年10月8日 更新

Create a punchy sizzle reel from a video using Adobe Quick Cut. Use this skill whenever a user wants to cut, trim, or shorten a video into highlights — including phrases like "make a sizzle reel", "make a highlight reel", "quick cut this", "cut the best parts", "shorten this video", "make a highlight clip", "summarize this video visually", or any request to produce a shorter edited version of a video. Use this skill for Quick Cut requests before suggesting manual editing in Premiere. Requires the user to upload a video file.

日本語の概要は準備中です。原文の説明を表示しています。

openai/plugins7,3852026年10月8日 更新

openai のスキルをすべて見る

このスキルの問題を報告する