WOLFRAM

Wolfram Language & System Documentation Center
Wolfram Language Home Page »

"BloombergTerminal" (Service Connection)

This service connection requires Wolfram Finance Platform »

Connect your Bloomberg Terminal account to the Wolfram Language to obtain and analyze live market data.

Bloomberg entities are automatically mapped to Wolfram Language entities for immediate or asynchronous lookup.

Connecting & Authenticating

ServiceConnect["BloombergTerminal"] creates a connection to the Bloomberg LP Desktop API. To use this service, you must have an active subscription with Bloomberg Professional Services and Bloomberg Terminal installed.
Authentication occurs via the Bloomberg Terminal app.

Entity Values

Entity["BloombergTerminal","name"]["property"] gets the value of the specified property for the Bloomberg Terminal entity with the specified name.

Requests

ServiceExecute["BloombergTerminal","request",params] sends a request to the BloombergTerminal API, using parameters params.
ServiceExecute[req] sends a ServiceRequest object req to the Bloomberg Terminal API.
ServiceSubmit["BloombergTerminal","request",params] submits an asynchronous task requesting data from the Bloomberg Terminal API, using parameters params.
ServiceSubmit[req] submits an asynchronous task requesting data from the Bloomberg Terminal API.
ServiceSubmit[ContinuousTask[req]] submits a ServiceRequest that object req be continually updated.
ServiceSubmit[ContinuousTask[req,end]] submits a ServiceRequest that object req be continually updated until the time specified by end.
ServiceSubmit[ContinuousTask[req,tspan]] submits a ServiceRequest that object req be continually updated over the time span tspan.
The following requests may be made:

Properties

Requests:

"Properties" — look up properties supported by Bloomberg Terminal service

Requests:

"PropertyInformation" — look up description for the specified properties.

Parameters:
  • "Properties"(required)Bloomberg properties
    • Requests:

    "PropertySearch" — look up description for the specified fields

    Parameters:
  • "Query"NoneBloomberg properties

    • Instruments

    Requests:

    "InstrumentSearch" — look up instruments

    Parameters:
  • "Query"Nonequery term
    "YellowKeyFilter"Nonefilter product type
    MaxItems100number of elements to return

    • Market Data

    Requests:

    "Lookup" — look up information on Bloomberg Terminal service

    Parameters:
  • "Instrument"(required)Bloomberg instrument name or Bloomberg Global ID (BBGID)
    "Properties"(required)Bloomberg properties
    • Requests:

    "TickData" — tick-by-tick history

    Parameters:
  • "Instrument"(required)Bloomberg instrument name or BBGID
    "Date"Automatictime interval of tick events
    "EventType""TRADE"tick events corresponding to the event type
    • Requests:

    "IntradayBars" — returns OHLC (open, high, low, close) prices

    Parameters:
  • "Instrument"(required)Bloomberg instrument name or BBGID
    "Date"Automaticdate range, specified as an Interval or Span
    "Event""TRADE"intraday bar data for the corresponding event
    • Requests:

    "HistoricalData" — returns historical data

    Parameters:
  • "Instruments"(required)Bloomberg instrument name or BBGID
    "Properties"(required)Bloomberg Properties
    "Date"Automaticdate range

    • Examples

    open allclose all

    Basic Examples  (6)Summary of the most common use cases

    Create a new connection:

    In[1]:=1
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-cijr8o
    Out[1]=1

    Get the property "PX_LAST" of the BloombergTerminal entity "MSFT US Equity":

    In[2]:=2
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-bz71xm
    Out[2]=2

    Get the first 5 Bloomberg Terminal properties:

    In[1]:=1
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-jy67rs
    Out[1]=1

    Count all Bloomberg Terminal properties:

    In[2]:=2
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-f3gm1v
    Out[2]=2

    Get "TickEvents" for a "TRADE" event:

    In[1]:=1
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-ezjber
    Out[1]=1

    Get "IntradayBars" for a "TRADE" event:

    In[1]:=1
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-bcfo6i
    Out[1]=1

    Get "IntradayBars" for a "BID" event:

    In[1]:=1
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-eawzi7
    Out[1]=1

    Values stored in the TimeSeries:

    In[2]:=2
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-731xq
    Out[2]=2

    Continually update "BID", "ASK" and "PX_LAST" for an instrument:

    In[1]:=1
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-vfwx78
    Out[1]=1
    In[2]:=2
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-pgz6r
    Out[2]=2
    In[3]:=3
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-c5umtx
    Out[3]=3

    Scope  (7)Survey of the scope of standard use cases

    Get an Association for a list of entities:

    In[1]:=1
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-ml3ony
    Out[1]=1

    Get index members:

    In[1]:=1
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-fwku88
    Out[1]=1

    Plot daily "OPEN" price for "GE US Equity" since January 1, 2018:

    In[1]:=1
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-72z8l
    Out[1]=1

    Plot "HIGH" price for "GE US Equity" for every "Month" since January 1, 1990:

    In[1]:=1
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-b2nh33
    Out[1]=1

    Create a ServiceRequest to submit:

    In[1]:=1
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-dkxvtq
    Out[1]=1

    Submit the request and receive updates as they happen:

    In[2]:=2
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-nnlzse
    Out[2]=2
    In[3]:=3
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-x39qi
    Out[3]=3

    Remove the task:

    In[4]:=4
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-c85ejp
    Out[4]=4

    Create a task:

    In[1]:=1
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-iugfy6
    Out[1]=1

    Submit the task:

    In[2]:=2
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-cbkqbv
    Out[2]=2

    List the keys:

    In[3]:=3
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-efqsqd
    Out[3]=3

    Received result:

    In[4]:=4
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-eleu71
    Out[4]=4

    Remove all running tasks:

    In[5]:=5
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-jid18
    Out[5]=5

    Create a request to fetch fields:

    In[1]:=1
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-i03yd
    Out[1]=1

    Asynchronously fetch fields:

    In[2]:=2
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-ce7nkn
    Out[2]=2
    In[3]:=3
    ✖
    https://wolfram.com/xid/0hrps0endp46m9z509egp46fhnkm-i7ybay
    Out[3]=3