Hey guys, I have access to a bloomberg terminal but I don't know how to use it. All I really want to do is export historical data on the S&P500 and DJIA for the past 50 years (though I don't even know how far back bloomberg will go) so I can play with it in excel. Easy way to do this?
If you live in NYC or another city that Bloomberg has offices, you can take a free class on how to use the terminal. The owner of the terminal has to sign you up. Bloomberg is not very user friendly. Feels like your using PC-DOS.
Start Excel on that machine and use the Bloomberg Add-In toolbar to import data. It's pretty self-explanatory (there's a big "Import Data" button) and the wizard will walk you through it.
if you're still having probs after using the excel add in, press <HELP> twice and make them someone else's probs