Bloomberg Excel插件是否存在可显示字段名称的函数？

Absolutely, there's a dedicated function in the Bloomberg Excel Add-in that solves exactly your problem—letting you pull human-readable field names from Bloomberg field codes like IS_EPS.

The FIELD_NAME() Function #

This is the simplest and most direct tool for your use case. It takes a Bloomberg field code as input and returns its official, user-friendly name.

Example Usage #

If your dropdown-selected field code is in cell A1, enter this formula in a nearby cell to show the corresponding name automatically:

=FIELD_NAME(A1)

For your specific example with IS_EPS:

=FIELD_NAME("IS_EPS")

This will return "Basic Earnings per Share" right away.

Alternative: BDP for Detailed Field Descriptions #

If you need more context than just the short field name (like a longer explanatory description), you can use the BDP function paired with the FIELD_DESC field. Note this requires specifying any valid Bloomberg ticker (since field descriptions are universal across securities):

=BDP("IBM Equity", "FIELD_DESC", "FIELD_ID=IS_EPS")

This will return a more detailed breakdown of what the field measures, beyond just the basic name.

Key Notes #

• Make sure your Bloomberg Excel Add-in is fully loaded and you have an active Bloomberg terminal connection (these functions won't work offline).
• For non-English field names, add a language code as a second parameter to FIELD_NAME(). For example, to get the Chinese name for a field:

  =FIELD_NAME("IS_EPS", "ZH")
  

• Some fields may have region-specific variants, but FIELD_NAME() will return the most common global name by default.

内容的提问来源于stack exchange，提问作者Oleg K.