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.