Introduction to Bloomberg Terminals

Lesson 3 - Using Excel with Bloomberg

Video 1 - Loading Bloomberg Data into Excel

This video shows you how to download Bloomberg data into Excel.

No matter what software you would like to use to analyze the data, you should first load it into Excel and save it as a file. It is theoretically possible to load the data straight into some tools such as MATLAB or a C++ program without using Excel, but it is not a good idea. It is good software design to write small programs that communicate using text files as this makes it much easier to debug and test your code. Trying to communicate to Bloomberg directly from another language will almost certainly make your software design worse. It will also mean you waste time on programming that you could be spending analysing financial data.

Remember you may need to install the Bloomberg office add in if you change computer or if the computer you are using forgets your preferences. The process is as follows:

Exercise

Download the end of day mid prices for Google and Apple stocks for the last year. The mid price is the average of the bid and ask prices. It is available directly from Bloomberg. You don't have to calculate it yourself.

Video 2 - Pricing a Portfolio

This next video shows you how to price a portfolio in Excel using Bloomberg. Of course, we have already seen how you can get the Bloomberg terminal to do this for you, but it is interesting to do it yourself. If you haven't used Excel before, this video will also teach you the basics of how to create your own Excel spreadsheets.

Key ideas:

Exercise

Price a portfolio of your choosing by writing your own spreadsheet. If you get completely stuck, there is an working example for you to download below. But it is much better if you do this yourself.

Here are some tips:

Resources