Functions errors codes and definition

#Err 1001

Session timeout : please refresh.

The connection has expired.

Close Excel and restart it.

#Err 1002

Session revoked : please refresh.

The connection has expired.

Close Excel and restart it.

#Err 1003

Internal Error.

The request encounter a server error.

Either use "Recalculate Formula" or close Excel and restart it.

#Err 1005

Internal Server Error.

The request or connection encounter a server error.

Either use "Recalculate Formula" or close Excel and restart it.

#Err 1007

Service Unavailable.

The connection or request has failed.

The database server could not be reached.

#Err 1008

Connection Error.

The connection has failed.

Check your credentials and your network. The database server could not be reached.

#Err 1010

IDP Communication Error - Wait, Retry or check your credentials.

The IDP Manager needed for specific functions is:

• Not started yet.

• Your credentials are not recognized.

• The formula has not been updated since the launch of IDP Manager.

Open the RTD() panel to enable first connection of IDP Manager.

Update the formula with error.

If the error remains:

• Try to change a parameter in the formula. Wait one minute and refresh it.

• Close Excel and restart it.

#Err 2000

Error Getting Data.

The data retrieved could not be read or has not a proper format.

Refresh the formula by changing a parameter or click on "Recalculate Formula".

#Err 2002

Invalid contribution value.

The value to be contributed via

has not a proper format.

Change the value to be contributed.

#Err 2004

Contribution fields and value are not coherent.

Number of fields is higher or less than number of value to be contributed.

Check that you have selected as many fieldsId cells than value cells in your 

formula.

#Err 2005

Contribution : invalid array.

The list of fields or list of values selected should represent a one dimensional array (one row of value or one column of value only).

Check that your 

formula is set with proper parameters and cells selection.

#Err 2007

No data to contribute.

Cells selected for fieldId or value are empty.

Check the parameters of your

formula.

#Err 3001

Invalid Company Code.

The code set in formula has not a proper format and is not recognized.

Check your code using CodeLookUp, INFCODECONVERT() or  and Analytics platform.

#Err 3002

No match found.

Impossible to transform code used in formula into CompanyCode.

INFGET(), INFGETHIST() and INFGETTABLE() can request data only on Company/Stock or for some fields on Index. The code used is not recognized in database. Use 

or 

to retrieve the proper code for the company requested.

#Err 3003

Invalid Index code or name.

The name or code used for Index is not recognized.

You can check the updated list of indices using INFGETINDEXES() function.

#Err 3004

Invalid code.

The code used in INFGETSYMBOLTYPE() is null, empty or not recognized.

Check your code using CodeLookUp, INFCODECONVERT() or  and Analytics platform.

#Err 3010

Invalid field_name.

The FieldId or FieldName used in formula has no equivalent in Field dictionnary.

Use the

.

#Err 3011

Unauthorized field.

The field could not be used as calculated fields, in specific functions or user has not the rights to access it.

Some fields cannot be requested as

or in functions as

or

for example.

#Err 3013

Invalid field (name or type). Calculation fields are not handled.

The field used could not be used as calculated one.

Check the list of

and use the INFGET Panel to check possibility for each field.

#Err 3014

Not implemented yet.

Some field cannot be request with Index.

Some fields cannot yet be used in formula using Index as CompanyCode in functions.

#Err 3015

Feature not available - Upgrade to Infront Professional Terminal.

User cannot access some specific functions whithout rights, credentials and access.

Functions like INFALLLISTINGS(), INFINSTRUMENTSEARCH() and INFCONTRIBUTE() are not accessible without account.

#Err 3016

Feature not available - You need a specific package to use it.

function is not available for all users yet and needs specific package to be used.

Contact

to ask them to add the specific package to your user's profile.

#Err 3020

Period : Missing parameter.

The 3rd parameter in

function is missing and needed for this field.

You can use INFGET() panel or

.

#Err 3021

Period : Invalid keyword.

The referencePeriod or referenceDate used in 3rd parameter is not recognised.

Check specific keywords used for

.

#Err 3022

