Pulling Stock Quotes from the web into Access

[Bwaldin]

Hello Everyone,
I am working on a database which requires financial information and I would love to have access be able to pull down stock quotes from the web(i wish it could pull info from SEC docs as well but I am pretty sure that is out of the question). From some digging I am pretty sure that it can be done using XML, only i am not at all experienced in XML and I have no idea where to begin. Can someone point me in the right direction? If anyone has this function in their database i would really appreciate it if you could share the knowledge. Thanks

Ben

 

[Pat Hartman]

I haven't done this but I think you need to find a "web service" that provides the information you want. You would call the web service and it would return the requested data, usually in XML format. Let us know if you find a suitable web service.

 

[Bwaldin]

I have seen examples using Yahoo Finance to pull the quote info, the code usually looks something like a funny version of HTML(is it xml?) and I have no idea how to integrate it into access so that i can get the info that i need. I have found several examples and they all have different extensions that i am not too familiar with(PHP files, ASP, XSL). Does anyone know a good XML tutorial or somewhere that i can get the background on all of this, at the moment i am lost.

 

[tkpstock]

This place has a section on XML:

http://www.devx.com/projectcool/door/7051

XML is just a way of defining data.