Auditor's Report (Historical)
Returns the auditor's opinion/report type for a company's audited financial statements. This indicates whether the auditor issued an unqualified (clean) opinion or had qualifications.
Return Values
| Value | Meaning |
|---|---|
| UQ | Unqualified opinion (clean) |
| Q | Qualified opinion |
| AD | Adverse opinion |
| D | Disclaimer |
Notes
- Part of standard financial statement audit process
- Unqualified (UQ) is the most common and preferred outcome
- Qualified or adverse opinions may indicate financial reporting concerns
Syntax
=hf_Auditors_Report(Symbol, Year, [Quarter], [TTM])Parameters
Stock ticker symbol
Fiscal year
Quarter (1-4)
Use TTM for trailing twelve months
Examples
=hf_Auditors_Report("AAPL", 2023)=hf_Auditors_Report("MSFT", 2023, 2)=hf_Auditors_Report("GOOGL", "lq")=hf_Auditors_Report("TSLA", "ly")=hf_Auditors_Report(A1, B1, C1)When to Use
Audit quality assessment, financial statement reliability analysis, due diligence
When NOT to Use
| Need auditor name | hf_Auditors_Name() |
Common Issues & FAQ
What year formats are accepted?
Use numeric years (2023) or period codes: lq (last quarter), ly (last year), lt (last twelve months), lq-1 (quarter before last).
Why am I getting "NA"?
The company may not report this metric, or data may not be available for the requested period.
What's the difference between quarterly and TTM?
Quarter shows one quarter's data. TTM (trailing twelve months) sums the last 4 quarters.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Average Assets (Historical)
- Average Equity (Historical)
- Basic EPS Accounting Change (Historical)
- Basic EPS Continuing Operations (Historical)
- Basic EPS Discontinued Operations (Historical)
- Basic EPS Extraordinary Items (Historical)
- Basic EPS Other Gains/Losses (Historical)
- Basic EPS Preferred Securities (Historical)
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today