Profile

Finaquant Analytics
20 followers|28,160 views

Stream

Finaquant Analytics

Shared publicly  -

As I wrote before, I am working on a Python module which makes the table functions of the non-commercial .NET library Finaquant Protos available for Python developers. You may download the latest release of this module (tablenet.py) here: Download tablenet.py - Version 1.01 (26. June 2015) ...
1

Finaquant Analytics

Shared publicly  -
Following steps demonstrate how you can call the methods of a third party java class from Matlab, with a simple example (MyMathLib.java) that you can try yourself. This example also demonstrates how simple standard variables (as method arguments) can be passed from Matlab to java, and vice versa ...
1

Finaquant Analytics

Shared publicly  -
With Finaquant's Excel add-in for table/matrix functions it becomes quite easy to implement complex calculations like commissions, performance, risk, bonus, estimations, financial plans & forecasts etc. directly in Excel. You can pack any complex calculation (in C#/.
1

Finaquant Analytics

Shared publicly  -

A notation for data tables as Information units that can be used in requirement engineering and for formulating analytical operations on tables.
1

Finaquant Analytics

Shared publicly  -

NEW ARTICLE: CALCULATING SALES COMMISSIONS IN EXCEL

How to calculate sales commissions with tiered rates for each product group in Excel
http://finaquant.com/calculating-sales-commissions-in-excel/4419

#excel #spreadsheets #salesforce #commission #analytics #fintech #finserv #financialservices  ﻿
How to calculate Sales Commissions with Tiered Rates for each Product Group in Excel
1

Finaquant Analytics

Shared publicly  -

COMMISSION CALCULATION IN EXCEL

It is possible to calculate sales commissions with tiered rates and product groups in Excel. Following steps show how:

Commission scenario explained in:
http://finaquant.com/commission-calculation-with-finaquant-calcs/3607

1) Download and install new release (R105) of the Excel add-in for Table Functions (Finaquant in Excel):

2) Run Table Function named "Create Test Tables" to generate the four input tables that are required for the commission calculation.

3) Run Table Function named "Calculate Sales Commissions" after selecting and entering proper parameters into the parameter form as shown in the image below.

Two output tables will be generated:
* Commissions per Product Pool, and
* Commissions per Dealer

#commission #commissions #calculation #excel #TableFunctions #NoSQL #fintech #finserv #analytics #data #DataScience﻿
1
In their circles
11 people
Have them in circles
20 people

Finaquant Analytics

Shared publicly  -

Calling .NET objects from Python
http://forum.finaquant.com/viewtopic.php?f=7&t=1321

Includes code example: How to convert a NumPy array into a .NET array

#dotnet #python #array #numpy  ﻿
I have recently developed an interest in the programming language Python that I use like an open-source Matlab with its modules like NumPy, Pandas and MatPlotLib. I am currently working on a simple integration module in python, which will enable python users to call table-valued functions of the ...
1

Finaquant Analytics

Shared publicly  -
Hello, my question is related with your excel add-in for table functions. How can i replay a sequence of table functions in excel? For example, i have 3 input tables, applied some table functions on these data tables like table multiplication, aggregation, combination etc. in a certain order to ...
1

Finaquant Analytics

Shared publicly  -
1

Finaquant Analytics

Shared publicly  -
Hello, for a forecasting scenario we want to use statistical matrix functions of math.net numerics. Is it possible to use functions of such a library with finaquant's table functions like subtable transformer, or function router? Martin. kubot: Posts: 2: Joined: 26 Jul 2014, 12:11 ...
1

Finaquant Analytics

Shared publicly  -

1

Finaquant Analytics

Shared publicly  -
1
People
In their circles
11 people
Have them in circles
20 people
Contact Information
Contact info
 Phone +41 78 842 24 47 Email contactfq@finaquant.com
Story
Tagline
Calculation Engines and Frameworks - Innovation in Business Analytics
Introduction
DotNet Calculation Engine with table-valued functions; stored procedures in .NET