Closed Thread
Results 1 to 2 of 2

Need help in calculating transactionwise Portfolio Percentage Gain/Loss on an Investment

  1. #1
    Forum Contributor
    Join Date
    11-29-2014
    Location
    India
    MS-Off Ver
    MS Excel 2007
    Posts
    240

    Need help in calculating transactionwise Portfolio Percentage Gain/Loss on an Investment

    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
    Attached Files Attached Files
    Last edited by sabha; 06-24-2021 at 01:29 PM. Reason: Added new question with proper explanation

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Need help in calculating transactionwise Portfolio Percentage Gain/Loss on an Investme

    Quote Originally Posted by sabha View Post
    I have posted a new question
    Please do not do this. If you need to revise a question simply edit the original question. We have a rule against duplicate threads.



    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Finding Percentage Difference Gain or Loss
    By tylerpick in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-31-2013, 05:56 PM
  2. Replies: 2
    Last Post: 08-14-2013, 11:03 AM
  3. Replies: 1
    Last Post: 06-24-2013, 11:52 PM
  4. calculating percentage of loss
    By J Glanton in forum Excel General
    Replies: 4
    Last Post: 11-12-2011, 02:51 PM
  5. Excel 2007 : Calculating gain loss with +or- sign
    By J Glanton in forum Excel General
    Replies: 10
    Last Post: 11-12-2011, 01:30 PM
  6. Replies: 4
    Last Post: 03-29-2009, 01:37 AM
  7. Finding the Investment Gain for Retirement
    By xcbrina3206 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-06-2008, 09:44 PM
  8. Spreadsheet to do annual investment gain$, % gain, for list
    By notaspreadsheetgenius in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-09-2005, 04:08 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1