查找技能

交叉查询企业披露、政府合同、制裁名单等公开记录，核对名称差异，并将资金与组织关系整理为附有来源和置信度的调查结果。

• 调查企业控制关系与披露内容
• 核对制裁名单和离岸信息
• 比较游说活动与政府合同

生成Excel文件，估算企业收购对每股收益的影响。整理收购价格、融资和协同效应假设，制作不同条件的比较表，以及用于说明收购影响的摘要。

• 估算收购对每股收益的影响
• 比较现金和股票支付条件
• 比较收购价格与协同效应假设

将未来现金流折算为现值，生成计算企业价值和每股估值的Excel文件。支持修改假设后重新计算、比较不同情景，并通过敏感性分析查看估值变化。

• 制作企业估值Excel文件
• 比较悲观、基准和乐观情景
• 查看假设变化对估值的影响

创建用公式联动利润表、资产负债表和现金流量表的 Excel 模型，分阶段填入历史实际数据与预测假设，比较不同情景，并检查三张报表之间的一致性。

• 向财务模板填入历史实际数据
• 建立三张财务报表联动的预测
• 比较基准、乐观和悲观情景

Build Excel workbooks for buyouts financed with debt. Using a supplied or standard template, the skill connects funding, operating forecasts, debt repayment, and returns, calculating IRR, an annualized return measure, and MOIC, the investment multiple.

中文简介正在准备中。当前显示英语简介。

• Populate an LBO template with acquisition assumptions
• Review borrowing, interest, and repayment schedules
• Calculate investment returns using IRR and MOIC

制作Excel工作簿，比较类似企业的收入、利润率及估值倍数。汇总公式、中位数、四分位数和数据来源，为投资或收购评估准备可更新的比较资料。

• 与同行比较企业价值
• 制作收购评估比较资料
• 比较行业增长与盈利能力

Retrieve facts from named scientific, regulatory, economic, and other databases through documented APIs. Get results with recorded filters, retrieval dates, and record counts so another person can repeat the lookup and assess its completeness.

中文简介正在准备中。当前显示英语简介。

• Look up gene or compound records by identifier
• Collect clinical trials matching defined criteria
• Retrieve economic statistics with documented sources

Build an Excel comparison of public companies using financial performance, valuation ratios, and statistical benchmarks. The spreadsheet includes formulas, source notes, medians, and quartiles to show how each company compares with its peers.

中文简介正在准备中。当前显示英语简介。

• Comparing public company valuations for M&A
• Benchmarking performance against industry peers
• Identifying unusually high or low valuation ratios

Create quarterly earnings reports for companies already being followed. Compare results with market expectations, explain differences, revise forecasts, and assess the investment case in a Word document with charts, summary tables, and linked sources.

中文简介正在准备中。当前显示英语简介。

• Writing a report after a quarterly earnings release
• Explaining results above or below market expectations
• Revising forecasts after new company guidance

Retrieve U.S. company filings and financial series from SEC EDGAR. Resolve stock tickers to company identifiers, list recent reports with document links, and fetch reported metrics such as revenue or assets without an API key.

中文简介正在准备中。当前显示英语简介。

• Find a company's recent annual reports and document links
• List quarterly reports and material event filings
• Retrieve reported revenue or net income series

Access stock fund flows, disclosures, news, financial statements, and market rankings through Vibe-Trading tools. The skill documents available data interfaces and examples, including symbol lookup, with market-specific sources and no token required.

中文简介正在准备中。当前显示英语简介。

• Review fund flows for Chinese, Hong Kong, and US stocks
• Check Chinese stock disclosures and lockup expiry dates
• Retrieve company financial statements and stock news

Choose financial data sources and tools for price history, financial statements, news, and economic research. The skill maps market coverage, credentials, access limits, and fallback options, and provides rules for checking important figures against independent sources.

中文简介正在准备中。当前显示英语简介。

• Choose price data sources for historical strategy testing
• Find tools for financial statements, news, and economic indicators
• Check required API keys and alternative data sources

Analyze US public company filings to summarize financial health, management commentary, changing risks, insider trades, and institutional holdings. Combine these findings into a structured research report with scores and investment implications.

