Finder Bonds
The "Bond Finder" is a table optimized for searching for bonds, which you can use to configure individual search queries via the filter settings. In open security finders, the "Bond Finder" is stored on the worksheet of the same name.
In detail, the "Finder Bonds" contains the following columns:
Column | Description |
|---|---|
Name | The name of the bond. |
WKN | The WKN from the master data of the bond. |
Security no. | The Swiss security number from the bond's master data. |
MMWKN | The MMWKN from the master data of the price quotation (standard valuation place). |
ISIN | The ISIN from the master data of the bond. |
Bond type | The WM bond type of the bond from the master data, e.g. coupon bond, zero bond or convertible bond. |
Bond group | The sector from the bond's master data. |
Interest rate | The interest rate of the bond from the master data. |
Yield | The yield on the bond. The yield formula type of the calculation is "Moosmüller", the period formula type comes from the master data of the bond. |
Remaining term | The remaining term of the bond. |
Interest days | The interest dates of the bond from the master data. |
Interest interval | The interest rate interval of the bond from the master data. |
Interest payment date | The interest payment date of the bond from the master data. |
Course | The most recent price of the bond on the specified price date. |
Course date | The most recent price date for the evaluation date entered. |
Currency | The currency from the master data of the price quotation (standard valuation place). |
Market price risk (EDG risk class) | EDG risk class assigned to the bond. |
You can use the parameters to select a different evaluation date.