MSNStockQuote add-in for Excel: limitations

S

Steve Conover

I found the add-in function for retrieving stock quotes into Excel
from MSN Money, and have found it useful. (link: http://tinyurl.com/4bfmf
) There's a 15-minute delay on the quotes, and the function is
deactivated for five minutes after each time it is used to update
quotes. (Neither is a problem for me.)

My problem: I have recently been receiving a message informing me that
I had exceeded the limit of quotes it can retrieve, and my analysis
sheet is full of error cells as a result.

First, does anyone know where I can find documentation of the limits?
I'd like to stay under the limit, but need to know what it is.

Second, does anyone know whether there's an option available to pay
the data source providers a fee to get real-time quotes through this
same function? I may want that someday.

Thanks.
 
D

Don Guillett

You may prefer Yahoo as a source thru an external query

goto
(e-mail address removed)
and look in the files section. There are several free files.
I have a couple of free files under author donalb36
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top