Functions on certificates

Master data for certificates

Certificate.barrier→number

Result: The Barrier function provides the barrier for various certificate types.

Certificate.BonusLevel→Number

Result: The BonusLevel function returns the bonus for bonus certificates.

Certificate.cap→number

Result: The Cap function returns the cap for various certificate types.

Certificate.CertificateType→Certificate type

Result: The function returns the type of certificate.

Certificate.EDGScoreRC1→number

Result: The EDGScoreRC1 function provides the EDG certificate rating (number of stars) of the certificate in risk class 1 (security-oriented).

Certificate.EDGScoreRC2→number

Result: The EDGScoreRC2 function provides the EDG certificate rating (number of stars) of the certificate in risk class 2 (limited risk appetite).

Certificate.EDGScoreRC3→number

Result: The EDGScoreRC3 function provides the EDG certificate rating (number of stars) of the certificate in risk class 3 (risky).

Certificate.EDGScoreRC4→number

Result: The EDGScoreRC4 function provides the EDG certificate rating (number of stars) of the certificate in risk class 4 (more risky).

Certificate.EDGScoreRC5→number

Result: The EDGScoreRC5 function provides the EDG certificate rating (number of stars) of the certificate in risk class 5 (speculative).

Certificate.EDGScoreTopClass→Number

Result: The EDGScoreTopClass function returns the EDG certificate rating (number of stars) of the certificate in the EDG risk class ("top risk class").

Certificate.emissionvolume→number

Result: The IssueVolume function returns the issue volume.

Certificate.issuer→Issuer

Result: The Issuer function returns the issuer.

Certificate.ExerciseStyle→ExerciseType

Result: The ExerciseStyle function provides the exercise type (American, European...).

Certificate.fee→number

Result: The Fee function provides the fees.

Certificate.financialinnovation→Boolean

Result: The financial innovation function returns "True" if the certificate belongs to the class of financial innovations and had to be taxed accordingly before the introduction of the flat-rate withholding tax.

Certificate.GuaranteeLevel→Boolean

Result: The GuaranteeLevel function provides the guarantee threshold for guarantee products.

Certificate.IsKnockedOut→Boolean

Result: The IsKnockedOut function shows whether a certificate is knocked out .

Certificate.IsNonMaturing→Boolean

Result: The IsNonMaturing function returns "True" if it is an endless certificate. In the certificate master data, you will find the "Endless certificate" checkbox on the "Advanced" tab.

Certificate.IsQuanto→Boolean

Result: The IsQuanto function shows whether the security is currency-hedged.

Certificate.IsRolling→Boolean

Result: The IsRolling function returns "True" for rolling certificates.

Certificate.IssuePrice→Number

Result: The IssuePrice function returns the issue price.

Certificate.KnockInBarrier→Number

Result: The KnockInBarrier function returns the knock-in threshold.

Certificate.KnockInDate→Date

Result: The KnockInDate function returns the date of the knock-in.

Certificate.KnockOutDate→Date

Result: The KnockOutDate function returns the date of the knockout.

Certificate.term→Date

Result: The runtime function returns the runtime of the paper as a date if it is not endless.

Certificate.PaymentDate→Date

Result: The PaymentDate function returns the payment date of the certificate.

Certificate.ParticipationLimit→Number

Result: The ParticipationLimit function returns the participation limit.

Certificate.participationRate→number

Result: The ParticipationRate function provides the participation rate, e.g. for outperformance certificates.

Certificate.ProductNameIssuer→String

Result: The ProductNameIssuer function returns the product name of the issuer.

Certificate.ProtectLevel→Number

Result: The ProtectLevel function provides the security limit for Protect products.

Certificate.range→Barrier type

Result: The Range function returns the barrier type as "Above", "Below" or "Within".

Certificate.SpeculationType→SpeculationType

Result: The SpeculationType function returns the speculation direction as long or short.

Certificate.StopLoss→Boolean

Result: The function returns "True" for existing stop/loss or knockout thresholds.

Certificate.strike→number

Result: The Strike function provides the strike for various certificate types.

Certificate.StrikeCurrency→Currency

Result: The StrikeCurrency function returns the currency of the strike price for various certificate types.

Certificate.SubscriptionRatio→Number

Result: The SubscriptionRatio function provides the subscription ratio of a certificate.

Key figures for certificates

Certificate.discount→number

Result: The Discount function provides the absolute discount for standard discount certificates.

Certificate.DiscountPercent→Number

Result: The DiscountPercent function provides the relative discount for standard discount certificates.

Certificate.DistanceCap→number

Result: The DistanceCap function provides the absolute distance to the cap for standard discount certificates.

Certificate.DistanceCapPercent→number

Result: The DistanceCapPercent function provides the relative distance to the cap for standard discount certificates.

Certificate.maximumyield→number

Result: The MaximumYield function provides the maximum yield for standard discount certificates.

Certificate.maximumyieldPA→number

Result: The MaximumYieldPA function provides the annualized maximum yield for standard discount certificates.

Certificate.remaining.term[date]→number

Date (date).

Result: The Remaining term function returns the remaining term of the certificate in years.