FVSCHEDULE equivalent in Qlikview

[rkondaveti]

Hi Gurus,

I would like to calculate

FVSchedule,

Tacking error,

Information ratio

Sharpe Ration

Beta,

In qlikview, Does anyone know how to calculate them in QV.

Thanks.

RK

[marcus_sommer]

Have a look on the qlikview help by finance functions, for example:

fv(rate, nper, pmt [ ,pv [ , typ ] ])

- Marcus

[#3]

Please find the below Help Info:

fv(rate, nper, pmt [ ,pv [ , type ] ])

Returns the future value of an investment based on periodic, constant payments and a constant interest rate. The result has a default number format of Money.

Example:

You are paying a new VCR by 36 monthly installments of $20. The interest rate is 6% per annum. The bill comes at the end of every month. What is the total value of the money invested, when the last bill has been paid?

fv(0.005,36,-20) returns $786.72