StockReturn functions, again

Discussion in 'Formulae' started by Nemanja, Jun 19, 2018.

StockReturn functions, again

  1. Nemanja

    Nemanja New Member

    Joined:
    Apr 18, 2018
    Messages:
    6
    Likes Received:
    2
    Ankur, can you post a precise explanation how dates are selected for the following Stock return functions:
    StockReturnFifteenDays(Symbol)
    StockReturnFiveYears(Symbol)
    StockReturnNineMonths(Symbol)
    StockReturnOneYear(Symbol)
    StockReturnSevenDays(Symbol)
    StockReturnSixMonths(Symbol)
    StockReturnThirtyDays(Symbol)
    StockReturnThreeMonths(Symbol)
    StockReturnThreeYears(Symbol)
    StockReturnTwoYears(Symbol)
    For example, when I calculate stock return for the last 3 months manually, I get different results than when calculated with your formula. Considering that the formula itself has been corrected a few days ago, it must be about selection of dates. So, how does MarketXLS define dates for these functions?
     
  2. Nemanja

    Nemanja New Member

    Joined:
    Apr 18, 2018
    Messages:
    6
    Likes Received:
    2
    I figured it out, sorry.
     
    marketxls likes this.

Share This Page