Search code examples
c#excelvbams-accessbloomberg

Loading Bloomberg Api Data Using VBA Access Program

we have subscription to Bloomberg data, we use excel to load data from bloomberg using bdp function. but its pain,so we decided to find easy way to do this . Is there any way to program and calculate Fixed Income Chars from a list of securities using VBA ,access,sql or anything.?

Thanks

Solution

  • It is an old question, but maybe one will look for an answer. Basically you can retrieve the same data via Bloomberg API. For the personal use it is a Desktop API (currently version 3). The Quick Start Guide (can be downloaded from Bloomberg Terminal) provides examples for C++, Java and C#. The names of the fields are exactly the same as in the bdp function. For example:

    Element fields = request.GetElement("fields");
fields.AppendValue("PX_LAST");
fields.AppendValue("VOLUME_AVG_30D");
session.SendRequest(request,null);