MicrosoftThis is pretty entertaining. Having never been able to get access to the stock data feature, I can tell you the majority of complaints and wishlist items are "user error."
EPS, etc is a waste of time since each is an easy calculation based on exisiting fundamental data.
HYG is an ETF, not a "stock." The $ in front of an ETF is in many cases to provide the NAV as opposed to trading value. The IPOs not showing is most likely wrong protocol to exchange via excel, not the specific stock itself.
The latter would also explain the variance in mutual fund pricing. On MS side, compliance with OFX protocols should be verified, should be easy as MS helped create such. As to pricing, exchanges do not provide free real time data, so your last price will be delayed how long each chooses.
Finally, make sure you are using the correct ticker, the currency post would be invalid ticker issue.
I shall now step off my soapbox....
