Bloomberg: Downloading Asset Data to Excel

Downloading Asset Data

After exploring some different price histories, it’s time to save some data.

• Open Excel

 

[accordion]
[acc title=”BLOOMBERG MENU IN EXCEL” icon=”menu-1″]

[separator top=”30″ style=”none”]

• If the Bloomberg application is full-screen, you can make it smaller (so you can access Excel and other programs) using this menu.
• You also use this menu to log out, after you’re finished.

[separator top=”30″ style=”none”]

[separator top=”30″ style=”none”]

• Choose to import real-time historical end-of-day data.

[/acc]

[acc title=”DATA WIZARD” icon=”chart-bar-1″]

This opens up the Data Wizard, which has several steps.

1. First, choose an asset by typing its name or ticker symbol. It will appear in the menu.[separator top=”30″ style=”none”]

[separator top=”30″ style=”none”]
[separator top=”30″ style=”none”]

• Double-click it to add it to the list on the right.
• Repeat for several assets. [separator top=”30″ style=”none”]

[separator top=”30″ style=”none”]

[/acc]

[acc title=”EXPORT TO EXCEL” icon=”export-1″]

1. Click “Next“, and you’ll see options for which data to import.
2. Search for “last price“, and
3. Double-click to add it on the right.[separator top=”30″ style=”none”]

[separator top=”30″ style=”none”]

[separator top=”30″ style=”none”]

• Click “Next“, and you’ll see options for date ranges.
• Choose to get 30 days of data as shown.
• Click “Next” again, and keep clicking “Next” to skip the remaining steps of the wizard.
• Finally click “Finish” and after a few seconds your data will appear.

Take a look. You will see two Excel columns filled with data – the date, and the closing price of the chosen asset. If the date looks like ######, just widen the column a little.

Finally, make sure to save the Excel spreadsheet and either email it to yourself or copy it to a USB stick. [separator top=”30″ style=”none”]

[/acc]

[/accordion]