MSNStockQuote function gives #value

B

Bobsbizzy

I have a file containing approx. 200 rows, each row starts with a Stock ID
and I use MSNStockQuotes to return the last price stock value. It works
successfully for the first 100 or so rows, then randomly doesn't work for the
second 100 rows. Maybe 30 or 40 of the last 100 rows doesn't work. If I
change the stock id on each row that doesn't work and then hit backspace it
works successfully. It seems very random on the 30 or 40 that don't work in
the last 100 rows, and nearly everytime the first 100 rows work flawlessy.

Anyone else seen this and have a fix for it?
 

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