CODEWITHSUNDEEP
javabloombergblpapi
Krish
Krish

Reputation: 319

How to download Corporate Actions using Bloomberg blpapi

I want to download Corporate Actions from Bloomberg (specifically Bankruptcy Filing, Default Corp Actions, Default Resolution) automatically every month and save it somewhere. To do this, I am using Java blpapi.

What I actually want to retrieve is the information when you do the following in Bloomberg Terminal.

  1. CACT <GO>
  2. Action Types: Bankruptcy Filing, Default Corp Actions, Default Resolution
  3. Asset Types: All Securities
  4. Effective Date: 09/24/2016 - 10/24/2016 (For example)
  5. Exchange: Global

However, I am lost as to how to get Corporate Actions from blpapi. I only know how to retrieve market cap data through Historical Data Request and outstanding shares through Reference Data Request. What Reference Data Service should I use to retrieve corporate Actions data?

Upvotes: 3

Views: 3093

Answers (2)

DaveDotNet
DaveDotNet

Reputation: 356

What you have to remember is that the BBG API, the BLP (DAPI/SAPI/B-PIPE) is about speed. It's the "I really need this information right now". I would question... whether you need corporate actions "right now" in you code. If you do, then with the BLP API (with Python) there is a microservice (//blp/mktnews-content) and associated fee to deliver Corporate actions to you, real fast. But you need to balance speed with price. Unless you're trading, you probably don't need it and if you're on the Bloomberg Terminal then you can't be trading with the API.

So I would consider Data License. If you have corporate actions bulk file then that is delivered daily. If your holdings/universe are relatively small then go for Per Security (Request-wait-response). These mechanisms are available as REST, SOAP/XML and SFTP.

There is a twist, in that if you have a data licence dataset, then you can access it through the BLP API using something called DLaaPS.

Upvotes: 0

Krish
Krish

Reputation: 319

After consulting with Bloomberg Help Desk thru HELP HELP in Bloomberg Terminal, their reply is the following.

We don't have an option to programmatically request CACT data. I would recommend making a template, {LPHP CACT:0:1 1015663} that you can reference when you run the function. The Java API will only include the data available from our Desktop API. You cannot create screening data in the Desktop API for CACT to request.

It seems that CACT data cannot be downloaded thru the blpapi. However, I am quite lost at what they mean by,

You cannot create screening data in the Desktop API for CACT to request.

Also, as @assylias mentioned in the comment above if we have a specific list of tickers, we can play with FLDS to check for the fields we want to request. However in my case, I do not have a specific list of tickers that I can use to query blpapi. Thus, I will just go back in exporting this data from BBG terminal itself to an excel file.

Upvotes: 1

Related Questions