ESQuotes
Tools you can use
www.esquotes.com
|
Watch, manage and research your stocks and funds in Excel |
|
|
FAQ | A: | Make sure your software is activated and you have selected "real-time" from the data tab. |
| A: | 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. Really! |
| A: | 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! |
| A: | Updates are free to everyone! Upgrades are a minimal fee, usually 50% of the retail price. |
| A: | Yes! We use state of the art SSL encryption, plus we accept all major credit cards and have fraud protection. |
| A: | 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. |
| A: | You probably have real time quotes selected. Run the ESQMgr program and select delayed quotes. |
| A: | 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. |
| A: | 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! |
| A: | 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 hat matter. If you have a personal firewall, you may have to configure it to allow Excel to access the Internet. |
| A: | The connection is opened and closed in less than 1 second. Actual performance depends on the complexity of your page. |
| A: | 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. |
| A: | We use a variety of public servers and select the most reliable one for you automatically! |
| A: | 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. |
| A: | Yes! We just released version 2 and more great features are on the way! |
| A: | The problem usually is that =ESQSymbols(range,"title") isn't included in your spreadsheet or the isn't including the new symbols you just added. Cell B4: in ESQExample2.xls shows this. Make sure the includes all the symbols you want
quoted. Then force Excel to recalculate a couple of times. |
| A: | 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
fees required! |
| A: | 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. |
| A: | You can simply copy SetupESQ2.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! |
| A: | 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 ways. |
| A: | Yes. Contact us for possibility and rights for your intended use and what kind of product you want to include ESQuotes with. |
| A: | It's likely that they are disabled. You will need to go to ESQMgr.exe and click the "Data" tab. Make sure the function you want to use is checked on. Then try forcing a recalculation with F9 or Ctrl+Alt+F9. Also, make sure that =ESQSymbols() includes the range of cells for all the symbols you use, otherwise ESQuotes won't get any data for that symbol.Hint: If you are using an unregistered copy, you can only use 9 functions at one time. You may have to turn a function off in order to test out the one you want. Once ESQuotes is registered, all functions
will be available at the same time. |
| A: | This is caused when a cell uses a function or symbol that doesn't exist. Your problem could be a couple of things: Macros might be disabled. This happens in some corporate environments where they want to eliminate possible viruses. In Excel, Go to Menu: Tools: Macro: Security and allow macros to run. ESQuotes2.dll
is not in the Windows\system directory or where Excel can find it. Try copying or moving ESQuotes2.dll to directory where Excel.exe is stored. |
Disclaimer 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).
| | | |
|
|
Del.icio.us