Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |