AnsweredAssumed Answered

Calculating 90 day Moving Min & Max Stock Prices

Question asked by FergyMitch on Feb 9, 2018
Latest reply on Feb 10, 2018 by FergyMitch

I have a stock price database for all of the Australian Stock Exchange (ASX) stocks, and I want to be able to calculate the min & max price for each stock on a daily basis. There are currently around 300,000 records in the table, growing at  roughly 10,000/wk. At this stage it does not need to work over a network.

The PRICES table:

     StkCode     Text

     Date          Date

     Price          Number

I have another WATCHLIST table that has a subset of the ASX stocks I monitor closely, and I want to be able to view the current day's price with the last 90 days min & max price (not via a portal).

I have looked at using Self joins on the PRICES table, but cannot make it work.


Any help would be greatly appreciated.