0
$\begingroup$

I have a table of the weights of stocks in my portfolio for various periods and another with the returns that those stocks had for the same periods.

If I sum the product between the weights and the returns and compound the returns for each period, I will end up with my portfolio return for all periods.

I want to calculate the contribution of each individual stock for my portfolio return across all periods, in a manner that the result will sum to my total return.

Can you help me with this calculation?

Improve this question
$\endgroup$
4
  • $\begingroup$ Same question as this I think. You cannot sim the individual contributions across periods because the weights change constantly. $\endgroup$
    – AKdemy
    Aug 4, 2021 at 14:20
  • $\begingroup$ I believe my case to be different because I know the weights for all periods. The portfolio's weights change at the end of each period. Wouldn't you agree? $\endgroup$
    – pelelter
    Aug 4, 2021 at 14:42
  • $\begingroup$ Yes and that is why you cannot sum up the contributions of portfolio components to the total return of the portfolio (edit 2 in the link). $\endgroup$
    – AKdemy
    Aug 4, 2021 at 14:52
  • $\begingroup$ The method described by Feibel and mentioned here quant.stackexchange.com/questions/36520/… may help. $\endgroup$
    – nbbo2
    Aug 4, 2021 at 17:58

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.