Change Month To Date In Percent
Returns the percentage change in stock price from the first trading day of the current month.
Formula
% Change = (Current Price - Start of Month Price) / Start of Month Price × 100
Return Value
Percentage value (e.g., 5.2 means up 5.2%).
Examples
=ChangePercentMTD("AAPL")=ChangePercentMTD("MSFT")When to Use
MTD performance comparison, percentage returns analysis
When NOT to Use
| Need dollar change | ChangeMTD() |
| Need YTD percent | ChangePercentYTD() |
Common Issues & FAQ
Q: Why am I getting "NA"? A: Check that the symbol is valid and has sufficient trading history for the requested period.
Q: Are returns price-only or total return? A: These are typically price returns. Dividend-adjusted returns may differ.
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?