Available Information
The data you can retrieve from both sources are listed below:
Stock and mutual fund quotes
These elements may be queried with the functions SQ( ) and SQY( ) For the SQ( ) function, consider the MSN Money list. For the SQY( ) function, consider the Yahoo! Finance list.
Examples:
With these functions, you can query for any kind of quote information available in both sources. These are the links listing all quotes available in each: http://help.Yahoo!.com/l/us/Yahoo!/finance/quotes/quote-02.html http://finance.Yahoo!.com/lookup
Querying for Stock Market Indices
All stock market indices available to both providers are listed below:
The data available for each is listed below:
Index data should be queried with the Indx( ) and Indxy( ) functions, for MSN Money and Yahoo! Finance, respectively.
Note: Notice that both sources use different symbols for the same index; however, this is not always the case when querying for stock prices. For example, both SQ( ) and SQY( ) use MSFT as the ticker symbol for Microsoft.
These are the links of the websites showing all stock market indices available to Yahoo! Finance and MSN Money, respectively: http://moneycentral.msn.com/investor/market/usindex.aspx http://finance.Yahoo!.com/indices
Querying for Historical Quotes
Use the SQByDate( ) function to query for historical data. The parameters are: SQByDate("MSFT","6/28/2007","Close") For the second parameter, i.e. the date, make sure it is not a Saturday or Sunday, since there are no historical data available those days. Notice that the format is MM/DD/YYYY
* Only available in Yahoo! Finance	http://finance.Yahoo!.com/q/hp?s=MSFT
* If your query includes too much historical data, it may take quite long. So please always bear this in mind. * The date may not be today's, since there are no historical data for the current day. For example, there is no close price, since the exchange is still open and stock trading has not yet been closed.