{"id":41748,"date":"2018-11-14T17:32:04","date_gmt":"2018-11-14T12:02:04","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=41748"},"modified":"2018-11-14T17:32:04","modified_gmt":"2018-11-14T12:02:04","slug":"qlik-sense-financial-functions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-financial-functions\/","title":{"rendered":"Qlik Sense Financial Functions – Example & Syntax"},"content":{"rendered":"

1. Objective<\/span><\/h2>\n

In our last Qlik Sense Tutorial, we discussed Table Functions<\/strong><\/a>. Today, we will see Qlik Sense Financial Functions. We use the financial functions in a Qlik Sense data load script when we deal with data related to finance like to calculate interest rates, payments, profits, loss etc. In the parameters and results of the financial functions which we will discuss below will represent the money or cash paid out (debited) as negative values and the amount or cash received i.e. credited money as positive values.<\/span><\/p>\n

So, let’s start Qlik Sense Financial Functions.<\/p>\n

\"Qlik<\/a>

Qlik Sense Financial Functions – Example & Syntax<\/p><\/div>\n

Have a look at Qlik Sense advantages and disadvantages<\/a><\/strong><\/p>\n

2. Qlik Sense Financial Functions<\/h2>\n

i. BlackAndSchole() function<\/span><\/h3>\n

The Black and schole function evaluates parameters used in the function according to the Black and Schole formula which is so formulated that it calculates the variation in financial instruments like stocks, over a certain period of time. The result is calculated using six variables which are the strike, time left, underlying price, volatility, risk-free rate, and type. This function returns a numeric value.<\/span><\/p>\n

The syntax of BlackAndSchole Function:<\/strong><\/p>\n

BlackAndSchole(strike , time_left , underlying_price , vol , risk_free_rate , type)<\/pre>\n
The parameters or variables are described below, and they are all in the context of stock prices. Also, certain things must be kept in mind that is the values of the strike, time_left, and underlying_price must be greater than zero and the values of vol and risk_free_rate must be either less than zero or greater than zero.<\/span><\/p>\n
Do you know about Qlik Sense Mapping\u00a0Function<\/a><\/strong><\/p>\n