NOV.COMP Function - Novata Excel Add-in Documentation

Description

The COMP function fetches specific field values for a company from the Novata API. This function allows you to retrieve various company attributes such as name, structure, industry classifications, revenue, ownership details, and more by providing the company ID and the desired field name.

Syntax

=NOV.COMP(companyId, fieldName, [fundId])

Parameters

Parameter	Type	Required	Description
`companyId`	String	Required	Unique identifier for the company in the Novata system.
`fieldName`	String	Required	The name of the field you want to retrieve (see available fields below).
`fundId`	String	Optional	Fund identifier. Required when retrieving `company_fund_ownership`.

Available Field Names

You can use any of the following field names as the second parameter:

Basic Information

fund_name

Name of the company

company_structure

Legal structure of the company

company_yoi

Year of incorporation

company_currency

Operating currency

Industry Classifications

company_sics_sector

SICS sector classification

company_sics_industry

SICS industry classification

company_gics_industry

GICS industry classification

company_gics_subindustry

GICS sub-industry classification

company_edci_subindustry

EDCI sub-industry classification

company_deal_sector

Deal sector classification

company_deal_subsector

Deal sub-sector classification

company_edci_growth_stage

EDCI growth stage

Geographic Information

company_op_region

Operating regions

company_country

Country of domicile

company_country_revenue

Primary country for revenue

company_country_FTE

Primary country for FTE employees

Financial & Ownership

company_revenue

Annual revenue

company_investment_year

Year of investment

company_gp_ownership

GP ownership percentage

company_fund_ownership

Fund-specific ownership (requires fundId)

Examples

Example 1: Get Company Name

=NOV.COMP("COMP-001", "fund_name")

Result: "Tech Innovations Inc."

Example 2: Get Company Structure

=NOV.COMP("COMP-001", "company_structure")

Result: "Corporation"

Example 3: Get Year of Incorporation

=NOV.COMP("COMP-002", "company_yoi")

Result: 2015

Example 4: Get GICS Industry

=NOV.COMP("COMP-001", "company_gics_industry")

Result: "Software & Services"

Example 5: Get Annual Revenue

=NOV.COMP("COMP-003", "company_revenue")

Result: 25000000

Example 6: Get GP Ownership

=NOV.COMP("COMP-001", "company_gp_ownership")

Result: 65.5

Example 7: Get Fund-Specific Ownership (with optional fundId)

=NOV.COMP("COMP-001", "company_fund_ownership", "FUND-001")

Result: 45.2

Example 8: Get Operating Region

=NOV.COMP("COMP-002", "company_op_region")

Result: "Asia Pacific"

Important Notes

Note:

The first two parameters (companyId and fieldName) are required.
The fundId parameter is optional for most fields but required when using company_fund_ownership.
The companyId must be a valid company ID from your Novata system.
Field names are case-sensitive. Use the exact field names listed above.
If the field doesn't exist or the company is not found, the function will return an error message.
Make sure you're logged into the Novata Excel Add-in before using this function.

Related Functions

NOV.FUND - Retrieve fund attributes
NOV.METRIC - Retrieve metric information
NOV.ANSWER - Retrieve answer data
NOV.REPORT - Retrieve report information