Functions on securities

Securities are represented in MM-Talk by two equivalent object types, the security object (security) and the quote object (price quotation). Security objects represent the master data of a class, but also receive all price-related attributes and key figures via a default quote object. Quote objects represent the price quotations for different places of a security, if applicable, and therefore essentially carry the price-related data, but also inherit the attributes of their security object.

Securityidentifier→String

Result: The Identifier function provides an external reference key for the security.

Security keys have the format for securities:
SID:<SecurityId>:<ISIN>

Security keys have the following format for price quotations (quotes):
QID:<MMWKN>

Security.ESGCoverage[Date]→NumberWithTime

Date (date [evaluation date]): Optional parameter.

Result: The ESGCoverage function returns the most recent value for the ESG coverage (0-100%) of a security (fund) with a timestamp that is available on this date, otherwise "n/a".

Security.ESGRelevance[ESGRiskCategory;Date]→NumberWithTime

ESG risk category (ESGRiskCategory|String).

Date (date [evaluation date]): Optional parameter.

Result: The ESGRelevance function returns the most recent value for the ESG relevance indicator (0-100) of a security with a time stamp that is available for this ESG risk category and on this date, otherwise "n/a".

Security.ESGScore[ESGRiskCategory;Date]→NumberWithTime

ESG risk category (ESGRiskCategory|String).

Date (date [evaluation date]): Optional parameter.

Result: The ESGScore function provides the most recent value for the ESG score (0-100) of a security with a time stamp that is available for this ESG risk category and on this date, otherwise "n/a".

Security.IsQuoteFixed→Boolean

Result: The IsQuoteFixed function returns "True" if the valuation quote has been explicitly stored in the security.

Security.IsSecurity→Boolean

Result: The IsSecurity function returns "True" if the security is a security object. The type check function Is does not allow securities and quotes to be differentiated.

Security.NameSuffix→String

Result: The function returns the name suffix of the price quotations. This field is used if the place code is not sufficient to differentiate the quotations.

Security.OriginalName→String

Result: The NameSuffix function returns the original name of the security object, i.e. without applying the configured name assignment.

Security.PAIReferenceDate[PAIMetric;Date]→Date

PAIMetric (PAIMetric|String).

Date (date [evaluation date]).

Result: The PAIReferenceDate function returns the PAI reference date.

Security.PAIValue[PAIMetric;Date]→(String|Boolean|Number)

PAIMetric (PAIMetric|String).

Date (date [evaluation date]).

Result: The PAIValue function returns the most recent value of the indicator for the security on the date.

Security.ProductProfileCategories→List(IndexString)

Result: The ProductProfileCategories function provides a list of all available target market categories for the security.

Target market" module

Security.ProductProfileCategory[Category]→IndexString|String

Category (category).

Result: The ProductProfileCategory function provides the target market category of the security.

Target market" module

Security.quote→Security

Result: The Quote function returns the valuation quote object for a quote or security object.

Security→Securities

Result: The Security function returns the security object for a quote or security object.

SecurityId→String

Result: The SecurityId function returns the identification symbol of the security object.

List(Security).TargetMarketProfileMatches[Portfolio]→List(TargetMarketMatchResult)

Portfolio (Portfolio): This parameter contains the corresponding portfolio.

Result: The TargetMarketProfileMatches function returns a list of TargetMarketMatchResult on a list of securities, which shows the match of the investment profile of the selected portfolio with the respective target market category of the securities from the target market service.

Even if the "Portfolio" parameter is unassigned ("_"), the target market data can still be queried for the securities in the list - without comparing them with an investment profile.

"Target market" module and "Investment profile recording" module or "Direct investment profile recording" module

Security.WMEndOfBusinessYear[Year]→Date

Year (number): Optional parameter. If the parameter is not set, the current year is set.

Result: The WMEndOfBusinessYear function returns the financial year-end closing from the WM master data for the security in the date format dd.mm.