Activex or code for financial calculation ?

[tdong]

Hello every

Currently I am using a VB call to Excel to do yield calculation. It is kinda slow sometimes. Is there a Financial formula vb6 code around ? or Activex so that I can use for faster computattion instead of calling another program to do the calculation. Any suggestions are very appreciated.

Thanks veryone in advance

 

[garths2]

tdong,

Not sure what functions you are looking for but here is a good link.

http://home.comcast.net/~rthamper/html/financialfunctions.htm

-GS

 

[garths2]

Here is another link where they post code for a yield function (towards the bottom of the post)

http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_20385382.html

-GS

 

[tdong]

Thanks guys, I need those math functions in excel, like yield , price, coupon date, etc for bonds These links are nice but not exactly what i have in mind. I need something like an ActiveX which has all the financial function and I just have to pass parameters to it to get the result doesn't have to be free I can pay for some shareware version.

 

[tdong]

This is what I am doing right now. I need an active x to handle this instead of excel. loading and computing in excel is quite slow

' Opens the add-in, which is in the Analysis folder of the Microsoft Excel Library Directory.
CalcBondAccrint = oExcelApp.Application.Run("atpvbaen.xla!Accrint", dteIssue, dteFirstInterest, dteSettlement, coupon / 100, par, Frequency, Basis)

 

[chiph]

Are you going to require your users to own Excel? Because you can't redistribute it with your app.

The links everyone else pointed out was to allow you to write your own yield code, thus removing the need for Excel.

If you don't want to write this code yourself, I would spend some time at Google and

http://components.org/About/cvcmembers.aspx

to see if someone sells a component you can call.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[tdong]

This is an internal software and all of our local computer has excel in it. and we been using it for 3 years already. Just that I need to change if possible since we don't just only use yield formula I use almost all financial formula that come with excel since this is a Trading company we trade commercial paper, bonds etc daily and we have a math guy to do some pretty complicate math I only make it into code