Generate Peer Comparables Workbook (xlsx)
generate_comps_xlsxRender a peer comparables table into an Excel workbook. The Comps sheet is formatted as a named Excel Table (ValueinPeerComps) so the user gets one-click Insert Chart on any column — the cleanest workaround for not embedding chart objects server-side. Subject-row highlight makes side-by-side comparison instant. A Summary sheet adds subject vs peer-median deltas.
SERVER-TRUST: the ratios you pass are rendered as-supplied and are NOT re-derived by Valuein, so the workbook carries a visible 'figures supplied by caller, not verified by Valuein' watermark (response verification.status = 'unverified'). For authoritative numbers, source them from get_peer_comparables / get_financial_ratios first.
Pair with get_peer_comparables for a typical flow.
Tier: pro+.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| notes | No | Optional free-text note (≤500 chars) rendered on the Summary sheet. | |
| peers | Yes | Peer companies to tabulate against the subject (1–50 rows); each row carries the peer's ticker, name, and comparable ratio values. | |
| subject_ticker | Yes | Stock ticker symbol of the subject company the comps sheet is built around, e.g. AAPL. | |
| subject_company_name | No | Optional display name for the subject company; falls back to the ticker if omitted. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| url | Yes | ||
| _meta | Yes | Provenance envelope — data lineage for every MCP response | |
| r2_key | Yes | ||
| filename | Yes | ||
| expires_at | Yes | ||
| size_bytes | Yes | ||
| content_type | Yes | ||
| verification | Yes | Server-trust record. Comps ratios are rendered as supplied and are NOT re-derived by Valuein, so the workbook carries a visible 'figures supplied by caller' watermark. Pull authoritative ratios via get_peer_comparables / get_financial_ratios. | |
| expires_in_seconds | Yes |