Skip to content

Octagon Deals Agent

Model Name: octagon-deals-agent

A specialized database agent for M&A and IPO transaction analysis.

Capabilities

  • Retrieve information about mergers and acquisitions
  • Track initial public offerings and valuation metrics
  • Analyze financial transactions across industries
  • Monitor corporate deal activity
  • Compare transaction multiples

Use Cases

The Deals Agent is best for:

  • Research on corporate transactions
  • Analyzing IPO valuations and performance
  • Tracking M&A activity in specific sectors
  • Understanding acquisition strategies of major companies
  • Benchmarking transaction valuations

Example Queries

  • "What was the acquisition price when Microsoft acquired GitHub?"
  • "List the valuation multiples for AI companies in 2024"
  • "List all the acquisitions and price, valuation by Salesforce in 2023?"

Code Examples

Python
response = client.responses.create(
    model="octagon-deals-agent",
    input="What was the acquisition price when Microsoft acquired GitHub?",
    stream=True
)
JavaScript
const response = await client.responses.create({
  model: "octagon-deals-agent",
  input: "What was the acquisition price when Microsoft acquired GitHub?",
  stream: true
});
cURL
curl -X POST https://api.octagonagents.com/v1/responses \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer your-octagon-api-key" \
  -d '{
    "model": "octagon-deals-agent",
    "input": "What was the acquisition price when Microsoft acquired GitHub?",
    "stream": true
  }' \
  --no-buffer

Available Fields and Descriptions

How to Use These Fields

When querying the Octagon Deals Agent, you can reference these field names to request specific information about M&A and IPO transactions. For example, you can ask "What was the Deal Size for Microsoft's acquisition of GitHub?" or "List all deals with Deal Class of Private Equity where Percent Acquired was over 80%." You can also combine multiple fields for targeted research, such as "Show me technology sector acquisitions with Post Valuation over $1 billion in the last year."

Deal Basic Information

FieldDescription
Registration NumberUnique identification number assigned to a security during the registration process for public offerings
Deal TypeThe type of the deal (IPO, Corporate, Merger/Acquisition, Joint Venture, Merger of Equals, Public Investment 2nd Offering, Reverse Merger)
Deal ClassThe type of investment deal, categorized as Corporate, Public Investment, Other, Individual, or Private Equity
Deal StatusThe status of a deal in the IPO process (completed or announced/in progress)
Deal SynopsisBrief descriptions of the IPO deal
Deal DateThe column holds dates of IPO deals
Announced DateThe column holds the announced date for each IPO deal in variant format
Deal Business StatusThe status of the deal's business phase
Deal Financing StatusThe status of financing for the IPO deal
Add-onIndicates whether an additional feature or service is included in the IPO deal
PricedIndicates whether the IPO deal has been priced or not
Percent AcquiredThe percentage of shares acquired in a private market deal
Contains Cross BorderIndicates whether the IPO deal involves cross-border transactions

Financial Details

FieldDescription
Deal SizeThe column holds deal sizes represented as JSON objects with an "amount" key and a currency code as a string
Deal Size StatusThe status of the deal size estimation, either "Estimated" or "Actual"
Deal Size RevenueThe size of the deal in revenue
Deal Size EBITThe deal size in ebits (earnings before interest and taxes)
Deal Size EBITDAThe deal size measured in EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortization)
Deal Size Net IncomeThe deal size in net income (dollars)
Deal Size Cash FlowThe amount of cash flow generated from a deal
Pre-Money ValuationThe column holds the premoney valuation data in various formats
Post ValuationThe column holds data representing post-valuation financial information
Price Per SharePrices per share, represented as JSON objects containing an "amount" field and a "asOfLiveCurrency" field
Total Invested EquityThe total invested equity in the deal, represented as a JSON object containing the investment amount and its associated currency
Total VC FundingThe total amount of venture capital funding in decimal format
VC RoundA column holding data representing the series of venture capital financing rounds for a company
VC Round Up/Down/FlatIndicates the round of venture capital investment, with values representing up-round, down-round, or flat financing events
Native CurrencyCurrencies represented in native form

