How do you operate on only the non-zero elements of columns within an array?

27 次查看（过去 30 天）
txvmi07
txvmi07 2014-7-7
评论： txvmi07 2014-7-9
Problem: I have an m-by-n matrix of values, some positive and some negative, and I am only concerned with values greater than zero. I used logical operators to set all values in the original array that are less than zero to zero, and would like to then be able to do some operation on only those column values that are greater than zero, for instance, find the IRR of the column for all values >0.
I have found the row subscripts (and linear indices) for the first element and last non-zero element in each of the columns, but can't figure out how to use these to calculate the IRR/SUM/other operation on each column individually.
Attached is the variable I am referencing. I am trying to apply a function (IRR) to only positive rows and return the IRR for the positive elements in each column (so rows 1:317 for column 1).
Thanks in advance for your help!

请先登录，再回答此问题。

采纳的回答

txvmi07
txvmi07 2014-7-9
Thanks for the help! My problem was sort of difficult and while I didn't use your suggestion in that explicit manner it did point me in the right direction. I ended up being able to figure this out with a combination of indexing and looping as you can see below. The difference between the netcfq array I referred to in the original question and the cfq variable referenced below is that row 1 in cfq is the initial cash outlay (a negative number) while netcfq are the cash inflows. The IRR calculation won't work with zeros or extremely small numbers as I found out by setting netcfq(netcfq<0) = 1/10^9 and then using the IRR function.
Thanks again!
Code:
warning('off','finance:irr:multipleIRR')
%IRR Calculations
irr_index_nz = sum(netcfq>0)+1; % row subscript of last day of non-zero cash flow
irr_value = zeros(1,size(cfq,2));
for i = 1:size(cfq,2)
rows = 1:irr_index_nz(i);
column = (i);
irr_value(i) = irr(cfq(rows, column))*12;
end

更多回答（1 个）

Sara
Sara 2014-7-7
For sum:
netcfq(netcfq<0) = 0;
mysum = sum(netcfq,1)
for other functions, you could use a loop on the columns and a temporary array temp = netcfq(netcfq>0) as input.
  3 个评论
显示 1更早的评论
Sara
Sara 2014-7-7
try this:
myres = zeros(1,size(netcfq,2));
for i = 1:size(netcfq,2)
myres(i) = irr(netcfq(netcfq(:,i)>0));
end

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Cash Flows 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by