Saturday, September 4, 2010

The easiest way to get Bloomberg data into Excel

There are many tools for getting Bloomberg data into Excel. The easiest way is using Windows copy-and-paste. I've got a short, low-quality video of doing exactly that.

If you make a graph of a price in Bloomberg, Use the Copy, Copy data to Clipboard commands, you can then paste the data into Excel.

This solution is not as elegant as using the API provided by Bloomberg, but it's very flexible and fast!

The video demonstration of this technique is at:
http://glennpowers.fileave.com/EasyDataFromBloomberg.wmv

No comments:

Post a Comment