>Has anybody written or know of a library of financial functions for VFP?
>I am looking at a lot of hours of coding for stuff like security yield, dollar price (for bonds) etc. MS Excel has a bunch of them built in, but because I need them for a web app, for safety's sake, I really don't want to automate Excel to do this.
>
>Any pointers would be welcome-
Check with a guy named Jan Mayle from a firm called Tips. I believe he may still be affiliated with the SIA (Securities Industry Association) in New York. You can reach the SIA at (212)608-1500. Jan is the author of SIA's book, Standard Securities Calculation Methods. I spoke with Jan several years ago and, though my memory is very sketchy, I believe we discussed him making the stuff available as Foxpro libraries.
I had written the calcs myself years ago but have never used them in production. The inhibiting factor for me has been the high price of bond descriptions. I.e., the hard data about a bond that includes things like odd coupon periods, etc. To my knowledge, Excel does not take things like odd coupon periods into account.
You can also check with Tech Hackers (
www.techhackers.com).
Let me know how you do.
Mark