Chart error: againObject error

Discussion in 'Troubleshooting' started by objredline, May 18, 2018.

Chart error: againObject error

Tags:
  1. objredline

    objredline New Member

    Joined:
    May 18, 2018
    Messages:
    7
    Likes Received:
    0
    I entered my own data in OHLC columns, and successfully calculated the MACD. Then, when trying to create a line plot of the MACD, the blue/gray window with scrolling progress bar at the bottom will show up, at the same time a window in Excel opens that says: "Something when wrong, please try againObject reference not set to an instance of an object".

    This error occurs for bar and line charts.
    Thanks in advance
     
  2. marketxls

    marketxls Administrator
    Staff Member

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

    Sure, please can you check the date format in the date column? Would it be possible for you post me the date format you have in the date column?

    Many thanks
    Ankur
     
  3. objredline

    objredline New Member

    Joined:
    May 18, 2018
    Messages:
    7
    Likes Received:
    0
    Hi, I tried this date format, and the one with AM/PM:

    Timestamp
    5/9/18 0:00
    5/9/18 0:30
    5/9/18 1:00

    Same error
     
  4. objredline

    objredline New Member

    Joined:
    May 18, 2018
    Messages:
    7
    Likes Received:
    0
    Hi, can you see my date format above? Thanks
     
  5. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,075
    Likes Received:
    10
    Ok, I checked it. Please can you structure the data as sown below and try again. This is format in which MarketXLS should return the data.

    The date format is like shown below...

    upload_2018-5-30_13-14-0.png

    Date MSFT-Open MSFT-High MSFT-Low MSFT-Close MSFT-Volume MSFT-Adj Close
    5/29/2018 97.83999634 98.87999725 97.23000336 98.01000214 28338000 98.01000214
    5/25/2018 98.30000305 98.98000336 97.86000061 98.36000061 18363900 98.36000061
    5/24/2018 98.73000336 98.94000244 96.80999756 98.30999756 26649300 98.30999756
    5/23/2018 96.70999908 98.73000336 96.31999969 98.66000366 21114800 98.66000366
    5/22/2018 97.68000031 98.16999817 97.19999695 97.5 15441200 97.5
    5/21/2018 97 98.01000214 96.80000305 97.59999847 19422500 97.59999847
    5/18/2018 96.01000214 96.93000031 96.01000214 96.36000061 17865800 96.36000061
    5/17/2018 96.76000214 97.54000092 95.83000183 96.18000031 17246700 96.18000031
    5/16/2018 97.36000061 97.40000153 96.62000275 97.15000153 17384700 97.15000153
    5/15/2018 97.23999786 97.84999847 96.33999634 97.31999969 24594000 96.90000153
    5/14/2018 97.91999817 98.69000244 97.30999756 98.02999878 19454100 97.60693359
    5/11/2018 97.80000305 97.87000275 97.04000092 97.69999695 16778300 97.27835846
    5/10/2018 97.45999908 97.94999695 97.05000305 97.91000366 22388100 97.48745728
     
  6. objredline

    objredline New Member

    Joined:
    May 18, 2018
    Messages:
    7
    Likes Received:
    0
    I get the same error with that format. However, I have 30min data so I need to preserve the time. Here are my columns:

    Timestamp Open High Low Close Volume (BTC) Volume (Currency) Weighted Price Percentage Price Oscillator
    5/9/2018 9,181.52 9,195.81 9,119.53 9,141.05 203.56 1,863,352.40 9,154.02 -0.17671
    5/9/2018 9,149.41 9,199.98 9,119.53 9,122.62 65.65 601,039.07 9,155.87 -0.24209
    5/9/2018 9,130.35 9,169.54 9,122.63 9,154.50 53.07 485,666.10 9,151.41 -0.29114
    5/9/2018 9,148.41 9,166.64 9,146.01 9,159.81 62.76 574,582.48 9,155.56 -0.41101
     
  7. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,075
    Likes Received:
    10
    Hi, one quick thing please. Can you try changing the text 'Timestamp' in the column header to 'Date' please? And try again?

    Thanks
     
  8. objredline

    objredline New Member

    Joined:
    May 18, 2018
    Messages:
    7
    Likes Received:
    0
    Changed column title to "Date", same error.
     
  9. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,075
    Likes Received:
    10
    I have reported this and we are working to fix this in coming release. I will send you a version this week.

    Thank You for your patience.

    Kind regards
    Ankur for MarketXLS
     
  10. objredline

    objredline New Member

    Joined:
    May 18, 2018
    Messages:
    7
    Likes Received:
    0
    Thanks Ankur. Is it possible to extend my license while this error cannot be fixed? I purchased the license to use this feature and have not been able to explore the product while this is broken. Thanks
     
  11. marketxls

    marketxls Administrator
    Staff Member

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

    Yes, I have been working on it to try and debug this issue. Yes I can do the extension.
    Will email shortly.

    Kind regards
    Ankur
     
  12. objredline

    objredline New Member

    Joined:
    May 18, 2018
    Messages:
    7
    Likes Received:
    0
    Awesome, thank you!
     

Share This Page