Answered By: Jen Beauregard
Last Updated: Apr 25, 2016     Views: 69733

Log in to Bloomberg Professional

  • In Excel, use the step-by-step wizards by choosing Import Data from the Bloomberg menu or the Bloomberg toolbar.
  • In Excel, type in functions using the following syntax:
    • For current data for a single security: =bdp("ticker market sector","data item"); e.g., =bdp("f us equity","last_price") for the lastest price of Ford stock.
    • For historical data for a single security: =bdh("ticker market sector","data item","start date","end date"); e.g., =bdh("f us equity","px_last","10/01/07","10/31/07") for the last price of Ford stock each day in October 2007.

Related Topics