The field "xxxx" doesn't support periods "xxxx", but expects a reference date.

The 3rd parameter for this formula should be a Date or referenceDate instead of a referencePeriod.

Check the

parameter of your formula. You can use INFGET() or INFGETHIST() panel (depending on the formula) or

.

#Err 3023

Invalid or missing dates range (start date, end date or duration).

A date or duration is missing or not recognized in 3rd or 4th parameter or both of

formula.

Check your formula. You can use INFGETHIST() panel.

#Err 3024

Invalid or missing start date.

Only the 3rd parameter of

formula is missing or not recognized.

Check your formula. You can use INFGETHIST() panel.

#Err 3025

Invalid or missing end date or duration.

Only the 4th parameter of

formula is missing or not recognized.

Check your formula. You can use INFGETHIST() panel.

#Err 3026

Invalid or missing duration parameter.

The 4th parameter of

or the 3rd parameter of

for specific fields as BETA or VOLATILITY is not recognized.

Check your formula. You can use INFGETHIST() or INFGET() panel.

#Err 3030

AdvParam : Invalid parameter.

The parameter used is not enabled in this function.

Use INFGET() or INFGETHIST() panel or check the list of parameters enabled in each function using Help Center documentation:

• INFGET() advanced parameters

• INFGETHIST() advanced parameters

• INFGETTABLE() advanced parameters

• INFINSTRUMENTSEARCH() & INFALLLISTINGS() advanced parameters

• INFCONTRIBUTE() advanced parameters

#Err 3031

AdvParam : Invalid Json.

The json format used to add list of parameters has not a proper format.

You can pass harcoded advanced parameters in formula using Json format:

• "{'parameter1':'valueForThisParameter','parameter2':'valueForThisParameter'}"

• the separator between 2 different parameters could be a coma (,) or a semi-column (;) depending on regional settings.

 "{'referenceDate':'today','currency':'EUR'}"

Or you can refered to a 2 dimensional array Excel cells:

Unknown Attachment

#Err 3032

Currency : Invalid currency code or name.

The currency code or value selected is not recognized.

The error can be displayed either as a result of an INFGET() formula or in INFGET() panel. Use the list of currencies available in INFGET() panel (advanced parameters section) to select the good one.

#Err 3033

AdvParam : Expecting 2 columns array.

The cell selection for advanced parameter is no consistent.

Advanced parameter passed in 2 dimensional array should be referenced as an array of 2 columns.

Unknown Attachment

Unknown Attachment

#Err 3034

Invalid frequency parameter.

The value selectef for frequency parameter is not recognized.

Frequency parameter has only 4 values:

• daily

• weekly

• monthly

• yearly

In INFGET() formulas, only the fields BETA or UNLEVEREDBETA uses frequency to run its calculation. But in this case the YEARLY frequency is not enabled.

In INFGETHIST() formulas, some fields like TARGETPRICE or CONSRECO doesn't enabled the DAILY frequency.

#Err 3035

Invalid property parameter: no more than 8 columns.

table could display till 8 columns depending on the field selected.

Change the value of the property parameter to match the column to display.

#Err 3036

Invalid property parameter: Dividends table has only 3 columns.

You have selected a value for the

that is not compatible with the number of columns available for this field.

Change the value of the property parameter to match the column to display.

#Err 3037

Invalid rank parameter: no more than 10 rows.

table could display till 10 rows for company details fields.

Change the value of the rank parameter to match the row to display.

#Err 3040

Multiple cells selection : you can only select one cell.

You cannot select more than one cell to use cell reference in INFGET() panel or INFGETHIST() panel.

This error appears only in panel. User should select the proper cell to build his formula.

#Err 10000

This error code is used for unhandled errors or exceptions.

This error code may be related to multiple messages. These are rare errors or exceptions that are not easily catchable or identifiable.

#Err 5

Not Available.

No data is available for this formula.

Try to change the period or source.

#Err 23

No available report for the selected year.

No data is available for this period (year).

Try to change the period or source.

#Err 67

Reference currency is unknown [%s].

Unable to retrieve the market currency for this company / instrument.

