Getting Started Guide:
In addition to the tutorials listed below, a getting started guide and collection of initial tutorials are available in this .pdf document: Getting Started Guide
Here is a video guide when demonstrates how to create a Bloomberg username and password as well as install the Excel Add-In:
This guide gives instructions on how to enroll in the Bloomberg Market Concepts online course. This is a course that may be taken at no charge in the MTSM Ray Cassetta Financial Analysis Laboratory and will provide you with an overview of many Bloomberg functions and their application in obtaining information and data through practical examples. This course takes approximately eight hours to complete and upon completion of this course, you will obtain a Bloomerberg certificate that may be added to your resume. Please enter the CLASSCODE: C0ZKN12GM7 when prompted during the registration process.
Students can take this course for free in the Ray Cassetta Financial Analysis Laboratory at NJ or online for a charge of $149 with an .edu email account. The following is a link to Bloomberg's certification website: https://about.bloomberginstitute.com/students/bloomberg-market-concepts/
To get started, first create a Bloomberg account following the guide in the above video. Then log into your account and load the function BMC by typing “BMC” in the command line of a terminal. This should load the following screen:
Next, click the “7) Sign Up” link in the left panel to get started enrolling in the course. The below screen should then be displayed. Please fill out the form and click the “1) Sign Up” button at the lower right of the screen when finished.
You next will receive an email from Bloomberg that contains an account activation code. Enter this code into the activation field to completed the account creation process. Once your account is activated, you will see the following screen:
Finally, click the “Access Course” button in the upper right of the screen. After clicking this button, you will be able to access course materials either in the terminal or in an internet browser. If you select the browser option, you will be directed to the following website:
Finally, begin going through the content in the Introduction, Economic Indicators, Currencies, and Fixed Income modules. Upon completion, you will receive your Bloomberg certification.
The Bloomberg Python API can be used to download financial data directly from the Bloomberg terminal into your Python programs. Similarly, the Bloomberg Excel AddIn may be used to download Bloomberg data directly into Excel. The following are instructions that discuss how to get started and set up the Bloomberg Excel and Python API on the machines in the RCFAL.
1) Download Anaconda Python Windows Python 2.7 by going to this link:
and install. When installing, follow all the default options. In particular, we you arrive at the “Install for:” screen, ensure that you have the “Just Me (recommended)” radio button highlighted. You should install the program to:
Except the remainder of the default options to complete the install.
2) Make sure that you have created a Bloomberg Account following the above guide and log into the Bloomberg terminal. The Python and Excel APIs will ONLY work if you are using them on a machine where you have previously logged into Bloomberg.
3) Start an “Anaconda Prompt” from the Windows start menu then in the terminal type:
conda install -c dsm blpapi
pip install tia
to install the Bloomberg Python API as well as a wrapper library called tia which makes returns data downloaded from Bloomberg in convenient pandas DataFrame formats.
4) Next, in an Anaconda Prompt, start IPython by typing “ipython” and run a few of the test examples available on this site:
5) Enjoy the Bloomberg Python API, and ensure that you do not download two much data so that you breach your API limit. More information about these limits can be found in the WAPI function in Bloomberg.
Data may also be downloaded from Bloomberg directly into Excel. In order to achieve this, one first must set up Bloomberg Excel Office Tools by:
1) In the windows start menu, go to
Bloomberg -> Install Office Add-Ins
2) Open up Excel, you should have a new “Bloomberg” tab at the top
3) Explore the “Import Data” tab, and feel free to chat with a Bloomberg representative by typing “Help Help” in the Bloomberg terminal in order to learn how to use this tool. For example, ask the representative, “How can I download historical end of day exchange rates for EUR/USD for the past 20 years using the Bloomberg Excel AddIn?”
4) You should also to test your installation with the =BDP and =BDH Bloomberg Excel functions now. For example, typing:
=BDP(“IBM US EQUITY”,”PX_LAST”)
in cell A1 should return the last trade price of IBM.