We
have found the best way to help somone is by showing them,
thus we have created a series of flash movies demonstrating
how to use the various parts of the system. The movies are
easier to view when your browser is in full screen mode .
In IE just press F11. Also, if it is skipping on the internet
let it run through once, then the second time it will be cached.
Lastly, turn your speakers on, the movies are narrated.
.
Updating
Quotes:
Go to "Data" then on the MSN MoneyCentral Stock
Quotes toolbar, click Update Quotes.
Note The Update Quotes button is unavailable until updated
values are returned to the worksheet, and for five minutes
after these values are returned. Values are always delayed
by at least 15-20 minutes.
Stopping
the Update:
On the MSN MoneyCentral Stock Quotes toolbar, click Cancel
Update.
Troubleshooting
Using
Excel 2007, TradeSmart V3, and the MSN MoneyCentral Stock
Quotes
If
you are having issues with Excel 2007 and quotes the MSN add
in may need to be added to the list of Add ins that are available
to excel. Here is how you do that
1.
Make sure you have installed the msnsq.exe Add In that came
with TradeSmart. You can also download it directly from Microsoft
at: http://www.microsoft.com/downloads/details.aspx?FamilyID=485FCCD8-9305-4535-B939-3BF0A740A9B1&displaylang=EN
2. Click the Microsoft Office Button , and then click Excel
Options in the bottom right hand corner.
3.
Then click Add-ins. . That will show you your active and inactive
add ins. If it is inactive go to Manage: “Excel Add Ins” click
go.
4.
Then check the “MSNStockQuote.Functions” check box.
5. Then Click OK.
I
see #VALUE! errors where my stock quotes should be
If
this happens on a few symbols, the symbol is either incorrect
or there is no quote on MSN for that symbol. In either case
the actual cost will be used in the market value calculations.
Check
to be sure that:
You
can connect to MSN MoneyCentral via the Internet.
.
The add-in is loaded properly, and that the MSNStockQuote.Functions
check box is selected in the Add-ins dialog box (Tools menu).
If MSNStockQuote.Functions is not listed, click Automation,
and then click MSNStockQuote.Functions in the Automation servers
available list.
If you're not sure the add-in is loaded properly, try uninstalling
and reinstalling the add-in while you're connected to the
Internet. See the section above titled Uninstall the add-in.
The
add-in is not disabled. Click About Microsoft Excel on the
Help menu, then click Disabled Items. If MSN MoneyCentral
Stock Quotes Function Add-In is in the list, click it and
click Enable.
Macros are not disabled. Macros may be disabled if:
When you installed the add-in, you cleared the Always trust
macros from this source check box, and/or clicked Disable
Macros in the Security Warning dialog box. To return to the
Security Warning dialog box so you change these settings,
quit Excel, start Excel, and attempt to insert a stock quote.
The Always trust macros from this source check box is disabled
on the Security Warning dialog box. You can change the security
setting on the Security Level tab of the Security dialog box
(Tools, Macro menu) to medium. See Excel Help for more information.
I
see #NAME? errors where my stock quotes should be
If
you used the Export to Microsoft Excel command in Internet
Explorer, the add-in may not be loaded properly. Save your
files, quit Excel, open Excel, and open your files again.
Check to be sure that the add-in is installed, and that the
MSNStockQuote.Functions check box is selected in the Add-ins
dialog box (Tools menu). If MSNStockQuote.Functions is not
listed, click Automation, and then click MSNStockQuote.Functions
in the Automation servers available list.
If you're not sure the add-in is loaded properly, try uninstalling
and reinstalling the add-in while you're connected to the
Internet. See the section above titled Uninstall the add-in.
If you're sure the add-in is installed and loaded, click Insert
Stock Quotes on the toolbar, click Cancel in the dialog box,
and quit Excel. Then, open Excel.
Make sure the add-in is enabled by clicking About Microsoft
Excel on the Help menu, then clicking Disabled Items. If MSN
MoneyCentral Stock Quotes Function Add-In is in the list,
click it, and click Enable.
My stock quote values are not updating when I click Update
Quotes
The
Update Quotes button is not available for five minutes after
the last time you update.
Values
are always delayed by at least 15-20 minutes, so it is possible
that the previous values will be returned.
If
the market is closed (after hours, holidays or weekends) the
previous values will be returned.
Tip To make it easy to determine the time or date of the last
returned quote, include the Time of Last Sale or Date of Last
Sale properties as part of the information you return for
quotes.
The MSN MoneyCentral Stock Quotes toolbar disappeared
On
the Data menu, click Stock Quotes from MSN MoneyCentral, and
then click MSN MoneyCentral Stock Quotes Toolbar.
The
MSN MoneyCentral Stock Quotes toolbar doesn't work or only
has Stop and Refresh buttons
Make
sure the add-in is installed properly by uninstalling and
reinstalling the add-in while you're connected to the Internet.
See the section above titled Uninstall the add-in.
Make
sure the add-in is enabled by clicking About Microsoft Excel
on the Help menu, then clicking Disabled Items. If MSN MoneyCentral
Stock Quotes UI Add-In is in the list, click it, and click
Enable.
The
Update Quotes and Cancel Update buttons are disabled
Immediately
after an update, both the Update Quotes and Cancel Update
buttons are disabled for 5 minutes.
If
it has been more than five minutes since your last update,
make sure the add-in is enabled by clicking About Microsoft
Excel on the Help menu, then clicking Disabled Items. If MSN
MoneyCentral Stock Quotes Function Add-In is in the list,
click it, and click Enable.
If
it has been more than five minutes since your last update,
make sure the add-in is installed properly by uninstalling
and reinstalling the add-in while you're connected to the
Internet. See the section above titled Uninstall the add-in.
I
get an error message when I try to update values
Make
sure you are connected to the Internet and have access to
MSN MoneyCentral.
Check
MSN MoneyCentral to make sure it is available and working
correctly. To do this, type the address for MSN MoneyCentral
(http://www.moneycentral.msn.com/home.asp ) in your browser.
Click
Cancel Update, and then click Update Quotes again.
I
get a message that says the function that retrieves quotes
failed.
Make
sure macros are enabled for MSNStockQuote.dll. When you install
the add-in, you should select the Always trust macros from
this source check box, and click Enable Macros in the Security
Warning dialog box. If you didn't do this when installing,
you can return to the Security Warning dialog box without
reinstalling by quitting Excel, starting Excel, and inserting
a stock quote.
Before
you save the workbook that the stock quotes are in, make sure
that none of the stock quotes are returning error values such
as #VALUE! or #N/A. You can update the quotes by clicking
Update Quotes on the toolbar, or clear the cells that are
resulting in error values before you save the workbook.
For
Further assistance please contact us through our contact
page.
