Home
Download
Overview
Order
Support
Download ESQuotes stock quotes in Excel for the Internet
ESQuotes
Tools you can use

www.esquotes.com
ESQuotes Micorsoft Excel stock quotes for the Internet
Watch, manage and research your stocks and funds in Excel

ESQMgr Support

Getting started

ESQMgr is where you select the various exchanges you want to use and register your version of ESQuotes.

Visit our FAQ or support page for common questions on ESQuotes.
Real Time quotes and other exchanges

To select real time quotes and other exchanges, run ESQMgr and click on the "options" tab. Select the exchange you want to use and click on the "apply" button.

If you selected real time quotes and haven't purchased ESQuotes, a message will pop up and ask you to register before allowing the real time quote option to work.

The symbols for non US exchanges will require a suffix like:

FUL.L, EID.L, 500340.DE, 840400.DE, etc.

You may discover that selecting real time quotes makes the mutual funds option not work any longer. This is because mutual funds only get priced after the market closes and the real time quote server won't get the last price. You must select delayed quotes using ESQMgr to get mutual funds to price. We're looking into making them both work at the same time.

Auto quotes

Auto quotes makes Excel retrieve quotes on a selected time interval. Registration is required before this option will work.

To use: Simply click on the spin box arrows in the "options" tab, select the time interval in hours: minutes: seconds you would like ESQuotes to refresh. Press the "apply" button to activate the feature.

The option is turned off by setting the interval to zero or clicking on the "off" option.

Cache

The cache option stores the last known price values retrieved from the Internet. This is useful if you are on a dialup connection and you want to see the last known values without having to connect. This option is turned off by default because we don't want to confuse anyone with old quote data. But if this feature is useful to you, then simply enable the cache.

On your disk, you may find a file named ESQuotes.csv. This is our cache file. It is simply a text file with comma separated values for the symbol, price, open, high, low, date and time. You may delete this file without causing any errors, but then you won't get your cached values until the next time you connect to the Internet..

 

Copyright © 2000-2007 Gilmore Software info@esquotes.com. All rights reserved.

Problem Solved! Gilmore Software Development
www.esquotes.com