How to have Historical Values in the same named sheet each time.

Discussion in 'Historical Data' started by Jack_S, Jul 29, 2017.

How to have Historical Values in the same named sheet each time.

  1. Jack_S

    Jack_S New Member

    Joined:
    Jul 29, 2017
    Messages:
    3
    Likes Received:
    0
    On July 28, 2017, historical data was placed next to the Security Symbol. :- )
    As of today it is placed in a new sheet, with a different sheet name each time. :- (
    This makes it very hard to create efficient links to the data and almost impossible to automate the data analysis.

    How do I have the historical data always show up in a sheet with a locked name, over-writing the prior data,
    or how do I go back to the old way, where it was placed in the sheet next to the symbol?

    The sheet could be the symbol name if you want. But it needs to always be the same named sheet, same location, for the same symbol.
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,157
    Likes Received:
    11
    Hi Jack,

    Go to MarketXLS Menu, click on settings/help, then open settings form.

    upload_2017-7-29_19-49-9.png
    The select here and save your settings.

    upload_2017-7-29_19-49-43.png
     

Share This Page