11 nm -- Balance sheets of investment firms, 2018 Q 1-2018 Q 4

Tables

Fact, Statfin spy pxt 11nm px, Full historyTSV
Balance sheets of investment firms by Information and Quarter
Fact, Statfin spy pxt 11nm px, LatestTSV
Balance sheets of investment firms by Information and Quarter

Column Descriptions

Fact, Statfin spy pxt 11nm px, Latest

Column	Type	Comment
quarter	string	Datasource did not contain a description for Quarter. Column quarter has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2018Q1 and maximum string is 2018Q4.
assets	int	Datasource did not contain a description for ASSETS. Column is empty.
cash_cash_balances_at_central_banks_and_other_demand_deposits	int	Datasource did not contain a description for Cash_cash_balances_at_central_banks_and_other_demand_deposits. Column cash_cash_balances_at_central_banks_and_other_demand_deposits has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 131301 and maximum value is 172150.
financial_assets_held_for_trading	int	Datasource did not contain a description for Financial_assets_held_for_trading. Column financial_assets_held_for_trading has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4337 and maximum value is 20147.
financial_assets_outside_the_trading_inventory_that_are_mandatorily_measured_at_fair_value_through_profit_or_loss	int	Datasource did not contain a description for Financial_assets_outside_the_trading_inventory_that_are_mandatorily_measured_at_fair_value_through_profit_or_loss. Column financial_assets_outside_the_trading_inventory_that_are_mandatorily_measured_at_fair_value_through_profit_or_loss has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5293 and maximum value is 12731.
financial_assets_designated_at_fair_value_through_profit_or_loss	int	Datasource did not contain a description for Financial_assets_designated_at_fair_value_through_profit_or_loss. Column financial_assets_designated_at_fair_value_through_profit_or_loss has 4 rows, out of which 3 are empty, making the null percent 75.00. Constant value is 1294.
financial_assets_measured_at_fair_value_through_other_comprehensive_income	int	Datasource did not contain a description for Financial_assets_measured_at_fair_value_through_other_comprehensive_income. Column financial_assets_measured_at_fair_value_through_other_comprehensive_income has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4926 and maximum value is 7087.
financial_assets_measured_at_amortised_cost	int	Datasource did not contain a description for Financial_assets_measured_at_amortised_cost. Column financial_assets_measured_at_amortised_cost has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2396 and maximum value is 4261.
derivatives__hedge_accounting	int	Datasource did not contain a description for Derivatives__Hedge_accounting. Column is empty.
fair_value_changes_of_the_hedge_items_in_portfolio_hedge_of_interest_rate_risk_assets	int	Datasource did not contain a description for Fair_value_changes_of_the_hedge_items_in_portfolio_hedge_of_interest_rate_risk_assets. Column is empty.
investments_in_subsidiaries_joint_ventures_and_associates	int	Datasource did not contain a description for Investments_in_subsidiaries_joint_ventures_and_associates. Column investments_in_subsidiaries_joint_ventures_and_associates has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 16081 and maximum value is 30808.
tangible_assets	int	Datasource did not contain a description for Tangible_assets. Column tangible_assets has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4337 and maximum value is 5963.
intangible_assets	int	Datasource did not contain a description for Intangible_assets. Column intangible_assets has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 15004 and maximum value is 19087.
tax_assets	int	Datasource did not contain a description for Tax_assets. Column tax_assets has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4485 and maximum value is 5414.
other_assets	int	Datasource did not contain a description for Other_assets. Column other_assets has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 91712 and maximum value is 124381.
noncurrent_assets_held_for_sale_and_transferable_item_groups	int	Datasource did not contain a description for Noncurrent_assets_held_for_sale_and_transferable_item_groups. Column noncurrent_assets_held_for_sale_and_transferable_item_groups has 4 rows, out of which 3 are empty, making the null percent 75.00. Constant value is 1887.
total_assets	int	Datasource did not contain a description for TOTAL_ASSETS. Column total_assets has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 337729 and maximum value is 382672.
liabilities	int	Datasource did not contain a description for LIABILITIES. Column is empty.
financial_liabilities_held_for_trading	int	Datasource did not contain a description for Financial_liabilities_held_for_trading. Column is empty.
financial_liabilities_designated_at_fair_value_through_profit_or_loss	int	Datasource did not contain a description for Financial_liabilities_designated_at_fair_value_through_profit_or_loss. Column is empty.
financial_liabilities_measured_at_amortised_cost	int	Datasource did not contain a description for Financial_liabilities_measured_at_amortised_cost. Column financial_liabilities_measured_at_amortised_cost has 4 rows, out of which 2 are empty, making the null percent 50.00. Minimum value is 7077 and maximum value is 9540.
derivatives_hedge_accounting_liabilities	int	Datasource did not contain a description for Derivatives_Hedge_accounting_liabilities. Column is empty.
fair_value_changes_of_the_hedge_items_in_portfolio_hedge_of_interest_rate_risk_liabilities	int	Datasource did not contain a description for Fair_value_changes_of_the_hedge_items_in_portfolio_hedge_of_interest_rate_risk_liabilities. Column is empty.
provisions	int	Datasource did not contain a description for Provisions. Column provisions has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6825 and maximum value is 8713.
tax_liabilities	int	Datasource did not contain a description for Tax_liabilities. Column tax_liabilities has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2006 and maximum value is 4678.
share_capital_repayable_on_demand	int	Datasource did not contain a description for Share_capital_repayable_on_demand. Column is empty.
other_liabilities	int	Datasource did not contain a description for Other_Liabilities. Column other_liabilities has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 75962 and maximum value is 121788.
liabilities_included_in_disposal_groups_classified_as_held_for_sale	int	Datasource did not contain a description for Liabilities_included_in_disposal_groups_classified_as_held_for_sale. Column is empty.
total_liabilities	int	Datasource did not contain a description for TOTAL_LIABILITIES. Column total_liabilities has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 105241 and maximum value is 165408.
equity	int	Datasource did not contain a description for Equity. Column equity has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24466 and maximum value is 31418.
share_premium	int	Datasource did not contain a description for Share_premium. Column share_premium has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 5669.
equity_instruments_issued_other_than_capital	int	Datasource did not contain a description for Equity_instruments_issued_other_than_capital. Column equity_instruments_issued_other_than_capital has 4 rows, out of which 2 are empty, making the null percent 50.00. Minimum value is 863 and maximum value is 3026.
other_equity	int	Datasource did not contain a description for Other_equity. Column other_equity has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1190 and maximum value is 2103.
accumulated_other_comprehensive_income	int	Datasource did not contain a description for Accumulated_other_comprehensive_income. Column accumulated_other_comprehensive_income has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -4971 and maximum value is 5410.
retained_earnings	int	Datasource did not contain a description for Retained_earnings. Column retained_earnings has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 61726 and maximum value is 96109.
revaluation_reserves	int	Datasource did not contain a description for Revaluation_reserves. Column is empty.
other_reserves	int	Datasource did not contain a description for Other_reserves. Column other_reserves has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 56594 and maximum value is 66427.
treasury_shares	int	Datasource did not contain a description for Treasury_shares. Column is empty.
profit_or_loss_allocated_to_shareholders_of_the_parent_company	int	Datasource did not contain a description for Profit_or_loss_allocated_to_shareholders_of_the_parent_company. Column profit_or_loss_allocated_to_shareholders_of_the_parent_company has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 23635 and maximum value is 85517.
interim_dividends	int	Datasource did not contain a description for Interim_dividends. Column interim_dividends has 4 rows, out of which 3 are empty, making the null percent 75.00. Constant value is 2129.
minority_interests_noncontrolling_owners_interests	int	Datasource did not contain a description for Minority_interests_noncontrolling_owners_interests. Column is empty.
total_equity	int	Datasource did not contain a description for TOTAL_EQUITY. Column total_equity has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 216962 and maximum value is 241454.
total_equity_and_total_liabilities	int	Datasource did not contain a description for TOTAL_EQUITY_AND_TOTAL_LIABILITIES. Column total_equity_and_total_liabilities has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 337729 and maximum value is 382673.

