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,109
    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
     

Share This Page