Stock Quotes for Excel 4.6.0

PRICE

US$ 59.95

FREE TRIAL

BUY

View Demo Presentation

Download User Guide

AS A GIFT
Buy this product and take
FREE
"Tools for Excel Tables"
or
"Exchange Rates"

 
Options

   

 
Stock Quotes Wizard Stock Quotes Wizard

This function retrieves online stock market index data from Yahoo! Finance.

Create a Watchlist Rapidly Create a Watchlist Rapidly

Use this tool to quickly create a watchlist, as its name indicates.

Stock Quotes By Date Wizard Stock Quotes By Date Wizard

Use this wizard to enter the SQByDate( ) function to query for historical data.

Stock Quotes By Date Wizard 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 fillStock Quotes - Quick fill

Use this functionality to quickly fill a column with the data queried.

HiperLynk to Web Services Wizard 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 SettingsRefresh Settings

With this functionality you can configure data refreshing options.

Insert latest refresh (Date and Time) 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 Data Downloader

Use this tool to download historical data of stock prices.

Data Data

The data you can retrieve from both sources are listed below.....

Retrieve the Company Name 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 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 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 IndexesExport 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 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 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 Multiple Conditional analysis & formatting

It gives format to cells in a database, based on previously established criteria defined in a decision table.

Select by FormatSelect by Format

This tool selects cells of a given range, but only taking into account those with a given format.

   

 
Reference Analyzer
   
Toggle Settings 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 PanesFreeze 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 .....

GuidesGuides

This tool is specially convenient if you want to navigate throughout databases with records or fields stretching beyond the screen.

Arithmetic CalculatorArithmetic Calculator

With it you can make arithmetic operations quickly from the selected cells and using its GET and PASTE buttons.

Change Color PaletteChange 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 ShadingAlternate 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 Sheets Manager

Use Sheet Manager –a comprehensive tool that will make any worksheet management task easier to you.

Refresh DataRefresh Data

In this window you can choose the functions
to refresh in order to download the values from Yahoo Finance y MSN Money.

 

 

PRODUCTS

Model building & Analysis Tools

Online Functions

Other Analysis Tools

Excel Databases

Financial Calculators

Others

Third Party

Bundles




Related Sponsors
 

Related Sponsors