Fact, Statfin spy pxt 11nm px, Full history

Column	Type	Comment
quarter	string	Datasource did not contain a description for Quarter. Column quarter has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2018Q1 and maximum string is 2018Q4.
assets	int	Datasource did not contain a description for ASSETS. Column is empty.
cash_cash_balances_at_central_banks_and_other_demand_deposits	int	Datasource did not contain a description for Cash_cash_balances_at_central_banks_and_other_demand_deposits. Column cash_cash_balances_at_central_banks_and_other_demand_deposits has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 131301 and maximum value is 172150.
financial_assets_held_for_trading	int	Datasource did not contain a description for Financial_assets_held_for_trading. Column financial_assets_held_for_trading has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4337 and maximum value is 20147.
financial_assets_outside_the_trading_inventory_that_are_mandatorily_measured_at_fair_value_through_profit_or_loss	int	Datasource did not contain a description for Financial_assets_outside_the_trading_inventory_that_are_mandatorily_measured_at_fair_value_through_profit_or_loss. Column financial_assets_outside_the_trading_inventory_that_are_mandatorily_measured_at_fair_value_through_profit_or_loss has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5293 and maximum value is 12731.
financial_assets_designated_at_fair_value_through_profit_or_loss	int	Datasource did not contain a description for Financial_assets_designated_at_fair_value_through_profit_or_loss. Column financial_assets_designated_at_fair_value_through_profit_or_loss has 4 rows, out of which 3 are empty, making the null percent 75.00. Constant value is 1294.
financial_assets_measured_at_fair_value_through_other_comprehensive_income	int	Datasource did not contain a description for Financial_assets_measured_at_fair_value_through_other_comprehensive_income. Column financial_assets_measured_at_fair_value_through_other_comprehensive_income has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4926 and maximum value is 7087.
financial_assets_measured_at_amortised_cost	int	Datasource did not contain a description for Financial_assets_measured_at_amortised_cost. Column financial_assets_measured_at_amortised_cost has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2396 and maximum value is 4261.
derivatives__hedge_accounting	int	Datasource did not contain a description for Derivatives__Hedge_accounting. Column is empty.
fair_value_changes_of_the_hedge_items_in_portfolio_hedge_of_interest_rate_risk_assets	int	Datasource did not contain a description for Fair_value_changes_of_the_hedge_items_in_portfolio_hedge_of_interest_rate_risk_assets. Column is empty.
investments_in_subsidiaries_joint_ventures_and_associates	int	Datasource did not contain a description for Investments_in_subsidiaries_joint_ventures_and_associates. Column investments_in_subsidiaries_joint_ventures_and_associates has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 16081 and maximum value is 30808.
tangible_assets	int	Datasource did not contain a description for Tangible_assets. Column tangible_assets has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4337 and maximum value is 5963.
intangible_assets	int	Datasource did not contain a description for Intangible_assets. Column intangible_assets has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 15004 and maximum value is 19087.
tax_assets	int	Datasource did not contain a description for Tax_assets. Column tax_assets has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4485 and maximum value is 5414.
other_assets	int	Datasource did not contain a description for Other_assets. Column other_assets has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 91712 and maximum value is 124381.
noncurrent_assets_held_for_sale_and_transferable_item_groups	int	Datasource did not contain a description for Noncurrent_assets_held_for_sale_and_transferable_item_groups. Column noncurrent_assets_held_for_sale_and_transferable_item_groups has 4 rows, out of which 3 are empty, making the null percent 75.00. Constant value is 1887.
total_assets	int	Datasource did not contain a description for TOTAL_ASSETS. Column total_assets has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 337729 and maximum value is 382672.
liabilities	int	Datasource did not contain a description for LIABILITIES. Column is empty.
financial_liabilities_held_for_trading	int	Datasource did not contain a description for Financial_liabilities_held_for_trading. Column is empty.
financial_liabilities_designated_at_fair_value_through_profit_or_loss	int	Datasource did not contain a description for Financial_liabilities_designated_at_fair_value_through_profit_or_loss. Column is empty.
financial_liabilities_measured_at_amortised_cost	int	Datasource did not contain a description for Financial_liabilities_measured_at_amortised_cost. Column financial_liabilities_measured_at_amortised_cost has 4 rows, out of which 2 are empty, making the null percent 50.00. Minimum value is 7077 and maximum value is 9540.
derivatives_hedge_accounting_liabilities	int	Datasource did not contain a description for Derivatives_Hedge_accounting_liabilities. Column is empty.
fair_value_changes_of_the_hedge_items_in_portfolio_hedge_of_interest_rate_risk_liabilities	int	Datasource did not contain a description for Fair_value_changes_of_the_hedge_items_in_portfolio_hedge_of_interest_rate_risk_liabilities. Column is empty.
provisions	int	Datasource did not contain a description for Provisions. Column provisions has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6825 and maximum value is 8713.
tax_liabilities	int	Datasource did not contain a description for Tax_liabilities. Column tax_liabilities has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2006 and maximum value is 4678.
share_capital_repayable_on_demand	int	Datasource did not contain a description for Share_capital_repayable_on_demand. Column is empty.
other_liabilities	int	Datasource did not contain a description for Other_Liabilities. Column other_liabilities has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 75962 and maximum value is 121788.
liabilities_included_in_disposal_groups_classified_as_held_for_sale	int	Datasource did not contain a description for Liabilities_included_in_disposal_groups_classified_as_held_for_sale. Column is empty.
total_liabilities	int	Datasource did not contain a description for TOTAL_LIABILITIES. Column total_liabilities has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 105241 and maximum value is 165408.
equity	int	Datasource did not contain a description for Equity. Column equity has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24466 and maximum value is 31418.
share_premium	int	Datasource did not contain a description for Share_premium. Column share_premium has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 5669.
equity_instruments_issued_other_than_capital	int	Datasource did not contain a description for Equity_instruments_issued_other_than_capital. Column equity_instruments_issued_other_than_capital has 4 rows, out of which 2 are empty, making the null percent 50.00. Minimum value is 863 and maximum value is 3026.
other_equity	int	Datasource did not contain a description for Other_equity. Column other_equity has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1190 and maximum value is 2103.
accumulated_other_comprehensive_income	int	Datasource did not contain a description for Accumulated_other_comprehensive_income. Column accumulated_other_comprehensive_income has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -4971 and maximum value is 5410.
retained_earnings	int	Datasource did not contain a description for Retained_earnings. Column retained_earnings has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 61726 and maximum value is 96109.
revaluation_reserves	int	Datasource did not contain a description for Revaluation_reserves. Column is empty.
other_reserves	int	Datasource did not contain a description for Other_reserves. Column other_reserves has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 56594 and maximum value is 66427.
treasury_shares	int	Datasource did not contain a description for Treasury_shares. Column is empty.
profit_or_loss_allocated_to_shareholders_of_the_parent_company	int	Datasource did not contain a description for Profit_or_loss_allocated_to_shareholders_of_the_parent_company. Column profit_or_loss_allocated_to_shareholders_of_the_parent_company has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 23635 and maximum value is 85517.
interim_dividends	int	Datasource did not contain a description for Interim_dividends. Column interim_dividends has 4 rows, out of which 3 are empty, making the null percent 75.00. Constant value is 2129.
minority_interests_noncontrolling_owners_interests	int	Datasource did not contain a description for Minority_interests_noncontrolling_owners_interests. Column is empty.
total_equity	int	Datasource did not contain a description for TOTAL_EQUITY. Column total_equity has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 216962 and maximum value is 241454.
total_equity_and_total_liabilities	int	Datasource did not contain a description for TOTAL_EQUITY_AND_TOTAL_LIABILITIES. Column total_equity_and_total_liabilities has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 337729 and maximum value is 382673.
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	July 19, 2019
Created	July 19, 2019