Description
The FUND function fetches specific field values for a fund from the Novata API. This function allows you to retrieve various fund attributes such as name, currency, operating regions, fund type, vintage year, and more by providing the fund ID and the desired field name.
Syntax
=NOV.FUND(fundId, fieldName)
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
fundId |
String | Required | Custom Fund ID created in the Novata Investor app. This uniquely identifies the fund. |
fieldName |
String | Required | The name of the field you want to retrieve (see available fields below). |
Available Field Names
You can use any of the following field names as the second parameter:
fund_name
Name of the fund
fund_currency
Currency used by the fund
fund_op_region
Operating regions of the fund
fund_country
Country of domicile
fund_inv_region
Investment regions
fund_type
Type of fund
sub_fund_type
Sub-type of the fund
fund_classification
Fund classification
fund_vintage
Fund creation/vintage year
fund_size
Fund size in millions
edci_fund_id
EDCI Fund identifier
custom_id
Custom fund identifier
fund_status
Current status of the fund
ownership_percentage
Ownership percentage
Examples
Example 1: Get Fund Name
=NOV.FUND("FUND-001", "fund_name")
Result: "Global Growth Fund I"
Example 2: Get Fund Currency
=NOV.FUND("FUND-001", "fund_currency")
Result: "USD"
Example 3: Get Fund Vintage Year
=NOV.FUND("FUND-002", "fund_vintage")
Result: 2020
Example 4: Get Fund Size
=NOV.FUND("FUND-001", "fund_size")
Result: 500 (in millions)
Example 5: Get Fund Type
=NOV.FUND("FUND-003", "fund_type")
Result: "Private Equity"
Example 6: Get Operating Region
=NOV.FUND("FUND-001", "fund_op_region")
Result: "North America, Europe"
Important Notes
Note:
- Both parameters are required. The function will return an error if either is missing.
- The
fundIdmust be a valid fund ID from your Novata Investor app. - Field names are case-sensitive. Use the exact field names listed above.
- If the field doesn't exist or the fund 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.COMP - Retrieve company attributes
NOV.METRIC - Retrieve metric information
NOV.ANSWER - Retrieve answer data
NOV.REPORT - Retrieve report information