Percentage Difference
Core Financial Applications
- Budget vs. Actual Variance — The percentage difference formula is the correct tool when neither value is a “baseline.” If Q3 revenue was $4.2M and the budget was $4.0M, the percentage difference quantifies the variance symmetrically.
- ETF Tracking Error — Tracking error measures how far a fund’s returns deviate from its benchmark index. A low percentage difference signals tight replication; a high one signals significant active drift.
- Bid-Ask Spread Analysis — The spread between a security’s bid and ask price expressed as a percentage difference is a direct proxy for liquidity and transaction cost.
- Cross-Asset Comparison — When comparing two assets with no clear “reference” value (e.g., the price of two similar bonds), percentage difference is more appropriate than percentage change.
Percentage Difference vs. Percentage Change
These two formulas are frequently confused, but they answer different questions:
| Formula | Use Case | Directional? |
|---|---|---|
Percentage Difference |V₁ − V₂| / ((V₁ + V₂) / 2) | Comparing two equivalent values with no hierarchy | No — always absolute |
Percentage Change (V₂ − V₁) / |V₁| | Measuring movement from a known baseline | Yes — positive or negative |
Use percentage difference when both values are peers with no ordering. Use Percent Change when you have a clear “before” and “after.”