Function Reference - University of Notre Dame（函数引用圣母大学）.pdf

MICROSOFT® EXCEL ADD-IN AVAILABLE FOR EXCEL 2002 AND ABOVE Function Reference 25 October 2007 Version: 1.0 Bloomberg Functions Calculation Overrides 1 BDP (Bloomberg Data Point) 1 Single Security with a Single Field 1 Single Security with Multiple Fields 2 Multiple Securities with Multiple Fields 3 BDS (Bloomberg Data Set) 4 BDH (Bloomberg Data History) 5 Historical Time Series 5 Intraday Historical Time Series 7 Overrides 8 Cell referencing 8 Returning a value to one cell 9 Cell referencing with multiple input cells/values 9 Absolute Referencing 10 Appendix A: Optional Arguments for BDH formulas 12 1 Bloomberg Formulas Calculation Overrides ® In the new Microsoft Excel Add-in the Bloomberg functions have been consolidated and the optional parameters made more flexible. The new functions are: BDP BDP (Bloomberg Data Point) is for current data. This is the equivalent of BLP. BDH BDH (Bloomberg Data History) is for historical end of day and historical intraday data. This is the equivalent of BLPH, BLPSH and BLPI. BDS BDS (Bloomberg Data Set) is for large data sets/ bulk data. This is the equivalent of BLPB. BDP (Bloomberg Data Point) BDP (Bloomberg Data Point) returns the same data as the Market Data/Reference data option in the Data Wizard. This is static or real time current market data. It is the equivalent of the BLP formula from the previous add-in. The previous method of automatic array creation when using multiple securities or fields is no longer permitted. Excel cell locking rules apply if using multiple fields/securities. Syntax =BDP (security, field) Single Security with a Single Field The single