Type X17Financial
Type category Entity
Description Data filed with the Securities and Exchange Commission (SEC) for Broker Dealers: the broker dealer firms are require to file X-17 documents with the SEC with an annual update consist of balance sheet and income statement information
Fields
Name Type Filters Description
key id string(36)* = Financial Period Key. A financial period is any period of time over which an institution's financial information is measured. Different measures of financial information may be available for the same institution and time period as the result of restatements.
accountingPrincipleId long(-32768,32767)* Lookup key used to identify accounting principles used to create financial statements
accountsPayableAccruedExp long(-2147483648,2147483647) Total accounts payable and accrued expenses. Magnitude: ($000)
accountsReceivable long(-9223372036854775807,9223372036854775806) Amounts owed to the company including amounts due from customers and affiliated entities. Magnitude: ($000)
accruedCompensation long(-2147483648,2147483647) Compensation accrued and payable for services already rendered. Magnitude: ($000)
annualization decimal{22,8}* Number by which flow financial items need to be multiplied to get an annualized figure
asReportedRevenue long(-2147483648,2147483647) Revenue as reported by the company. Magnitude: ($000)
asReportedRevenueGrowth decimal Growth in revenue reported by the company. Magnitude: (%)
assetGrowth decimal Growth in total assets. Magnitude: (%)
assetMgmtFeesReceivable long(-2147483648,2147483647) Fees receivable based on the value of assets being managed. Magnitude: ($000)
assetsManagedforIndividuals long(-9223372036854775807,9223372036854775806) Assets managed for individuals. Magnitude: ($000)
assetsManagedforInstitutions long(-9223372036854775807,9223372036854775806) Assets managed for institutional investors. Magnitude: ($000)
assetsManagedforTaxableOrgs long(-2147483648,2147483647) Discretionary assets under management for which income is subject to taxation. Magnitude: ($000)
assetsManagedforTaxexemptOr long(-2147483648,2147483647) Discretionary assets under management for which income is not subject to taxation. Magnitude: ($000)
assetsUnderAdministration long(-9223372036854775807,9223372036854775806) Assets in accounts over which the firm has administrative responsibilities. Includes trust administration, custody, fiduciary, and escrow services. Magnitude: ($000)
assetsUnderManagement long(-9223372036854775807,9223372036854775806) All assets directly managed by the firm, over which the firm has discretionary investment authority, not for its own accounts. May include mutual funds, money market funds, institutional accounts. Magnitude: ($000)
assetsUnderManagementOther long(-9223372036854775807,9223372036854775806) Component of assets under management that represents all investments not included above. Magnitude: ($000)
aumEquity long(-9223372036854775807,9223372036854775806) The portion of assets under management invested in equity-type securities. Magnitude: ($000)
aumFixedIncome long(-9223372036854775807,9223372036854775806) The portion of assets under management invested in fixed-income securities. Magnitude: ($000)
avgEmployees decimal Average full-time equivalent employees for the period, as reported by the company, if available, otherwise calculated. Magnitude: (actual)
link batch Batch* = The Batch for which this BatchRun is an instance.
link batchRun BatchRun* = The BatchRun in which the Price is calculated.
brokers long(-2147483648,2147483647) Retail and institutional brokers either employed directly by or acting as independent contractors for the company. Magnitude: (actual)
brokersEmployed long(-2147483648,2147483647) Retail and institutional brokers directly employed by the company. Magnitude: (actual)
capitalEquityNoncurrentSu long(-9223372036854775807,9223372036854775806) Shareholders' equity, both common and preferred, and subordinated debt. Magnitude: ($000)
capitalGrowth decimal Growth in capital consisting of equity and subordinated debt. Magnitude: (%)
cashCashEquivalents long(-9223372036854775807,9223372036854775806) Cash and cash equivalents such as money orders, coins, and checks. For banks, this includes central bank balances. Magnitude: ($000)
cashSegregatedunderRegulation long(-9223372036854775807,9223372036854775806) Mandatory cash deposits required by central banks or cash restricted for redistribution by regulatory bodies. Magnitude: ($000)
cashandCashBalances long(-9223372036854775807,9223372036854775806) Money deposited in a bank and items that a bank will accept for immediate deposit such as paper money, coins, checks, and money orders. Includes money market funds and balances with other banks. Magnitude: ($000)
clearingDeposits long(-2147483648,2147483647) Deposits maintained for clearing transactions. Magnitude: ($000)
commercialPaperOutstanding long(-2147483648,2147483647) Short-term loans (secured or unsecured), usually issued at a discount with maturities not beyond 270 days, typically used to finance accounts receivable and inventories. Magnitude: ($000)
companyId long(-2147483648,2147483647) S&P company identifier.
currencyISOCode string(3)* Alphabetic code used to identify currencies pursuant to ISO-4217
dataSourcePeriod string(6)* A unique key used to identify a financial period within the DataSource. Concatenation of the Fiscal Year and Fiscal Period values, or for derived periods.
dateBegun date* Date on which fiscal period began
dateEnded date* Date on which the fiscal period ended
dateEndedStandard date* Ending date of the fiscal period, standardized to be the last day of the month in which the period ends. For example, if a fiscal period ends on June 29, this date will be June 30, so that there is a consistency among different companies.
discretionaryAccounts long(-2147483648,2147483647) The number of customer accounts the firm considers active and for which the institution has direct investment control, including both retail and institutional accounts. Magnitude: (actual)
dueFromBDsClearingOrg long(-2147483648,2147483647) Accounts receivable from brokers, dealers or clearing organizations. Magnitude: ($000)
dueFromCustomers long(-2147483648,2147483647) Amounts owed to the company in the normal course of trade, by customers for products or services provided on credit or by counterparties for pending trades of financial assets. Magnitude: ($000)
duetoBrokersDealersCleari long(-2147483648,2147483647) Accounts payable to brokers, dealers and clearing organizations. Includes contract value of securities which have not been received by settlement date and payables for clearing house services. Magnitude: ($000)
duetoCustomers long(-2147483648,2147483647) Accounts payable to customers'. Magnitude: ($000)
earningsReleaseDate date Date on which earnings were first released to the public via news release, securities filing, or other public disclosure
ebitdaGrowth decimal Growth rate of earnings before interest, taxes, depreciation and amortization. Magnitude: (%)
equityAttributabletoParent long(-9223372036854775807,9223372036854775806) Total equity attributable to the parent as defined under the indicated accounting principles. Includes par value, paid in capital, retained earnings, and other adjustments to equity. Includes all classes of common and non-redeemable preferred equity. Magnitude: ($000)
equityGrowth decimal Growth in total equity. Magnitude: (%)
excessNetCapital long(-2147483648,2147483647) Regulatory net capital over and above the required minimum net capital as defined by SEC's (Securities and Exchange Commission) Uniform Net Capital Rule (Rule 15c3). Magnitude: ($000)
fiscalQuarter string(1) Fiscal quarter to which the financial information is applicable
fiscalYear string(4) Fiscal year to which the financial information is applicable
fixedAssets long(-2147483648,2147483647) Property, plant and equipment acquired for long-term use in normal operations. Fixed assets are carried at cost, net of accumulated depreciation. Magnitude: ($000)
flowPeriodId long(-2147483648,2147483647) Financial Period Key. A financial period is any period of time over which an institution's financial information is measured. Different measures of financial information may be available for the same institution and time period as the result of restatements.
fteEmployees long(-2147483648,2147483647) The number of full-time-equivalent employees working for the company and its subsidiaries. In determining this value, it assumes two part-time employees equal one full-time employee, but excludes temporary employees. Magnitude: (actual)
incomeTaxesPayable long(-2147483648,2147483647) Federal, state, and other income taxes payable. Magnitude: ($000)
independentBrokersContracted long(-2147483648,2147483647) Retail and institutional brokers acting as independent contractors for the company. Magnitude: (actual)
institutionId long(-2147483648,2147483647) S&P's unique key to identify institutions. Institutions are corporations, partnerships, proprietorships, not-for-profit organizations, government agencies, and any other chartered organization.
investmentInPartnerships long(-2147483648,2147483647) Investments in joint ventures and partnerships that are not consolidated. Magnitude: ($000)
investments long(-2147483648,2147483647) Total investment in securities and unconsolidated subsidiaries, excluding segregated securities or securities pledged as collateral for broker-dealers and asset managers. Magnitude: ($000)
isCurrent boolean Indicates the financial period, current data is the most up-to-date financial information available
isLatestPeriod long(-32768,32767) Indicates the most recent data available within a time series. Rows with this value = 1 indicate that the row is the most recent. Some objects, but not all objects, require the calculation of varying numbers of data prior to the most recent. These rows are indicated with increasing values moving back through time. For example, the most recent row has a value of 1, the next most recent, or immediately prior, has a value of 2. The next prior record has a value of 3, and so on. The number of rows flagged with these values varies from object to object, but there will always be at least the one row marked with a 1.
isOriginal boolean Indicates that financial period, originally reported data is that which was reported to the public prior to any later restatement
mutualFundsunderManagement long(-9223372036854775807,9223372036854775806) Net asset value of mutual funds managed, including open-end funds and closed-end funds. Magnitude: ($000)
netCapitalRatio decimal{5,2} Aggregate indebtedness as a multiple of regulatory net capital, as reported by the company. Magnitude: (x)
netIncome long(-9223372036854775807,9223372036854775806) Net income after taxes, minority interest, and extraordinary and other after-tax items. Noncontrolling interest may be included, per relevant accounting standards (e.g., FAS 160 for U.S. GAAP which includes noncontrolling interests for fiscal years starting after December 15, 2008). Magnitude: ($000)
netIncomeGrowth decimal Growth in net income, after taxes, minority interest, and extraordinary and other after-tax items. Noncontrolling interest may be included, per relevant accounting standards (e.g., FAS 160 for U.S. GAAP which includes noncontrolling interest for fiscal years starting after December 15, 2008). Magnitude: (%)
noncontrollingInterests long(-2147483648,2147483647) Portion of net assets of a subsidiary attributable to equity interests that are not owned by the parent. Magnitude: ($000)
numberOfInstitutionalAccounts long(-2147483648,2147483647) Number of accounts over which the company has direct investment control, managed for institutional clients. Magnitude: (actual)
numberOfRetailAccounts long(-2147483648,2147483647) Number of accounts over which the company has direct investment control, managed for individual clients. Magnitude: (actual)
obligationtoReturnSecurities long(-2147483648,2147483647) Obligation to return securities in matched book term repurchase agreements for which the collateral provider does not have the explicit contractual right to substitute. Magnitude: ($000)
otherAccountsPayableAccru long(-2147483648,2147483647) Accounts payable not otherwise classified above. Magnitude: ($000)
otherAccountsReceivable long(-9223372036854775807,9223372036854775806) Other accounts receivable not otherwise classified above. Magnitude: ($000)
otherSeniorDebt long(-2147483648,2147483647) Any senior debt obligations not otherwise classified above. Magnitude: ($000)
periodTypeId long(0,255) Standardized code that classifies a financial records reporting period type. Allowable values include: ‘1’ – Yearly, ‘2’ – Quarterly, ‘3’ – Triannual, ‘4’ – Semiannual and ‘10’ – Half-Year.
redeemableFinancialInstruments long(-2147483648,2147483647) Mandatorily redeemable preferred and other redeemable financial instruments. For companies under US-GAAP, this does not include those securities classified in the mezzanine prior to the adoption of FAS 150 or those exempted from that statement. Magnitude: ($000)
regulatoryNetCapital long(-2147483648,2147483647) Regulatory Net Capital at all brokerage subsidiaries, as determined by the Securities and Exchange Commission (SEC). Generally equal to equity and subordinated debt, subject to certain adjustments. Magnitude: ($000)
regulatoryNetCapitalGrowth decimal Growth in regulatory net capital. Magnitude: (%)
reportedEBITDA long(-2147483648,2147483647) Reported earnings before interest, taxes, depreciation and amortization. Magnitude: ($000)
reportedEBITDAGrowth decimal Growth rate of reported earnings before interest, taxes, depreciation and amortization. Magnitude: (%)
repurchaseAgreements long(-9223372036854775807,9223372036854775806) Securities that are sold under a corresponding agreement that those securities will be repurchased by the original holder on a specified future date and at an agreed-upon price. Magnitude: ($000)
requiredMinimumNetCapital long(-2147483648,2147483647) Minimum regulatory net capital the company is required to maintain as defined by the Securities and Exchange Commission (SEC) uniform net capital rule (rule 15c3). Companies can calculate this using the basic method, which requires net capital to be the greater of a minimum amount mandated by the SEC or 6 2/3 percent of its aggregate indebtedness, or by using the alternative method, which requires net capital to be the greater of a minimum amount mandated by the SEC or 2 percent of its customer-related receivables. Magnitude: ($000)
restatementReason string(30) Generalized reason why a financial restatement might occur
securitiesBorrowed long(-2147483648,2147483647) Securities borrowed from another party, usually another broker-dealer, usually to cover a customer's short sale. Magnitude: ($000)
securitiesLoaned long(-2147483648,2147483647) Loan of securities by one broker to another, usually to cover a customer's short sale. The lending broker is secured by the cash proceeds of the sale. Magnitude: ($000)
securitiesPledgedAsCollateral long(-2147483648,2147483647) Securities pledged as collateral in matched-book term-resale agreements for which the collateral provider does not have the explicit contractual right to substitute. Magnitude: ($000)
securitiesPurchasedToResell long(-2147483648,2147483647) Securities that have been purchased under an agreement that those securities will be resold to the original holder on a specified date and at an agreed-upon price. Also known as Reverse Repurchase Agreements. Magnitude: ($000)
securitiesSoldnotyetPurchas long(-2147483648,2147483647) Securities sold short, to be purchased at a later date. Magnitude: ($000)
seniorDebt long(-9223372036854775807,9223372036854775806) Principal amounts outstanding on loans, notes payable, bonds, securities sold under repurchase agreements, mortgage-backed bonds, short term borrowings, mortgage notes and other notes payable, capitalized lease obligations, and other debt instruments not classified as subordinated debt. Magnitude: ($000)
stockPeriodId long(-2147483648,2147483647) Object key identifying end-of-period financial data
totalAssets long(-9223372036854775807,9223372036854775806) All assets owned by the company as of the date indicated, as carried on the balance sheet and defined under the indicated accounting principles. Magnitude: ($000)
totalDebt long(-9223372036854775807,9223372036854775806) The aggregate unpaid principal balance owed under financial obligations to other parties, required to be paid by a specified date or on demand. Magnitude: ($000)
totalDeposits long(-9223372036854775807,9223372036854775806) Total deposits from customers. For US banks, this is the total deposits from customers and banks. Magnitude: ($000)
totalEquity long(-9223372036854775807,9223372036854775806) Equity as defined under the indicated accounting principles. Includes par value, paid in capital, retained earnings, and other adjustments to equity. Minority interest may be included, per relevant accounting standards (e.g., FAS 160 for U.S. GAAP which includes minority interest for fiscal years starting after December 15, 2008). Magnitude: ($000)
totalEquityTotalAssets decimal Equity as a percent of assets. Magnitude: (%)
totalIntangibleAssets long(-2147483648,2147483647) Total goodwill and any other intangible assets. Under IFRS guidance, total intangibles may include value of business acquired (VOBA) where applicable. Magnitude: ($000)
totalLiabilities long(-9223372036854775807,9223372036854775806) Total liabilities as carried on the balance sheet and defined by the indicated accounting principles. Excludes minority interests and other mezzanine-level financings. Magnitude: ($000)
totalMezzanineLevelItems long(-2147483648,2147483647) Minority interest, redeemable equity, and all other items that appear between liabilities and equity on the face of the balance sheet. Magnitude: ($000)
totalNetLoans long(-9223372036854775807,9223372036854775806) Total loans and finance leases outstanding, including those held for sale. The value is net of unearned discount and loan-loss reserves, and does not include interest receivable on loans. Magnitude: ($000)
totalOtherAssets long(-9223372036854775807,9223372036854775806) All assets not otherwise classified above. Magnitude: ($000)
totalOtherLiabilities long(-9223372036854775807,9223372036854775806) All liabilities not otherwise classified above. Magnitude: ($000)
totalSecurities long(-9223372036854775807,9223372036854775806) Total of all securities owned, valued as shown on the balance sheet according to the applicable accounting standards used for this financial statement. For U.S. GAAP, includes all securities in the trading, available for sale, held to maturity and other securities categories and does not include segregated securities or securities pledged as collateral for broker-dealers and asset managers. For full coverage banks outside of the U.S. and Canada and summary coverage banks, includes other financial assets. Magnitude: ($000)
totalSubordinatedDebt long(-2147483648,2147483647) Debt in which the creditor's claims to the assets of the company are subordinated to those of other creditors. In the event of liquidation, dissolution, bankruptcy, or reorganization, such debts are junior to present or future obligations (e.g., payables, deposits, and senior debt). Subordinated debt is usually not collateralized by any specific asset, but only pledged by the full faith and credit of the company. Magnitude: ($000)
valueOfClientAssets long(-9223372036854775807,9223372036854775806) Total value of client's assets in customer accounts. Includes both assets under management and assets in client accounts over which the institution does not exercise discretionary investment powers. Magnitude: ($000)
101 rows of 101 total
API Open API Specification