SQLFinancials - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

SQLFinancials by TotallySQL

URLs: sqlfinancials, totallysql

The analytical capability of Excel with the raw data-crunching power of SQL Server. SQLFinancials extends and enhances your T-SQL programming environment by adding 50+ powerful new financial functions and aggregates that faithfully replicate and extend all the financial analysis features available in Microsoft Excel. SQLFinancials includes: 29 functions for calculating yields, rates, coupon periods etc. for corporate and government bonds, 7 functions for calculating depreciation on various bases, 15 functions for calculating interest payments, rates, principal payments, durations, present and future values etc. for loans or investments, 3 functions for calculating internal rates of return for a series of cashflows and 2 functions for converting between dollar fractions and decimal values.

Beyond Excel

As the use of Microsoft Excel for financial analysis is so widespread, the SQLFinancial functions have been developed so that they faithfully reproduce the same results for the same set of input values in virtually all cases, enabling a smoother migration of existing spreadsheet-based systems into the more powerful, structured and manageable world of SQL Server. However there are also some improvements in the SQLFinancial functions versus their Excel counterparts:

The precision of calculations in Excel is limited to 13 decimal places. In SQLFinancials accuracy is to 17 decimal places.

SQLFinancials functions generally accept a wider possible range of input values, that in Excel would just lead to a #NUM result.

For securities SQLFinancials recognises coupon frequencies of 6 and 12 (bi-monthly and monthly) as well as 1, 2 and 4.

There are a couple of additional functions not found in Excel, namely DAYCOUNT and DAYSINYEAR.

There is vastly greater capacity and data processing power of SQL Server behind them.

Native Look and Feel

All TotallySQL Transact-SQL extensions are implemented using familiar programming objects within SQL (scalar and table-valued functions, aggregate functions, user-defined types, stored procedures) , keeping the syntax clean and making them as fast and easy to use as the built-in native math functions such as AVG, SUM etc.

Multi-Valued Aggregates - even in SQL2005

Six of the 50+ SQLFinancials functions (IRR, MIRR, XIRR, NPV, XNPV, FVSCHEDULE) are in the form of aggregate functions that take multiple input values. This works fine for SQL2008 but is commonly supposed to be impossible in SQL2005 - since you can supply only one input parameter to an aggregate function. TotallySQL have, however, devised a very simple but smart way of doing this in SQL2005 using SQLTuples: you simply combine the input parameters (of any type) into a SQLTuples object on-the-fly as part of the function call. Only a very minor syntax change is needed and there is no measurable performance penalty even when used with truly enormous data sets.

SQLFinancials Features

Accrued interest on bonds that pay interest periodically or at maturity

Calculation of effective coupon days, days per period & days since last / before next coupon date

Effective days between two dates, days in a year & year fraction for the given day count convention

Calculation of price & yield for securities paying interest periodically or at maturity

Calculation of price, yield and discount rate for a discounted security

Calculation of price & yield for a security with an odd first or last period

Calculation of the interest rate & the amount payable at maturity for a fully-invested security

Calculation of the Macaulay duration and the modified Macaulay duration for a security

Support for coupon frequencies of 6 per year and 12 per year in addition to 1, 2 and 4 per year on securities.

Calculation of the price, yield and bond-equivalent yield for a US Treasury bill

Depreciation using declining, double-declining or variable declining balance methods

Depreciation using straight line or sum-of-year's digits methods

Depreciation for the French accounting system using depreciation coefficients

Calculation of interest, principal and total payments on a loan for a given period or range of periods

Calculation of nominal rate, effective annual rate & periodic rate of interest for a loan

Calculation of future value, present value & net present value of an investment or loan

Calculation of the number of periods required for a loan or investment to reach a specified value

Internal rate of return or modified internal rate of return for a series of regular or dated cashflows

Conversion of dollar prices between fractions and decimal representations

The analytical capability of Excel with the raw data-crunching power of SQL Server.

