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:

- Click the windows key and type "Excel". Start Excel.
- Close Excel.
- Click the windows key and type "Install". Select Install Office Add In
- Install the add in into your profile and then close all the windows.
- Open Excel and create a new spreadsheet. There should be a Bloomberg tab
- Log into Bloomberg
- Use the Bloomberg tab to download data from Bloomberg

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.

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:

- Writing formulae in Excel using.
- Excel's IF function.
- The BDP function to load Bloomberg data.
- Using the dollar symbol ($) to fix a row or column in an Excel formula.
- Real time fields in Excel.

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:

- You will need to be logged into Bloomberg.
- The formulae you type must be exactly correct. You must not make any spelling mistakes. You should make sure that you use uppercase or lowercase letters exactly as Bloomberg does in its field names and ticker names. You must not include any additional spaces in tickers or field names. Computers are very fussy about being precise!