Company Financial Information

FieldDescription
RevenueThe column represents monetary revenue values
Revenue GrowthThe change in revenue from the previous period
Gross ProfitThe column represents the gross profit as a decimal value
EBITEBIT values represent earnings before interest and taxes
EBITDAEBITDA: earnings before interest, taxes, depreciation, and amortization
EBITDA MarginThe EBITDA margin, a measure of a company's profitability, calculated as EBITDA divided by revenue
Net IncomeThe column represents monetary values of net income or loss
Implied EVThe column IMPLIEDEV holds data representing monetary amounts in various currencies
Implied EV RevenueThe implied revenue generated from a financial investment or deal
Implied EV EBITThe implied earnings before interest and taxes (EBIT) value
Implied EV EBITDAThe implied EBITDA value, represented as a decimal number
Implied EV Cash FlowThe implied cash flow, represented as a decimal value
Fiscal YearFiscal years represented as decimal numbers
Valuation RevenueThe column represents the valuation revenue in decimal format
Valuation EBITThe column represents the valuation of a company based on its earnings before interest and taxes (EBIT)
Valuation EBITDAThe valuation of a company based on its earnings before interest, taxes, depreciation, and amortization (EBITDA)
Valuation Net IncomeThe net income used in valuation calculations
Valuation Cash FlowThe column represents cash flows used in calculating the valuation of an IPO deal
Valuation StatusThe status of the valuation for an IPO deal

Debt Information

FieldDescription
Debt RaisedThe column "DEBTRAISED" holds data representing the amount and currency of debt raised in a variant format
Debt Raised EBITDAThe difference between a company's debt and its earnings before interest, taxes, depreciation, and amortization (EBITDA)
Debt Raised EquityThe amount by which debt was reduced in the equity financing deal
Total DebtThe total amount of debt in decimal format
Total Debt AmountThe column holds monetary values in various currencies
DebtsA column holding data representing various debt information
Debt and LendersA column holding data of type VariantType representing the debt and lenders involved in the IPO deals
Has Amended DebtsIndicator of the presence or absence of amended debts
First Lien AmountThe amount of the first lien on an IPO deal
First Lien OIDA column holding data of type DecimalType, potentially serving as a unique identifier for the first line in an IPO deal record
First Lien FloorThe price at which a lender is willing to extend the first lien mortgage loan
First Lien YTM PrimaryA column holding data of type VariantType representing temporary primary keys in first lien IPO deals

Investment and Funding Information

FieldDescription
InvestorsA column holding data representing investor information in a variant format
Investor CountThe number of investors involved in each IPO deal
Investor FundsA column holding data representing investor funds in a variant format
Lead InvestorThe identity of the lead investor in the IPO deal
First Time InvestorsA column holding data indicating whether each entry represents a first-time investment or not
First Time Investor CountNumber of first-time investors in a deal
Follow-on InvestorsA column holding data representing the list of follow-on investors
Follow-on Investor CountThe number of investors following a particular IPO deal
Financing StatusThe financing status of the deal, indicating the current stage of funding
Financing Status NoteNotes on the financing status of the deal
LendersA column holding data representing the names and identifiers of the lenders involved in the IPO deals
Contingent PayoutThe column holds data representing contingent payout amounts in various currencies
Anti-Dilution ProvisionsVariants of antidilution provisions in IPO deals

Company Information

FieldDescription
Company NameThe column holds the name of the company represented in the JSON format
Company WebsiteThe URL address of the company's official website
Business StatusThe status of the business, categorized as Generating Revenue, Not Profitable, Profitable, Clinical Trials - Phase 1, Startup, Restart, Out of Business, Bankruptcy: Admin/Reorg, Product Development, or Clinical Trials - Phase 2
Year FoundedThe year the IPO deal was founded
Current EmployeesThe number of current employees for each record in the MA_IPO_DEALS table
Employee CountThe number of employees associated with each IPO deal
DescriptionBrief descriptions of business services or products offered by the IPO deals

