Tutorial 8: How to download the last price and price earnings ratio for the constituents of a stock index over a period of time in Excel (00:03:30)
This video will show you how to find and download the last price and price earnings ratio for the constituents of a stock index over a period of time using the Bloomberg Excel Add-In. It explains how to install the Bloomberg Excel Add-In, use the Spreadsheet Builder to select securities and data items, set periodicity and time frame, select layout options, and export data to Excel.