Improved Features:
1. With this version queries use two sources: Yahoo! Finance and MSN Money. As a result, Stock Quotes now has a broader coverage worldwide, so you can see the indices available in both sources, as well as the available data items.
2. The ‘Stock Quotes Wizard’ has been fully redesigned so you can query for Stocks, Mutual Funds and Stock Market Indices in a more intuitive fashion.
3. The ‘Stock Quotes by Date Wizard’ functionality has been redesigned to make it more intuitive and descriptive.
4. The query method for historical prices has been improved with the SQByDate( ) function.
5. The ‘Stock Quotes-Quick Fill’ functionality has been redesigned to support data queries on Yahoo! Finance and MSN Money, showing the available data items in each data source.
6. The ‘Refresh Settings’ functionality has been improved, which is used to configure the time interval for automatic data update.
7. The ‘Data Downloader’ functionalities have been improved to make data queries both more efficient and faster. It now includes the ‘Dividends Only’ option, which you can use to query for the dividends of selected tinker symbols. You can also use it to plot a chart of such dividends so you can analyze trends.
8. The functionality that in prior versions was called ‘Retrieve the company symbol’ has been renamed as ‘Search for company’s symbol’, which provides two links to the Yahoo! Finance and MSN Money websites so you can look up company symbols there.
9. The ‘Retrieve company name’ functionality is now faster.
10. The ‘Export Stock Quotes’ functionality has been redesigned to support data export from both Yahoo! Finance and MSN Money.
11. The ‘Export Market Indexes’ has been redesigned to support stock market index data from both Yahoo! Finance and MSN Money.
12. A message has been added to the ‘Export sheet values’ functionality to tell the user that a copy of the active sheet has been created with values instead of formulas. This is especially useful when the user needs to get quotes as values rather than as the result of formulas with Stock Quotes functions.
13. The ‘Alternate rows shading’ functionality has been improved to create alternate lines much faster than before.
14. Data query algorithms have been improved, so now queries are much faster.
New Functionalities:
1. New functions have been included, SQY( ), INDXY( ), which allow you to get stock prices and stock market index information from Yahoo! Finance, respectively.
2. Now you can use the ‘Data Downloader’ functionality to download Dividends as part of historical data.
3. The ‘Create a watchlist rapidly’ functionality has been created. You can use it to create a watchlist with such basic data as Symbol, Last, Change, % Change, High, Low, and Volume. This tool includes conditional formats so the cells will be colored depending on the values of updated data, similar to the Yahoo! Finance and MSN Money websites. |