Bloomberg
Founded in 1981 by Michael Bloomberg
link - bloomberg.com
BloombergUI.xla - Bloomberg Office / Excel Tools
VBA Project Name - BloombergUI
C:\blp\API\Office Tools\BloombergUI.xla
This automatically loads all the other add-ins in blue
The add-ins dialog box is not updated to reflect that these add-ins are now loaded in the current session.
The registry "Add-in Manager" and "Options" keys are also not dynamically updated
Version 56.7.56 - August 2023 (32 and 64 bit)
Bloomberg API COM 3.5 Type
c:\program files (x86)\bloomberg\DAPI\blpapicom2.dll
replacement for blp.BLPSubscribe(array, fields)
SWPM - swap interest rate calculator
WEI - World Equity-Indices
GIP GBPEUR CURNCY - intraday graph currency
FXC - current exchange rates
bloomberguichartsevents
blpsmarthost.exe
blpaddinhost.exe
bloomberg.taskpane.host-dll
bofaddin.dll
link - researchguides.smu.edu.sg/c.php?g=421858&p=2882200
Bloomberg Excel Tools Add-in
The Excel addin is installed in the following location:
C:\blp\API\
Checking for updates, type UPGR
download and install the following - BBComm, DDE Server, Excel add-ins
blp.exe - C:\blp\API\dde\blp.exe
wintrv.exe ??
Bloomberg DDE Server
C:\blp\api\dde\ bbcomm.exe
What is the bbcomm.exe ?
Addins Dialog Box
SS
There should only be a single entry in the Add-ins dialog box
Drop-Down Menu - Bloomberg
SS
Import Data
Opens the
Scenario Builder
Lets you perform financial calculations in your workbooks for multiple securities
Fundamental Analysis
Template Library
Lets you search, filter, provide feedback or open a bloomberg template.
Equity Screening
Function Builder
Field Search
Populate Table
Use this to create an automatically updating table of data using column and row headers
Refresh
Formula Conversion Tool
IBES/Best Estimate Conversion Tool
Options
Previous Menu
Help
Live Chat
Toolbar - Bloomberg Tools
SS
Toggles Realtime Updates On/Off -
Refresh All Workbooks -
Import Data -
Scenario Builder -
Fundamentals Analysis -
Equity Screening -
Function Builder -
Field Search -
Populate Table -
Contact Bloomberg -
VBA Addins
BlpMain.xla -
VBA Project Name - Bloomberg
C:\blp\API\dde\BlpMain.xla
Bloomberg Data Functions.xla
VBA Project Name - BloombergDataFunctions
C:\blp\API\Office Tools\Bloomberg Data Functions.xla
Blph.xla
VBA Project Name - BloombergHistory
C:\blp\API\dde\Blph.xla
BloombergUI.xla
VBA Project Name - BloombergUI
C:\blp\API\Office Tools\BloombergUI.xla
BloombergV3Support.xla
VBA Project Name - BloombergV3Support
C:\blp\API\dde\BloombergV3Support.xla
BloombergVbe.xla
VBA Project Name - BloombergVbe
C:\blp\API\Office Tools\BloombergVbe.xla
Blp.xla
VBA Project Name - Blp.xls
C:\blp\API\dde\Blp.xla
Blpchart.xla
VBA Project Name - BlpCharting
C:\blp\API\dde\Blpchart.xla
BlpLib.xla
VBA Project Name - BlpLib.XLS
C:\blp\API\dde\BlpLib.xla
blprds.xla
VBA Project Name - blprds
C:\blp\API\Office Tools\blprds.xla
BTSAddin.zla
VBA Project Name - BTSAddin
C:\blp\API\Office Tools\BTSAddin.xla
C:\blp\API\Office Tools\BTSAddin.xll
BloombergOfficeToolsRibbonUI.xlam
Contains the Office 2007 Ribbon customisation
Notes
Securities are priced for each terminal and can use different pricing sources
(different people might like to see slightly different prices)
SWPM - swap interest rate calculator
WEI - World Equity-Indices
GIP GBPEUR CURNCY - intraday graph currency
FXC - current exchange rates
link - researchguides.smu.edu.sg/content.php?pid=128903&sid=1117575
Error Messages
#N/A Authorization - limited functionality or login is restricted
#N/A Connection - the connection between the BBCOMM and the RTD has been lost
Check that bbcom.exe is running in the task manager
Open Excel, select (Bloomberg > About Bloomberg Excel Tools). Select Diagnostics...
bbcomm running - but no data cannot be killed ??
#N/A Invalid Field - field mnemonic is not valid
#N/A End Date -
#N/A Field Not Applicable -
#N/A Invalid Parameter -
#N/A Invalid Screen Name -
#N/A Invalid Security -
#N/A Limit -
#N/A N/A -
#N/A Real Time -
#N/A Refresh Failed -
#N/A Refresh Pending -
#N/A Requesting Data -
#N/A Start Date -
#N/A Time Out -
#N/A Unknown -
blp("isin", CHG_NET_1D) - daily change %
blp("isin", CHG_NET_MTD) - month to date change %
blp("isin", CHG_NET_YTD) - year to date change %
blp("isin", PX_ASK) - offer price
blp("isin", PX_BID) - bid price
blp("isin", PX_LAST) - last price (either offer or bid)
blp("isin", PX_MID) - middle of (last bid and last offer)
blp("isin", YLD_TYM_MID) - blended YTM
blp("isin", YAS_YLD_SPREAD) - stripped spread
blp("isin", DUR_ADJ_ASK) - spread duration
blp("isin", DUR_ADJ_MID) - mod duration
blp("isin", DUR_ASK) - EIR duration
blp("isin", RTG_SP) - S&P rating
blp("isin", RTG_MOODY) - moody rating
blp("isin", CNTRY_OF_RISK) - country
blp("isin", SECURITY_DES) - description
blp("isin", CPN) - coupon
Bloomberg Data Type Library
C:\blp\API\activex\blpdatax.dll
Library BLP_DATA_CTRLLib
Classes
BlpData
BlpProps
lBlpData
lBlpData2
lBlpData3
lBlpDiagnostics
lBlpSnapShot
Functions
Function - BDP
This replaces the previous BLP function and is an abbreviation for Bloomberg Data Point.
This provides current and descriptive real-time or streaming data
The optional argument can be used for Updated Fequency - ie how often the function is updated
Cell anchoring is necessary as arrays are not created automatically
Examples:
=BDP(security, field, optional)
security - a single valid bloomberg security identifier including optional security type
field - the field
optional - UpdateFrequency - the updating frequency in milliseconds, default is 300 (minimum is 300, and must be in increments of 100)
=BDP("EUR003M INDEX","px last")
=BDP("EUR003M INDEX","px_last")
=BDP("EUR003M INDEX","last_price")
=BDP("f us equity","last_price") latest price for the Ford Stock (single security)
=BDP("isin", CHG_NET_1D) - daily change %
=BDP("isin", CHG_NET_MTD) - month to date change %
=BDP("isin", CHG_NET_YTD) - year to date change %
=BDP("isin", PX_ASK) - offer price
=BDP("isin", PX_BID) - bid price
=BDP("isin", PX_LAST) - last price (either offer or bid)
=BDP("isin", PX_MID) - middle of (last bid and last offer)
=BDP("isin", YLD_TYM_MID) - blended YTM
=BDP("isin", YAS_YLD_SPREAD) - stripped spread
=BDP("isin", DUR_ADJ_ASK) - spread duration
=BDP("isin", DUR_ADJ_MID) - mod duration
=BDP("isin", DUR_ASK) - EIR duration
=BDP("isin", RTG_SP) - S&P rating
=BDP("isin", RTG_MOODY) - moody rating
=BDP("isin", CNTRY_OF_RISK) - country
=BDP("isin", SECURITY_DES) - description
=BDP("isin", CPN) - coupon
Function - BDH
This replaces the previous BLPH function and is an abbreviation for Bloomberg Data History.
This provides historical end-of-day and historical intra-day data.
=BDH(security, field(s), start_date, end_date, [optional arguments])
Examples:
=BDH(security, fields, startdate, enddate, optional)
security -
fields -
startdate - a current or historical date
enddate - a date equal to or later than the start date, it cannot be a future date
optional - BarSize [BarSz], BarType [BarTp], CapChg, CshAdjAbnormal, CshAdjormal, Currency, Days, Dates, DateFormat [DtFmt], ExchCode, Period [Per], Sort
=BDH("f us equity","px_last","10/01/07","10/31/07") gets the latest price for each day in October 2007
=BDH("IBM equity","last_price","10/01/07","10/31/07","Currency=GBP, period=cm")
Function - BDS
This replaces the previous BLPB function and is an abbreviation for ??
This provides data sets and bulk data
Returns multi-cell descriptive data
Examples:
=BDS(security, field, optional)
security -
field -
optional - Direction, Aggregate
Function - BQL
Bloomberg Query Language
Function - BEQS
Lets you return multi-cell data for a selected Screen created using the EQS terminal function
Examples:
=BLPSH(screenname, isbloomberg)
screenname - the name of the screen to execute
isbloomberg -
=BLPSH("My Energy", FALSE)
=BLPSH("New Eqs", "ScreenType=C","Group=Italy Market") - loads the screen New Eqs and the group Italy market
Function - BPGE
Bloomberg Page Based Data
This performs the same functionality as GPGX<GO> and assumes you already know the Broker ID, Category and Page Number
Enables you to return data for pages contributed to the Bloomberg Professional Service
Examples:
=BPGE(topicid, [rownumber], optional)
topicid -
rownumber -
optional - BrokerId, Category, PageNumber
=BPGE("1102/1/274")
=BPGE("1102/1/274","7")
Examples:
=BPGE(firm, bookname, booktype, fields, optional)
firm -
bookname -
booktype -
fields -
optional -
Installation
Bloomberg Ribbon
C:\Program Files\Bloomberg\API\ActiveX\ccycodes.dll
Bloomberg Taskpane Host
C:\Program Files\Bloomberg\API\OfficeTools\BloombergTaskPane.Host.dll
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext