In this casde you should use the Bloomberg BDH function to populate the historical quotes for the tickers. If the month end dates are entered across the top in columns and the security tickers are entered down the left as rows, then use can specify the horizontal direction as "Dir=H" in the fourth argument of the function.