Functions
The TMS Excel Toolbar Function Library offers an extensive range of financial functions designed to make Excel a more efficient tool for treasuries and other financial professionals. These features can also be utilized during the data import phase to build advanced reports and perform complex calculations. Here is a breakdown from some of the functions available in the library:
Foreign Exchange Related Functions:
Cross rate calculator: Computes the exchange rate between two currencies using a currency pairs as a reference.
Foreign Exchange Forward cross rate (linear interpolation): Calculates forward exchange rates using linear interpolation.
Extract currency spread from the forward rate: Determines the currency spread implied in the forward rate.
Forward tenor date: Computes the maturity date of a forward contract.
Currency position hedging: Helps manage currency risk by determining optimal hedging strategies.
...
Interest Related Functions:
Create a zero-coupon yield curve (dual curve method supported): Constructs a zero-coupon yield curve using market-observable data and supports dual curve methods.
Calculate interest forward rate: Computes forward interest rates from the yield curve.
Convert interest basis: Transforms interest rates between different day count conventions.
Convert interest compound: Changes the compounding frequency of interest rates.
Linear and spline interpolations: Offers various interpolation methods to estimate rates or yields for maturities not directly observable in the market.
...
Interface Related Functions:
Check if a date is a bank holiday: Verifies whether a specific date is a bank holiday.
Get rate(s) or average rate(s): Retrieves interest rates or average rates from data sources.
...
Common Functions:
Text converters: Provides tools to manipulate and format text data.
Pivot update trigger: Automatically updates Pivot-tables if values are updated within a defined area.
...
In summary, the TMS Excel Toolbar Function Library offers a comprehensive suite of financial functions that enhance Excel's capabilities for treasuries and financial professionals. These functions cover various aspects of foreign exchange, interest rates, data interfaces, and common utility features, allowing users to perform advanced analysis and generate sophisticated reports with ease.