Latest List of MarketXLS Functions

Discussion in 'General Questions' started by marketxls, Jun 24, 2017.

Latest List of MarketXLS Functions

  1. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,099
    Likes Received:
    10
  2. sdm

    sdm New Member

    Joined:
    Nov 6, 2017
    Messages:
    18
    Likes Received:
    2
    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.

    Thanks.
     
  3. sdm

    sdm New Member

    Joined:
    Nov 6, 2017
    Messages:
    18
    Likes Received:
    2
    It's been nearly two weeks without any information being provided. Help?
     
  4. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,099
    Likes Received:
    10
    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.

    Kind regards
    Ankur
     
  5. sdm

    sdm New Member

    Joined:
    Nov 6, 2017
    Messages:
    18
    Likes Received:
    2
    When I put this in a cell,

    =ETFYield("SCHB")

    I get "NA" back, though

    =DividendYield("SCHB")

    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?

    Thanks,

    Scott
     

Share This Page