fundamental-balance-sheet

name

fundamental-balance-sheet

description

Use to look up the exact path or spelling of any Morningstar BALANCE SHEET field on a QuantConnect/LEAN `Fundamental` object — everything under `f.FinancialStatements.BalanceSheet.*` — assets, liabilities, stockholders' equity, debt, working-capital components, and share counts. Triggers — "path to total assets / total equity / long-term debt / cash and equivalents / inventory / shares issued". For other field families start at the equity-fundamental-data skill.

Balance-sheet fields — Fundamental data points

Full path from the snapshot f with the field's description — copy the path rather than guessing from English names; a wrong path wastes a backtest run. The path-reading rules and the index of all field-family skills are in the equity-fundamental-data skill.

Reading the paths

• A path ending in .[value 1M 2M 3M 6M 9M 12M] is a MultiPeriodField — append one period accessor to read the number. .Value is the most recent reported period; the 1M–12M tokens are .OneMonth .TwoMonths .ThreeMonths .SixMonths .NineMonths .TwelveMonths respectively (trailing-twelve-month at 12M). e.g. f.FinancialStatements.IncomeStatement.NetIncome.TwelveMonths. Forgetting the accessor is silent — the wrapper compares as truthy and numeric inequalities give nonsense.
• A path with no bracket is read directly. e.g. f.ValuationRatios.PERatio.
• The integer *_code fields under asset_classification compare against the named constants in the fundamental-classification skill.

Data points

Data point	Description
f.FinancialStatements.BalanceSheet.BSFileDate.[Value 1M 2M 3M 6M 9M 12M]	Filing date of the Balance Sheet
f.FinancialStatements.BalanceSheet.AccountsPayable.[Value 1M 2M 3M 6M 9M 12M]	Any money that a company owes its suppliers for goods and services purchased on credit and is expected to pay within the next year or operating cycle.
f.FinancialStatements.BalanceSheet.AccountsReceivable.[Value 1M 2M 3M 6M 9M 12M]	Accounts owed to a company by customers within a year as a result of exchanging goods or services on credit.
f.FinancialStatements.BalanceSheet.CurrentAccruedExpenses.[Value 1M 2M 3M 6M 9M 12M]	An expense recognized before it is paid for. Includes compensation, interest, pensions and all other miscellaneous accruals reported by the company. Expenses incurred during the accounting period, but not required to be paid until a later date.
f.FinancialStatements.BalanceSheet.NonCurrentAccruedExpenses.[Value 1M 2M 3M 6M 9M 12M]	An expense that has occurred but the transaction has not been entered in the accounting records. Accordingly, an adjusting entry is made to debit the appropriate expense account and to credit a liability account such as accrued expenses payable or accounts payable.
f.FinancialStatements.BalanceSheet.AccruedInvestmentIncome.[Value 1M 2M 3M 6M 9M 12M]	Interest, dividends, rents, ancillary and other revenues earned but not yet received by the entity on its investments.
f.FinancialStatements.BalanceSheet.AccumulatedDepreciation.[Value 1M 2M 3M 6M 9M 12M]	The cumulative amount of wear and tear or obsolescence charged against the fixed assets of a company.
f.FinancialStatements.BalanceSheet.GainsLossesNotAffectingRetainedEarnings.[Value 1M 2M 3M 6M 9M 12M]	The aggregate amount of gains or losses that are not part of retained earnings. It is also called other comprehensive income.
f.FinancialStatements.BalanceSheet.AdditionalPaidInCapital.[Value 1M 2M 3M 6M 9M 12M]	Excess of issue price over par or stated value of the entity's capital stock and amounts received from other transactions involving the entity's stock or stockholders. Includes adjustments to additional paid in capital. There are two major categories of additional paid in capital: 1) Paid in capital in excess of par/stated value, which is the difference between the actual issue price of the shares and the shares' par/stated value. 2) Paid in capital from other transactions which includes treasury stock, retirement of stock, stock dividends recorded at market, lapse of stock purchase warrants, conversion of convertible bonds in excess of the par value of the stock, and any other additional capital from the company's own stock transactions.