Infront Portfolio Manager

Functions on currencies

Currency.DevPriceFactor[Currency;Date]→Number

Currency (Currency).

Date (date).

Result: The Dev rate factor function returns the factor by which a currency rate is usually multiplied for better readability. Example: 1000 Lire = ... Euro.


FindCurrency→Currency

Result: The FindCurrency function returns the currency object for an abbreviation.

Example: FindCurrency("EUR") returns the currency object for euros.


Currency|Currency string.RiskFreeRateSeries[Consolidation]→Time series

Consolidation: For example, Close 1 for day, 7 for week, 30 for month and n for n-day interval.

Result: The RiskFreeRateSeries function provides the safer interest rate time series (annual interest rate). The values are interpreted here as percentages based on 100.


Currency.secureInterest[date]→number

Date (date).

Result: The SichererZins function returns the safe interest rate for the currency according to the Sicherer-Zins table. The function returns a value as long as there is a value in the associated time series before the default setting.


Currency.exchange rate[target currency;date]→number

Target currency (currency).

Date (date).

Result: The Exchange rate function returns the conversion factor in the target currency at<date>. A string (currency abbreviation) can also be used as the source object (example: "EUR".exchange rate("USD")).


FromCurrency.ExchangeRate[ToCurrency;Interval]→TimeSeries

By currency (currency).

Interval: Consolidation interval (see Close).

Result: The exchange rateZR function provides a time series of the exchange rates between the two currencies.