Stock Quotes for Excel is a powerfull Excel add-in that allows you to update Stock Quotes automatically, Market Indexes and Mutual Funds into your Excel spreadsheets - via Internet. No more manual and tedious updates. No more risk of using outdated data.

Stock Quotes for Excel is like any other Excel function. When the function is inserted in any cell or inside a formula, the add-in refreshes the quotes automatically, indexes and funds with the latest data.

Moreover you are able to:

• Obtain an historical report of the stock market quotations letting yourself to adjust the inicial and final dates using the tool: Data Downloader.
  
• Obtain more than 10,000 stock market quotations at the same time at only one click.
  
• Adjust as you wish the time to update the stock quotes.
  
• Obtain all the data of a specific quotation in determined date using: Stock Quotes by Date Wizard.
  
• Use more useful tools such as:
  • Refresh Settings
  • Export Stock Quotes
  • Export Market Indexes
  • Export Sheet Values
  • Cell's math by format
  • Multiple Conditional analysis & formatting
  • Select by Format
  • Guides
  • Arithmetic Calculator
  • Change Color Palette
  • Sheets Manager
  • And more....

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.

Enhancements in this New version 4.0.3 of Stock Quotes for Excel:

DataDownloader (Financial Statements), modified due to changes in the data supplier MSN Money Central Investor.

Moreover, Stock Quotes for Excel is TOTALLY COMPATIBLE WITH EXCEL 2007 and WINDOWS VISTA!!!

NOTE: Please, take into account that the tool “Stock Quotes by Date” of our product SQ recovers historic stock quotes coming from free services of MSN Money and Yahoo Finance Which are NOT ALWAYS available or don't accept big quantities of historic consultations.

Therefore we only guarantee an optimal performance of our product: SQ for small and medium portfolios.
If you are working with big portfolios and a great quantity of symbols is better to request paid services of any Stock Quotes's supplier.