Pricing: SQLFinancials - CAL (Client Access License) V1.0 1 CAL License, SQLFinancials - CAL (Client Access License) V1.0 5 CAL License, SQLFinancials - CAL (Client Access License) V1.0 10 CAL License, SQLFinancials - CAL (Client Access License) V1.0 25 CAL License, SQLFinancials - CAL (Client Access License) V1.0 50 CAL License, SQLFinancials - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 1 CAL License, SQLFinancials - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 5 CAL License, SQLFinancials - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 10 CAL License, SQLFinancials - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 25 CAL License, SQLFinancials - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 50 CAL License, SQLFinancials - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 1 CAL License, SQLFinancials - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 5 CAL License, SQLFinancials - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 10 CAL License, SQLFinancials - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 25 CAL License, SQLFinancials - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 50 CAL License, SQLFinancials - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 1 CAL License, SQLFinancials - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 5 CAL License, SQLFinancials - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 10 CAL License, SQLFinancials - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 25 CAL License, SQLFinancials - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 50 CAL License, SQLFinancials CAL (Client Access License) - 1 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, SQLFinancials CAL (Client Access License) - 1 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, SQLFinancials CAL (Client Access License) - 1 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, SQLFinancials CAL (Client Access License) - 1 Year Support & Maintenance Renewal 25 CAL Support & Maintenance Renewal License, SQLFinancials CAL (Client Access License) - 1 Year Support & Maintenance Renewal 50 CAL Support & Maintenance Renewal License, SQLFinancials CAL (Client Access License) - 3 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, SQLFinancials CAL (Client Access License) - 3 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, SQLFinancials CAL (Client Access License) - 3 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, SQLFinancials CAL (Client Access License) - 3 Year Support & Maintenance Renewal 25 CAL Support & Maintenance Renewal License, SQLFinancials CAL (Client Access License) - 3 Year Support & Maintenance Renewal 50 CAL Support & Maintenance Renewal License, SQLFinancials CAL (Client Access License) - 5 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, SQLFinancials CAL (Client Access License) - 5 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, SQLFinancials CAL (Client Access License) - 5 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, SQLFinancials CAL (Client Access License) - 5 Year Support & Maintenance Renewal 25 CAL Support & Maintenance Renewal License, SQLFinancials CAL (Client Access License) - 5 Year Support & Maintenance Renewal 50 CAL Support & Maintenance Renewal License, SQLFinancials - CPU License V1.0 1 CPU License, SQLFinancials - CPU License V1.0 2 CPU License, SQLFinancials - CPU License V1.0 4 CPU License, SQLFinancials - CPU License V1.0 8 CPU License, SQLFinancials - CPU License V1.0 Unlimited CPU License, SQLFinancials - CPU

Evals & Downloads: Read the SQLFinancials help file, Read the TotallySQL License Agreement, Download the SQLFinancials V1.0 evaluation on to your computer - Expires After 30 Days

Operating System for Deployment: Windows 7, Windows Server 2008, Windows Server 2003

Architecture of Product: 32Bit, 64Bit

Product Type: Component

Component Type: .NET Class, 100% Managed Code

Compatible Containers: Microsoft SQL Server 2008, Microsoft SQL Server 2005

Keywords: SQLFinancials

totally sql

Financial finance bank banking insurance

Math Stats Mathematics Mathematical Statistic Statistical

SQL query language

Part numbers: PC-541720-407526 541720-407526 PC-541720-407527 541720-407527 PC-541720-407528 541720-407528 PC-541720-407529 541720-407529 PC-541720-407530 541720-407530 PC-541720-407531 541720-407531 PC-541720-407532 541720-407532 PC-541720-407533 541720-407533 PC-541720-407534 541720-407534 PC-541720-407535 541720-407535 PC-541720-407536 541720-407536 PC-541720-407537 541720-407537 PC-541720-407538 541720-407538 PC-541720-407539 541720-407539 PC-541720-407540 541720-407540 PC-541720-407541 541720-407541 PC-541720-407542 541720-407542 PC-541720-407543 541720-407543 PC-541720-407544 541720-407544 PC-541720-407545 541720-407545 PC-541720-407546 541720-407546 PC-541720-407547 541720-407547 PC-541720-407548 541720-407548 PC-541720-407549 541720-407549 PC-541720-407550 541720-407550 PC-541720-407551 541720-407551 PC-541720-407552 541720-407552 PC-541720-407553 541720-407553 PC-541720-407554 541720-407554 PC-541720-407555 541720-407555 PC-541720-407556 541720-407556 PC-541720-407557 541720-407557 PC-541720-407558 541720-407558 PC-541720-407559 541720-407559 PC-541720-407560 541720-407560 PC-541720-407806 541720-407806 PC-541720-407807 541720-407807 PC-541720-407808 541720-407808 PC-541720-407809 541720-407809 PC-541720-407810 541720-407810 PC-541720-407811 541720-407811 PC-541720-407812 541720-407812 PC-541720-407813 541720-407813 PC-541720-407814 541720-407814 PC-541720-407815 541720-407815 PC-541720-407816 541720-407816 PC-541720-407817 541720-407817 PC-541720-407818 541720-407818 PC-541720-407819 541720-407819 PC-541720-407820 541720-407820 PC-541720-407821 541720-407821 PC-541720-407822 541720-407822 PC-541720-407823 541720-407823 PC-541720-407824 541720-407824 PC-541720-407825 541720-407825 PC-541720-407826 541720-407826 PC-541720-407827 541720-407827 PC-541720-407828 541720-407828 PC-541720-407829 541720-407829 PC-541720-407830 541720-407830 PC-541720-407831 541720-407831 PC-541720-407832 541720-407832 PC-541720-407833 541720-407833 PC-541720-407834 541720-407834 PC-541720-407835 541720-407835 PC-541720-407836 541720-407836 PC-541720-407837 541720-407837 PC-541720-407838 541720-407838 PC-541720-407839 541720-407839 PC-541720-407840 541720-407840