Below is the list of all MarketXLS functions. Search for a metric, for example, Market Cap, and see the function with examples. Click on an example to copy a function to the clipboard and then paste it into Excel. The examples are shown with arguments passed as strings, but all MarketXLS functions support references. So, for example, =MarketCap("MSFT") will return the Market Cap of Microsoft , and it can also be written as =MarketCap(A1), where cell A1 contains the ticker symbol MSFT.