Hello..
I am using excel 2007 and stuck at a mathematical question and unable to figure out how to calculate return on investment in terms of percentages on every transaction. After every transaction, I should know how much percentage is my portfolio worth. Here is a pic of my sample data and I am also attaching excel file. Please help me with a formula in column H. I dont know if the data structure I have maintained in excel is the correct way or not. Please advice efficient way of putting the data in a presentable manner.
Thank you.
EDIT : I wasn't getting reply to this question so I have posted a new question with real time example here and online portfolio screenshots for proper explanation. Kindly ignore this question. I am closing this tread as solved.
pgain.png
Bookmarks