Bloomberg Office Add In For Excel On

 admin

  • In Excel:
    • In the Bloomberg ribbon tab click Help.
    • In the amber 'Search DAPI Help' box, search for: error message codes
  • In the Bloomberg software: Copy and paste the following into the command line and hit <GO>/Enter: LPHP DAPI:0:1 1489652

See All Results For This Question

Bloomberg error codes:

  • Open Excel and verify that the Bloomberg tab is on the menu bar If you receive an error, check the Task Manager for any open instances of Excel or Microsoft Office End Task on any open instances of Excel or Office From the Start menu, click Bloomberg.
  • Open the Bloomberg program group from the Windows icon on the tray at bottom of screen and choose Install Office Add-in. Login into Bloomberg, then open Excel. Choose the Bloomberg Add-in. The API Template library is a sophisticated Excel version of financial tools and displays in Bloomberg like Yield Curve views or company valuation models.
  • Bloomberg Excel Add-in. Excel Details: The Bloomberg Excel Add-In is a powerful tool that delivers Bloomberg data and analytics into an Excel spreadsheet on the user’s desktop. To use the Excel Add-In, you must be logged into the Bloomberg terminal. Working with the Excel Add-In 1. Office 365 excel help › Verified Just Now.

Then, choose 'Add-Ins' → 'Gehe zu' 2. In the following dialog box, uncheck 'Bloomberg Excel Tools', press OK and then terminate Excel.

Descriptions of the error messages follow. Please consult the terminal's support documentation using the above steps to learn more about possible causes and solutions, and for the most up-to-date list.

  • #N/A Authorization - The #N/A Authorization error occurs because you or your Bloomberg terminal are not authorized to download the data using the Bloomberg API.
  • #N/A Array Size Limit - The #N/A Array Size Limit error occurs because the size of the array imported to your spreadsheet exceeds Excel's displayable limit. During array generation, data results are returned in a single string.
  • #N/A Calculating - For BInterpol formulas, the #N/A Calculating indicates the formula is calculating the value.
  • #N/A CNV - The #N/A CNV error message is a momentary error code that occurs when a sheet created in one API version is opened in a different version (e.g. v2 API sheet opened in v3 API or vice-versa).
  • #N/A Connection - The #N/A Connection error occurs because the connection between bbcomm.exe and the dotnet API data provider has been interrupted.
  • #N/A End Date - The #N/A End Date error occurs because there is a problem with the end date parameter that is specified in the formula.
  • #N/A Error Setting Target Range - For BQR formulas, the #N/A Error Setting Target Range indicates Bloomberg is unable to create the array.
  • #N/A Field Not Applicable - The #N/A Field Not Applicable error occurs because the data field used in the formula is not applicable for the specified security.
  • #N/A Invalid Field - The #N/A Invalid Field error occurs because the data field mnemonic was not recognized.
  • #N/A Invalid Hash - For BQR formulas, #N/A Invalid Hash indicates Bloomberg detected a tampered/invalid hash.
  • #N/A Invalid Input - For BQR formulas, #N/A Invalid Input indicates invalid parameters are included in the BQR formula.
  • #N/A Invalid Parameter - The #N/A Invalid Parameter error occurs because there is a problem with one or more of the parameters in the formula.
  • #N/A Invalid Query - For BQR formulas, #N/A Invalid Query indicates the generated sql is not recognized by sqlite.
  • #N/A Invalid Request - For BQR formulas, #N/A Invalid Request indicates the request to API for historical data failed.
  • #N/A Invalid Screen Name - #N/A Invalid Screen Name indicates the screen name is not valid.
  • #N/A Invalid Security - The #N/A Invalid Security error occurs because the security in the formula was not recognized as a valid Bloomberg security.
  • #N/A Missing Value - For BInterpol formulas, #N/A Missing Value indicates that there are missing X or Y values in the formula.
  • #N/A N/A - The #N/A N/A error occurs because data is not available for the data field or date specified in the formula.
  • #N/A No Data - For BQR formulas, #N/A No Data indicates there is no data available for the security.
  • #N/A Out of Bounds - For BInterpol formulas, #N/A Out of Bounds indicates the interpolation point is outside the boundaries of the set of X values and the Extrapolate parameter is not included in the formula.
  • #N/A QSP Privilege - The #N/A QSP Privilege occurs because you do not have permission to download certain data.
  • #N/A Real Time - The #N/A Real Time error occurs because realtime data is not available for the selected security.
  • #N/A Refresh Failed - #N/A Refresh Failed indicates the data field used in a formula is a static field that is supposed to automatically refresh and the refresh did not occur.
  • #N/A Refresh Pending - #N/A Refresh Pending indicates the data field is a static field that is supposed to automatically refresh. If the Bloomberg server does not have data, this error message appears and the field will attempt an automatic refresh a few seconds later.
  • #N/A Repeat - For BInterpol formulas, #N/A Repeat indicates there are repeated X values within the formula.
  • #N/A Requesting Data - The #N/A Requesting Data message is the initial value that is placed in a cell when the formula (BDP, BDH, and BDS) first attempts to import data. This message may remain if no value is returned by the dotnet API data provider or if there is a problem with placing the data value into the Excel cell.
  • #N/A Review (Capacity) - Bloomberg caps data requested via the API to prevent strain on the system. The following error messages appear in Microsoft Excel when your usage exceeds daily or real-time thresholds or otherwise requires review.
  • #N/A Sort - For BInterpol formulas, #N/A Sort indicates the X values in the formula are not sorted.
  • #N/A Start Date - The #N/A Start Date error occurs because there is a problem with the start date parameter that is specified in the formula.
  • #N/A Syntax Not Supported - #N/A Syntax Not Supported indicates the use of a Bloomberg formula as an embedded argument in a formula may not be supported - for example, using a BDH formula (which would return a multi-cell result) as an argument in an 'IF' formula statement for comparison purposes.
  • #N/A Terminated - #N/A Terminated indicates the subscription has been terminated by the BDP, BPGE, BTP, or BRB formula.
  • #N/A Time Out - The #N/A Time Out error occurs because a subscription request for a data field has timed out.
  • #N/A Unclassified - #N/A Unclassified indicates an error with no known Excel classification has occurred.
  • #N/A Unknown - The #N/A Unknown error occurs because data retrieval has failed and no other errors apply. The data provider has received a new Bloomberg error code that it is not able to process correctly. A fatal error has occurred in the RTD data infrastructure during data subscription or when a data tick is processed.
  • #N/A Unknown Error - For BQR formulas, #N/A Unknown Error indicates an unrecoverable error has occurred.
  • #N/A Unsupported Excel Version - For BQR formulas, #N/A Unsupported Excel Version indicates an unsupported version of Excel is being used.
  • #NAME? - The #NAME? error occurs because Excel does not recognize the specified formula.
  • #REF! - #REF indicates an invalid link is referenced in the formula.
  • BPUB/BPUBA & BPUP Codes - The following are possible codes that may appear when you enter new BPUB/BPUBA or BPUP formulas onto your spreadsheet or refresh existing ones: #N/A Published Data - N Succeeded, N Failed; #N/A Publishing Data; #N/A Publish Failed; #N/A Resolving...; #N/A Resolution Succeeded; #N/A Creating Topic...; #N/A Topic Creation Failed;
  • VBA Errors - You may receive a pop-up window with a VBA error message.

1. Use the Import Data Wizard

The Import Data Wizard makes it easy to import Bloomberg data into a spreadsheet by automatically generating the appropriate functions through an easy step-by-step process.

Office

You can launch the Import Data wizard by, selecting Import Data from the Bloomberg Menu or by clicking on the Import Data icon on Excel toolbar.

Software Updates | Bloomberg Professional Services

Select the type of data you want download, then follow the steps.

2. Use Worksheet Functions in Excel

Bloomberg’s worksheet functions provide intermediate to advanced Excel users flexibility to construct their own formulas to customize the way Bloomberg data is delivered and organized in the spreadsheet.

In the Excel Add-in, Bloomberg functions are consolidated with flexible optional parameters:

  • BDP (Bloomberg Data Point) is for current data.
  • BDH (Bloomberg Data History) is for historical end of day and historical intraday data.
  • BDS (Bloomberg Data Set) is for large data sets/ bulk data.

Bloomberg Office Add In For Excel Only

When using any of the formulas, you must specify the security for which you want to retrieve data (Security), and you must specify the data item you want to retreieve (Field). The Security must be represented as (Ticker) (Market Sector), for example TGT Equity.

Fields are represented by mnemonics. Use the Field Search tool in Excel to search by category or keyword.

For more information about the using Excel Add-in

ExcelSirJi | Simplest Way To Create Excel Add-in

  • Watch the Bloomberg Essentials video (Bloomberg Data in Excel) BESS <GO>
  • Download the Getting Started Guide for Students
  • Download the Bloomberg Excel Desktop Guide
  • Download the Function Reference Guide