Search results

This is the best support Group with fast support. Also is it possible instead of adding SOLD, SELL, BUY, BOUGHT separately, can be point to the group cell A3 to A7 so the formula will be shorter. Reason is (Sell, Sold) should be treated same and (Buy, Bought or In transit) should be treated as...

Thankyou bosco_yip For some reason I am not getting same answer in row 20.

Solved

Hi, Trying to do a project with keeping accurate real cost after sale of item , I was able to do when only item is purchased but stuck as soon as item get sold. Formula trying to modify and use is...

Hi, Work on this sheet when try to run on main sheet dose not work will get Cell on line 8 as blank which is correct but rest is #VALUE

Hello, New problem found some time formula work some time I get only #Value ( have tried all suggestion but get same result )

Thankyou for the help and the support received. Happy New year

Thankyou Both bosco_yip & John Jairo V I wanted to keep the Cell Blank if conditions not exists John formula insert - . Both solution work

Hello, Thanks for quick reply, Problem is it should only multiply and add only White and Grey items and rest should be zero.

Hello, I am trying to work with Sumproduct formula with multiple criteria but is not working can someone help me with this. i am trying to calculate total value of each product with some color good and imperfect separate. Thanks

Hello, @joeu2004, Is it possible to calculate the Monthly TWR when we don't have the "portfolio value @ end of month" for every month, so, we don't get #DIV/0

Once again Thank you for explaining in-detail everything. learned lot of new things. Thankyou

Hello, Look like still having issue with the TWR calculation cannot understand what the difference is. Line 14 TWR is way out.

Hello, Can you please comment why my cumulative TWR to date percentage is so high? Thanks

Thank you for your help, and explanation.

Hello just found issue which I cannot understand if the money added start from 2nd cell, I get 0.00% both Cells have same date.

Thank you for such nice explanation much easy then what someone can understand in a classroom. I am still digesting all the explanation you have given. Also will read more about TWR this is something I have not read in detail.

Yes, let's talk about very first month gain in month of Aug is about $409.56 which is about 13.65% in 25 days and XIRR is so high 555.12%. In sept month total gain is $271.21 in 55 days is 9%. and if calculate per day and then for 365 days is about 60%. So, look like my XIRR are not correct.

Once again Thanks for detail explanation. So, what is the best way to find more accurate return on a portfolio on a monthly and yearly base.

Thanks for your help. For some reason it looks like that the XIRR percentages are not correct. can it be verified? Thanks

Thank you for the explaining the steps, I have made modifications to the formula and corrected my mistakes on the sheet but not sure if the calculations are correct. can you see and help. Thanks

Further reading Found that XIRR can only work if the dates are oldest to new. So have dropped this idea. Thanks everyone.

Hello, I have been trying to work on this project from some time as I am not strong with Excel. so, trying to get some help from EXCEL GURU's. Sheet with multiple entries in a month for adding money or taking money out. When try to calculate with limited EXCEL Knowledge I get #VALUE or #NUM...

Hello Any help

Hello, I am not sure if it is possible calculating XIRR with New to old date / Data as shown. Also, can have more than 1 entry per month. List keeps growing Help Please. Thanks