Stockwatch Excel RTD Plugin
Stockwatch has a RealTimeData (RTD) plugin for Excel 2007 or later.
This plugin provides realtime updating of various stock data in your cells, either single stocks or portfolios.
When installed, it adds a tab "Stockwatch Quotes" to the toolbar in Excel, which you can use to configure the plugin.
To install the Stockwatch RTD plugin, download and install the Stockwatch Desktop:
Install Stockwatch Desktop and Excel Plugin
The RTD plugin requires the Microsoft .NET Framework version 2.0 or higher.
The setup program will prompt to you install this if you do not already have it, OR you can install the framework directly from Microsoft with this link:
Stockwatch Web Query
This feature allows you to automatically download stock information, either into a spreadsheet such as Excel, a file,
or any application program that can automatically extract data from web pages.
We have a sample Excel spreadsheet which contains a macro for automatic stock price download.
Click here to download the spreadsheet.
Stockwatch subscription level Trader or higher is required for this function.
You must be logged in to the Stockwatch web site before this web query will function.
Authorization with Internet Explorer and Windows - if you are logged in with IE on Windows, the web query will work without the auth parameter.
Excel on Windows will share your current login session that you started in IE.
Authorization with any other browser or operating system - you must supply the auth parameter.
This value changes every time you login to Stockwatch with your web browser.
Your macro must prompt you for this when it starts, and append it to the web query URL on every access.
You can copy and paste your current auth parameter from here:
You are not logged in!
How To Use
Use this template to construct a URL for use as a web query in Excel:
&fields=<list of field codes>
&pf=<portfolio number - omit if you enter symbols>
&symbols=<symbol list - omit if you use a portfolio>
®ion=<default region (C or U)>
&auth=<auth parameter - omit if not needed>
Test the Query
Available fields for stock quotes and close prices
| S ||symbol|
| X ||exchange|
| R ||region|
| D ||bid size|
| B ||bid price|
| A ||ask price|
| F ||ask size|
| L ||last price|
| C ||price change|
| V ||volume|
| W ||dollar value|
| O ||open price|
| H ||day high|
| I ||day low|
| T ||#trades|
| Y ||year high|
| Z ||year low|
| P ||open interest|
| E ||last trade time
| p ||p/e ratio|
| y ||dividend yield|
| s ||shares issued|
| d ||dividend per share|
| x ||ex-dividend date|
Base symbols are unique to a company within Canada and within the US,
but the same symbol may be used simultaneously in both regions to represent two different companies.
Each quote query includes a default region - Canada or US. If you do not specify an exchange code,
your symbol will be searched in the default region. To specify a specific region, precede your symbol
with the code and a colon eg U:MSFT U:IBM T:RY.
|U||USA||All US symbols|
|C||Canada||All Canadian symbols|