Search results

Thanks a lot guys, The dime fell. Why is it giving me #NUM! error on the action in the pic?

Yes, I agree, but I prefer to spend money on my self, then to give it to someone else :D

I'm sorry, but It's not what I need and can't calculate this type of return. I don't just need cash flow return, there's also the aspect of how much return I've gained on my trades. I'll explain again: I deposit 100 traded and gained 10% now I have 110 (and I can gladly brag that I...

I'd like to calculate the return. For example, in cell A1 (the account value) I have 1100. In cell B1 (The deposits) I have 1000 and cell C1 has date 1/1/07 ok, now I can calculate 1000R^(365/365)=1100 Or R=(1100/1000-1)*100=10% which is my return and indeed I can calulate that...

I'd like to see how XIRR calculate return based on different deposits. Would be great if you could upload an example. From what I understand about this function it doesn't calculate return and it require a cash flow with at list one negative value. I don't have withdraws yet, so it won't work.

Sorry, but excel does not have a function to calculate this. What layout do you need? I have a cell with the current account value a column for deposit, a column for deposit date A column for withdraw, a column for withdraw date

a. It costs money, thats a no no. b. doesn't work in the market I work in. c. I enjoy the sheet I build to my self, just need this one function.

Hello all, This is my first post after reading here for a couple of months, I'd like to tell you I enjoy this forum very much. Sorry if my english is messed up, specially with financial lingo, it's not my mothers language. On to my question. I'd like to have an excel function or vba...