Advanced Parameter Settings Table

Keyword

Description

Value

datasettype

historical

Historical fundamental

forecast

Estimates

source

Specifies the data provider

WVB

WVB (historical fundamental)

FDS

FactSet (historical fundamental and 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

…

referenceDate

Specifies a specific date. See Period and Reference Date Settings Tables for more details

YYYYMMDD

A date between 1/1/1900 and 31/12/2999 in a valid ISO date format. Can be used only in conjunction with “referencePeriod” to build NTM, or LTM rolling 12 months period.

Today

Refers to today’s date. Can be used to refer to a relative date.

Yesterday

Refers to yesterday's date. Can be used to refer to a relative date.

CWS

Current Week Start (always a Monday). Can be used to refer to a relative date.

CMS

Current Month Start. Can be used to refer to a relative date.

CYS

Current Year Start for the 1^st January of the current year. Can be used to refer to a relative date.

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 Add-in Settings, Functions Module menu, Default values panel.

U

K (default)

M

B

Convert in unit

Convert in thousands

Convert in millions

Convert in billions

roundingDecimals

n

The number n of decimals.

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.