Online Functions - Stock Quotes

Allows to update automatically through Internet the stock quotes or market indexes into your Excel spreadsheets. No more manual and tedious updates or risk of using no updated data.

This add-in is like any other Excel function. When the function is inserted in any cell or inside a formula, the add-in automatically refreshes the stock quotes or market indexes with the latest data.

The add-in includes a wizard to help you to use the tool. Additionally it includes different refreshing data options and reports with the stock quotes and market indexes used.

New Functions:

1. Now the SQ() function works as an another Excel function; simply writing that formula and dragging the cursor by all of desired cells.

2. Now, the SQByDate() function works as an another Excel function; simply writing that formula and dragging the cursor by all of desired cells , alike.

3. Refresh Data tool has been re-designed allowing you to choose between up date all of data or wished data only.

4. Export Stock Quotes tool shows a window where you can choose, between to export with or without updated data.

5. The Data Downloader's algorithmic and storage mode have been enhanced.

7. Moreover, This version (3.1) is totally compatible with Excel 2007.

Functions

Stock Quotes Wizard

The Stock Quotes Wizard helps you in the construction of the Stock Quotes function. To use it follow these steps:
  1. Select an empty cell and press the Stock Quotes Wizard button .
  2. Insert the Company Symbol that you want to use.
  3. Select the type of data you want to obtain.
  4. Select a cell in that you want to paste the function.
  5. Click in Insert button and the function will paste in the selected cell.
Notes:
  • All the companies symbols inserted are saved in the Companies List of the Stock Quotes report. If you want to insert them after you use the Stock Quotes Wizard, check the "Update companies list at the end" option.
  • If you want to update the data of the companies symbols inserted after you use the Stock Quotes Wizard, check the "Update data at the end" option.
  • Also you could do the same automatically or manually using the Refresh Settings button.
Use Refresh Settings* to setup the refresh data periods of the stock quotes and market indexes used. You could determine the refresh data as a manual option (you need to use Refresh Data each time you want to do it) or automatic option (select the minutes and the add-in refresh data automatically). To do it press . Your PC needs to be connected to Internet.

Also you could configure the Update Companies List option. You could add only the used companies with the Stock Quotes function in your MS Excel sheet in this moment or all the companies (used or not used in your MS Excel sheet in this moment).

*The stock quotes and market indexes data is obtained from the MSN MoneyCentral Investor web site (http://moneycentral.msn.com/investor/home.asp). The quotes are delayed by at least 20 minutes.

Market Indexes Wizard

The Market Indexes Wizard helps you in the construction of the Stock Quotes function. To use it follow these steps:
  1. Select an empty cell and press the Market Indexes Wizard button.
  2. Select the type of Index.
  3. Insert the Market Index that you want to use or select it from the list.
  4. Select the type of data you want to obtain.
  5. Select a cell in that you want to paste the function.
  6. Click in Insert button and the function will paste in the selected cell.
Note: All the market indexes are saved in the Market Indexes report.

Insert Latest Refresh (Date & Time)

Use Insert latest refresh (date and time) to insert the latest date and time in which the functions has been refreshed. Select a cell in your worksheet and press to insert the lastest refresh.

30-days money back guarantee!

Download DoStock Quotes + Spreadsheet V. Analyzer

Download Stock Quotes + Exchange Rates

Download Online Functions - Stock Quotes

Additional Information: Online Functions - Stock Quotes
Requires Windows XP / 2000/98 or later and Excel 2000 or later

Buy Online  $99.90

 bbuy.gif (1156 bytes)

More Jabsoft Software

Home   More Business Software