I am no expert at all in Access all I can do partially wel is run queries, this i what I have to do I have two tables that
derive from queries.
The first one gives the whole accounts fro the firm and a check mark on the composite
classification they belong too. and then for every month of each year the account existed in teh firm it calculates the gross
Something like this
Acct # Composite 1 Composite 2 Composite 3 200202 200203...
231 1 1.2% -1% 3%
256 0 1 0 0 2% 1.6%
288 1 0 0 0 0 1%
291 0 1 0 3% 2.2% -1% 213 0
0 1 2% .2% 1.4%
And the second table we obtain The accounts and their
beggining market value for those same periods
Acct# 200202 200203..................200607
231 $300,000 $350,000 645000
256 0 100000 150000
288 0 0 50000
291 600000 595000 550000
213 1500000 1450000 1320000
I made up the numbers as an example since I cant provide
the actual data.
Now I need to create a query in which it will calculate the standard deviation and the asset
weighted std deviation for Each composite, like If I specify in the query to show these results for composite 1 It will show
the accounts belonging to that composite and the std dev and Asset Wiegth Std for each month of the years:I have attached the
example bt I solved this manually in excell. And I need to figure out a way to do it in access through a query.
These are the formulas:
Std Deviation= ((Sum(Return%of Acct #-MEan %tot)/n))^1/2
n=number of accounts
that had a return on that month.
Mean %Tot= Sum the returns of the accounts for that month/n
Weighted Std Dev= Sum( BegMarket Value of Account#*(Return of thr account#))/Sum of all the beginning Mkt values of the
accounts of that month.
THANKYOUUU soo much I know this is probably too complicated or tooo basic but if you can
give me some pointers it woudl be greatle appreciated