The file has a lot of sheets in it, but only some of them are interesting for people like me who are interested in adding up the numbers for transactions values.
First there's Table 8, which gives the total value of transactions by non-banks. In fact you can also find the breakdown according to credit transfers, direct debits, card payments, cheques and so forth.
Then there's a sheet called PS3 which details "Payments processed by selected interbaank funds transfer systems".
Next comes sheet TRS3 ("Trades executed on selected exchanges and trading system").
Then there's sheet CCP3 ("Transactions cleared by selected central counterparties and clearing houses"), and finally sheet CSD3 (Transactions processed by selected central securities depositories").
I extracted all the data and got the following breakdown for the four tables.
Here's the breakdown country by country.
LCH.Clearnet didn't provide the numbers. I think that it is safe to conclude that the real numbers for global activity in the 23 countries covered by B.I.S. are probably back up around $9,000 trillion again - especially when you take into account all the transactions that are done by agencies that were not "selected" by B.I.S. Take NYSE Liffe for example, which doesn't get covered at all. Oh well....
Having this global data is really very interesting, because you can compare the numbers with the total amount of government revenue in each country and per year. For this, I used the data from the World Bank which provides numbers as a percentage of GDP. The revenue numbers refer to "cash receipts from taxes, social contributions, and other revenues such as fines, fees, rent, and income from property or sales". In other words, pretty much everything. For some reason, the World Bank data lacks data points for a few countries, but the table below is fairly complete, at least until 2009.
And if you are lucky enough to live in a country where the levels of financial transactions are particularly high (the UK, the USA and Belgium), you might well end up paying less than 0.1%. You'd have to be mad not to vote for that...
Well, either mad, or not given the option....