>>>>>>I can download historical stock data from Yahoo/Finance into a spreadsheet (their choice). The whole process is manual. Would it be possible to automate it?
>>>>>>Thanks Mark
>>>>>
>>>>>At DevCon, Ken Levy showed how he can pull stock information from the web. He has a hidden page on his web site. Behind the scenes, the web application reads the HTML from MSNBC and converts the pertinent information into XML, then sends it to the browser. So, while the answer is yes, you can automate it...I don't know how. If you can find an XML source for the information, it would be MUCH easier.
>>>>
>>>>Is there any chance to see how it's done?
>>>>Thanks Mark
>>>
>>>I don't think you can see how it is done. But you can switch over to the XML forum area of the UT and post your questions there. Ken Levy is the SysOp there.
>>I thought he is monitoring this forum too <g>
>>Thanks Mark
>
>Mark-
>
>try this from your machine, and let me know if it works.
>
>oIE = CREATEOBJECT("InternetExplorer.Application")
>oIE.Navigate("http://finance.yahoo.com/d/quotes.csv?s=dell&f=sl1d1t1c1ohgv&e=.csv")
>
>If not, the Yahoo interface will take a little more exploring...
>
>I am a little worried about where the second form variable came from :
>f=sl1d1t1c1ohgv
Hi Eric,
Yes, It brought DELL stock. Which is not bed at all. But I need to get a historical data from this site and more important access data from a spreadsheet.
Thanks Mark