Identificadores e referência
Parte do dicionário de dados de LatAm Bonds by SQX. Lista de campos (.csv)
Identificadores e referência
| Campo | Tipo | Aceita vazio | Descrição |
|---|---|---|---|
isin | text | always filled (key) | International Securities Identification Number of the bond; with pricing_date, the key of the file. |
pricing_date | date | always filled (key) | The date the evaluated price is for (YYYY-MM-DD); with isin, the key of the file. |
cusip | text | filled when on file, else blank | CUSIP or CINS of the bond (nine characters). |
secid | integer | always filled | Exchange Data International security id of the bond line the row prices. |
issuer_name | text | always filled | Legal name of the issuer. |
issuer_country | code | always filled | Country of the issuer's business, read past a foreign financing subsidiary or guarantor. Unit: ISO 3166-1 alpha-2. |
issuer_type | text | always filled | Sovereign, State-owned, Sub-sovereign, Supranational, Bank and financial, or Corporate. |
issuer_sector | text | filled when on file, else blank | The issuer's sector in the SQX industry taxonomy. |
issuer_industry | text | filled when on file, else blank | The issuer's industry in the SQX industry taxonomy. |
security_description | text | always filled | Short description of the bond: coupon, form, maturity, currency and minimum denomination. |
currency | code | always filled | Currency the bond is denominated in. Unit: ISO 4217. |
coupon_type | code | always filled | FIXED, FLOATING, FIXED_TO_FLOATING, STEP, VARIABLE, or NONE (zero coupon). |
coupon_rate | decimal | filled when the bond pays a coupon, else blank | Current annual coupon rate. Unit: percent per year. |
coupon_frequency | code | filled when the bond pays a coupon, else blank | MONTHLY, QUARTERLY, SEMI_ANNUAL, ANNUAL, or AT_MATURITY. |
day_count | text | filled when the bond pays a coupon and the value is on file, else blank | Day count convention interest accrues on. |
issue_date | date | always filled | Date the bond was issued. |
dated_date | date | filled when the bond pays a coupon, else blank | Date interest starts to accrue (interest commencement date). |
first_coupon_date | date | filled when the bond pays a coupon and the value is on file, else blank | Date of the first coupon payment. |
maturity_date | date | always filled | Date the principal is due. |
seniority | text | filled when the issuer is not a sovereign, or EDI ranks the bond and the value is on file, else blank | Rank of the bond in the issuer's capital structure (Senior, Senior Non Preferred, Junior). |
subordinated | flag | filled when on file, else blank | Y when the bond is subordinated to the issuer's senior debt, else N. Where Exchange Data International leaves the flag blank, it follows seniority: Junior and Mezzanine are subordinated. |
issue_size | decimal | always filled | Amount issued, in units of the bond's currency (Exchange Data International's figure in millions, times a million). Unit: currency units. |
amount_outstanding | decimal | always filled | Amount outstanding on amount_outstanding_date, in units of the bond's currency. Unit: currency units. |
amount_outstanding_date | date | always filled | Date the amount outstanding was last reported. |