Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
i am able to read my table using macro -
Sub ReadStraightTable
Set Table = ActiveDocument.GetSheetObject( "CH05" )
For RowIter = 1 to table.GetRowCount-1
For ColIter = 2 to table.GetColumnCount-1
set cell = table.GetCell(RowIter,ColIter)
MsgBox(cell.Text)
Next
Next
End Sub
now i want to calculate irr in table box but im not getting how to pass table values from macro above to the table box properties to calculate irr. any help would be thankful.
yup one column is dates and another one is amount
you want to calculate iir using dates?
plz have a look at my data. so i want to calc. for date and amount column.
for calculating IRR we need to have dates and amount. so first column is dates only.
As long as I know (IRR documentation : IRR - chart function ‒ QlikView) does not support dates.
"These cash flows do not have to be even, as they would be for an annuity. However, the cash flows must occur at regular intervals, such as monthly or annually. "
ok for xirr calculation we do need dates. i am trying to calculate either irr or xirr.
the table i have is in straight table. my question is to write a macro to that will read a table and then pass it to a variable and that varaible can be used in text for calc. of xirr as =xirr(var1,var2)