General discussion


MS Access Question

By hascons ·
I Have a MS Access Database that I use to store years of Stock Price Information. I'm trying to develop a query with a calculated field eg.[100 Day Volatility]to calculate the 100 day Volatility(or any other time period) on the closing Price.I would like to be able to perform this function on many different securities(Similar to Metastock)so I would prefer the querypower of a Database. I currently can perform this with an excel sheet,but performing this task on muliple securities at once is very cumbersome.Does anybody know how to perform this type of Function With MS Access?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

I think I have an idea

by john.a.wills In reply to MS Access Question

but I would like to know first more precisely what you mean by volatility. Do you mean trhe standard deviation of the price over the previous so many trading days? What is the formula you use in Excel?

Related Discussions

Related Forums