Retrieving stock information in Access

[Derek]

Is their a way in Access to quickly retrieve on a stock from differnt dates
and bring it into the current date. I have built something now but the query
takes a long time to run and I was hoping there was a command in Access I
could use. What I am doing is downloading stock data daily and running
queries to see find stocks that are moving. To do this I have made rules such
as what was the stock price average the last 5 trading days and last 30
trading days (numerous other calculations also). I go through all the stocks
and the query retrieves certain stocks that match my filters, unfortunately I
have 500,000 lines od data the sort through.

 

[John Vinson]

Is their a way in Access to quickly retrieve on a stock from differnt dates
and bring it into the current date. I have built something now but the query
takes a long time to run and I was hoping there was a command in Access I
could use. What I am doing is downloading stock data daily and running
queries to see find stocks that are moving. To do this I have made rules such
as what was the stock price average the last 5 trading days and last 30
trading days (numerous other calculations also). I go through all the stocks
and the query retrieves certain stocks that match my filters, unfortunately I
have 500,000 lines od data the sort through.

Half a million rows is a decent sized table, but a properly indexed
table and a properly designed query should make it possible to
retrieve this information. Do you have indexes on the stock ticker
symbol and the trading date field? Perhaps you could post the SQL view
of a particularly slow query - someone might be able to suggest a way
to speed it up.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps