Calling Financial Functions

[Raj20091]

Hello,

Is there a way to call VBA Financial Functions such as PV, PMT from QTP?
Or
These functions are available in Excel, is there a way to call these functions with out actually writing the parameter to these functions to excel?

Thanks,
Raj

[milindsd]

Hi,
You can use Excel formulas, in the QTP Data Table.

Bellow is the example:
'''-------------------------------------------------------------

Code:

DataTable("Formula", dtLocalSheet) = "=PV(10, 48, 200000)"
valPV = DataTable("Formula", dtLocalSheet)

DataTable("Formula", dtLocalSheet) = "=PMT(10, 48," & valPV &")"
valPMT = DataTable("Formula", dtLocalSheet)
Print "PV: " & valPV
Print "PMT: " & valPMT

'''-------------------------------------------------------------
Hope, this would help you!

Thanks,

[Raj20091]

That should do it. I will try it out. Thanks!