The INFGETTABLE() function

From the 27th of December 2021, FactSet source will be completely replaced and will be no longer available.

For any issue you may encounter, please refer to our recommendations and workaround. For more information about this process please follow our guidelines and information.

Starting from version v3.41.0 of all those functions will inherit some Real Time Data functions behavior. Thereby, the RTD throttle interval will impact every functions. For more information, please check the handling process of RTD throttling.

INFGETTABLE() allows to retrieve a range of details values available on multiple fields for a given company, as:

Company details:
- The top 10 shareholders.
- The top 10 officers.
- The list of upcoming events.
Estimates details:
- Interim or yearly values.
- Values can be retrieved as high, low, mean or median values.

For more information on how to use array functions in Excel, see the Array Functions mechanism.

Function syntax

INFGETTABLE(company_code,table_name,advanced_parameters)

Function parameter

Description

company_code

Infront Analytics company identifier.

Company code, instrument code and ISIN are supported.

For more information, see The INFCODECONVERT() function. This function can be passed to this argument to convert an ISIN into a company code for example.

Example

00378F: company code for Danone.

LSE:VOD: instrument code for Vodafone.

table_name

The name of the table of elements to retrieve.

Elements available:

List of officers : OFFICERS.
List of shareholders : SHAREHOLDERS.
List of upcoming events : UPCOMINGEVENTS.
List of all estimates values : ESTIMATESASREPORTED.

Example

Officers, Shareholders, UpcomingEvents, EstimatesAsReported

_{Advanced_parameters}

The optional advanced_parameter argument specifies additional information such as:

The interim and the statistics to retrieve for estimates details,
The number of column of row to be displayed for company details.

It can be passed as a 2-dimensional array with a set of keyword-value pair. For more information, see the estimates advanced_parameter table and the compay advanced parameters table.

Only the keyword/value pairs referenced can be used.

Overview

The data are displayed in columns, using a matrix formula. One call from the function will display a table with all the details available for the company selected.

Any changes made to the formula will need to be validated pressing <CTRL>+<SHIFT>+<ENTER> if you are not using Office 365. This is specific to any array function in Excel for those Excel versions.

Company details

Example

To display the list of officers for the company Apple Inc, you should use the function as follow:

INFGETTABLE("30015NU","OFFICERS")

Example

To display the list of shareholders for the company Apple Inc.:

INFGETTABLE("30015NU","SHAREHOLDERS")

Example

To display the list of upcoming events for the company Apple Inc.:

INFGETTABLE("30015NU","UPCOMINGEVENTS")

Specific advanced Parameters

You can here specify if you want to retrieve all the company details or select a specific column of row to retrieve. By default the function will display all the values with headers.

Keyword	Value	Description
`Property`	from 0 to 3	Will display: only the column relative to the number selected. N/A in case the number of columns for the table is less than the number selected. Default: 0, will display all the columns.
`Rank`	from 0 to 10	Will display: only the row relative to the number selected. N/A in case the number of rows available is less than the number selected. Default: 0, will display all the rows.
Header	Select whether to display the name of the property or not.	Header	The name of properties are displayed in first row. Selected by default.
Header	Select whether to display the name of the property or not.	None	The row with properties names is not displayed.

Example

To display only the first officers for the company Apple Inc.:

=INFGETTABLE("30015NU","OFFICERS","{'property':0,'rank':1}")

To display only the name of the first officers of Apple Inc company:

=INFGETTABLE("30015NU","OFFICERS","{'property':2,'rank':1,'header':'none'}")

Estimates details

Example

To display the list of estimates details for Nokia Oyj.:

INFGETTABLE("90006SF","ESTIMATESASREPORTED")

Specific advanced Parameters

You can here specify if you want to retrieve the estimates interim values or not via the "interim" keyword. By default the function will display the yearly values.

Keyword

Value

Description

Interim

True

False

Will retrieve the last interim values available.

Will retrieve the yearly values available.

Default: False, will display the yearly values.

Statistics

High

Low

Mean

Median

Will select the type of value to retrieve.

Default: mean value.

Example

To display the list of interim estimates details for Nokia Oyj.:

INFGETTABLE("90006SF","ESTIMATESASREPORTED","{'interim':'true'}")

Example

To display the list of interim and high estimates details for Nokia Oyj.:

INFGETTABLE("90006SF","ESTIMATESASREPORTED","{'interim':'true','statistics':'high'}")