Intraday Prices Excel Add-In
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.
Task Pane Controls
|Ticker Text Box||Specify stock tickers.|
|Get Prices Button||Click to insert a new table or to update prices in the current table.|
|Trade Period Combo Box||Select a 5 or 15 minute period.|
|MSN Money Link||Click to open the stock page at MSN Money.|
|Home Link||Click to open this page.|
|Privacy Link||Click 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.
|Date||Trade dates for daily prices or the last dates of weekly and monthly periods.|
|Change||Calculated price change.|
|ChangePercent||Calculated 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
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.
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.
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.
Supported versions of Microsoft Excel:
- Microsoft Excel 2013
- Microsoft Excel 2016
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.
- Google Analytics.
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:
- Microsoft Services Agreement at https://go.microsoft.com/fwlink/p/?linkid=530144
- Yahoo! Terms of Service at https://policies.yahoo.com/us/en/yahoo/terms/utos/index.html
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.