Bloomberg

COM API
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/content.php?pid=128903&sid=1117575


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


Bloomberg Excel Tools - BloombergUI.xla

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


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



© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext