Stock Quotes

MSN Money Stock Quotes

More Info
create a page, link Yahoo Finance

.iqy Files

Latest Exchange Rates
Data > Get External Data > From Other Sources > From XML Data Import

add filename (SS) http://
Excel will tell you there is no XML Schema.
Press OK to let Excel create one for you
Browse to the top left cell
Before pressing OK, press Properties and change the Name (SS)

Linked Data Type - Stock

Stock Quotes - Morningstar

This lets you display stock prices and other company information
This includes:
1) Company Data
2) Historical Data
3) Real-Time Index Quotes
4) Delayed Quotes
5) Dividend Data

A large number of exchanges are supported (inc link)

Using a Ticker Symbol

Using a Company Name

Using a Fund Name

Excel will try to find a match
If a match has been found the text/cell will be converted to a stocks data type
If a match has not been found a question mark will be displayed. Clicking on this will display the Selector task pane

Add Column Smart Tag

Click on the Add Column button to insert additional columns (or press Ctrl + Shift + F5)

Convert to Table

When the records are in a table, you can use column names in the formulas.

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext