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.
- 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″]
- Click “Next“, and you’ll see options for which data to import.
- Search for “last price“, and
- 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 filled 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]