Usually the company is inactive or have a non liquid market history.

#Err 68

No data available for the requested `reference period` - over 120 months.

The period or date used in 3rd parameter is over 10 years time.

INFGET() & INFGETHIST() covers till 10 years prior to today of data.

#Err 69

Field {TOTINVSEC, with source: MRS} is not available in due to company model type.

In this case, an industrial company cannot access to field TOTINVSEC (Total investments securities) with source MRS (MorningStar).

Some fields are specific to a source and to a company model type.

#Err 70

Field TOTINVSEC, with source: WVB is not available.

In this case, the field TOTINVSEC (Total investments securities) is not available with source WVB.

Some fields are specific to a source.

#Err 74

Datasettype value is not valid - available options are: `historical` or `forecast`.

The value set for advanced parameter "datasettype" is not recognized.

The only values available are "Historical" and "Forecast".

#Err 75

No data available for the selected period.

No data is available for this period (year / interim / referencePeriod).

Try to change the period or source.

#Err 78

Year value is not valid - available options are [Q1,Q2,Q3,Q4,S1,S2,H1 or H2]

The interim period is not recognized.

An interim period is a combination of a year:quarter.

2020:S1 for 1st semester of 2020
2017:Q3 for 3rd quarter of 2017

#Err 79

No interim report available with forecast data.

No data is available for this period (interim) with a datasettype set to forecast.

Try to change the period or source.

#Err 80

LTM period for: "xxxxxx" is over 12-Months - (interim period length:3)

The reference date of the formula doesn't enable enough history to calculate the LTM period.

Try to change the reference date.

#Err 81

Reference period shortcut is unknown [].

The keyword used as a value for Period (3rd parameter) or referencePeriod (advanced parameter) is not recognized or those not have value for this request.

Check the

or use the

.

#Err 82

Reference date is malformed. Please use this date format: YYYYMMDD.

The date used in the 3rd parameter of INFGET() or INFGETHIST() or in advanced parameter has not a proper format.

Check the

A date can be set using an Excel Date format or text formated "YYYYMMDD". You can use the

.

#Err 84

Reference date invalid - please use +/- attributes with [`day`,`week`,`month`,`year`] parameter.

The keyword used as referenceDate is incomplete or not recognized.

Check the specific format for referenceDate. Some specific keyword can be extended;

CYS+1Y means CurrentYearStart + 1 Year 
CWS-3D means CurrentWeekStart (monday) - 3 days = friday last weeek

You can use the PeriodPicker.

#Err 85

Invalid future reference date.

The keyword used as referenceDate is not recognized or non compatible with calculation fields.

Check the

or use the

.

#Err 88

Field: [CASHSTINV] not available in the service type: [ESTIMATES].

Some field cannot be requested with estimates parameter (forecast period or datasettype).

Try to change the period, datasettype (using historical option) or source.

#Err 89

Unknown Scale factor shortcut: [p] - available options are: `u|unit`, `k|thousands`, `m|millions`, `b|billions`

The value set for scale factor parameter (advanced parameter) is not recognized.

The only values for scale factor are:

• u or unit,

• k or thousands

• m or millions

• b or billions

#Err 90

Unknown Quotes adjustment keyword: [skit] - available options are: `split`, `splitDividends`, `no`

The value set for adjustment parameter (advanced parameter) is not recognized.

In INFGETHIST(), adjustment parameter can handle only 3 values:

• split

• splitDividends (not implemented yet)

• no

#Err 91

[DAYSACCPAYABLE] is no available for: [FORECAST] dataset

Some fields cannot be requested with estimates parameter (datasettype set to forecast).

Try to change the period, datasettype (using historical option) or source.

#Err 92

NTM period is not available for [BVPS].

Some fields cannot be requested with NTM period.

NTM means Next Twelve Months (estimates).

Try to change the period, datasettype (using historical option) or source.

#Err 93

Duration shortcut is unknown [150YARS].

Some fields use the duration parameter instead of a date or period. This duration is not recognized.

Use the INFGET() or INFGETHIST() panel.