中文简介正在准备中。当前显示英语简介。

• Reviewing annual and quarterly financial performance
• Comparing risk disclosures with previous filings
• Investigating major events reported in 8-K filings

Create, edit, and clean spreadsheet files, including Excel workbooks and CSV data. Add formulas, formatting, and charts, preserve existing template styles, and recalculate formulas to check for errors before delivering the spreadsheet.

中文简介正在准备中。当前显示英语简介。

• Clean messy CSV rows and headers into a usable spreadsheet
• Add formulas and charts to an existing Excel workbook
• Build a financial model with editable assumptions

Create, edit, repair, and convert spreadsheet files, including Excel and CSV. This skill covers cleaning messy tables, adding formulas and charts, preserving existing formatting, and recalculating formulas to check for spreadsheet errors.

中文简介正在准备中。当前显示英语简介。

• Cleaning messy CSV data into a spreadsheet
• Adding formulas and charts to an existing workbook
• Creating a financial model with editable assumptions

Research a listed company's business quality and valuation using official filings, comparisons with similar companies, and historical performance. Produce an evidence-backed report and scorecard, with separate modes for accounting concerns and companies preparing for an IPO.

中文简介正在准备中。当前显示英语简介。

• Compare a company's financial strength with sector peers
• Investigate gaps between reported profit and cash flow
• Assess assumptions built into a stock's current price

Create and edit Excel workbooks for data analysis, reports, and financial models. Build formulas that update with inputs, organize sheets, add charts and interactive pivot tables, and recalculate the workbook to check for formula errors.

中文简介正在准备中。当前显示英语简介。

• Create an Excel report with charts
• Build a financial model with adjustable assumptions
• Summarize data in interactive pivot tables

Support stock and cryptocurrency analysis with reference formulas for price indicators, position sizing, and risk measures. The skill also covers financial data sources and Alpaca API operations, including market data retrieval, order management, and paper trading.

中文简介正在准备中。当前显示英语简介。

• Comparing price indicators and candlestick patterns
• Calculating position sizes and loss limits
• Exploring paper trading with the Alpaca API

Collect company financial figures from two independent sources, compare discrepancies, and document possible causes. The workflow covers market-specific sources, currency and accounting differences, and historical share prices adjusted for stock splits and dividends.

中文简介正在准备中。当前显示英语简介。

• Cross-checking revenue and profit figures from two sources
• Investigating differences in currencies and accounting methods
• Collecting Taiwanese stock financials and monthly revenue

Create and edit spreadsheet files, clean messy tables, and convert tabular formats. Add formulas, formatting, and charts while following existing template styles, then recalculate formulas and check for errors before delivering the spreadsheet.

中文简介正在准备中。当前显示英语简介。

• Clean messy CSV data into a spreadsheet
• Add formulas and charts to an Excel workbook
• Update a workbook using its existing formatting

Create, edit, repair, and convert spreadsheet files, including Excel workbooks and CSV data. Clean messy tables, add formulas and formatting, preserve existing template styles, and recalculate formulas to check for errors before delivery.

中文简介正在准备中。当前显示英语简介。

• Clean messy CSV data into a spreadsheet
• Add formulas and columns to an existing workbook
• Update a workbook while preserving its template

Investigate organizations, domains, media locations, and cryptocurrency flows using open-source intelligence, or OSINT. The skill helps select relevant research tools, connect findings across sources, and preserve evidence with timestamps, screenshots, file hashes, and reproducible logs.

中文简介正在准备中。当前显示英语简介。

• Mapping an organization's publicly exposed infrastructure
• Connecting public company records and social profiles
• Investigating image locations and video evidence

Create, edit, and analyze spreadsheets with formulas, formatting, and visualizations. Preserve existing workbook conventions, keep calculations responsive to input changes, and use formula recalculation and error checks to verify the resulting files.

中文简介正在准备中。当前显示英语简介。

• Create a spreadsheet with formulas and formatting
• Update an existing workbook while preserving formulas
• Analyze and visualize Excel or CSV data

Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.

中文简介正在准备中。当前显示原文说明。