Re: Financial formulae

2012-11-09 Thread Graham Samuel
Thanks Mike I am keeping this as part of my growing library of such stuff. Incidentally my own problem with imitating spreadsheet behaviour has moved from financial functions (solved for now thanks to your help and some internet searches) to the problem of simulating recursive evaluation in a g

Re: Financial formulae

2012-11-09 Thread Mike Bonner
found my other stack, heres the script from it. (got the script from somewhere else and adjusted for lc) */ * //-- * *// COMPOUND INTEREST* *// present value, future value, imputed compound interest rate

Re: Financial formulae

2012-11-08 Thread Peter M. Brigham
On Nov 5, 2012, at 3:02 AM, Graham Samuel wrote: > You know I did search the dictionary, but never thought of something so > obvious as 'annuity' or 'compound'. Well, you learn something new every day > (at least I do). I have been known to browse through the dictionary from time to time. That

Re: Financial formulae

2012-11-05 Thread Graham Samuel
Mike, thanks for that - very useful. No need for an extra clean-up. You know I did search the dictionary, but never thought of something so obvious as 'annuity' or 'compound'. Well, you learn something new every day (at least I do). I need to understand a little more about the functions I have

Re: Financial formulae

2012-11-04 Thread Mike Bonner
Oops.. one more. Look at "annuity" in the dictionary, I didn't use it, but could be a time saver for some things. Also the compound function. On Sun, Nov 4, 2012 at 9:43 AM, Mike Bonner wrote: > Forgot to mention. The actual calculation is done in the behavior script > of the datagrid (form) on

Re: Financial formulae

2012-11-04 Thread Mike Bonner
Forgot to mention. The actual calculation is done in the behavior script of the datagrid (form) on the left. ffv for future value amortize for amortization of course and boatspeed is obvious too. If its easier, I can dig out the specific handlers for the 2 financial functions, clean them up (get

Re: Financial formulae

2012-11-04 Thread Mike Bonner
https://dl.dropbox.com/u/11957935/FMM.livecode Look through that. Haven't looked at it in a while, not sure if anything is broken but the calcs and such should be correct. Does amortization schedule, future values and estimates outboard boat speed based on prop pitch and gear ratio. On Sun, Nov

Re: Financial formulae

2012-11-04 Thread dunbarx
Hi. Just enter 42 in all required fields. Craig Newman -Original Message- From: Graham Samuel To: use-livecode Sent: Sun, Nov 4, 2012 10:44 am Subject: Financial formulae Here at the unfashionable end of the galaxy, I find I have to code some financial formulae, for example for