Stock Quotes


MSN Money Stock Quotes

More Info
create a page, link Yahoo Finance


finance.yahoo.com/quote/USDCAD=X?ltr=1


.iqy Files


Latest Exchange Rates
floatrates.com/daily/usd.xml
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.






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