Skip to main content

INFGETHIST() advanced parameters

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.


Keyword

Description

Value

frequency


Specifies the frequency of the time series points to be retrieved.



Daily or D

One point per day (not available for target price and consensus recommendation). Set by default.

Weekly or W

One point per week.

Would be the default value for target price and consensus recommendation.

Monthly or M

One point per month.

sort


Specifies how to display the range of time series point order by dates.


DESC

In descending order (by default) = form the most recent date to the least one.

ASC

In ascending order.

source
 




Specifies the data provider.




WVB

WVB (historical fundamental).

MRS

Morning Star (historical fundamental).

SNPS&P (historical estimates).

Infront

Infront data source (estimates).

AUTO (default)

Infront Analytics's best source (see help center for rules explanation).

currency
 




Specifies the output currency.




Reference (default)

The currency used by the company when reporting its financial statements.

EUR


USD



adjustment
 



Specifies the way historical values must be adjusted for split and dividends. Applies only to items such as open, high, low, close, volume or dividends.
Default: split.



split

Values are split adjusted.

splitDividends

Values are split and dividend adjusted.

no

Value are not adjusted.

scaleFactor
 

Does not apply on items such as open, high, low, close.
Please note that you can set the default value from the Infront Excel Add-In settings, in the "Functions Module" menu, on the default values panel.
 

U
K (default)
M
B

Convert in unit.
Convert in thousands.
Convert in millions.
Convert in billions.
 

backPadding
 

Applies only to time series items such as open, high, low, close, volume, market capitalization.

n

The number n of days to go backward to find a point.

roundingDecimals


n

The number n of decimals. The default value is set to 4 decimals.

orientation


Specifies the way the array result will be displayed.


Vertical

The date and values would be displayed vertically (set by default).

Horizontal

The date and values would be displayed horizontally.

header


Specifies if the name of the fields selected, the dates of the time series points retrieved or neither of them would be displayed.


Header

Only the name of field is displayed.

Dates

Only the dates are displayed.

Header & DatesThe name of field & the dates are displayed (set by default).
NoneNor field names nor dates would be displayed.
propertySpecifies the number of column to display.from 0 to 8The number of property to be displayed. Some fields handle less columns than others. In this case an error message will be displayed with the maximum of columns available for this table.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.