Material Corporate Events (Historical)
Retrieves significant corporate events.
Syntax
=hf_Material_Corporate_Events(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
Stock ticker symbol
yearstringRequired
Fiscal year or period code
quarterstring
Quarter (1-4)
TTMstring
TTM for trailing twelve months
Returns
string
Material corporate events
Examples
=hf_Material_Corporate_Events("AAPL", 2023, 4)When to Use
- Event-driven analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Financial data | Financial statement functions |
Common Issues & FAQ
What events are included?
M&A, restructuring, and other material announcements.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Minority Interest (Historical)
- NCFO Growth (Historical)
- Net Cash Flow Business Acquisitions And Disposals (Historical)
- Net Cash Flow Change In Cash And Cash Equivalents (Historical)
- Net Cash Flow From Financing (Historical)
- Net Cash Flow From Investing (Historical)
- Net Cash Flow From Operations (Historical)
- Net Cash Flow Investment Acquisitions And Disposals (Historical)
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?