The add-in allows getting intraday stock prices of US and worldwide stocks from MSN Money 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 5 or 15 minute period.
MSN Money LinkClick to open the stock page at MSN Money.
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 Intraday 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.

Source Data and Calculations

The add-in loads source data from MSN Money. Other services are not used.

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

MSN Money publishes 5-minute prices for the current day and 15-minute prices for the last five days.

Tips and Tricks

Getting Tickers

The add-in loads data from MSN Money directly.

To find a ticker, you may click on the Open at MSN Money link.

Then find a ticker and paste it into the ticker text box.

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 shows 20 last rows only.

The paid version shows all the data published: one day for 5 minutes and the last five days for 15 minutes.

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.