Security:
Name | Type | Mandatory | Description |
---|---|---|---|
<Record Type =”32“> | Long | Y | Type of object to import. 32 is for security |
<DBId></DBId> | Long | Y | Database Id in DeMaSy. It is displayed in Utilities |
<Name></Name> | Char(100) | Y | Name of the Security |
<Description></Description> | Char(255) | N | Security description |
<SerialNumber></SerialNumber> | Char(50) | / | Serial number |
<Code></Code> | Char(50) | Y | Security code used in DeMaSy |
<SecurityType></SecurityType> | Integer | Y | Code type of security (share, bond,…) |
<Basis></Basis> | Integer | Y | For Bonds: 1 = 365/366 2 = 365/365 3 = 365/360 4 = 360/360 Europe 5 = 365/365 Quasi-coupon (US treasury) 6 = 360/360 USA 7 = 360/365 8 = 360/366 |
<SecurityCountry></SecurityCountry> | Char(50) | Y | Issue country (ISO code) |
<StockExchange></StockExchange> | Char(50) | Y | Stock exchange code |
<Currency></Currency> | Char(10) | Y | Security currency (ISO code) |
<IssueDate></IssueDate> | Date/Time | Y | Security issue date (for bonds) |
<IssueRate></IssueRate> | Double | N | Security issue rate (for bonds) – if not provided = 100% |
<IssueValue></IssueValue> | Double | N | Issue value (for bonds) |
<NomValue></NomValue> | Double | Y | Nominal value |
<InterestRate></InterestRate> | Double | Y | Interest rate (for fixed rate bonds) – zero for floating rates (to be provided by the user) |
<FirstIntDate></FirstIntDate> | Date/Time | N | First interest date (for bonds) |
<Frequency></Frequency> | Integer | Y | Coupon frequency ( for bonds ): 1 = Yearly 2 = Twice a year 3 = Quaterly 6 = Twice a month 12 = Monthly |
<MaturityDate></MaturityDate> | Date/Time | Y | Maturity date (for bonds) |
<CouponDate></CouponDate> | Date/Time | Y | Coupon date (for bonds) – format: MMDD |
<FirstCouponDate></FirstCouponDate> | Date/Time | N | First coupon date after issuance date |
<SecurityCode></SecurityCode> | Char(50) | N | / |
<OrgSecurityCode></OrgSecurityCode> | Char(50) | / | / |
</Record> | Y | End of block |