📋
📋
📋
📋
MarketXLS Tutorials
Search…
Welcome to MarketXLS
Getting Started
Signing Up
Installing MarketXLS
Real-time data feed
Functions: How to Use
Function List
mxls_db_query function
How to use Forex functions in MarketXLS
Function: QM_List()
Core concepts
Watch List - Save Stock Tickers
Getting additional data
Connect Interactive Brokers With MarketXLS
Connect ThinkorSwim With MarketXLS
Growth Functions
Crypto Data
Portfolio Management
Using Templates
Perform Technical Analysis (Template)
Dividends
Custom Beta
Options Pricing
Options Pricing
Options Greeks
Utilities Tab in MarketXLS
Option Pricing with Quotemedia
Options Screener
Real Time Stock Option Pricing In Excel
Historical Pricing
Historical Fundamental Functions
Getting Historical Stock Prices in Excel
Create Charts using MarketXLS
Quick Stock and Currency Charts in Excel with MarketXLS
Custom Charts in Excel with MarketXLS
MarketXLS Charts – Candlestick Charts
FAQs
Contact Us
Powered By
GitBook
Growth Functions
These functions can also be found by clicking on the Search and Help panel and filtering them by "New". These functions value a stock on the basis of the growth of the company.
​
Functions
=BookValuePerShareOneYearGrowth("MSFT")
=CashFlowOneYearGrowth("MSFT")
=CashAndEquivalentOneYearGrowth("MSFT")
=DividendOneYearGrowth("MSFT")
=DividendPerShareFiveYearCAGR("msft")
=EBITDAOneYearGrowth("MSFT")
=EBITDAGrowthFiveYearCAGR("msft")
=EBITDAMarginFiveYearAverage("msft")
=EBITDAMarginOneYearGrowth("MSFT")
=EpsFourQuarterAverageGrowth("MSFT")
=EPSOneYearGrowth("MSFT")
=EpsThreeYearCAGR("msft")
=EpsFourYearCAGR("msft")
=EpsFiveYearCAGR("msft")
=FreeCashFlowOneYearGrowth("MSFT")
=FreeCashFlowPerShare("MSFT")
=GrossMarginFiveYearAverage("msft")
=GrossProfitMarginOneYearGrowth("msft")
=NetIncomeGrowthFiveYearCAGR("msft")
=NetProfitMarginOneYearGrowth("MSFT")
Core concepts - Previous
Connect ThinkorSwim With MarketXLS
Next - Core concepts
Crypto Data
Last modified
4mo ago
Copy link