One person requested bid/ask price of stock. I will include this in the next release, along with many other new quote types, but remember that GETQUOTE relies on a Yahoo! service that is not always real-time:
Many quotes are delayed!Click here for a list of exchanges and their delays.
Hi Ted,
ReplyDeleteAs of a couple of days ago Getquote("^DJI") is returning "#VALUE!" instead of a number?
Any thoughts?
Thanks.
The Yahoo! web service on which GETQUOTE relies no longer accepts "^DJI" as a valid symbol. It's odd because it accepts "^NDX", for example.
ReplyDeleteAs a work-around, try "^DJX", which is 1/100 of the Dow Jones Industrial Average. Unfortunately, it is not as precise.