LSE‎ > ‎

FTSE 100

Historical stock prices for the FTSE 100 stocks can be downloaded using either the bulk downloader spreadsheet or online.

You will need to feed the FTSE 100 symbols list into the spreadsheet or download page.

Best for 1 month - 10 years of data.
Excel Spreadsheet Macro.

To download the data, perform the following steps:
  • Download the spreadsheet: historical data downloader.xls.
  • Paste the FTSE 100 symbols into the symbols tab of the spreadsheet.
  • Choose your start and end dates. 
  • For the spreadsheet, the default location to save the historical files is C:\historicaldata\. You can change this to any location you prefer.
  • Select your data frequency
    • EOD (end of day) - Daily
    • End of Week - weekly
    • End of Month - monthly
  • The download functions can include data where the close price is unadjusted (raw) or adjusted for stock splits and dividends.
The spreadsheet will download the historical prices for each stock in metastock csv (comma separated values) files. Each stock will be contained in its own file.

If you want to download more stocks that are not in the FTSE 100 index list, you can feed this into the spreadsheet. Put each stock symbol into cell A2, A3, A4...etc. One cell per stock symbol. You will also need to put the '.L' suffix at the end of each stock for the London Stock Exchange. Press the 'download' button.

Once you've downloaded your historical data, you can import them into your technical analysis software program.

Daily Download

Best for 1 day - 1 month of data.
Online Download.

To download the data, perform the following steps:
  • Save the FTSE 100 symbols.
  • Paste the symbols into the stocks text area.
  • Choose your start & end dates, and data format.
  • Select 'Download'.
  • Once the download has completed, save the data into a text or .csv file.

Yahoo! Finance