Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Welcome to MarketXLS
GETTING STARTED
Signing UpInstalling MarketXLSReal-time data feed
FUNCTIONS: HOW TO USE
Function Listmxls_db_query functionHow to use Forex functions in MarketXLSFunction: QM_List()
CORE CONCEPTS
Watch List - Save Stock TickersGetting additional dataConnect Interactive Brokers With MarketXLSConnect ThinkorSwim With MarketXLSGrowth FunctionsCrypto Data
Portfolio ManagementUsing TemplatesPerform Technical Analysis (Template)DividendsCustom Beta
OPTIONS PRICING
Options PricingOptions GreeksUtilities Tab in MarketXLSOption Pricing with QuotemediaOptions ScreenerReal Time Stock Option Pricing In Excel
HISTORICAL PRICING
Historical Fundamental FunctionsGetting Historical Stock Prices in Excel
CREATE CHARTS USING MARKETXLS
Quick Stock and Currency Charts in Excel with MarketXLSCustom Charts in Excel with MarketXLSMarketXLS Charts – Candlestick Charts
FAQsContact Us

Function List

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.


MarketXLS functions in excel

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.


MarketXLS functions in excel - copy feature

Download the Function List below:


MarketXLS Functions List.xlsx51KB
Binary