This can only be done from the training terminal. If the librarian is unable to help, then hit the F1 key and ask a Bloomberg expert. If there are issues after correcting, reach out to a librarian. If there is an error, chances are something is not right about the data fields selected. Now the spreadsheet should be full of desired data.
If today's date is chosen as the most recent date, some data fields may give an error. Select the date range to extract and hit next, then create. Commodities have different data tags than securities so it is important to know what information is needed in this step Then hit next and choose which the fields to extract, and hit next. Once the spreadsheet builder loads, enter the ticker symbol that was identified through the terminal into the search bar. Open the Bloomberg tab and click "Import Data" then choose to create a historical data table. Once the ticker symbol is found, then open excel. Open the Bloomberg terminal and search for information that should be extracted. 
Use the training Bloomberg terminal (the first one on the left). These types of errors can be avoided by examining the data to be extracted in the Bloomberg terminal.įirst go to the Kopolow Business Library on the second floor of Simon Hall, where the Bloomberg terminals are located. Additionally, some securities are actually sold as contracts, so they may have closing prices, but this is not a valid option for extracted and will present errors. 
For instance, interest rates do not have a daily closing price, but securities do.
To better understand the data to be extracted, first examine the index on the Bloomberg terminal to see what types of data is displayed. The list of information to be extracted, otherwise errors will occur when data is imported into excel.
#Bloomberg terminal wiki how to#
This tutorial will cover how to extract static data to an excel workbook. The data can be extracted all at once onto a USB flash drive, so this method is not viable for a dynamic stream of data. The school's Bloomberg terminals are tools which can be used to extract data on historical stock, commodity, and index pricing data.
0 kommentar(er)
