skip to Main Content

Historical Stock Prices Scraper

4.0 (5 reviews)

With Historical Stock Price Scraper you will get historical stock data straight into this Excel Template included list of company symbols!


Learn more about License Types

Someka refunds icon


Someka one time payment icon


Someka direct download icon



Are you new to stock market? Or a professional trader? It doesn’t matter your experience. Everyone must see the data from the past and discover patterns to be a successful trader and not rely on luck. Traditionally, historical quotes on stocks were harder to learn and fetch, but this is no longer the case with this scraper tool.

Historical Stock Prices Excel Template brings key historic data of NASDAQ and NYSE for analysis with just a click of a button!

The analysis of previous data can give you an insight on the following aspects:

  • Can provide you with an idea of which characteristics are normal and which are extraordinary and that might help you take important decisions on when to buy or sell.
  • Looking on how a stock performed over time, there is less likely that you will get unexpected results

Historical Stock Prices Scraper Excel Template Features:

This template provides row data with several options for time selection that is ready for you to build graphics and perform analysis.

Lets see details of the Dashboard:


Dashboard is a kind of scraper page to get historical data for NYSE and NASDAQ stocks. All you have to do is just putting your company symbols in the “Symbol” cell on the left and after you get your API Key, click “Fetch New Data” button. All other information of the table will fill out automatically.


On the top right section, you can change the time frame according to your needs.

How to Get My API Key?

Historical Stock Prices Template will provide the framework to fetch data from IEX platform so we are not the seller / owner of the data. You can get your API with a few simple steps:

  • Create an Free account here:
  • You can Select START as a Free plan and that includes:
      • – 500,000 Messages per month
      • – No credit card needed
      • – Non-commercial use only
  • After that, you will go to this page: and you can click on API Tokens from the list at the left hand side:


  • Then press on “Reveal secret token” button and your API Key  Code  will show up to copy it to the clipboard. Finally you can paste it as value to the “API Key section” of the Historical Stock Prices Template



There are 2 navigational buttons that you can use to move throughout the template. Indicator Explanation will give details of each indicator here. You will find the following data categories for each stock symbol for a period up to 5 years.

– Open price – The open is the first price traded at the beginning of day
– High price – The high is the greatest price traded during the day
– Low price – The low is the lowest price traded during the day
– Close price – The close is the last price traded at the end of the day
– Volume – Represents the total stocks on the market
– Change – The price of the stock, compared with last close price
– Change percent – The price of the stock, compared with last close price, shown as percentage

Warning! Please note that this template only provides row data and does not include any further analysis.

Company Symbols List is a comprehensive list of all stock symbols you can use in this template. Use this section if you are not sure about your symbol of a company.


Historical Stock Prices Scraper Features Summary

  • No installation needed.
  • Easy-to-use Stock Price Scraper
  • Historical data from 1 day to 5 years
  • No monthly fees
  • Suitable for both beginner and experienced traders
  • One click access to data
  • On Sheet Instructions
  • Compatible with Excel 2007 and later versions

This excel template is ready-to-use and provided as is. If you need customization on your reports or in need of more complex templates, please refer to our custom services.


Watch the video below to see the template in action! Presentantation also includes usage notes, explanations and tips & tricks about the template.



5 reviews for Historical Stock Prices Scraper

  1. Frank4

    Really nice spreadsheet.. no waste of time at all………… thanks for ur effort

  2. Chloe P

    This was great, thanks, I have been researching “historical quarterly stock prices” for a while now, and I think this has helped

  3. David Scheer

    Didn’t work for one day for me either. Also was hoping this was actually a ‘template’ as described, and I could use it to build my own custom form, but all the functions are hidden even after unlocking the workbook, and it’s not very flexible. Wanted to get just a single past date historical quote, but to get that, I have to get 5 years of data and find the date I’m interested in. Frankly this was a waste of money for me. Going back to the IEX Cloud API docs to build my own for free.

    • Someka

      Hi David,

      First of all, thanks for your time to spend to write feedback. All comments are welcomed!

      Apparently, the real reason why it wasn’t working for a one-day time frame is the data providers made some changes in the structure of data. The only thing you should not avoid is entering your API Key.

      Our developer team have sent an e-mail regarding the issue, please check your mailbox to get detailed information about it.

      Hope this clarified things up for you David, otherwise please do not hesitate to contact us.

  4. khanna

    Didn’t work on for one day time frame like it should

  5. janellperez

    Used your template many times. Good design and features.

Leave a customer review

Your email address will not be published. Required fields are marked *