Excel Bloomberg question, any advice is greatly appreciated. I have an automated trend following index that I am back testing, at this point I have the stocks that it would invest in going back to 1990. the basket of stocks updates monthly so I have in on column the end of month dates and in columns to the right the respected stock tickers as represented on Bloomberg. I now need to see the returns and eventually create a line graph of the results. how should I precede?
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.