hey!
I have a query set up like this:
ID.. CompanyName....ReturnDate.....Return...
The date is the last date of every month with a corresponding return. now the returns have been going for years. so there is alot of them each company has a list of returns. I currently have an annualized return. set up like this: avg([Return])*12
I want to get the 6 month, 12 month, and 18 month anuallized return. so it would be taking the last 6 data points, 12 datapoints and 18 datapoints. all company names send in there returns at different points, so im not able to have a domain. as then my results would be skewed positively or negatively depending on the returns. I need to some how come up with a function which grabs the last number of returns in the list. how would i do this?
eg. for 6 month return
avg(last6[Return])*12
that wont work, just showing what im going to need. thanks,