Share Based Compensation (Historical)

Stock options and RSU expenses.

Syntax

=hf_Share_Based_Compensation(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Parameters

symbolstringRequired
yearstringRequired
quarterstring
TTMstring

Returns

number

Stock-based compensation in USD

Examples

=hf_Share_Based_Compensation("META", 2023, 4)

When to Use

  • Dilution analysis
  • True cash flow calculation

When NOT to Use

Scenario Use Instead
Operating expenses hf_Operating_Expenses()

Common Issues & FAQ

Non-cash expense added back in cash flow.

Market data in your Excel sheets

1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.

See plans
MarketXLS Excel Add-in Tutorial - How to Use Share Based Compensation (Historical) and Other Financial Formulas
▶
How does MarketXLS work?