Home > Forum Home > Valuing Investments and Businesses > Bloomberg Excel Backtesting Share

Bloomberg Excel Backtesting

Excel Help for Bloomberg Excel Backtesting in Valuing Investments and Businesses


Forum TopicPost Reply Login

Bloomberg Excel Backtesting

Rate this:
(3/5 from 1 vote)
Confused
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?


Thank You!
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Happy
Rate this:
(4.3/5 from 3 votes)
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.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Bloomberg Excel Backtesting in the