dbs-report

📁 didierrlopes/dbs-report-skill 📅 12 days ago
1
总安装量
1
周安装量
#53508
全站排名
安装命令
npx skills add https://github.com/didierrlopes/dbs-report-skill --skill dbs-report

Skill 文档

DBS Group Research — US Equity Research Report Generator

You are generating a DBS Group Research US Equity Research report in HTML format. The output must be a single self-contained HTML file that, when opened in a browser and printed to PDF, is visually indistinguishable from the original DBS reports.

The user will provide a company name (and optionally a ticker). You must gather the required financial data using available tools (financial datasets MCP, web search, etc.) and produce the full report.

For the complete formatting specification, see report-spec.md. For the HTML/CSS template, see template.html.


REPORT GENERATION WORKFLOW

Step 1: Gather Data

Use available tools to collect:

  1. Company facts: Sector, market cap, share price, volume, free float, dividend yield, Bloomberg ticker
  2. Financial statements: 3 years of actuals + 2 years of consensus estimates for income statement, balance sheet, cash flow
  3. Valuation metrics: P/E, P/B, EV/EBITDA, dividend yield, FCF yield
  4. Credit metrics: Debt/Equity, Net Debt/Equity, Debt/Assets, EBITDA/Interest, Debt/EBITDA, receivable days, payable days, inventory days
  5. Stock price history: ~4 years of monthly prices for the indexed performance chart
  6. S&P 500 history: Same period for the benchmark comparison
  7. Recent news and filings: For writing the investment overview narrative

Step 2: Write Narrative Content

Generate the following sections using the voice and style rules from the spec:

  1. Company Overview (1 paragraph, ~100-150 words): Factual description of what the company does, key products/segments with revenue percentage breakdowns.
  2. Investment Overview (2-4 paragraphs, each starting with a bold lead-in sentence):
    • Each paragraph covers one investment thesis point
    • The final paragraph is always the rating/valuation call
    • Use specific data points, percentages, and figures inline
  3. Risks (1-2 short paragraphs, bold lead-in sentence): Key downside risks

Step 3: Determine Rating and Target Price

Based on the analysis:

  • Apply the DBS Absolute Total Return rating system:
    • STRONG BUY: >20% total return over 3 months
    • BUY: >15% (small caps) / >10% (large caps) over 12 months
    • HOLD: -10% to +15% (small caps) / -10% to +10% (large caps) over 12 months
    • FULLY VALUED: negative total return >-10% over 12 months
    • SELL: negative total return >-20% over 3 months
  • State the valuation methodology (e.g., “based on Xx forward PE, +Y SD above peers’ average”)

Step 4: Build the HTML Report

Use the template from template.html and populate all sections. The HTML must be self-contained with inline CSS and embedded SVG charts.


CRITICAL FORMATTING RULES

These rules must be followed exactly. Deviations will make the report look non-authentic.

Font & Typography

  • Font family: Sans-serif throughout: Calibri, 'Segoe UI', Arial, Helvetica, sans-serif — this applies to body text, tables, headers, everything. Do NOT use serif fonts (Georgia, Times, etc.)
  • Banner: US EQUITY RESEARCH banner must span 100% full page width, not just the left column
  • Lead-in sentences: Must be both bold AND underlined (font-weight: bold; text-decoration: underline;)
  • Rating names in the rating definitions box: Must be bold AND underlined
  • Source attributions below financial tables: Regular weight, NOT italic
  • DBS logo star: Use ❖ (❖), not ✶ (✶)
  • SVG chart text: Must also use the same sans-serif font family

Writing Style

  • Justified text alignment for all body paragraphs
  • Bold + underlined lead-in sentences: Every paragraph in Investment Overview and Risks starts with a bold and underlined first sentence (.lead-in { font-weight: bold; text-decoration: underline; }), ending with a period, then continues in regular weight with no underline
  • Currency: Always “USD” prefix (e.g., “USD210”, “USD1.2 trillion”), never “$” in body text ($ is acceptable in tables)
  • Percentages: Use % symbol inline (e.g., “17% y/y”, “51% of FY24 revenue”)
  • Year-over-year: Write as “y/y”
  • Fiscal year: Format as “FY24”, “FY9/25F”, “FY2025F” — “F” suffix for forecasts
  • Tone: Institutional, analytical, third-person. No first-person (“I/we think”), instead use “We expect”, “We believe”, “We are [RATING] on [TICKER]”
  • No bullet points in body text — everything in paragraph form
  • Company name used in full on first reference, then ticker or shortened name thereafter

Page Layout

  • Page 1: Two-column (60% left narrative / 40% right data sidebar)
  • Page 2: Full-width financial tables (3 tables stacked)
  • Page 3: Target Price & Ratings History chart + Rating definitions box + start of disclaimer
  • Pages 4-7: Boilerplate legal disclaimer (use the standard text from the spec)

Numbers in Tables

  • Right-aligned
  • Comma-separated thousands (e.g., “394,328”)
  • Negative values in parentheses: (2.8), (10.6) for percentage rows
  • y/y percentage sub-rows: italicized, indented
  • Missing data: show as “-“
  • Not meaningful: show as “nm”

Every Page Must Have

  1. “DBS Group Research” — top-right corner, small font
  2. 3-line disclaimer footer at bottom
  3. DBS logo (red diamond ❖ ❖ + “DBS” text) — bottom-right corner

OUTPUT FORMAT

Produce a single HTML file named {CompanyName}_DBS_Report.html. The file must:

  1. Be completely self-contained (inline CSS, embedded SVG charts, no external dependencies)
  2. Use @media print CSS for proper PDF generation
  3. Use @page rules for A4 sizing and margins
  4. Render charts as inline SVG elements
  5. Include page breaks at the correct locations

When generating charts as SVGs:

Indexed Performance Chart (Page 1):

  • Two-line chart: Company (orange/gold #D4A843) vs S&P 500 (dark gray #333)
  • Both indexed to 100 at the start date
  • ~4 year window
  • X-axis labels: “Mon-YY” format at ~6-month intervals
  • Y-axis: indexed values
  • Horizontal gridlines only, light gray
  • Legend at top: horizontal, with colored line samples

Target Price & Ratings History Chart (Page 3):

  • Dual series: share price (red line #CC3333) and target price (black step-line)
  • Numbered circle markers at each report date
  • ~12-month window
  • Y-axis: Stock Price (USD)

$ARGUMENTS