Finder Fund
The "Fund Finder" is a table optimized for searching for funds, which you can use to configure individual search queries via the filter settings. In open security finders, the "Finder Fund" is stored on the worksheet of the same name.
In detail, the "Finder Fund" contains the following columns:
Column | Description |
|---|---|
Name | The name of the fund. |
WKN | The WKN from the fund's master data. |
Security no. | The Swiss security number from the fund's master data. |
MMWKN | The MMWKN from the master data of the price quotation (standard valuation place). |
ISIN | The ISIN from the fund's master data. |
Fund type | The type of fund, e.g. equity fund, bond fund or fund of funds. |
Country | The country from the fund's master data. |
Issuer | The issuer of the fund from the fund's master data. |
Issue premium | The front-end load of the fund. |
Management fee | The management fee of the fund. |
Volume in million | The fund volume in millions. |
Accumulating? | For accumulating funds the column returns "yes", for all others "no". |
Issue date | The issue date of the fund from the master data. |
Issue price | The issue price of the fund. |
Redemption price | The redemption price of the fund. |
Currency | The currency from the master data of the price quotation (standard valuation place). |
Performance | The 1-year performance of the fund according to the BVI method (BVI Bundesverband Investment und Asset Management e. V.). The calculation interval goes back 1 year from the currently selected evaluation date. Performance of the security |
Performance | The 3-year performance of the fund according to the BVI method. The calculation interval here goes back 3 years from the currently selected evaluation date. |
Sharpe ratio | The Sharpe ratio of the fund. This key figure measures the excess return of a fund over the safe money market investment per unit of risk. |
Market pressure risk | The EDG risk class assigned to the fund. |
Course date | The most recent price date for the evaluation date entered. |
You can use the parameters to select a different evaluation date.