Bloomberg: Downloading Financial Statement Data

Downloading Financial Data

After you have logged into the terminal, start Excel from the start menu in Windows. You may need to move your mouse to the bottom of the screen or minimise some of the Bloomberg windows in order to see the start menu.

[alert type=”error” title=”Caution!” animation_type=”0″ animation_speed=””]

Make sure you do not log out of the Bloomberg terminal as the data collection in Excel only works when you are logged in.[/alert]

[accordion]
[acc title=”Starting Excel” icon=”laptop”]
You should see the following ribbon bar when Excel starts:[separator top=”30″ style=”none”]

[/acc]
[acc title=”Open Bloomberg” icon=”off”]
Click on Bloomberg and the Bloomberg ribbon appears.[separator top=”30″ style=”none”]

[/acc]
[acc title=”Data Navigation” icon=”spread”]
Click on Data Navigation.
A box should appear to the right of your spread sheet.[separator top=”30″ style=”none”]
[separator top=”30″ style=”none”]
Put the ticker in the box and click on Financial/Valuation.[separator top=”30″ style=”none”]

[separator top=”30″ style=”none”]Click Income Statement in the next box.[separator top=”30″ style=”none”]

[separator top=”30″ style=”none”]The box now displays Apple’s Income Statement. Use the arrow button to drag the numbers onto the blank spread sheet.[separator top=”30″ style=”none”]

[/acc]
[acc title=”Return Excel Spreadsheet” icon=”chart-bar-1″]
Apple’s Income Statement should now appear in your spread sheet.[separator top=”30″ style=”none”]
[separator top=”30″ style=”none”]
[alert type=”info” title=”Tip!” animation_type=”0″ animation_speed=””]

When you have collected your data you should click on the top left hand corner of the sheet then right click and select copy then right click again and select ‘Paste Special’ and Values. This will convert the formulas in the sheet into numbers. You can now save the sheet on a USB key and use it on your own computer.[/alert]
[/acc]
[/accordion]

Notes:

[checklist icon=”check” iconcolor=”#dd9933″ bg_icon=”square”]

• A wide range of data is available in Bloomberg for most listed companies. Take the Bloomberg University training course for more information.
• Data is available for Irish Companies (try CRH:ID) for CRH.
• Historic stock prices are available.

[/checklist]