Get Company Financial Tearsheet
bigdata_company_tearsheetFull Description
Returns a comprehensive company tearsheet with financial data, market intelligence, and analyst coverage. PREREQUISITE: Call find_securities first to get rp_entity_id and listing_type. Tearsheet routing by security_type (from find_securities): - security_type "COMPANY" → call this tool (bigdata_company_tearsheet) - security_type "ETF" → call bigdata_etf_tearsheet instead - security_type "BOND" → no tearsheet available Workflow for company tearsheet: 1. Call find_securities → check security_type. Only proceed here if security_type is "COMPANY". 2. Read "listing_type" from the result ("PUBLIC" → "Public", "PRIVATE" → "Private") — this is company_type. 3. Call this tool with rp_entity_id and company_type. 4. Optionally call bigdata_search for supporting content. CRITICAL — Never infer company_type from training knowledge: The listing classification comes from RavenPack's Point-in-Time (PiT) entity database — it is the authoritative source and will always be present for company entities. It may differ from your training knowledge (e.g. a company you believe is private may be listed, or may have financial data from a previous listing period). Always use the value from find_securities. Never guess. When to Use: Company financials, earnings, revenue, valuation, balance sheet, cash flow, analyst ratings, price targets, ESG data, risk assessment, real time sentiment and media attention, or any financial analysis. Data Returned by Company Type: → PUBLIC companies (from financial data APIs): • Company profile & real-time quote (price, market cap, volume) • C-level leadership: the people leading the company, including the executive directory, board composition, and management stats • Price performance (52-week range, moving averages, price changes over time) • Competitors comparison (symbol, price, market cap) • Financial statements (income, balance sheet, cash flow) • Key metrics & ratios (P/E, ROE, ROA, debt ratios, margins) • Analyst ratings & recommendations (Strong Buy/Buy/Hold/Sell/Strong Sell) • Analyst price targets (consensus, median, high, low) • Analyst estimates (forward revenue & EPS projections for next 8 quarters) • Latest earnings release (actual vs estimated, surprise %) • Earnings calendar & upcoming earnings dates • Dividend history (dates, amounts, yields, frequency) • Revenue segmentation by product and geography • Sentiment data (last 24h real-time, company-specific news) • Fund trends & institutional holdings (top buyers/sellers, position changes, options activity) • ESG performance scores (Environmental, Social, Governance scores & classifications) • ESG historical trends (yearly ESG scores, performance buckets, sector comparisons) • Workforce signals & employee trend metrics: modeled employee counts and net in/out workforce changes with time-series comparisons (MoM, YoY, trailing-12-month), enabling company growth and contraction analysis regarding job market trends.
→ PRIVATE companies: • Company overview (legal name, status, founded date, headcount, tags, founders, description) • Contact details (phone, email) & headquarters location (region, country, categories) • Web & social links (website, LinkedIn, Twitter/X, Facebook) • Crunchbase rank with trend changes (7/30/90-day) • Sentiment data (last 24h real-time, company-specific news) • Leadership team (executives, board members, advisors with roles and start dates) • Funding rounds (valuation, total raised, round details with investors and lead investors) • Investments made & acquisitions (target companies, amounts, status) • Founder profiles (investment activity, portfolio, exits) • Workforce signals & employee trend metrics: modeled employee counts and net in/out workforce changes with time-series comparisons (MoM, YoY, trailing-12-month), enabling company growth and contraction analysis regarding job market trends.
Filtering: The sections parameter exists for cases where the user EXPLICITLY references specific sections by name or concept. Do NOT use it for general tearsheet requests — omit it to return the complete tearsheet. Data sources: When presenting the tearsheet results to the user, identify the data sources mentioned or implied in the tool response content and add a "Data sources" section at the bottom listing them.
Parameters (2 required, 4 optional)
company_typestringREQUIRED. Must be "Public" or "Private". HARD RULE: Use ONLY the value returned by find_securities — NEVER derive this from your own training knowledge. From find_securities: read the "listing_type" field ("PUBLIC" → "Public", "PRIVATE" → "Private"). This value comes from RavenPack's Point-in-Time (PiT) entity database. It is always present for company entities and is the authoritative source — it may differ from what you believe about the company (e.g. a company commonly known as private may be classified as Public due to a past or current listing). Passing the wrong type returns incorrect data.
PublicPrivaterp_entity_idstringREQUIRED. The 6-character RavenPack entity ID from find_securities response ("id" field). Example: "4A6F00" (Alphabet), "DHLJNI" (RavenPack).
include_source_attributionbooleanWhen true, metric values in the Financial Statements, Financial Ratios, and Key Metrics tables are rendered as clickable [value](url) markdown links pointing directly to the FactSet audit card for that metric and period, allowing every figure to be traced back to its original source. SET TO TRUE automatically when the user asks for any of the following (or similar phrasing): "grounded data", "source of truth", "verified data", "fact-check", "sourced figures", "with sources", "with links", "auditable", "traceable", "cite the source", or any request that implies they want to verify or validate the numbers against an authoritative source. OUTPUT RULE: When include_source_attribution is true, you MUST preserve every [value](url) hyperlink exactly as returned in the tool response when presenting financial figures to the user. Do NOT strip, replace, or summarise these links — each number must remain a clickable link so the user can audit the source. Only applies when the user has access to the FactSet data provider and the company has FactSet fundamentals data. Has no effect when company_type is "Private" — private company tearsheets do not include FactSet fundamentals data. Also has no effect if the sections parameter is used and excludes all of "financial_statements", "financial_ratios", and "key_metrics". Defaults to false.
FalseintervalstringOPTIONAL. The period the financial statements cover: - "quarter" (default): Quarterly financial statements (Q1, Q2, Q3, Q4) - "annual": Annual/yearly financial statements (FY) IMPORTANT: This parameter only applies to public companies and is ignored for private companies. DEFAULT BEHAVIOR: Always use "quarter" unless the user explicitly requests annual data. When users ask for "latest" or "recent" or "current" financial information, use "quarter".
quarterannualquarterplugin_slugstringOptional analytics slug identifying the skill/plugin that drove this call. Omit when not invoked from a published skill.
sectionsarrayOPTIONAL. Filters the tearsheet to the listed sections. DEFAULT BEHAVIOR — DO NOT PASS THIS PARAMETER unless the user EXPLICITLY references one or more specific sections by name or concept (e.g. "financials", "analyst ratings", "ESG", "dividends"). If the user asks for a general tearsheet, company overview, or any broad financial analysis → omit this parameter entirely so all sections are returned. HARD RULE: Use when user says: "show me Apple's financials", "what are the analyst ratings?", "give me the ESG data", "who leads Apple?", "who are Tesla's executives?", "who's on the board?" Do NOT use for: "get me Apple's tearsheet", "tell me about Tesla", "run a full analysis on Microsoft" Only applies to public companies. Ignored for private companies. Valid values: - "company_overview" - Company profile, price performance, and description - "c_level_leadership" - The people leading the company: executives, board members, management stats (requires FactSet access) - "financial_ratios" - Gross margin, P/E, P/B, debt ratios (TTM) - "key_metrics" - EV, EV/EBITDA, ROE, ROA, free cash flow yield (TTM) - "dividends" - Dividend history, yields, and frequency - "analyst_estimates" - Forward revenue and EPS projections - "latest_earnings" - Most recent earnings actual vs estimated - "earnings_calendar" - Upcoming earnings dates - "financial_statements" - Income statement, balance sheet, cash flow - "revenue_segmentation" - Revenue breakdown by product and geography - "analyst_ratings" - Analyst recommendations and price targets - "fund_trends_history" - Institutional holdings and options activity - "hiring_trends" - Employee count trends and workforce signals - "esg_performance" - Environmental, Social, Governance scores - "mergers_acquisitions" - M&A activity (requires FactSet access) Example: ["financial_statements", "analyst_ratings"]
null