MarketXLS functions are custom functions that work exactly like any other Excel function. 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 starts typing Options. For the Stocks category, there is no prefix. Just start typing what you need.
You can download the functions list from the Settings/Help bar.
Another way to see the functions is to click on the "Search & Help" on the left side of the bar.
Now you have everything and can start using the functions to access your stocks data or create your own portfolio. MarketXLS is designed in such a way that it fits the needs of multiple users.
Download the Function List below: