Historical prices - also dividend adjusted available?

Discussion in 'Pre-Sale Questions' started by JAKE123, Jul 22, 2017.

Historical prices - also dividend adjusted available?

  1. JAKE123

    JAKE123 New Member

    Joined:
    Jul 22, 2017
    Messages:
    5
    Likes Received:
    0
    Hi

    I want to be able to do backtest using price date including and excluding dividends, for example for ETFs.

    Yahoo Finance data has an Adjusted Close data feature which adjust the historical closing prices downwards to reflect dividend paid out.

    Can such adjusted close data also be retrieved with MARKETXLS?

    Thanks, Jake
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    894
    Likes Received:
    8
    Hi Jake,

    Yes you can.

    Kind regards
    Ankur
     
  3. JAKE123

    JAKE123 New Member

    Joined:
    Jul 22, 2017
    Messages:
    5
    Likes Received:
    0
    Thanks Ankur

    What Function name is used to retrieve this data?

    /Jake
     
  4. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    894
    Likes Received:
    8
  5. JAKE123

    JAKE123 New Member

    Joined:
    Jul 22, 2017
    Messages:
    5
    Likes Received:
    0
    Thanks Arthur

    I am not sure I understand. Both the links you post to, relate to functions which costs an additional subscription to Barchart.

    Please could you confirm which functionality within MarketXLS that provides historical data, both "clean" and dividend adjusted, going back the last 20 years etc

    Thanks, Jake
     
  6. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    894
    Likes Received:
    8
    Hi Jake,

    That is correct. I confirm below...

    "Please could you confirm which functionality within MarketXLS that provides historical data, both "clean" and dividend adjusted, going back the last 20 years "

    Thanks
     

Share This Page