SQLFinancials
by TotallySQL - Product Type: Component / .NET Class / 100% Managed Code
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.
Our regular prices are shown below. Please logon to see your discounted prices.
SQLFinancials - CAL (Client Access License) V1.0
| Add to Cart | $ 146.02 | 1 CAL License | Download (794 KB) | |
| Add to Cart | $ 489.02 | 5 CAL License | Download (794 KB) | |
| Add to Cart | $ 783.02 | 10 CAL License | Download (794 KB) | |
| Add to Cart | $ 1,469.02 | 25 CAL License | Download (794 KB) | |
| Add to Cart | $ 2,449.02 | 50 CAL License | Download (794 KB) |
SQLFinancials - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance
| Add to Cart | $ 175.22 | 1 CAL License | Download (794 KB) | |
| Add to Cart | $ 583.88 | 5 CAL License | Download (794 KB) | |
| Add to Cart | $ 939.62 | 10 CAL License | Download (794 KB) | |
| Add to Cart | $ 1,762.82 | 25 CAL License | Download (794 KB) | |
| Add to Cart | $ 2,938.82 | 50 CAL License | Download (794 KB) |
SQLFinancials - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance
| Add to Cart | $ 204.43 | 1 CAL License | Download (794 KB) | |
| Add to Cart | $ 684.63 | 5 CAL License | Download (794 KB) | |
| Add to Cart | $ 1,096.23 | 10 CAL License | Download (794 KB) | |
| Add to Cart | $ 2,056.63 | 25 CAL License | Download (794 KB) | |
| Add to Cart | $ 3,428.63 | 50 CAL License | Download (794 KB) |
SQLFinancials - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance
| Add to Cart | $ 233.63 | 1 CAL License | Download (794 KB) | |
| Add to Cart | $ 782.82 | 5 CAL License | Download (794 KB) | |
| Add to Cart | $ 1,252.83 | 10 CAL License | Download (794 KB) | |
| Add to Cart | $ 2,350.43 | 25 CAL License | Download (794 KB) | |
| Add to Cart | $ 3,918.43 | 50 CAL License | Download (794 KB) |
SQLFinancials CAL (Client Access License) - 1 Year Support & Maintenance Renewal
| Add to Cart | $ 29.20 | 1 CAL Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 97.80 | 5 CAL Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 156.60 | 10 CAL Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 293.80 | 25 CAL Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 489.80 | 50 CAL Support & Maintenance Renewal License | Verify | Download (794 KB) |
SQLFinancials CAL (Client Access License) - 3 Year Support & Maintenance Renewal
| Add to Cart | $ 58.41 | 1 CAL Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 195.61 | 5 CAL Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 313.21 | 10 CAL Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 587.61 | 25 CAL Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 979.61 | 50 CAL Support & Maintenance Renewal License | Verify | Download (794 KB) |
SQLFinancials CAL (Client Access License) - 5 Year Support & Maintenance Renewal
| Add to Cart | $ 87.61 | 1 CAL Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 293.41 | 5 CAL Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 469.81 | 10 CAL Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 881.41 | 25 CAL Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 1,469.41 | 50 CAL Support & Maintenance Renewal License | Verify | Download (794 KB) |
SQLFinancials - CPU License V1.0
| Add to Cart | $ 2,449.02 | 1 CPU License | Download (794 KB) | |
| Add to Cart | $ 3,919.02 | 2 CPU License | Download (794 KB) | |
| Add to Cart | $ 5,879.02 | 4 CPU License | Download (794 KB) | |
| Add to Cart | $ 9,795.10 | 8 CPU License | Download (794 KB) | |
| Add to Cart | $ 15,674.12 | Unlimited CPU License | Download (794 KB) |
SQLFinancials - CPU License V1.0 with - 1 Year Support & Maintenance
| Add to Cart | $ 2,938.82 | 1 CPU License | Download (794 KB) | |
| Add to Cart | $ 4,702.82 | 2 CPU License | Download (794 KB) | |
| Add to Cart | $ 7,054.82 | 4 CPU License | Download (794 KB) | |
| Add to Cart | $ 11,754.12 | 8 CPU License | Download (794 KB) | |
| Add to Cart | $ 18,808.94 | Unlimited CPU License | Download (794 KB) |
SQLFinancials - CPU License V1.0 with - 3 Year Support & Maintenance
| Add to Cart | $ 3,428.63 | 1 CPU License | Download (794 KB) | |
| Add to Cart | $ 5,486.63 | 2 CPU License | Download (794 KB) | |
| Add to Cart | $ 8,230.63 | 4 CPU License | Download (794 KB) | |
| Add to Cart | $ 13,713.14 | 8 CPU License | Download (794 KB) | |
| Add to Cart | $ 21,943.77 | Unlimited CPU License | Download (794 KB) |
SQLFinancials - CPU License V1.0 with - 5 Year Support & Maintenance
| Add to Cart | $ 3,918.43 | 1 CPU License | Download (794 KB) | |
| Add to Cart | $ 6,270.43 | 2 CPU License | Download (794 KB) | |
| Add to Cart | $ 9,406.43 | 4 CPU License | Download (794 KB) | |
| Add to Cart | $ 15,672.16 | 8 CPU License | Download (794 KB) | |
| Add to Cart | $ 25,078.59 | Unlimited CPU License | Download (794 KB) |
SQLFinancials CPU License - 1 Year Support & Maintenance Renewal
| Add to Cart | $ 489.80 | 1 CPU Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 783.80 | 2 CPU Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 1,175.80 | 4 CPU Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 1,959.02 | 8 CPU Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 3,134.82 | Unlimited CPU Support & Maintenance Renewal License | Verify | Download (794 KB) |
SQLFinancials CPU License - 3 Year Support & Maintenance Renewal
| Add to Cart | $ 979.61 | 1 CPU Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 1,567.61 | 2 CPU Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 2,351.61 | 4 CPU Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 3,918.04 | 8 CPU Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 6,269.65 | Unlimited CPU Support & Maintenance Renewal License | Verify | Download (794 KB) |
SQLFinancials CPU License - 5 Year Support & Maintenance Renewal
| Add to Cart | $ 1,469.41 | 1 CPU Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 2,351.41 | 2 CPU Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 3,527.41 | 4 CPU Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 5,877.06 | 8 CPU Support & Maintenance Renewal License | Verify | Download (794 KB) |
| Add to Cart | $ 9,404.47 | Unlimited CPU Support & Maintenance Renewal License | Verify | Download (794 KB) |
Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase. All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed, including volume licensing and previous versions.
Our regular prices are shown above. Please logon to see your discounted prices.
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
Quick Links
Publisher
- TotallySQL (10)
Primary Category
- Financial (41)
Related Products
Related Categories
- Maths and Stats (46)
- SQL (140)
Why buy from ComponentSource?
ComponentSource offers a unique global service, used by over 1,000,000 software developers worldwide.