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

27 views (last 30 days)
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!

Accepted Answer

txvmi07
txvmi07 on 9 Jul 2014
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

More Answers (1)

Sara
Sara on 7 Jul 2014
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 Comments
Sara
Sara on 7 Jul 2014
try this:
myres = zeros(1,size(netcfq,2));
for i = 1:size(netcfq,2)
myres(i) = irr(netcfq(netcfq(:,i)>0));
end

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!