Holdings Gain
Returns the absolute dollar gain or loss for holdings.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Symbol | string | Yes | Stock ticker symbol |
Syntax
=HoldingsGain(Symbol)Returns
number
Holdings gain in dollars
Examples
=HoldingsGain("AAPL")When to Use
- Portfolio tracking
- P&L monitoring
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Percentage gain | HoldingsGainPercent() |
Common Issues & FAQ
How is gain calculated?
Current value minus cost basis.
Related Formulas
More MarketXLS Portfolio Analytics formulas you can use in the same worksheet:
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?