Software

Ask something
Discussion Locked

MS Access Question

0 helpful
1 reply

by hascons

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

1 reply

by john.a.wills

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?

This discussion is closed to new replies.