Using MarketXLS functions

Discussion in 'Formulae' started by marketxls, Apr 10, 2017.

Using MarketXLS functions

  1. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    MarketXLS functions are custom functions which work exactly like any other Excel functions. Start type the function and Excel will suggest similar sounding functions for you to use. Along with inbuilt Excel functions the new MarketXLS functions will also show up. For example, if you want to use Mutual Funds related functions start typing “=” and MF, for Options start typing Options. For Stocks category no prefix is there. Just start typing what you need.

    012816_2023_UsingMarket1[1].png

    012816_2023_UsingMarket2[1].png

    To check which functions are available go to Excel’s function browse and you can browse through all the available functions.

    Now, select the category you need and you should see all the functions.

    Apart from a very few like most of MarketXLS functions take “Symbol” as an argument. The symbol does not necessarily need to be a stock, it can be an ETF, a stock option contract of an index. As long as the symbol is recognized the result will appear in the cell.

    Currency Functions have more arguments and parameters to be supplied which are prompted automatically by Excel. The following are some usage examples…

    012816_2023_UsingMarket3[1].png

    012816_2023_UsingMarket4[1].png
     
    #1 marketxls, Apr 10, 2017
    Last edited: Apr 10, 2017

Share This Page