New MarketXLS release Version 4.0.0.0

Discussion in 'Announcements, Updates and New Releases' started by marketxls, Mar 29, 2016.

New MarketXLS release Version 4.0.0.0

  1. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    351
    Likes Received:
    0
    We are happy to release new version of MarketXLS which was published this Monday morning (March 28th 2016). If you are an existing user, you will see a prompt when you start Excel. If you do not see a message, go to Settings/Help in the menu and click on check for updates. Follow the instructions and your marketxls version will be updated.

    Below are the Key Updates:
    New MarketXLS S&P 500 returns Stock Screener
    Browse through the whole index by returns of all stocks. Following return KPIs are available"€¦

    7 Day Returns
    15 Day Returns
    1 Month Returns
    3 Month Returns
    6 Month Returns
    1 Year Returns
    3 Year Returns

    Export all the underlying data in the screener chart to Excel with a click. And create your own screener, charts etc in Excel. Following image shows it working

    [​IMG]

    [​IMG]

    Quick Charts


    We have also added the following charts in Quick Charts section. Simply select a group of stocks and click on these to get the charts like shown below
    [​IMG]

    [​IMG]

    36 New functions
    We have added 36 new functions in this release.

    The key the new functions are"€¦.
    =DividendBetweenTwoDates("MSFT", TODAY()-365,TODAY())
    This will get sum of last 1 year dividends of a stock.

    Return Functions"€¦.
    StockReturnCustomDates(Symbol, StartDate, EndDate)
    StockReturnFifteenDays(Symbol)
    StockReturnFiveYears(Symbol)
    etc

    And full list of new functions is below

    Option_Last_Price(Symbol)
    LastPriceRealTime(Symbol)
    DividendBetweenTwoDates(Symbol, StartDate, EndDate )
    StockReturnSevenDays(Symbol)
    StockReturnFifteenDays(Symbol)
    StockReturnThirtyDays(Symbol)
    StockReturnThreeMonths(Symbol)
    StockReturnSixMonths(Symbol)
    StockReturnNineMonths(Symbol)
    StockReturnOneYear(Symbol)
    StockReturnTwoYears(Symbol)
    StockReturnThreeYears(Symbol)
    StockReturnFiveYears(Symbol)
    StockReturnCustomDates(Symbol, StartDate, EndDate )
    EnterpriseValue(Symbol)
    SharesShort(Symbol)
    SharePercentHeldByInsiders(Symbol)
    ReturnOnAssets(Symbol)
    SharePercentHeldByInstitutions(Symbol)
    ProfitMargin(Symbol)
    OperatingMargin(Symbol)
    ForwardAnnualDividendRate(Symbol)
    FiveYearAverageDividendYield(Symbol)
    DividendPayoutRatio(Symbol)
    DividendDate(Symbol)
    ExDividendDate(Symbol)
    ReturnOnEquity(Symbol)
    QuarterlyRevenueGrowthYOY(Symbol)
    QuarterlyEarningsGrowthYOY(Symbol)
    TotalCash(Symbol)
    TotalDebt(Symbol)
    TotalDebtToEquity(Symbol)
    BookValuePerShare(Symbol)
    OperatingCashFlow(Symbol)
    LeveredFreeCashFlow(Symbol)
    Beta(Symbol)
    GrossProfit(Symbol)
    Revenue(Symbol)

    Basic Housekeeping

    Apart from basic housekeeping we have also optimized many functions for speed and have fixed some bugs in Portfolio Management Module.

    To your investing success
    Ankur for Marketxls.com Support

    A  1 min video is here
    showing update process
     

Share This Page