By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,464 Members | 1,165 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,464 IT Pros & Developers. It's quick & easy.

Rolling Rates of Return: Data Structure?

P: n/a
The one I would up was a pivot table presentation"

Fund Year ReturnForYear ReturnForYearPlusPreceedingYear,
ReturnForYearPlusTwoPreceedingYears.....and so-forth.

But that design compromise has caught up with me as now I need rolling
quarterly and monthly returns in addition to just yearly returns.

Lottal records involved here....
I'm thinking:

FundID BeginDate EndDate RateOfReturn Type (Yearly, monthly,
quarterly)

That would enable me to return all rolling rates for a given fund by
specifying the common EndDate and from there I could sort things out
based on Type and DateDiffs.
Seems like one of those situations where the "correct" solution may be
fraught with practical problems - like performance when sorting this
stuff out for a quick screen or report.

Anybody have actual experience?
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.