Yahoo Stock Downloader

[hascons]

Does anyone have a macro to download end of day stock quotes into access database. I would like to be able to choose a start date on the first download and then append the records on each subsequent download. I do this in excel to analyze a few stocks but would like to be able to do this in bulk.

Not sure if it's better to store in database or create a separate csv file for each stock

 

[jdraw]

What exactly do you want to do with the data?

 

[hascons]

I would like to be able to store the data in a table (Quotes). Preferably I would like to have a table ( Stock Tickers ) that would hold a list of stocks and then be able to append the new updated data to the table ( Quotes ). From there I could perform simple calculations and use the more powerful query engine that access offers.

I'm OK with access but i'm not sure here of the logic required to download the data ( which is a csv file ) into the table.

 

[jdraw]

for ideas, see http://www.access-programmers.co.uk/forums/showthread.php?t=203795&highlight=fncSharePrice

found it using search

 

[hascons]

Thanks jdraw I will play around with that a little bit and see where that brings me.

 

[access2010]

A charity I volunteer at would like a database such as you are working on to keep historical data on their stock investments.

Would you be interested in allowing us to use your database?

Thank you

10finch46 at wehavemail.ca