Attached is a rather rare sample database that downloads Yahoo quote data into an MS Access database. I'm posting this for traders who have MS Access programming experience and want to further develop their trading databases. I've seen a lot of postings on MS Access forums requesting for this information and I finally found a sample. This sample is posted on the Google Answers forum by aht-ga, Google Answers Researcher Automatically Importing Stock info from the web into MS Access
has given us a good example of how to accomplish this download process that requires using Yahoo Query Language
(YQL) to interface with MS Access.
Although this is a good example of how to download to a csv file and then import the data back into Access, a posting by Albert D. Kallal
shows how to download quotes directly into Access using many of the available quote properties. However, he does this by one symbol at a time. To make this useful, the code needs to be adapted to cycle through your list of stock symbols like the attached database. His technique also makes use of all the symbol properties for the current symbol status or for historical quotes. Other methods of downloading are shown by Matthew Reeves
and Alex Dybenko
for the stocks basic properties within a specified date range.
These codes are by no means a complete database, but they are starter modules that work and are meant to provide IT members with MS Access database programming experience and who want to further develop their applications. I am posting this information after doing a considerable amount of research on this topic. There's tons of information on downloading quotes into MS Excel, but almost no help on downloading quotes into MS Access.
If you don't have MS Access, you can still see these samples by using MS Access Runtime
. See the video How to Distribute a Microsoft Access Application