Clarification request: Last, Last1, Last2; Open, Open1, Open2

Discussion in 'General Questions' started by Lloyd, Nov 6, 2017.

Clarification request: Last, Last1, Last2; Open, Open1, Open2

  1. Lloyd

    Lloyd Member

    Joined:
    Nov 6, 2017
    Messages:
    46
    Likes Received:
    4
    New PRO user here (installed MarketXLS 11/5/2017)
    Last(Symbol) and Open(Symbol) functions have three variants.
    No documentation.

    What is the difference between LAST, LAST1 and LAST2?
    Same for OPEN.

    P.S. Documentation on the MarketXLS functions (e.g. calculation basis) and proper function error indication is sorely needed.
    For function errors, on hf Functions using the quarter, TTM options, if the data does not exist or the server is down.
    Possibly use the same error reporting as in cars (a published lookup code).
    Excel based error statements provide very limited clarity on resolving a errors.

    I have had to query my other sources of company financial data to verify if financial data is available and the data accuracy.
    The overhead in using MarketXLS is piling up.
    Hope it gets better.

    Thank you.
     
  2. AndyTrades

    AndyTrades New Member

    Joined:
    Aug 11, 2017
    Messages:
    21
    Likes Received:
    3
    YES, please explain:
    Last(Symbol)
    Last1(Symbol)
    Last2(Symbol)

    Open(Symbol)
    Open1(Symbol)
    Open2(Symbol)

    What is the the Difference?? why no explanation in the MarketXLS functions Spreadsheet that describes these duplicates. Please ADD a column to your spreadsheet labeled "Description" for EACH function on that sheet that is not self-explanatory. Don't leave us guessing. Most are self-explanatory, but others are not (like duplicates 1, 2, 3, etc)
     
  3. marketxls

    marketxls Administrator
    Staff Member

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

    The =Last is the main one to be used all time. The rest all are legacy, will hide them in new release. Sorry for the confusion.

    Kind regards
    Ankur
     
  4. AndyTrades

    AndyTrades New Member

    Joined:
    Aug 11, 2017
    Messages:
    21
    Likes Received:
    3
    Ok, I understand now, I'll use the first one, thanks for the quick response :)
     

Share This Page