Portfolio Software Reviewed These software use geometric averaging of returns. So, if period returns (daily, weekly, monthly) are d1, d2, d3,....,dn, then total-return (TR) is,
TR = (d1*d2*d3*......*dn)^(1/n).
For 30 years, with monthly returns, n = 30*12 = 360 only, for daily returns, n = 30*252 = 7,560.
Daily data are more prone to errors due to ex-div date errors and rounding.
So, I am OK with TR, CAGR being close enough.
I would be more concerned about tiny differences among the software that use monthly data (MFO, PV, M*), but there could be minor discrepancies in TR, CAGR with those that use daily data (TestFol. Stock Rover).
BIG differences for SD, Sharpe Ratio, Sortino Ratio, Drawdowns have already been explained.
I mentioned in my post on 8/3/25 that weekly data would be a good compromise (n = 30*52 = 1,560) but that's isn't used by many (StockCharts has Daily, Weekly and Monthly (paid version) views and so are the related data, but that's a charting software, so it wasn't included in my review).
I can predict that all these FREE software will use us, the users, to debug and then flip to subscription software. Morningstar is doing that, PV and StockCharts already charge arm-&-leg for their paid versions.
Any ideas for estimating capital gain distributions this early in the year? I don't think it can be done so early. As you have noted, there is no pattern seen from past history. Many funds with high % of retirement a/c don't manage the fund at all for CGs - Fido, etc. As the funds are allowed to close books for the year at October-end, November is the earliest this info is available or may be modelled.
If a fund has high UNREALIZED gain and/or high turnover, it's a potential candidate for high REALIZED CGs. Market down years when there can be lot of redemptions can lead to high realized CGs.
One thing is certain - ETFs have no/low realized CGs.
Any ideas for estimating capital gain distributions this early in the year? Does anyone have a method for estimating fund capital gain distributions this
early in the year? I need to keep my income below a certain level for 2025
and have a few mutual funds that sometimes throw a big surprise at
the ends of the year. Normally this is not a problem :-)
What drives distributions? I figure it would be some function of turnover, NAV,
fund inflows and outflows, and of course fund policy.
Any ideas? Also where I might be able to see more timely
turnover and inflow outflow data - funds and Morningstar seems to report it only at
year end.
An an example, I looked up 5 years of data for RYPNX (Royce Small Cap
Opportunity) and plotted turnover vs change # of shares vs the CG distribution for 5 years.
[I tried to post an image, didn't work.]
Not much of a pattern, they have reported 35% turnover for the past three years.
The 2021 distribution was a whopper, about 25% of NAV, turnover was 69%.
But the 2020 distribution was 0 even though turnover was 53%. Q1 2020 was the pandemic big correction
and then the fund had a big spike in Q2-3 2021, even though the asset unders management was
still nearly double a YE 21 vs 20.
Maybe I should calculate the upside volatility of my funds and pay attention to that.
Or I could use volume of a similar ETF as a proxy. So far, this year, RYPNX has been meh,
so I don't expect a big distribution for 2025.
The cool part if that Microsoft Copilot seems to want to work with me on this:
Q: "What us a useful model for predicting mutual fund capital gain distributions in advance?"
A: [edited]: "Would you like help building a predictive model using historical fund data?
I can assist with data sourcing, feature selection, and model development."
Government Statistics: Trump fires labor statistics chief after weaker than expected jobs report JPMorgan and Bank of America stocks drop as Trump warns of payback for ‘bad’ treatment
Trump confirms plans for an executive order to punish banks for what he said was discrimination against conservatives. Meanwhile, banks praise efforts to overhaul regulations.
Do we really have to deal with another 3.4 years of this? Its disgusting.
IShares Active Infrastructure ETF I used to have a big position in D (as a Northern VA resident) but sold it years ago when management embarked on a strategic review, cut the dividend, pledged to restore it, and never did. Part of me is inclined to retake a position in it precisely b/c of the # of data centers popping up around here, but I still haven't pulled the trigger .... I'm already into a bunch of utes as it is.
(and D apparently still isn't earning its dividend, per M* and other places reporting of its payout ratio)