Function List

MarketXLS functions are custom functions that work exactly like any other Excel function, seamlessly integrating with Excel's built-in intelligence system.

How MarketXLS Functions Work

Start typing the function and Excel will suggest similar functions for you to use. Along with built-in Excel functions, the new MarketXLS functions will also appear. For example, for Mutual Funds type "=MF", for Options type "=Options". For Stocks, there is no prefix - just start typing what you need.

Accessing the Function List

You can download the complete functions list from the Settings/Help bar in the MarketXLS ribbon.

Another way to see the functions is to click on "Search & Help" on the left side of the MarketXLS ribbon.

Using MarketXLS Functions

Now you have everything and can start using the functions to access your stock data or create your own portfolio. MarketXLS is designed to fit the needs of multiple users, from individual investors to professional analysts.

Copy Feature

Each function includes a convenient copy feature that lets you quickly copy the formula syntax and paste it into your Excel spreadsheet. This makes it easy to get started with any function.