Stock data type, Expense Ratio column
First of all, love the new Stock data type and can see this new feature getting better and better as time goes on.
One thing I noticed right off the bat is that the Expense Ratio column seems to be locked at 2 decimal places. ***.XX% for example. Checking one particular index fund from Vanguard (VINIX), they have the expense ratio listed for this fund as 0.035% but the Excel column brings it in at 0.040%.
It looks like their is either some rounding issue going on or the data source Excel is basing this off of has it saved as 0.040%. This discrepancy may not be big but in timescales of several decades of investing it does add up.
Thanks for the new feature!
Thanks for posting! I’m seeing that this is actually a bug in the data source and doesn’t have to do with a limit on the precision in the expense ratio field.
You can verify yourself that the incorrect data is replicated on Morningstar here: https://www.morningstar.com/funds/xnas/vinix/quote.html
Since this isn’t a feature request, I’m going to close this request as “declined”, and we will follow up with Morningstar about getting this fixed. For future reference you can report issues like this through the Excel “Send a smile” button in the top right of your Excel window.
1 commentComments are closed
When can I expect to see this feature in my Office 365 Excel? The help page indicates it was supposed to be rolled out over several weeks beginning June 12 - it's now Sep 9 and I don't have it. I'm on Version 1808 Build 10730.20088. I was on the phone with Tech Support for over an hour, and they had no idea what I was talking about.