Returns the date of the company's most recent stock split. Stock splits occur when a company divides its existing shares into multiple shares to boost liquidity. For example, in a 4-for-1 split, each share becomes 4 shares at 1/4 the price.
The date returned is when the split took effect (ex-date), not when it was announced. Returns the date in YYYY-MM-DD format.
Note: This function only returns the date, not the split ratio. For historical price adjustments accounting for splits, use Adjusted_Close_Historical() or hf_Share_Factor().
When to Use
- Checking when a company last split its stock
- Verifying split dates for corporate action analysis
- Building stock split calendars or alerts
- Historical research on company capital actions
When NOT to Use
- Need split ratio (not available from this function)
- Need full split history (only returns most recent)
- Need to adjust historical prices for splits (use Adjusted_Close_Historical)
- Need dividend dates (use DividendDate, Ex_DividendDate, DividendPayDate)
Common Issues & FAQ
- Returns empty or N/A for companies that have never split (many newer companies)
- Only shows the most recent split, not the full split history
- Does not include the split ratio (e.g., 4-for-1) - only the date
- For historical analysis requiring split adjustments, use Adjusted_Close_Historical() instead
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?