Corporate Events Capital Change Distributions
Name Change Merger Cash Dividends
Domicile Change Spin-off Stock Dividend
State of Incorporation
Change Bankruptcy Filing Stock Split
Round Lot Change Stock Buyback
Ticker Symbol Change Equity Offering ID Number Change Debt Redemption Call
Equity Delisting Debt Offering/Increase Change in Listing Debt Offering/New
Equity Listing Par Value Change Variable Interest Resets Debt Redemption Sinker
Voting Rights Change Acquisition Currency Quotation Change Divestiture
Reconvention Installment Call - Partial Pay Redenomination Reclassification Shareholder Meeting Debt Repurchase
Debt Redemption/Put Exchange Offers Variable Principle Redemption
Pay in Kind Rights Offering Conversion Price Refix
Exercise Price Refix Funged Issues Extendible Issues
The ACTION_DATE flag can be used with a getactions request to modify whether the reply file will return actions based on effective date, entry date, or both.
2008 Bloomberg Finance L.P. All rights reserved
Getcompany
This program returns company/entity level data such as industry classification, country of risk, and country of domicile for a given security/company ID. For the full list of available fields, please see crisk_fields.csv, which can be found in the root directory of client FTP servers. Only those fields listed in this file will be available in this program. Fields can be specified explicitly or can be requested via the Field Set macros below. The program supports requests by security/ticker or by entity/company ID.
This program requires the inclusion of header option CREDITRISK=Yes in the request file. It also requires that ID_BB_COMPANY be included within the fields list. If ID_BB_COMPANY is not included, an error report will be generated and no data will be returned.
Format:|<Identifier> |<Rcode> | <Nfields> | <Value-1> | <Value-2> | ....| <Value-Nfields>|
<Identifier> Security/Company identifier used in the request file
<Rcode> Return Code
<Nfields> Number of fields requested and received
<Value-1>….<Value-Nfields> Data element #1… Data element # Nfields
Return Codes:
0 Good return. No errors occurred.
10 Bloomberg cannot find the security as specified.
11 Security found, but no associated company
12 Bloomberg cannot find the security and the identifier syntax/format is incorrect
988 System Error on security level
990 System Error (Contact Technical Support) 994 Permission denied (Contact DL Sales Rep)
996 Buffer Overflow (some data for this security is missing).
998 Security identifier type (e.g., CUSIP) is not recognized.
999 System Error (Contact Technical Support)
2008 Bloomberg Finance L.P. All rights reserved
Applicable getcompany file header options
COLUMNHEADER FILETYPE OUTPUTFORMAT SECDESLENGTH TIME
COMPRESS FIRMNAME PORTSECDES SECID USERNUMBER CREDITRISK HEADER REPLYFILENAME SN VERSION DATEFORMAT LAUNCH REPORT SPECIALCHAR WS
DELIMITER LOGIN RUNDATE SYSTEM YELLOWKEY
FIELDSET
Field Set Macro
Getcompany has a new option, the FIELDSET macro, which offers the ability to include all fields available in the Credit Risk BackOffice module without explicitly listing each field individually.
Format: FIELDSET=<FieldMacro> | <Date>
<FieldMacro> Macro name – corresponds to Credit Risk BackOffice file
<Date> Optional. This represents the effective date of when the field set was released into production. Setting this field to a specific date will prevent future releases of field sets from impacting existing requests and reply files. Format is YYYYMMDD. Default is the current date if not specified.
The following Field Macros are currently available:
BO_CREDIT_RISK_COMPANY fields included in credit_risk.out BO_CREDIT_RISK_FITCH fields included in credit_risk_fitch.out BO_CREDIT_RISK_MOODY fields included in credit_risk_moody.out BO_CREDIT_RISK_RATINGS1 fields included in credit_risk_ratings1.out BO_CREDIT_RISK_RATINGS2 fields included in credit_risk_ratings2.out BO_CREDIT_RISK_SP fields included in credit_risk_sp.out
The list of fields can be found in the crisklayout.xls file located in the notices sub-directory on your ftp server.
2008 Bloomberg Finance L.P. All rights reserved
Sample Request File for the getcompany Program (using Security)
START-OF-FILE FIRMNAME=dl12345
REPLYFILENAME=getcompanytest CREDITRISK=yes
PROGRAMNAME=getcompany
START-OF-FIELDS ID_BB_COMPANY CNTRY_OF_RISK IS_ULT_PARENT END-OF-FIELDS
START-OF-DATA IBM US Equity END-OF-DATA END-OF-FILE
Sample Reply File for the getcompany Program (using Security)
START-OF-FILE RUNDATE=20071106 PROGRAMFLAG=oneshot FIRMNAME=dl12345
REPLYFILENAME=getcompanytest CREDITRISK=yes
PROGRAMNAME=getcompany
START-OF-FIELDS ID_BB_COMPANY CNTRY_OF_RISK IS_ULT_PARENT END-OF-FIELDS
TIMESTARTED=Tue Nov 6 13:03:45 EST 2007 START-OF-DATA
IBM US Equity|0|3|100801|US|Y|
END-OF-DATA
TIMEFINISHED=Tue Nov 6 13:03:47 EST 2007 DATARECORDS=1
END-OF-FILE
2008 Bloomberg Finance L.P. All rights reserved
Sample Request File for the getcompany Program (using Company ID)
START-OF-FILE FIRMNAME=dl12345
REPLYFILENAME=getcompany_id_bb CREDITRISK=yes
SECID=BB_COMPANY
PROGRAMNAME=getcompany
START-OF-FIELDS ID_BB_COMPANY LONG_COMP_NAME CNTRY_OF_RISK IS_ULT_PARENT END-OF-FIELDS
START-OF-DATA 100801
END-OF-DATA END-OF-FILE
Sample Reply File for the getcompany Program (company ID)
START-OF-FILE RUNDATE=20071106 PROGRAMFLAG=oneshot FIRMNAME=dl12345
REPLYFILENAME=getcompany_id_bb CREDITRISK=yes
SECID=BB_COMPANY
PROGRAMNAME=getcompany
START-OF-FIELDS ID_BB_COMPANY LONG_COMP_NAME CNTRY_OF_RISK IS_ULT_PARENT END-OF-FIELDS
TIMESTARTED=Tue Nov 6 13:20:12 EST 2007 START-OF-DATA
100801|0|4|100801|International Business Machines Corp|US|Y|
END-OF-DATA
TIMEFINISHED=Tue Nov 6 13:20:12 EST 2007 DATARECORDS=1
END-OF-FILE
2008 Bloomberg Finance L.P. All rights reserved
Sample Request File for the getcompany Program using Field Set Macro (using Security)
START-OF-FILE FIRMNAME=dl12345
REPLYFILENAME=getcompany_fld_macro CREDITRISK=yes
PROGRAMNAME=getcompany
START-OF-FIELDS
FIELDSET=BO_CREDIT_RISK_COMPANY|20071106|
END-OF-FIELDS
START-OF-DATA IBM US Equity END-OF-DATA END-OF-FILE
2008 Bloomberg Finance L.P. All rights reserved
Sample Reply File for the getcompany Program using Field Set Macro (security)
TIMESTARTED=Tue Nov 6 13:26:52 EST 2007 START-OF-DATA
IBM US Equity|0|21|100801|International Business Machines Corp| |
|Technology|Computers|Computers|US|US|US|NY|NY|;2;6;1;1;One New Orchard Road;1; ;1;Armonk;1;NY;1;10504;1;United States;|Y|Computers|N|
|Company|100801|International Business Machines Corp|IBM|
END-OF-DATA
TIMEFINISHED=Tue Nov 6 13:26:52 EST 2007 DATARECORDS=1
END-OF-FILE
2008 Bloomberg Finance L.P. All rights reserved