Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to handle passwords via VBA to Yahoo Quote Server?
Have you asked Yahoo! themselves?
Scott << |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to handle passwords via VBA to Yahoo Quote Server?
Hi, Scott - I have. So far they haven't replied. Perhaps the issue is
that they don't really document this interface. The link above is to a third part site that documents the interface. - David |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to handle passwords via VBA to Yahoo Quote Server?
OK, I got the answer, thanks to help on the XLtraders Yahoo group. You
have to sign into Yahoo from within a browser instance created in excel. Then it hands back real time data as it should. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to handle passwords via VBA to Yahoo Quote Server?
So how do you automate the login from excel??
-- Billy Rogers Dallas,TX Currently Using Office 2000 "David" wrote: OK, I got the answer, thanks to help on the XLtraders Yahoo group. You have to sign into Yahoo from within a browser instance created in excel. Then it hands back real time data as it should. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get the quote from yahoo into excel? | Excel Discussion (Misc queries) | |||
How to get the quote from yahoo into excel? | Excel Discussion (Misc queries) | |||
Fill handle turned into a move handle | Excel Discussion (Misc queries) | |||
Typing a quote character Vs pasting a quote character= what happens to the resulting CSV? Interesting!! | Excel Programming | |||
Typing a quote character Vs pasting a quote character= whathappens to the resulting CSV? Interesting!! | Excel Programming |