Additional FAQs

< Browse all Support Topics

Differences in Model Portfolio Returns vs. “Portfolio Holdings” Excel Templates Returns

The Model Portfolio Returns are calculated use monthly/quarterly rebalancing for returns whereas the “Portfolio Holdings” excel templates use a total weighted average of all holdings in the portfolio. This will cause a difference in returns in time frames.

For example, if you wanted a 5 year total return of a monthly rebalanced portfolio, the “Portfolio Holdings” excel templates will take the weighted average of the 5 year total return for all holdings included in the portfolio. Model Portfolios, on the other hand, will take the weighted average monthly returns of the holdings over the same time frame to then calculate the 5 year total return of the portfolio

Are you an investing professional?

Click here to request a live demo of YCharts Professional, our premium suite of tools and data.
Learn more about our professional products. Call (866) 965-7552 or email sales@ycharts.com.

{{root.upsell.info.feature_headline}}.

{{root.upsell.info.feature_description}}

Please note that this feature is only available as an add-on to YCharts subscriptions.


Please note that this feature requires full activation of your account and is not permitted during the free trial period.

Start My Free Trial {{root.upsell.info.call_to_action}} No credit card required.

Already a subscriber? Sign in.