On Wed, Oct 05, 2005 at 11:23:00AM -0700, Mike Wexler wrote: > Jim Seymour wrote: > > >I have researched repeatedly and cannot find an answer to the following. I > >need to do something like the following (There is probably an easier > >way). > > > >end_date - start_date = diff / start_date = return for period > > > >The table contains 401k investment values. Ideas, pointers, etc.? I am > >using > >mysql v5.0.12 on Debian Linux. > > > >TIA, > > > >Jim > > > > > > > Depending on how fancy you want to get, you would calculate either an > IRR (Internal Rate of Return) that basically says, what interest rate > would I need to get on the funds to end up with the same results I > actually achived. Note that calculating an interest rate is going to > require an iterative approximation. >
Thanks Mike, What I was really looking for is how to structure a query in mysql to arrive at the return on the investment. I know I completely left that out of my first post. Is it even possible? Thanks, Jim Seymour -- I started using something better than the "standard" back when IBM advertised OS/2 Warp on TV. As Linux matured I made the transition from OS/2 v4 to Linux. You don't have to accept less than you deserve. "Use the Power of the Penguin" Registered Linux user #316735 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
