View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 10
Default How to handle passwords via VBA to Yahoo Quote Server?

Hi -

Yahoo has a great quote server, which provides real-time quotes if you
pay their premium charge of $13 per month, If you don't pay, you get
delayed quotes.

The syntax and instructions for quote server are he
http://www.gummy-stuff.org/Yahoo-data.htm

I have discovered that if you create a web query to access this quote
server from within a VBA procedure, you get delayed quotes even if you
have paid for real time quotes, and even if you have logged in to Yahoo
from Yahoo's web page. In other words, their server recognizes when it
is being called from a regular browser window, and when it is being
called by a program; in the first case, it gives you real time quotes
if you've subscribed, but in the latter case it doesn't recognize that
you've subscribed.

Does anyone know how to pass the user ID and password to the quote
server so real time quotes can be obtained? It seems that it must
some how be passed with the URL since logging in one the Yahoo site
apparently does not solve the problem.

TIA,
David