Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stock Quotes
Message
From
06/11/2003 14:59:20
 
 
To
06/11/2003 14:50:44
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00847250
Message ID:
00847309
Views:
24
Thank very much, i am going to play around with that a bit over the weekend, that looks realy cool!

>Depends on the interface of the provider. In this case I went to the yahoo finance page: http://finance.yahoo.com/?u and then typed in 'MSFT IBM' in the stock symbols textbox and clicked ok. Check out the URL in the address bar of IE and you will see it as http://finance.yahoo.com/q/cq?d=v1&s=msft+ibm. Now click on the download to spreadsheet link and the address line is http://finance.yahoo.com/d/quotes.csv?s=MSFT,IBM&f=sl1d1t1c1ohgv&e=.csv.
>
>See how it fits into the call to XMLHTTP?
>
>>excuse me for butting in...
>>
>>i am realy interested in that stuff for personel (playing around) things. can u tell us more how that works. I.E. "oxmlhttp.Send('s=MSFT,IBM&f=sl1d1t1c1ohgv&e=.csv')" how do i know how to put together that string - is that depending on the provider?
>>can u please tell me how i can find your article you were talking about.
>>
>>Thanks for your info.
>>
>>
>>>See Microsoft.XMLHTTP - for example:
>>>
>>>
>>>oxmlhttp = createobject('microsoft.xmlhttp')
>>>lcurl = 'http://finance.yahoo.com/d/quotes.csv'
>>>oxmlhttp.open('POST', lcURL, .F.)
>>>oxmlhttp.Send('s=MSFT,IBM&f=sl1d1t1c1ohgv&e=.csv')
>>>? oxmlhttp.responsetext
>>>STRTOFILE(oxmlhttp.responsetext, 'c:\temp\mystockinfo.txt')
>>>RELEASE oxmlhttp
>>>
>>>
>>>BTW, about 2 years ago I wrote a full page article on this very topic and submitted it to FoxPro Advisor for them to publish as either a tip or article. Never heard any response at all either good or bad.
>>>
>>>Perhaps that is why FPA is starving for persons to write articles - no feedback...
>>>
>>>>I would like to learn how to retrieve stock quotes from any of the available web sites that provide them (Yahoo, MSN, etc.). I know that it is possible to get a quote to downloaded from Yahoo as a .csv file, but I would like to get the info back as a message instead. Help anyone? TIA.
Previous
Reply
Map
View

Click here to load this message in the networking platform