Personal tools
User menu

Knowledge Base/Finance/Bloomberg

From Thalesians

Jump to: navigation, search

Contents

Service

  • BREP — contact your Bloomberg representatives (including your Account Manager) and/or see his/her contact details

Useful Pages

  • WEI — World Equity Indices

Useful functions

  • HP — Price table with average daily volume
  • GP — Price graph with volume

Obtaining a list of fields and mnemonics

If you want to obtain information for a particular security you need to know the list of fields. If you want to use the API to access these fields programmatically, you need to know the corresponding mnemonics.

First go to the security you are interested in, say, EUR Curncy. Then enter FPRP<GO>, which appears as a "Calcrt Test Function". This will list the available fields. If you want to see the mnemonics, change the options to View = Mnemonics, App = API.

Bloomberg Excel API error messages

Here is an unofficial list of the Bloomberg Excel API error messages. For more information, enter BBXL<GO> (Bloomberg Data and Calculations in Excel) followed by 13<GO> (Explanation of Error Messages).

  • N/A - The request for the field is in transition
  • N/A Auth - The user is not permissioned to receive data via the API
  • N/A Auth -2001 - The user is disabled because they have a Limited Functionality terminal or login that is not allowed to receive API data
  • N/A BulkFld - Attempting to use a field that does not conform to the Bloomberg Bulk format
  • N/A Ccy - The specified currency does not exist
  • N/A Com - The connection to the Bloomberg Communications Server has been lost
  • N/A Data Ctrl - The operating system has failed to register the file blpdatax.dll
  • N/A Dberr - The security for which data has been requested is not recognised
  • N/A DbTimeout - The user's request has timed out during processing
  • N/A Derived Limit - Exceeded the concurrent subscription limit of 500 securities for the derived real time fields for options
  • N/A Disable - The user has exceeded the limitation of data download per user applicable to static (not real time streaming) data
  • N/A Dly Lmt - The user has exceeded the limitation of data download per day per user applicable to static (not real time streaming) data
  • N/A End - The end date parameter is not valid or is set before the start date
  • N/A Fld - The specified field mnemonic is invalid
  • N/A Full - The BLPB function has failed to insert the necessary number of columns due to the final sheet column being occupied
  • N/A Hist Fld - The requested field is not a history field
  • N/A History - There is no historical data available for the date(s) specified
  • N/A InvalidRepl - An unspecified error has been identified
  • N/A Limit - The user has exceeded the security limitation of concurrent real time security subscriptions
  • N/A MD Limit - The user has exceeded the 500 security monitoring limit for Market Depth fields
  • N/A Mth Lmt - The user has exceeded the limitation of data download per month per user applicable to static (not real time streaming) data
  • N/A MultiFlds - The user is attempting to use the BLPB function with more than one field
  • N/A N Ap - The field is not applicable for the security
  • N/A N.A. - The data for the specified derived field is not available
  • N/A N/A - The data for the specified history, intraday or real time field is not available
  • N/A NA - The user has requested the inclusion of non-trading days, and specifically requested the 'filler' for the non-trading days to be '#N/A NA'
  • N/A Neg - The specified field is a numeric field that cannot be negative but the calculated value is negative
  • N/A Nested - =today() is used within a BLPSH and BLPH formulas. An obsolete error message
  • N/A NtrdVal - The optional 'filler' parameter of BLPH is invalid
  • N/A No Ovrd VWAP - Real time VWAP fields do not support overrides
  • N/A OvrdVal - Invalid override value has been entered for user input within a calculation override BLP statement
  • N/A Period - The optional 'period' parameter of BLPH is invalid
  • N/A Perm - Not permissioned to view the specific field requested, given the security and price provider selected. Third-party subscription required
  • N/A RevOrd - The optional 'Reserve' parameter of BLPH is invalid
  • N/A Rl Tim - The security for which real time data is being requested is not being priced in real time
  • N/A Sec - The security for which data has been requested is not recognised by Bloomberg
  • N/A Sec Tp - The specified security type is not among the valid security types (not ticker exchange nor SEDOL nor CUSIP)
  • N/A ShDatres - The optional 'Show Dates' parameter of BLPH is invalid
  • N/A Shntrd - The 'Non-Trading Days' parameter of BLPH is invalid
  • N/A ShYieldFlg - The Price/Yield flag parameter of BLPH is incorrect
  • N/A Size - Excel's array limitation of 1600 cells exceeded by a DDE request
  • N/A Sls Auth - The user has been manually disabled by the Bloomberg Risk Team
  • N/A Start - The compulsory 'Start Date' parameter of BLPH is invalid
  • N/A Tim - The request for the field has timed out (usually 90 seconds)
  • N/A Trd - The security for which real time data was requested has not traded in more than 30 days
  • N/A Unknown - An error has occurred that is not handled by Bloomberg API

Schedule of economic releases

The function ECO will give you the list of economic releases. If you want to see the schedule of releases for a particular index, go to that index, then call ECOC.

  • This page was last modified on 5 December 2008, at 12:21.
  • This page has been accessed 43,816 times.