Distribution of the Public Asset Portfolio, 1998-2017

ChartLab and SQL Console in ATSD

Data Source: Bank of Israel

Value of the Public Portfolio (NIS Billion)

View in ChartLab

SELECT date_format(time, 'yyyy-MM') AS "Date", tv.value AS "Total Value (NIS Billion)"
  FROM "total_(nis_billion)" AS tv WHERE date_format(time, 'MM') = '01'
GROUP BY 'Date', tv.value
  ORDER BY 'Date'
Date Total Value (NIS Billion)
1998-01 725
1999-01 847
2000-01 1048
2001-01 1074
2002-01 1162
2003-01 1177
2004-01 1331
2005-01 1433
2006-01 1675
2007-01 1878
2008-01 1960
2009-01 1916
2010-01 2312
2011-01 2581
2012-01 2574
2013-01 2730
2014-01 2974
2015-01 3190
2016-01 3306
2017-01 3429

View in ChartLab

Months with negative growth are shown in red, and months with positive growth exceeding 25 billion NIS are shown in dark blue.

SELECT date_format(time, 'yyyy-MM') AS "Date", ROUND(tv.value, 1) AS "Total Value (NIS Billion)", ROUND((tv.value/3428.9)*100, 1) AS "Percent of Current Value", ROUND(tv.value - LAG(tv.value), 1) AS "Delta"
  FROM "total_(nis_billion)" AS tv WHERE date_format(time, 'MM') = '01'
GROUP BY 'Date', tv.value
  ORDER BY 'Date'
Date Total Value (NIS Billion) Percent of Current Value Delta
1998-01 725.1 21.1 null
1999-01 846.6 24.7 121.5
2000-01 1047.9 30.6 201.3
2001-01 1074.1 31.3 26.2
2002-01 1162.3 33.9 88.2
2003-01 1177.4 34.3 15.1
2004-01 1331.1 38.8 153.7
2005-01 1432.8 41.8 101.7
2006-01 1674.7 48.8 241.9
2007-01 1878.2 54.8 203.5
2008-01 1959.8 57.2 81.6
2009-01 1916.4 55.9 -43.4
2010-01 2311.9 67.4 395.5
2011-01 2581.2 75.3 269.3
2012-01 2574.5 75.1 -6.7
2013-01 2730.4 79.6 155.9
2014-01 2974.3 86.7 243.9
2015-01 3189.5 93 215.2
2016-01 3305.5 96.4 116
2017-01 3428.9 100 123.4

Distributions of Assets by Type (Percent)

View in ChartLab

SELECT date_format(time, 'MM-yyyy') AS "Date",  cd.value AS "Cash and Deposits", gbn.value AS "Government Bonds (Non-Tradeable)", gbt.value AS "Government Bonds (Tradeable)", cbn.value AS "Corporate Bonds (Non-Tradeable)", cbt.value AS "Corporate Bonds (Tradeable)", cm.value AS "Cash (Makam)", i.value AS "Shares in Israel", iad.value AS "Investments Abroad (Deposits)", iab.value AS "Investments Abroad (Bonds)", ias.value AS "Investments Abroad (Shares)", iao.value AS "Investments Abroard (Other)"
  FROM "cash_and_desposits" AS cd JOIN "government_bonds_(non-tradeable)" AS gbn JOIN "government_bonds_(tradeable)" AS gbt JOIN "corporate_bonds_(non-tradeable)" AS cbn JOIN "corporate_bonds_(tradeable)" AS cbt JOIN "cash_(makam)" AS cm JOIN "shares_in_israel" AS i JOIN "investments_abroad_(deposits)" AS iad JOIN "investments_abroad_(bonds)" AS iab JOIN "investments_abroad_(shares)" AS ias JOIN "investments_abroad_(other)" AS iao WHERE date_format(time, 'MM') = '01'
GROUP BY 'Date', cd.value, gbn.value, gbt.value, cbn.value, cbt.value, cm.value, i.value, iab.value, iad.value, ias.value, iao.value
  ORDER BY 'Date'
Date Cash and Deposits Government Bonds (Non-Tradeable) Government Bonds (Tradeable) Corporate Bonds (Non-Tradeable) Corporate Bonds (Tradeable) Cash (Makam) Shares in Israel Investments Abroad (Deposits) Investments Abroad (Bonds) Investments Abroad (Shares) Investments Abroard (Other)
01-1998 44.7 13.5 12.9 0.8 1.2 2 15.9 0.9 2.2 0 5.9
01-1999 45.5 13.3 12 0 1.1 2.1 15.4 2.4 2.5 0 5.7
01-2000 41.6 11.5 10.7 0.8 1.5 1.9 19.6 2.4 0.3 4.9 4.8
01-2001 44.3 11.5 11.7 1.3 1.3 2.5 16.6 3 0.8 3.5 3.5
01-2002 43.4 11.5 13.4 1.6 1.5 2.5 15.6 4.1 2.1 2 2.3
01-2003 45.4 12.4 12.9 2 1.6 3.5 10.7 4.7 3.2 1.4 2.2
01-2004 39.6 11.2 14.2 2.3 1.8 3.8 16.3 3.8 3.4 2.3 1.5
01-2005 37.3 10.1 14.2 2.8 2.5 4.6 17 3.7 3.7 2.7 1.4
01-2006 33.7 8.5 12.6 3.6 4 3.7 20.1 4 4 3.9 1.9
01-2007 31.6 7.3 10.8 4 5 4.4 22.4 3.7 4.4 4 2.4
01-2008 32.1 6.9 10.8 4 7.9 3.4 21.6 3.9 3.5 3.5 2.4
01-2009 36.1 10.9 13.9 3 7.3 3.4 11.9 4.1 3.2 3.4 2.7
01-2010 31.6 9.3 12.5 2.6 9 2.7 19 3.1 3.1 4.6 2.6
01-2011 29.8 9.3 11.9 2.3 9.4 2.5 20.7 2.3 3.6 5.7 2.5
01-2012 33.1 9.4 12 2.2 9.6 3.1 16 1.8 4.2 5.8 2.8
01-2013 33.1 9.4 12.9 2.1 9.6 2.7 14.8 1.1 4.4 6.7 3.2
01-2014 31.5 9.4 13 1.7 9.1 2.7 16.6 0.9 4.3 7.4 3.4
01-2015 32.2 10.1 12.7 1.6 7.8 3 15 0.7 5.3 8.4 3.4
01-2016 33.9 9.9 11.9 1.3 8.3 2 14.5 0.8 5.4 7.9 4
01-2017 35.3 9.6 11.1 1.1 9 1.5 14 0.5 5.3 7.9 4.6

View in ChartLab