Results 1 to 4 of 4

How do I interpret weighted and non-weighted gains on a stock portfolio?

Threaded View

  1. #1
    Registered User
    Join Date
    05-21-2019
    Location
    Tennessee
    MS-Off Ver
    Office 365
    Posts
    8

    How do I interpret weighted and non-weighted gains on a stock portfolio?

    I have the following stock gains and losses for a stock portfolio. Overall, the portfolio has lost $40 or 28%. But when I calculate weights based on market value, and then calculate the gain/loss based on those weights, I come up with an 8% gain.

    My problem is how do I explain the $40 loss (-28%) on a non-weighted market value basis and the 8% gain on a weighted market value basis?

    So far, I've just come up with this: The market value weights amplify gains or losses embedded in the total gain/loss. Since the total gain/loss has no weights, you don't see the weighted gain/loss.

    But somehow this doesn't sound intuitive.

    Furthermore, how do I explain the 8% gain? I understand the math that calculates it. But what is it 8% of?

    Any help would be greatly appreciated
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sales weighted stock availability
    By Scottpet in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-20-2020, 10:44 AM
  2. Replies: 4
    Last Post: 07-19-2019, 04:47 PM
  3. Weighted Average Function for Series Weighted by Increments of 1
    By kratsexcel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-05-2018, 11:38 AM
  4. Replies: 1
    Last Post: 02-28-2018, 02:38 AM
  5. Replies: 0
    Last Post: 02-15-2018, 03:04 AM
  6. Weighted Averages and Stock Reconciliation
    By MarcusFuel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-16-2014, 03:57 PM
  7. Weighted average of ever changing stock
    By pansovic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2012, 04:27 PM

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