Financial formulae

[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 been asked for - they deal in annuities and interest, but they have more parameters than the LC 'annuity' function… all very instructive.

As to Craig's suggestion about 42, I think perhaps we haven't fully understood the question - but the deadline on this project doesn't allow me to wait the requisite millions of years to deal with that issue. I'm very fond of that passage, especially the striking philosophers: "we demand rigidly defined areas of doubt and uncertainty".

Thanks again

Graham

On Sun, 4 Nov 2012 09:47:37 -0700, Mike Bonner <bonnmike at gmail.com> wrote:

> ps.. 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 <bonnmike at gmail.com> wrote:
> 
>> 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 rid of dg specific stuff) and post them here.
>> Now that I know more about rev/lc i'm sure there are quite a few
>> improvements and optimizations to be made.
>> 
>> 
>> On Sun, Nov 4, 2012 at 9:28 AM, Mike Bonner <bonnmike at gmail.com> wrote:
>> 
>>> 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 4, 2012 at 9:05 AM, <dunbarx at aol.com> wrote:
>>> 
>>>> Hi.
>>>> 
>>>> 
>>>> Just enter 42 in all required fields.
>>>> 
>>>> 
>>>> Craig Newman
>>>> 
>>>> 
>>>> 
>>>> -----Original Message-----
>>>> From: Graham Samuel <livfoss at mac.com>
>>>> To: use-livecode <use-livecode at lists.runrev.com>
>>>> 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 amortization (PMT and IPMT) and very
>>>> probably other stuff of this kind - stuff which is available in Excel at
>>>> the
>>>> drop of a mouse but not AFAIK in any LC library. Of course it is just
>>>> tedious
>>>> work rather than anything at all cutting edge (all the fomulae are
>>>> readily
>>>> available), but has anyone tackled any of this already? If so I'd be
>>>> happy to
>>>> negotiate a small payment for the original code. Or I could just keep
>>>> grinding
>>>> on? and may eventually be able to put something into RevOnline myself.
>>>> 
>>>> TIA for any offers
>>>> 
>>>> Graham