Problems with historical Data overal

Discussion in 'Troubleshooting' started by Michael -, Apr 11, 2020.

Problems with historical Data overal

  1. Michael -

    Michael - New Member

    Joined:
    Jan 17, 2020
    Messages:
    2
    Likes Received:
    0
    Hey there,

    my purpose to use marketxls is to get historical data for the past lets say 20 years of all stocks available.
    Sadly there seems to be some issues with historical data and/or the functions that make it impossible for me to "do my math" on such data.

    Some examples:

    - close_historical_x_months_ago ... no data available before 02/2014. Some "NA" data here and there in betwee. 1 month ago is "NA" for any stock.
    - "Custom Dates" in menu bar. Lets say I want (montly, adjusted close) data from march 2015 to march 2020. I pick some dates but get sometimes data beginning from april, sometimes may,...always have to check if the start and also sometimes the end dates are correct.

    Overall I love the idea of marketxls but not getting reliable historical data as promised it's useless for me. :/

    Hope there will be some fixes soon.

    Greetings,
    Michael
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Hi Michael,

    We are working on this.

    Kind Regards
    Ankur for MarketXLS
     
  3. Michael -

    Michael - New Member

    Joined:
    Jan 17, 2020
    Messages:
    2
    Likes Received:
    0
    Hi Ankur,

    any news regarding this topic?

    Greetings,
    Michael
     
  4. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Hi Michael,

    The custom dates on the menu should return all the history. We will open up close_historical function to be able to go back 10 years today.

    Kind Regards
    Ankur for MarketXLS
     

Share This Page