FINBOURNE’s Bloomberg Data License Plus (BBG DL+) integration allows you to enrich your LUSID instruments with comprehensive Bloomberg data across all instrument types. The integration maps this data to appropriate LUSID property types for immediate use in valuations and analytics.
BBG DL+ is one of Bloomberg’s enterprise Data License products. The commercial model optimises between Data License Bulk subscriptions and the pay-per-use model of Data License Per Security, grouping the most widely-used fields across the following datasets:
Core entity
Instrument
Market
Price
ESG
More information on Bloomberg Data License.
Prerequisites
Before getting started, ensure you have:
An active DL+ contract with Bloomberg
Contacted your FINBOURNE representative to:
Enable the integration in your LUSID domain
Provide you with the IP addresses you’ll need to whitelist for the application in Bloomberg
Supported data types
Instrument types
LUSID supports all instrument types for instrument enrichment.
Fields
If one of your required fields isn’t currently available, contact your FINBOURNE representative.
Setting up the integration
Step 1: Obtain Bloomberg DL+ credentials
Contact your Bloomberg account representative to set up API access for your DL+ subscription.
Obtain and securely store your DL+ Key and DL+ Issuer - you’ll need to provide these in LUSID.
Add the Allowed IPs provided by your FINBOURNE representative.
Step 2: Create an integration instance
An integration instance is a configuration that defines which Bloomberg data fields to import.
Sign in to the LUSID web app.
Navigate to Integrations > Dashboard.
Select Create instance and choose Bloomberg Data License Plus.
Specify the following:
Name: A friendly name for this integration instance
Description: A detailed description
DL+ Credentials - Key and Issuer: Your DL+ credentials from step 1
Download Drive File Path: Optional; a path starting with
LUSID-Horizon
to download data import troubleshooting files in
Click Edit imported properties > Add properties and select which Bloomberg data fields to import.
Note
You can select the View imported fields button to inspect how LUSID maps your Bloomberg data.
Click Save to create the integration instance. Note the Instance ID, which you’ll need for certain run methods.
Step 3: Select the instruments to import data for
LUSID selects instruments to import Bloomberg data for using the Instrument/LUSIDConfig-Bloomberg-DLPlus/RefreshReferenceData
property.
Ensure your instruments have at least one of the following identifiers:
BloombergUniqueId
(recommended for best results; this identifier ensures the result is unambiguous)Figi
Sedol
Isin
Follow these steps to add the instrument property with scope
LUSIDConfig-Bloomberg-DLPlus
and codeRefreshReferenceData
to your instruments. Set the property value to True on the instruments you want to include in the integration runs.
Running the integration
You can run the integration manually using the Integrations dashboard, an API call, or via a Luminesce query. See how to run an integration instance.
Monitoring and troubleshooting integration runs
See how to monitor integrations and troubleshoot general issues.
LUSID adds Bloomberg data to instruments as properties in the LUSID-Bloomberg-DLPlus
scope.
Data handling and field mapping
Bloomberg provides data in various formats. The integration converts Bloomberg field types into LUSID data types to ensure the data works seamlessly in your LUSID operations.
Field mapping
Bloomberg field type | LUSID data type | Notes |
---|---|---|
Boolean |
| |
Date |
| |
Integer |
| |
Real |
| |
Price |
| |
Character |
| Short text fields |
Long character |
| Text fields up to ~500,000 characters; read more |
Bulk format |
| Large data sets |
Data quality handling
Bloomberg data doesn’t always conform to the expected field type. For example, price fields may contain values like N/A
, U/A
, or empty strings instead of numeric data. When this occurs, LUSID logs these values as AttributeFailed
in the Run details.
You can review the run logs for each integration instance to identify data quality issues.
Troubleshooting
Error: Connection timed out
Connection timed out
If you experience this error, check the IP addresses provided by FINBOURNE have been whitelisted in your BBG DL+ account.
Error: Authentication failed
Authentication failed
If you experience this error:
Check your DL+ Key and Issuer credentials are correct in your integration instance configuration
Contact your Bloomberg account representative to ensure your API access is configured correctly
No Bloomberg data imported for instruments
Check the following:
Your connection and authentication to Bloomberg is working (see troubleshooting above)
Instruments have the
Instrument/default/BloombergUniqueId
identifierInstruments have the
Instrument/LUSIDConfig-Bloomberg-DLPlus/RefreshReferenceData
property, with the value set toTrue
The integration instance is configured to import the relevant fields