Click here to download
the patch. This fixes the auto-quoting feature too. Please remember to install the
patch after the normal install. It's ok to apply the patch even if you aren't registered.
The auto-quote feature will now work even if you're not registered. Yea!
Are the real-time quotes free? No ECN fees? No subscription fees?
This is correct. All you pay is a single one time $15 fee for ESQuotes
1.x or $29 for ESQuotes 2.x to us for writing ESQuotes. There are no exchange fees.
How can I stop the reminder after 500 stock quotes?
By purchasing ESQuotes for a low one time fee, not only does the reminder
stop nagging you, but you get real time quotes, and auto quotes too!
What is your update policy?
Updates are free to everyone!
Is your order page secure?
Yes! We use state of the art SSL encryption, plus we accept all major credit cards
and have fraud protection.
How do I re-activate ESQuotes 1.x if I lost my serial number?
What exchanges do you support?
Right now we support most US equities on the major exchanges: NASDAQ, AmEx, NYSE
and OTC. ESQuotes also supports the Australia, Canada, France, German, Hong Kong,
India, Italy, Spain & UK exchanges. As we get requests, we add new ones. Use ESQMgr
to select the exchange you would like to use.
Why don't mutual funds quote?
You probably have real time quotes selected. Run the ESQMgr
program and select delayed quotes.
How does ESQuotes work?
It works by using ESQuotes2.DLL and a Visual Basic script inside Excel. VBScript
acts as a conduit between the spreadsheet and our DLL. Our DLL connects to the Internet
using low level routines and submits multiple requests to the quote server for the
stock symbols you selected. It then parses (figures out where each piece of information
is) the stock data and the individual functions in each cell returns the actual data
from the Internet.
Why do only 5 symbols get prices after a while?
If you quote more than a few thousand quotes, the free unregistered version will
eventually limit you to only 5 symbols. Purchasing
will remove the limit and allow you to quote up to 300 symbols per page!
Will our corporate firewall or proxy server block this?
No! Unless your firewall or proxy server blocks all browser access, it can't tell
the difference between this and a normal browser, neither can the quote server for
that matter. If you have a personal firewall, you may have to configure it to allow
Excel to access the Internet.
Does ESQuotes hold the connection open?
The connection is opened and closed in less than 1 second. Actual performance depends
on the complexity of your page.
Will the corporate Internet police detect suspicious activity?
Your net activity will be so brief (total connect time should be well under 10 minutes
for a whole day), that no one should notice. Bandwidth usage is virtually zero.
What quote server do you use?
We use a variety of public servers and select the most reliable one for you automatically!
What will happen if your quote server stops working?
We will update ESQuotes as soon as possible, inform our registered
users and post a link for an update. This will be free to everyone.
Are there plans for further improvements?
Yes! We just released version 2 and more great features are on the way!
I inserted new symbols and they aren't quoting. I get "symbol not found".
The problem usually is that =ESQSymbols(range,"title")
isn't included in your spreadsheet or the <range> isn't including the new symbols
you just added. Cell B4: in ESQExample2.xls shows this. Make sure the <range>
includes all the symbols you want quoted. Then force Excel to recalculate a couple
Can you get real time quotes?
Yes! But you have to purchase ESQuotes in order
to take advantage of this feature. Click here to purchase
ESQuotes. This is a one time $29 fee. There are no additional subscription
How did you come up with idea?
I wanted an easy to use stock portfolio that updated prices during the day. I used
to work where I had real-time quotes on my desk (Thanks Mike and Dan!) and got very
spoiled. I had a grid of stocks similar to the workbook I provide. I vowed to write
one just like it. I discovered that Excel could call a DLL. The proverbial light bulb
went on so I rushed some crude code out that did just what I wanted! It worked so
well, I decided to polish it up and publish it.
Can ESQuotes quote options?
I'd like to post ESQuotes on my site, how can I do this?
You can simply copy SetupESQuote2.exe on your site with no permission. Just don't
modify the files. You can also join our affiliate program
and make money by placing a link on your site. You can even request
a custom version made just for you to distribute!
I have proprietary data on our network that I'd like to able to import into
Excel the same way you retrieve quotes. Is a custom version possible?
We can make special versions for you that can retrieve any data you can think of.
The basic idea will work for any kind of data. ESQuotes is targeted to Excel and stock
market data, but the application of the technology can be applied in many different
Can ESQuotes be included as part of another product for sale?
Contact us for possibility and rights for
your intended use and what kind of product you want to include ESQuotes with.
This software is not to be used for trading decisions. The data
is delayed and may not represent actual current market data. The data is for informational
purpose only. We can not guarantee that this software will work for any amount of
time due to the fact that it relies on a public quote server, which can change and
break our software at any time. We will provide free updates (if possible)