Market Table Close vs Adj Close on Fixed Inc Funds

Discussion in 'Announcements, Updates and New Releases' started by Grady Parker, Nov 7, 2018.

Market Table Close vs Adj Close on Fixed Inc Funds

  1. Grady Parker

    Grady Parker New Member

    Joined:
    Apr 26, 2017
    Messages:
    28
    Likes Received:
    2
    I'm having trouble figuring out the difference between the Close and Adj Close on MarketXLS tables for fixed income funds such as FNMIX. I thought the difference would be the distributions (which occur monthly in most fixed income funds) . According to Fidelity FNMIX has had the following distributions since 7/1/18.
    Date Per Share Amount Reinvestment Price
    10/31/2018 $0.05972082500 $14.43
    9/30/2018 $0.05642725800 $14.88
    8/31/2018 $0.05971880500 $14.65
    7/31/2018 $0.06082037100 $15.21

    However the difference between the Close and Adj Close ( Close - Adj Close) is quite different on the day after the dividend.
    Date Close - Adj Close
    11/2/2018 $0.00000000000
    10/1/2018 $0.00000000000
    9/4/2018 $0.00000000000
    8/1/2018 $0.06183815002

    It looks like the data is missing the last three dividends, and incorrectly computed the dividend on 7/31. Can someone tell me what I am missing?
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Hi Grady,

    It will be best to use qm_gethistory("FNMIX") for Mutual funds. In the coming update we will make the form work with this formula by default, so there is no confusion.

    Kind Regards
    Ankur for MarketXLS
     
  3. Grady Parker

    Grady Parker New Member

    Joined:
    Apr 26, 2017
    Messages:
    28
    Likes Received:
    2
    qm_gethistory("FNMIX") returns just #NAME? when I updated to version 9.0.0.3
     
  4. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Hi Grady,

    #Name would generally mean the functions are not installed properly. You must have got the latest version, please can you check and install that one? 9.0.5.4



    Let me know if you face any issues.

    Kind Regards
    Ankur for MarketXLS
     

Share This Page