Industry Classification

FieldDescription
Primary Industry CodeThe primary industry code representing the main business sector for each deal
Primary Industry GroupThe primary industry group classification
Primary Industry SectorThe primary industry sector classification of the IPO deals
All IndustriesAn array of industry sectors represented as text strings
VerticalsThe vertical industries represented in the MA_IPO_DEals table
KeywordsAn array of keywords describing the business sectors or industries associated with each IPO deal
UniverseAn array of deal universe categories
Emerging SpacesA column holding data representing the emerging technology spaces

Patent Information

FieldDescription
Active PatentsA column holding data representing the number of active patents
Inactive PatentsA column holding data representing the status of patents, with values indicating inactive patents
Pending PatentsA column holding data representing the number of pending patents
Total Patent DocumentsThe number of patent documents associated with each IPO deal
Total Patent FamiliesThe number of patent families associated with each IPO deal
Patents Expiring in Next 12 MonthsIndicators for patents expiring within the next 12 months

Location Information

FieldDescription
HQ LocationThe headquarters location of the IPO deals
HQ CityThe city where the headquarters of the IPO companies are located
HQ State/ProvinceThe two-letter abbreviation for the headquarters' state or province
HQ CountryThe country where the headquarters of the IPO deal is located
HQ RegionThe region where the headquarters of the IPO company is located
HQ SubregionThe sub-region where the company headquarters is located
HQ Zip CodePostal codes of headquarters locations

Contacts and People

FieldDescription
Full NameA column holding data representing the full name of individuals, in a JSON format
BiographyBrief descriptions of individuals involved in MA IPO deals
EducationInformation about an individual's educational background, including degree, field of study, and year of graduation
EmailEmail addresses
PhonePhone numbers in various international formats

Sellers and Exiters

FieldDescription
SellersAn array of seller names or entities involved in the IPO deals
ExitersNames of individuals or entities that have previously exited (sold or IPO'd) from companies represented in this table

Service Providers

FieldDescription
Service ProvidersA column holding data representing various service providers involved in IPO deals
Sell-Side SPsArray of strings, each containing an advisor's role and name in the IPO deal
Buy-Side SPsA column holding data representing the identities of buy-side firms participating in IPO deals
Sell-Side Inter SPsArray of strings representing the names of sell-side intermediaries involved in the IPO deals

Other Financial Fields

FieldDescription
US AmountThe column holds monetary values in US dollars
EUR AmountA column holding data of type VariantType representing monetary amounts in Euros
TLB AmountA column holding data of type VariantType representing the total amount invested in a private market IPO deal
RC AmountA column holding data of type VariantType representing the amount invested in private market IPO deals
HY Bond AmountThe amount of hybrid bonds issued
US First Lien New MoneyThe column holds data representing the amount of new money invested by US first lien investors in IPO deals
US First Lien Institutional New MoneyA column holding data of type VariantType representing institutional new money investments in US first lien positions
US Total Institutional New MoneyTotal amount of new institutional investment in US dollars
Total New MoneyThe total amount of new money raised during the IPO deal
Total First Lien Institutional New MoneyThe total amount of new institutional money invested as the first lien in the IPO deals
New Institutional AmountThe column holds data representing the new institutional investment amount
Total New Inst AmountThe total net investment amount in the IPO deals
Contains Cov LiteIndicates whether the IPO deal contains confidential information
Cov Lite AmountA column holding data representing the coverage team's allocated amount for IPO deals
LCD Issuer IDsUnique identifiers for the underwriting syndicate members involved in the IPO deals
LCD Super Transaction IDA column holding data of type DecimalType, potentially representing unique identifiers for large-scale financial transactions
STLaunch DateThe date when a private market IPO deal was launched

Note: Not all fields will be populated for every transaction, and some fields may only apply to certain types of deals (M&A, IPO, Private Equity, etc.).