The add-in allows getting daily, weekly and monthly historical prices of US and worldwide stocks and indexes from MSN Money, Yahoo Finance, and Google Finance into Microsoft Excel.

The add-in works in Microsoft Excel 2013/2016, Excel Online, and Excel for iPad.

User Interface

Task Pane Controls

ControlDescription
Ticker Text BoxSpecify stock tickers.
Get Prices ButtonClick to insert a new table or to update prices in the current table.
Trade Period Combo BoxSelect a daily, weekly or monthly period.
Provider Combo BoxSelect a provider like MSN Money, Yahoo Finance, or Google Finance.
Start Month Combo BoxSelect a start month.
Start Year Combo BoxSelect a start year.
End Month Combo BoxSelect an end month.
End Year Combo BoxSelect an end year.
MSN Money LinkClick to open the stock page at MSN Money.
Yahoo Finance LinkClick to open the stock page at Yahoo Finance.
Google Finance LinkClick to open the stock page at Google Finance.
Home LinkClick to open this page.
Privacy LinkClick to navigate to the privacy statement.

Showing and Hiding Add-in Task Pane

To show the add-in task pane:

  • Click the INSERT tab.
  • Click the My Apps control in the Add-ins group.
  • Select the Historical Prices app.

To hide the add-in, close the add-in task pane.

Data Fields

FieldDescription
SymbolStock ticker.
DateTrade dates for daily prices or the last dates of weekly and monthly periods.
VolumeTrade volume.
OpenOpen price.
HighHigh price.
LowLow price.
CloseClose price.
ChangeCalculated price change.
ChangePercentCalculated price change in percent.
ShortTermSMAThe calculated simple moving average for 50 periods.
LongTermSMAThe calculated simple moving average for 200 periods.
AvgVolumeCalculated average trade volume for 50 periods.

Source Data and Calculations

The add-in loads source data only from the specified provider (MSN Money, Yahoo Finance, or Google Finance). Other services are not used.

The data are not cached and updated whenever you click the Get Prices button.

The add-in calculates fields described above and may calculate aggregated values if they are absent in a source.

ProviderDescriptions
MSN MoneyMSN Money publishes daily history for one year, weekly history for five years, and monthly history for the entire period.
Yahoo FinanceYahoo Finance publishes daily, weekly and monthly histories for the entire period.
Note that the add-in recalculates the Open, High, Low and Close values using the source Close and Adj Close fields.
You may compare results with data from another provider to be sure that the data is correct.
Google FinanceGoogle Finance publishes daily history for the entire period. The add-in calculates weekly and monthly histories.

Tips and Tricks

Getting Tickers

The add-in loads data from MSN Money, Yahoo Finance or Google Finance directly.

So you have to specify tickers available at the specified data provider.

The most of US tickers are the same for all data providers.

Tickers for worldwide markets may differ from a provider to provider.

For example, Glencore Plc traded at London Stock Exchange has the GLEN ticker at MSN Money, GLEN.L at Yahoo Finance, and GLEN or LON:GLEN at Google Finance.

To find a ticker, click on a link of a required provider and find it on a provider website.

Then paste it into the ticker text box.

Note that you may get historical data for market indexes from Yahoo Finance.

For example, use ^GSPC for the S&P 500 Index or ^FTSE for the FTSE 100 Index.

Working with Tables

You may easily add columns to data tables at the right side or inside the table.

You may use formulas. The add-in inserts data in the consistent order, from the newest to the oldest.

You may reorder columns.

You may delete source columns. In this case, the add-in does not restore and does not update columns.

To restore deleted column, just insert a column and type a column name as it is named in a source data.

For example, to restore the price change column, type Change in the column name.

You may create multiple tables on a worksheet or on multiple worksheets.

The add-in adapts task pane controls to the selected table.

The add-in has a particular behavior when you select a new worksheet. It may show values on a task pane for a table on a previously selected worksheet.

To update task pane controls, just click on any cell in a table.

Trial Period

We hope that our add-in will help you to make trading decisions better and faster.

You have 15 days to test the add-in and to make a decision about the purchase.

The trial version has the following limits for loaded data:

  • 50 trade dates for daily history.
  • 12 weeks for weekly history.
  • 12 months for monthly history.

Purchasing

You may purchase the add-in in the Microsoft Office Store.

This is a one-time fee.

You will have free updates of the add-in.

System Requirements

Supported versions of Microsoft Excel:

  • Microsoft Excel 2013
  • Microsoft Excel 2016

Getting Support

Feel free to contact us via email at or .

Privacy Policy

The add-in never collects or stores information that can be used to identify you.

The add-in never collects or stores information about loaded data and tickers.
The add-in makes requests directly to data provider websites or web services using the Yahoo! YQL web service.

The add-in makes requests using encrypted HTTPS connections.

The add-in is a part of the stock-data-solutions.com website.

At the stock-data-solutions.com website we can use:

  • Web server log files.
  • Cookies.
  • Google Analytics.

Please read details in the stock-data-solutions.com Privacy Policy.

Compliance with Data Provider Terms of Services

The Historical Prices add-in loads data from data provider websites or web services directly using the Yahoo! YQL web service.

See important documents about data use:

Disclaimer

All information provided "as is" for informational purposes only, not intended for trading purposes or advice. Neither Gartle Technology Corporation nor any of independent providers is liable for any informational errors, incompleteness, or delays, or for any actions taken in reliance on information loaded by the add-in.

MSN and Microsoft Excel are logos and registered trademarks of Microsoft Corporation.
Yahoo Finance is a logo and registered trademark of Yahoo! Inc.
Google Finance is a logo and registered trademark of Google Inc.