mathmonkey mathmonkey - 4 months ago 236
Python Question

Pandas wrapper for Bloomberg api?

I'm starting to use the python api for Bloomberg and I'm wondering if anyone has written a wrapper to convert responses from Bloomberg into pandas timeseries? pybbg is a wrapper for the old COM api which I could of course extend, but want to avoid reinventing the wheel if possible.

Answer

Have a look at this one

https://code.google.com/p/pyalma/source/browse/trunk/InfoProviders/Bloomberg.py

You can request Bloomberg and return a panda,Panel object with

def bdh(sec_list, fld_list, start_date,
    end_date=dt.date.today().strftime('%Y%m%d'), periodicity='DAILY',
    verbose=False, **kwargs):
    """ Sends a historical request to Bloomberg.
    Parameters:
        sec_list: tuple or list of valid Bloomberg tickers.
        fld_list: tuple or list of valid Bloomberg fields.
        start_date: string formatted YYYYMMDD.
        end_date: string formatted YYYYMMDD (default = Today()).
        periodicity: string (default: DAILY).
        verbose: boolean to log Bloomberg response messages (default: False)
        **kwargs: any valid parameter.
    Returns a panda.Panel object.
    """

from this lib.