#Err 100

No Interim data available for this instrument.

No data is available for this period (interim).

This error appears ususally with a source set to Infront or for a company which has Infront as best source. Try to change the period or source.

#Err 101

No data available with source: [Wvb].

No data is available for this specific source (WVB).

This error appears ususally with a source set to WVB or for a company which has WVB as best source. Try to change the period or source.

#Err 102

Source: [SOMETHING] is not valid.

The value set as a source is not recognized.

The sources available are:

• Auto (best source)

• MorningStar (MRS) for fundamental and historical data

• S&P (SNP) for estimates data

• WVB

• Infront

#Err 103

LTM period is not available for [DPS].

Some fields cannot be requested with LTM period.

LTM means Last Twelve Month.

Try to change the period, datasettype (using historical option) or source.

#Err 104

Field attribute [MEDIANS] is unknown.

The attribute selected in the calculation field is not recognized.

Use INFGET() panel or check fields and enabled attributes in

.

#Err 105

Custom function bad parameter.

The field or parameter selected in the calculation field is not recognized or authorized.

Use INFGET() panel or check fields and enabled attributes in

.

#Err 120

Sorting method is unknown.

The value for "sorting" parameter is not recognized.

User can choose to display history of time series points via INFGETHIST() with the sorting parameter using two values:

• DESC for descending order.

• ASC for ascending order.

#Err 122

No estimates as reported data available.

The company does not have

data available.

Only some companies are covered by the estimates data service. List of those companies is available in the INFGETTABLE model present in Analytics Library.

#Err 125

Reference date is malformed. Start date and end date should be different.

3rd and 4th parameters of

cannot be set using the same date.

Use INFGETHIST() panel or

.

#Err 129

Reference date cannot be set in the future.

Time series fields cannot be requested with a future date. No estimates data is available for time serie points.

Use INFGET() panel or

.

#Err 130

Duration expression is malformed.

The duration parameter set in the calculation field is not recognized.

Use INFGET() panel or check enabled attributes in

.

#Err 131

No data available for this instrument.

No ESG score available for this company.

This company doesn't publish their ESG score or the company is not covered by the specific source for ESG.

#Err 141

FactSet data is no longer available.

The source set to FactSet is not recognized anymore.

Change the source:

• to MorningStar (MRS) for fundamental or historical data.

• to S&P (SNP) for estimates data.

#Err 142

No data available for this instrument.

No data is available for this field for this company.

Try to change the period or source.

#Err 202

Incompatible Field ID parameter.

The field or attribute selected in the calculation field is not compatible with the period.

Use INFGET() panel or check fields and attributes enabled in

.

#Err 204

CAGR: Beginning Balance should be positive or equals to 0.

The calculation of CAGR could not be done using the field or period selected.

Use INFGET() panel, change the period or check enabled fields and attributes in

.

#Err 251

No data available.

There is not enough history to calculate the formula. It has trigger an arithmetic error.

Try to change the period or reference date.

#Err 252

No data available.

The field is calculated from multiple data in database and an error occurred (missing value for example).

Try to change the period or source.

#Err 254

No data available.

No data is available for this calculation field for this company.

Use INFGET() panel, change the period or check enabled fields and attributes in

.

#Err 255

DAILY frequency not available for this field: TARGETPRICE.

INFGETHIST() cannot retrieve history of time series points for TARGETPRICE with a daily frequency.

Fields as TARGETPRICE and CONSRECO could only be requested on:

• Weekly frequency

• Monthly frequency

• Yearly frequency

Other fields used in INFGETHIST() can be requested using DAILY frequency.

#Err 300

No data available.

No time series point is available for this field at this date for this company.

Try to change the date.

#Err 331

Indice no data available.

The indice used in the compared instrument parameter needed to calculate BETA or VOLATILITY fields is not recognized.

Use INFGET() panel and check

.

#Err 1006

No data available.

The companyCode or InstrumentCode has no match in database.

Company could be inactive.

#Err 4003

No data available.

There is not enough data to calculate the BETA value for this company.

Try to change the date or duration.