Our FAQs have moved!

As of August 7, 2024, Baker Library's FAQs have moved to https://www.library.hbs.edu/services/help-center.  Please visit Baker's Help Center to find our research FAQs and send us your questions.  Thank you!

Answered By: Austin Haley
Last Updated: May 13, 2024     Views: 49990

Q.
Stock prices: current & historical

Where do I find current or historical company stock prices?


A.

Bloomberg is best for current prices (Note: There is a 20-minute delay).

  1. Type a company ticker and then hit the EQUITY key; e.g., MSFT US [EQUITY] for Microsoft Corp. stock.
  2. Type HP and then hit GO for historical prices.
     

LSEG Workspace is good for downloading a time series:

  1. Type a company name or ticker into the main search bar and select the appropriate company to load the company overview.
  2. Hover over the Price & Charts tab and select Price History.
  3. Specify the desired frequency and time period.
  4. You can download this data into Excel.
  5. Another option is to choose Chart under Price & Charts.
  6. Expand the filter to the left of where it says ‘Templates’ to add in another company, and/or use the icons on the right to customize the chart with things such as ‘Add an Event Marker’.
  7. To download the data, click on the fifth icon from the right and select ‘Export to Excel’.
  • For a multimedia learning module on LSEG Workspace check out our Learn with Baker Library LSEG Workspace Introduction.

Capital IQ is also good for downloading a time series:

  1. Mouse over Charting, and then select Chart Builder.
  2. Near the center of the screen click on Advanced Search to add companies by Tickers or, by Company Search, to Add from Lists (from within CIQ), or Add Indices.
  3. Add desired items then click on Add to Chart.
  4. Click on Chart Options then Advanced Options to enter a custom time period and change the frequency. Click on Update Chart.
  5. To download the data click on the Excel icon above the chart.

  Note: All source above adjust for stock splits. (CRSP data in WRDS is not adjusted for splits).

See also the 'Market Data' section of the Baker Library Research Guide on Financial Markets