J
JbL
Hi, I am putting together a database that will store the stocks in an index
on a daily basis. I have a table that holds all of the stocks each day and
some data pertinent to that day ie price/ volume etc... (with the respective
date and stock id that are pkeys). I am trying to build a query that when I
any choose any 2 dates or a range of dates with differing frequencies (daily,
weekly, monthly, etc) I can calculate each stocks return and then avg, max,
min, etc. for each date and for whatever group I might select.
The calculation between the dates is what's throwing me off. Any assistance
would be greatly appreciated. Thank you very much.
on a daily basis. I have a table that holds all of the stocks each day and
some data pertinent to that day ie price/ volume etc... (with the respective
date and stock id that are pkeys). I am trying to build a query that when I
any choose any 2 dates or a range of dates with differing frequencies (daily,
weekly, monthly, etc) I can calculate each stocks return and then avg, max,
min, etc. for each date and for whatever group I might select.
The calculation between the dates is what's throwing me off. Any assistance
would be greatly appreciated. Thank you very much.