Separate names with a comma.
Discussion in 'General Questions' started by marketxls, Jun 24, 2017.
Where can I find information on (1) exactly what the functions do and (2) which versions of MarketXLS each function is supported by? I'm currently running the Personal MarketXLS Basic version, and I'm interested in yield information, but e.g., ETFYield and MF_Yield return #value for me. Even if they were returning data, I'd still need to know the details of exactly what yield is being returned.
It's been nearly two weeks without any information being provided. Help?
Hi, Sorry I missed it. I am checking on it. All versions should have these functions. I am updating this sheet with the latest set. Will come back shortly.
When I put this in a cell,
I get "NA" back, though
produces1.6297202. Strange, because SCHB is an ETF, not a stock. Also strange, because Morningstar says the 12-month yield for SCHB is 1.71%.
Why does ETFYield not apply to SCHB? Why does DividendYield apply to SCHB? And what is the definition of "yield" that DividendYield is returning for SCHB?