Hi,

I have program that downloads the historical data for over 1000 market stocks i.e. open, close, high, low and volume for the last 3 months.

I would now like to interrogate the data by creating a bunch of queries i.e. 30 day moving average, Moving Average Convergence/Divergence (MACD) and RSI etc.

Does anyone have any examples of doing this please or can you point me in the right direction.

Thanks for taking the time to read my post.

If I were you, I would buy some software that is designed specifically for investment analysis. Access was not designed for this, and I think you would give yourself quite a few headaches if you tried it with this program. Maybe you should talk to Charles Schwab... ;)

I think it would be best to research other software that would be better at handling your needs.