Search code examples
arraysexceladd-inbloomberg

Using Excel Functions to Get Data into a Single Cell

I'm working with the Bloomberg Add-in on Excel to gather some data. The problem I'm having is to get all the data into a single cell. For instance, I want to get the daily change % for the past 5 fives for IBM. The formula I am using is:

=BDH("IBM US Equity","CHG_PCT_1D","11/9/2012","","Array","TRUE")

I made this using the Formula Builder, so I'm not sure why this isn't working. It returns error message: "#N/A Invalid Parameter: Invalid Override Field ID Specified"

If I exclude the whole array part, then it returns the data I want but in 1827 or so different cells. Any way I can get all of these in one cell?

Thanks

Solution

  • Use the working method that fills cells A1 through A1827.
    Then in cell B1 enter:

    =TEXTJOIN("",TRUE,A1:A1827)

    This cell will contain all the data you require.