Convert Excel Formula to SQL -can help me-

  • Hello, I need to convert this excel formulas to SQL, can anybody help me, is pretty urgency for me...

    @duration(

    @yield(

    @couppcd(

    Thank you a lot

    Regards

  • Um, errr...

    There are companies that base their entire living on doing financial calculations in large scale for businesses. For example, take a look at Advent Software.

    Forget easily transcribed, these are about a week or two worth of work, each, and that's with full access to your data model and business assets, especially when you consider the different forms of accounting methods involved and the like. Add to that you need to reference existing tables that store all the necessary settlement, maturity, early buyout, etc...

    This is far beyond a little help on a forum, you're talking dedicated work by an expert for a while.

    EDIT: My original post could have been construed as rude if read the wrong way, changed the wording.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply