Spreadsheet Stock Quotes

Description
Functions
How To Videos
Documentation
Customers
Price

What is Spreadsheet Stock Quotes?

Spreadsheet Stock Quotes is a powerfull add-in software for Microsoft® Excel® which allows you to automatically obtain up to date data on Stock Quotes, Market Indexes, historical data, option prices and Mutual Funds, directly into your Excel spreadsheets – via Internet. For that purpose, Spreadsheet Stock Quotes has a number of Excel-based functions, which Stock Quotes uses to retrieve current and historical data. No more manual and tedious updates. No more risk of using outdated data.

Model Builder for Excel, Robust set of Excel tools

Moreover, Spreadsheet Stock Quotes is TOTALLY COMPATIBLE WITH EXCEL 2010 and MICROSOFT® WINDOWS 7!!!

Highlight Features

Spreadsheet Stock Quotes has many features:

Stock Quotes Wizard
Create a watchlist rapidly
Stock Quotes by Date Wizard
Stock Quotes by Date 2 Wizard
Stock Quotes – Quick fill
What are the advantages? You can perform the following: It seamlessly integrates to Microsoft Excel with functions that allow you to intuitively enter parameters, and query online for their values. You can query online for current and historical data, directly in Excel. You can refresh data either manually or automatically at customized time intervals, without disturbing your work in Excel. Spreadsheet Stock Quotes is a mature product in the global market and has thousands of users around the world. All functions have a step-by-step wizard, so you just can’t fail to understand how Stock Quote works! Spreadsheet Stock Quotes includes example videos for all tools, in addition to the usual help texts. Spreadsheet Stock Quotes fetches online quotes from two well known and renowned sources worldwide, as you will see below. Where does Spreadsheet Stock Quotes fetch quote values from? MSN Money Central Investor (http://money.msn.com) Yahoo! Finance (http://finance.yahoo.com/) What are the restrictions? Spreadsheet Stock Quotes query for data from the above sources, so we are subject to the features provided by them, as detailed below Spreadsheet Stock Quotes will not show current intraday data Saturdays or Sundays, and may not even show any data at all those days. No historical data is shown on Saturdays and Sundays. So please make sure to query for such data on weekdays. Not all Company or Stock Index ticker symbols are the same between MSN Money and Yahoo! Finance, so please make sure to use the right symbols. You are provided with links to both websites so you can look for the right symbols. With Spreadsheet Stock Quotes you can query for information of any number of company ticker symbols. However, bear in mind that the larger the volume of information required, the longer it will take to update the information. Additional factors affecting these times include: Internet connection speed. Hardware and software features of your computer. And of course, the number of ticker symbols queried. Querying for historical data takes much longer than for current intraday stock quotes. Who needs this Software? Any type of user that uses Microsoft Excel for his/her projects. It can be used by: Financial analysts Engineers Biologists Mathematicians Economists Teachers Students in general Scientists Any person who uses Excel in the decision making process and wishes to explore his model’s possibilities.

Stock Quotes Wizard This function retrieves online stock market index data from Yahoo! Finance.	Create a Watchlist Rapidly Use this tool to quickly create a watchlist, as its name indicates.
Stock Quotes By Date Wizard Use this wizard to enter the SQByDate( ) function to query for historical data.	Stock Quotes By Date Wizard 2 It is an alternative function to SQByDate(), it has been developed in order to avoid conflicts of formats in dates, so it allows to make explicit the month, day and year of consultation.
Stock Quotes - Quick fill Use this functionality to quickly fill a column with the data queried.	HiperLynk to Web Services Wizard This tool will enable you to very easily add to your spreadsheets, web links relating to a set of corporate symbols.
Refresh Settings With this functionality you can configure data refreshing options.	Insert latest refresh (Date and Time) Use Insert latest refresh (date and time) to insert the latest date and time when the data was updated .
Data Downloader Use this tool to download historical data of stock prices.	Data The data you can retrieve from both sources are listed below.....
Retrieve the Company Name With this tool you can retrieve the name of a company entering the appropriate tinker symbol.	Search for Company's Symbols With this tool, you can have direct access to MSN Money and Yahoo! Finance websites to check for company ticker symbols.
Tools
Export Stock Quotes Use this tool to get the Add-in to export retrieved stock and mutual fund data to a new Excel book.	Export Market Indexes Use this tool to export stock market index data from with the Add-In from either of both data sources, Yahoo! Finance or MSN Money.
Export Sheet Values Use Export Sheet Values to export the worksheet with the stock quotes or market indexes functions used in a new worksheet with values.	Cell's math by format Use this gainful tool to search all cells in a specific range with a particular background color and to do some math with the results.
Multiple Conditional analysis & formatting It gives format to cells in a database, based on previously established criteria defined in a decision table.	Select by Format This tool selects cells of a given range, but only taking into account those with a given format.
Reference Analyzer
Toggle Settings We often lose valuable time doing repetitive tasks -if, for example, we want to hide the headings in several sheets of the Workbook....	Freeze Panes We sometimes work with models whose information does not fit in the screen. And we may get lost as we navigate throughout the spreadsheet .....
Guides This tool is specially convenient if you want to navigate throughout databases with records or fields stretching beyond the screen.	Arithmetic Calculator With it you can make arithmetic operations quickly from the selected cells and using its GET and PASTE buttons.
Change Color Palette Change Excel's color palette, making it possible for you to have fresh colors with a more professional and personalized tone.	Alternate Rows Shading When you use this tool you will be able to format cells with a conditional format in an alternate basis, providing cell color and border formats.
Sheets Manager Use Sheet Manager –a comprehensive tool that will make any worksheet management task easier to you.	Refresh Data In this window you can choose the functions to refresh in order to download the values from Yahoo Finance y MSN Money.

Create a watchlist rapidly	Stock Quotes Wizard

Data Downloader	Hyperlink to web services wizard

Option prices	Retrieve the company name

Stock Quotes by date wizard 2	Stock Quotes by date wizard

Stock Quotes quick fill

How to open this help file:

Before pressing the button OPEN , the checklist must be uncheked, in this way we are telling Windows that this file if secure so that the window will not be displayed again for this action.

These are some of the Clients

If you would like to evaluate the software please contact us, and we will be delighted to arrange a free trial for you. Below is the pricing for your indication:

Quantity	Price per license (USD)
1	$74.95
2 to 5	$63.95
6 to 9	$56.95
10+	$37.50

For quantities above 10 licenses please contact us at sales@unitedaddins.com, and we will be happy to provide you the needed quote.

Thank You!

* First Name:
* Last Name:
* Company:
* Number of licenses:
* Country:
* Telephone:
* E-mail:
Write us a message:

Spreadsheet Stock Quotes

Spreadsheet Stock Quotes

Excel

OFFICE ADD-INS

OTHER TOOLS