1. Home
  2. Datasets
  3. 11 nk -- Profit and loss ...
To download the data set, please sign up or log in

11 nk -- Profit and loss accounts of investment firms, 2018 Q 1-2018 Q 4

11 nk -- Profit and loss accounts of investment firms, 2018 Q 1-2018 Q 4

Tables

Column Descriptions

Fact, Statfin spy pxt 11nk 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.
interest_income int Datasource did not contain a description for Interest_income. Column interest_income has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 80 and maximum value is 637.
interest_expenses int Datasource did not contain a description for Interest_expenses. Column interest_expenses has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 83 and maximum value is 530.
net_income_from_financial_operations int Datasource did not contain a description for NET_INCOME_FROM_FINANCIAL_OPERATIONS. Column net_income_from_financial_operations has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -108 and maximum value is 108.
expenses_on_share_capital_repayable_on_demand int Datasource did not contain a description for Expenses_on_share_capital_repayable_on_demand. Column is empty.
dividend_income int Datasource did not contain a description for Dividend_income. Column dividend_income has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2384 and maximum value is 5512.
fee_and_commission_income int Datasource did not contain a description for Fee_and_commission_income. Column fee_and_commission_income has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 109852 and maximum value is 402269.
fee_and_comission_expenses int Datasource did not contain a description for Fee_and_comission_expenses. Column fee_and_comission_expenses has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 30028 and maximum value is 103818.
gains_or_losses_on_derecognition_of_financial_assets_and_liabilities_not_measured_at_fair_value_through_profit_or_loss_net int Datasource did not contain a description for Gains_or_losses_on_derecognition_of_financial_assets_and_liabilities_not_measured_at_fair_value_through_profit_or_loss_net. Column gains_or_losses_on_derecognition_of_financial_assets_and_liabilities_not_measured_at_fair_value_through_profit_or_loss_net has 4 rows, out of which 3 are empty, making the null percent 75.00. Constant value is 942.
gains_or_losses_on_financial_assets_and_liabilities_held_for_trading_net int Datasource did not contain a description for Gains_or_losses_on_financial_assets_and_liabilities_held_for_trading_net. Column gains_or_losses_on_financial_assets_and_liabilities_held_for_trading_net has 4 rows, out of which 2 are empty, making the null percent 50.00. Minimum value is 577 and maximum value is 756.
gains_or_losses_on_financial_assets_outside_the_trading_fund_that_are_mandatorily_measured_at_fair_value_through_profit_or_loss_net int Datasource did not contain a description for Gains_or_losses_on_financial_assets_outside_the_trading_fund_that_are_mandatorily_measured_at_fair_value_through_profit_or_loss_net. Column is empty.
gains_or_losses_on_financial_assets_and_liabilities_designated_at_fair_value_through_profit_or_loss_net int Datasource did not contain a description for Gains_or_losses_on_financial_assets_and_liabilities_designated_at_fair_value_through_profit_or_loss_net. Column gains_or_losses_on_financial_assets_and_liabilities_designated_at_fair_value_through_profit_or_loss_net has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 32 and maximum value is 341.
gains_or_losses_from_hedge_accounting_net int Datasource did not contain a description for Gains_or_losses_from_hedge_accounting_net. Column is empty.
exchange_differences_gain_or_loss_net int Datasource did not contain a description for Exchange_differences_gain_or_loss_net. Column exchange_differences_gain_or_loss_net has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -339 and maximum value is -106.
gains_or_losses_on_derecognition_of_nonfinancial_assets_net int Datasource did not contain a description for Gains_or_losses_on_derecognition_of_nonfinancial_assets_net. Column is empty.
other_operating_income int Datasource did not contain a description for Other_operating_income. Column other_operating_income has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4978 and maximum value is 32429.
other_operating_expenses int Datasource did not contain a description for Other_operating_expenses. Column other_operating_expenses has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4703 and maximum value is 17910.
total_operating_income_net int Datasource did not contain a description for TOTAL_OPERATING_INCOME_NET. Column total_operating_income_net has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 82693 and maximum value is 321155.
administrative_expenses int Datasource did not contain a description for Administrative_expenses. Column administrative_expenses has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 46995 and maximum value is 185160.
of_which_personnel_expenses int Datasource did not contain a description for of_which_Personnel_expenses. Column of_which_personnel_expenses has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 27432 and maximum value is 106232.
of_which_other_administrative_expenses int Datasource did not contain a description for of_which_Other_administrative_expenses. Column of_which_other_administrative_expenses has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19563 and maximum value is 78927.
depreciation int Datasource did not contain a description for Depreciation. Column depreciation has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1369 and maximum value is 5343.
gains_or_losses_caused_by_the_changes_made_net int Datasource did not contain a description for Gains_or_losses_caused_by_the_changes_made_net. Column is empty.
provisions_or_reversal_of_provisions int Datasource did not contain a description for Provisions_or_reversal_of_provisions. Column is empty.
impairment_or_reversal_of_impairment_on_financial_assets_not_measured_at_fair_value_through_profit_or_loss int Datasource did not contain a description for Impairment_or_reversal_of_impairment_on_financial_assets_not_measured_at_fair_value_through_profit_or_loss. Column is empty.
impairment_or_reversal_of_impairment_of_investments_in_subsidaries_joint_ventures_and_associates int Datasource did not contain a description for Impairment_or_reversal_of_impairment_of_investments_in_subsidaries_joint_ventures_and_associates. Column is empty.
impairment_or_reversal_of_impairment_on_nonfinancial_assets int Datasource did not contain a description for Impairment_or_reversal_of_impairment_on_nonfinancial_assets. Column impairment_or_reversal_of_impairment_on_nonfinancial_assets has 4 rows, out of which 1 are empty, making the null percent 25.00. Minimum value is 357 and maximum value is 782.
negative_goodwill_recognised_in_profit_or_loss int Datasource did not contain a description for Negative_goodwill_recognised_in_profit_or_loss. Column is empty.
share_of_profit_or_loss_in_investments_in_subsidiaries_joint_ventures_and_associates int Datasource did not contain a description for Share_of_profit_or_loss_in_investments_in_subsidiaries_joint_ventures_and_associates. Column is empty.
profit_or_loss_from_noncurrent_assets_and_disposal_groups_classified_as_held_for_sale_not_qualifying_as_discontinued_operations int Datasource did not contain a description for Profit_or_loss_from_noncurrent_assets_and_disposal_groups_classified_as_held_for_sale_not_qualifying_as_discontinued_operations. Column is empty.
profit_or_loss_before_tax_from_continuing_operations int Datasource did not contain a description for PROFIT_OR_LOSS_BEFORE_TAX_FROM_CONTINUING_OPERATIONS. Column profit_or_loss_before_tax_from_continuing_operations has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 34104 and maximum value is 129845.
tax_expense_or_income_related_to_profit_or_loss_from_continuing_operations int Datasource did not contain a description for Tax_expense_or_income_related_to_profit_or_loss_from_continuing_operations. Column tax_expense_or_income_related_to_profit_or_loss_from_continuing_operations has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10462 and maximum value is 42343.
profit_or_loss_after_tax_from_continuing_operations int Datasource did not contain a description for PROFIT_OR_LOSS_AFTER_TAX_FROM_CONTINUING_OPERATIONS. Column profit_or_loss_after_tax_from_continuing_operations has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 23642 and maximum value is 87502.
profit_or_loss_after_tax_from_discontinuing_operations int Datasource did not contain a description for PROFIT_OR_LOSS_AFTER_TAX_FROM_DISCONTINUING_OPERATIONS. Column is empty.
profit_or_loss_for_the_year int Datasource did not contain a description for PROFIT_OR_LOSS_FOR_THE_YEAR. Column profit_or_loss_for_the_year has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 23642 and maximum value is 87804.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin spy pxt 11nk 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.
interest_income int Datasource did not contain a description for Interest_income. Column interest_income has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 80 and maximum value is 637.
interest_expenses int Datasource did not contain a description for Interest_expenses. Column interest_expenses has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 83 and maximum value is 530.
net_income_from_financial_operations int Datasource did not contain a description for NET_INCOME_FROM_FINANCIAL_OPERATIONS. Column net_income_from_financial_operations has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -108 and maximum value is 108.
expenses_on_share_capital_repayable_on_demand int Datasource did not contain a description for Expenses_on_share_capital_repayable_on_demand. Column is empty.
dividend_income int Datasource did not contain a description for Dividend_income. Column dividend_income has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2384 and maximum value is 5512.
fee_and_commission_income int Datasource did not contain a description for Fee_and_commission_income. Column fee_and_commission_income has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 109852 and maximum value is 402269.
fee_and_comission_expenses int Datasource did not contain a description for Fee_and_comission_expenses. Column fee_and_comission_expenses has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 30028 and maximum value is 103818.
gains_or_losses_on_derecognition_of_financial_assets_and_liabilities_not_measured_at_fair_value_through_profit_or_loss_net int Datasource did not contain a description for Gains_or_losses_on_derecognition_of_financial_assets_and_liabilities_not_measured_at_fair_value_through_profit_or_loss_net. Column gains_or_losses_on_derecognition_of_financial_assets_and_liabilities_not_measured_at_fair_value_through_profit_or_loss_net has 4 rows, out of which 3 are empty, making the null percent 75.00. Constant value is 942.
gains_or_losses_on_financial_assets_and_liabilities_held_for_trading_net int Datasource did not contain a description for Gains_or_losses_on_financial_assets_and_liabilities_held_for_trading_net. Column gains_or_losses_on_financial_assets_and_liabilities_held_for_trading_net has 4 rows, out of which 2 are empty, making the null percent 50.00. Minimum value is 577 and maximum value is 756.
gains_or_losses_on_financial_assets_outside_the_trading_fund_that_are_mandatorily_measured_at_fair_value_through_profit_or_loss_net int Datasource did not contain a description for Gains_or_losses_on_financial_assets_outside_the_trading_fund_that_are_mandatorily_measured_at_fair_value_through_profit_or_loss_net. Column is empty.
gains_or_losses_on_financial_assets_and_liabilities_designated_at_fair_value_through_profit_or_loss_net int Datasource did not contain a description for Gains_or_losses_on_financial_assets_and_liabilities_designated_at_fair_value_through_profit_or_loss_net. Column gains_or_losses_on_financial_assets_and_liabilities_designated_at_fair_value_through_profit_or_loss_net has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 32 and maximum value is 341.
gains_or_losses_from_hedge_accounting_net int Datasource did not contain a description for Gains_or_losses_from_hedge_accounting_net. Column is empty.
exchange_differences_gain_or_loss_net int Datasource did not contain a description for Exchange_differences_gain_or_loss_net. Column exchange_differences_gain_or_loss_net has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -339 and maximum value is -106.
gains_or_losses_on_derecognition_of_nonfinancial_assets_net int Datasource did not contain a description for Gains_or_losses_on_derecognition_of_nonfinancial_assets_net. Column is empty.
other_operating_income int Datasource did not contain a description for Other_operating_income. Column other_operating_income has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4978 and maximum value is 32429.
other_operating_expenses int Datasource did not contain a description for Other_operating_expenses. Column other_operating_expenses has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4703 and maximum value is 17910.
total_operating_income_net int Datasource did not contain a description for TOTAL_OPERATING_INCOME_NET. Column total_operating_income_net has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 82693 and maximum value is 321155.
administrative_expenses int Datasource did not contain a description for Administrative_expenses. Column administrative_expenses has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 46995 and maximum value is 185160.
of_which_personnel_expenses int Datasource did not contain a description for of_which_Personnel_expenses. Column of_which_personnel_expenses has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 27432 and maximum value is 106232.
of_which_other_administrative_expenses int Datasource did not contain a description for of_which_Other_administrative_expenses. Column of_which_other_administrative_expenses has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19563 and maximum value is 78927.
depreciation int Datasource did not contain a description for Depreciation. Column depreciation has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1369 and maximum value is 5343.
gains_or_losses_caused_by_the_changes_made_net int Datasource did not contain a description for Gains_or_losses_caused_by_the_changes_made_net. Column is empty.
provisions_or_reversal_of_provisions int Datasource did not contain a description for Provisions_or_reversal_of_provisions. Column is empty.
impairment_or_reversal_of_impairment_on_financial_assets_not_measured_at_fair_value_through_profit_or_loss int Datasource did not contain a description for Impairment_or_reversal_of_impairment_on_financial_assets_not_measured_at_fair_value_through_profit_or_loss. Column is empty.
impairment_or_reversal_of_impairment_of_investments_in_subsidaries_joint_ventures_and_associates int Datasource did not contain a description for Impairment_or_reversal_of_impairment_of_investments_in_subsidaries_joint_ventures_and_associates. Column is empty.
impairment_or_reversal_of_impairment_on_nonfinancial_assets int Datasource did not contain a description for Impairment_or_reversal_of_impairment_on_nonfinancial_assets. Column impairment_or_reversal_of_impairment_on_nonfinancial_assets has 4 rows, out of which 1 are empty, making the null percent 25.00. Minimum value is 357 and maximum value is 782.
negative_goodwill_recognised_in_profit_or_loss int Datasource did not contain a description for Negative_goodwill_recognised_in_profit_or_loss. Column is empty.
share_of_profit_or_loss_in_investments_in_subsidiaries_joint_ventures_and_associates int Datasource did not contain a description for Share_of_profit_or_loss_in_investments_in_subsidiaries_joint_ventures_and_associates. Column is empty.
profit_or_loss_from_noncurrent_assets_and_disposal_groups_classified_as_held_for_sale_not_qualifying_as_discontinued_operations int Datasource did not contain a description for Profit_or_loss_from_noncurrent_assets_and_disposal_groups_classified_as_held_for_sale_not_qualifying_as_discontinued_operations. Column is empty.
profit_or_loss_before_tax_from_continuing_operations int Datasource did not contain a description for PROFIT_OR_LOSS_BEFORE_TAX_FROM_CONTINUING_OPERATIONS. Column profit_or_loss_before_tax_from_continuing_operations has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 34104 and maximum value is 129845.
tax_expense_or_income_related_to_profit_or_loss_from_continuing_operations int Datasource did not contain a description for Tax_expense_or_income_related_to_profit_or_loss_from_continuing_operations. Column tax_expense_or_income_related_to_profit_or_loss_from_continuing_operations has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10462 and maximum value is 42343.
profit_or_loss_after_tax_from_continuing_operations int Datasource did not contain a description for PROFIT_OR_LOSS_AFTER_TAX_FROM_CONTINUING_OPERATIONS. Column profit_or_loss_after_tax_from_continuing_operations has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 23642 and maximum value is 87502.
profit_or_loss_after_tax_from_discontinuing_operations int Datasource did not contain a description for PROFIT_OR_LOSS_AFTER_TAX_FROM_DISCONTINUING_OPERATIONS. Column is empty.
profit_or_loss_for_the_year int Datasource did not contain a description for PROFIT_OR_LOSS_FOR_THE_YEAR. Column profit_or_loss_for_the_year has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 23642 and maximum value is 87804.

Additional Info

Last Updated July 20, 2019
Created July 20, 2019