Quotulatiousness

April 9, 2013

Bitcoins as Tulips or viable virtual gold?

Filed under: Economics, Law, Liberty — Tags: , , , , — Nicholas @ 10:27

In the New Yorker, Maria Bustillos reviews the history of bitcoins:

In many ways, bitcoins function essentially like any other currency, and are accepted as payment by a growing number of merchants, both online and in the real world. But they are generated at a predetermined rate by an open-source computer program, which was set in motion in January of 2009. This program produced each one of the nearly eleven million bitcoins in circulation (with a total value just over a billion dollars at the current rate of exchange), and it runs on a massive peer-to-peer network of some twenty thousand independent nodes, which are generally very powerful (and expensive) G.P.U. or ASIC computer systems optimized to compete for new bitcoins. (Standards vary, but there seems to be a consensus forming around Bitcoin, capitalized, for the system, the software, and the network it runs on, and bitcoin, lowercase, for the currency itself.)

[. . .]

There is an upper limit of twenty-one million new coins built into the software; the last one is projected to be mined in 2140. After that, it is presumed that there will be enough traffic to keep rewards flowing in the form of transaction fees rather than mining new coins. For now, the bitcoins are initially issued to the miners, but are distributed when miners buy things with them or sell them to non-miners (such as jumpy Spanish bank depositors) who desire an alternative currency. The chain of ownership of every bitcoin in circulation is verified and registered with a timestamp on all twenty thousand network nodes. This prevents double spending, since no coin can be exchanged without the authentication of some twenty thousand independent cyber-witnesses. In order to hack the network, you would have to deceive over half of these computers at the same time, a progressively more difficult task and, even today, a very formidable one.

[. . .]

A casual review of Nakamoto’s various blog posts and bulletin-board comments also confirms that, from the first, Bitcoin was devised as a system for removing the possibility of corruption from the issuance and exchange of currency. Or, to put it another way: rather than trusting in governments, central banks, or other third-party institutions to secure the value of the currency and guarantee transactions, Bitcoin would place its trust in mathematics. At the P2P Foundation, Nakamoto wrote a blog post describing the difference between bitcoin and fiat currency:

    [Bitcoin is] completely decentralized, with no central server or trusted parties, because everything is based on crypto proof instead of trust. The root problem with conventional currency is all the trust that’s required to make it work. The central bank must be trusted not to debase the currency, but the history of fiat currencies is full of breaches of that trust. Banks must be trusted to hold our money and transfer it electronically, but they lend it out in waves of credit bubbles with barely a fraction in reserve. We have to trust them with our privacy, trust them not to let identity thieves drain our accounts… With e-currency based on cryptographic proof, without the need to trust a third party middleman, money can be secure and transactions effortless.

* * *

Much of what has been written so far about bitcoins has centered on the perceived dangers of their relative anonymity, the irreversibility of transactions, and on the fact that they can be used for money laundering and for criminal dealings, such as buying drugs on the encrypted Web site Silk Road. This fearmongering is a red herring, and has so far prevented the rational evaluation of the potential benefits and shortcomings of crypto-currency.

Cash is also anonymous; it is also used in money laundering and illegal transactions. Like bitcoins, stolen cash is difficult to recover, and a cash transaction can’t readily be traced back to the source. Nor is there immediate recourse for the reversal of transactions, as with credit-card chargebacks or bank refunds when one’s identity has been stolen. However, I find it difficult to believe that anyone who has written critically of the dangers of bitcoin would prefer an economy where private cash transactions are illegal.

Update: Meet the $2 Million Bitcoin Pizza.

Floridian Laszlo Hanyecz thought it would be “interesting” to be able to say he paid for a pizza in bitcoins. He worked out a deal where he transferred 10,000 of his bitcoins to a guy in England, who ordered him two pizzas from Papa Johns.

Today, one Redditor notes, those 10,000 bitcoins would be worth about $2.3 million, thanks (in part) to folks fleeing unstable and politically risky state currencies in Cyprus and elsewhere.

Some news outlets are covering this as a “doh!” story. But these pizzas were a huge publicity boon for Bitcoin, contributing to the success of the currency today. If Lazslo had been a hoarder, perhaps his bitcoins would be worth very little now. Cashing in bitcoins for pizza when they were worth a fraction of a cent each is not obviously smarter or stupider than selling now would be, with bitcoins trading at $234. It’s a bet on which way the market is headed, that’s all.

April 1, 2013

Canadian government pre-approves Cyprus-style haircuts for bank depositors

Filed under: Cancon, Economics, Government — Tags: , , , — Nicholas @ 09:39

Not only can it happen here, but Stephen Harper’s Conservative government is making it explicit that it will happen here:

The politicians of the western world are coming after your bank accounts. In fact, Cyprus-style “bail-ins” are actually proposed in the new Canadian government budget. When I first heard about this I was quite skeptical, so I went and looked it up for myself. And guess what? It is right there in black and white on pages 144 and 145 of “Economic Action Plan 2013″ which the Harper government has already submitted to the House of Commons.

This new budget actually proposes “to implement a ‘bail-in’ regime for systemically important banks” in Canada. “Economic Action Plan 2013″ was submitted on March 21st, which means that this “bail-in regime” was likely being planned long before the crisis in Cyprus ever erupted. So exactly what in the world is going on here? In addition, as you will see below, it is being reported that the European Parliament will soon be voting on a law which would require that large banks be “bailed in” when they fail. In other words, that new law would make Cyprus-style bank account confiscation the law of the land for the entire EU.

I can’t even begin to describe how serious all of this is. From now on, when major banks fail they are going to bail them out by grabbing the money that is in your bank accounts. This is going to absolutely shatter faith in the banking system and it is actually going to make it far more likely that we will see major bank failures all over the western world.

What you are about to see absolutely amazed me when I first saw it. The Canadian government is actually proposing that what just happened in Cyprus should be used as a blueprint for future bank failures up in Canada.

March 31, 2013

The deep strangeness of the Cyprus bank haircuts

Filed under: Economics, Europe, Greece, Russia — Tags: , — Nicholas @ 11:36

At Forbes, Tim Worstall has some thoughts on the oddities now apparent in how the Cyprus banking crisis has played out so far:

Now that we’re seeing the real numbers coming out about who loses what in the Cyprus haircut/bank consolidations there’s something very strange about the numbers. Whiffy even, and that’s not with a good odour to it either. For, as far as I can tell at least, the haircuts are far larger than they need to be in order to make good the damage that we were told about. I’m therefore coming around to the idea that this wasn’t what we’ve been told it was, a story of Russian offshore deposits and tax avoidance. Rather, it’s two banks which invested regular domestic deposits into just terrible opportunities and then lost it all.

I don’t think I can make the case absolutely but I think it’s a case worth at least investigating.

[. . .]

But back to the point I’m trying to work through here. We’ve been told that the immediate cause was all about all that foreign money which flooded the country’s banking system. Yet when we look at the amount that is being raised by the haircuts it doesn’t look as if the two bankrupt banks had all that much of those foreign deposits. It looks very much like the banks which had the deposits didn’t invest badly and thus didn’t go bankrupt. So the problem isn’t therefore one of all that foreign money.

Rather, it’s a problem of where those two banks invested their deposits. And it looks as if this was largely in Greek Government and Cypriot Government bonds. Which is why they are bust.

March 29, 2013

Cyprus has become the EU’s “lab rat”

Filed under: Bureaucracy, Economics, Europe — Tags: , , , — Nicholas @ 09:59

In sp!ked, Bruno Waterfield talks about the EU’s most recent involuntary experimental subject, Cyprus:

Every negative European political trend has deepened in the latest round of the Eurozone crisis, as Cyprus has been treated by the EU with a disdain for self-determination worthy of the high age of imperialism. It is this which is really troubling, not the haircuts for depositors or the bank closures. In effect, an entire island nation has been made a laboratory rat for a new Eurozone experiment in rebalancing economies in the EU single currency — whether the Cypriots like it or not.

Cyprus is the perfect fall guy for the EU and IMF experts who, despite the mess in Greece and elsewhere in southern Europe, still believe they know best how to run a nation’s affairs. That’s because, as well as being too small to count, especially for the markets, Cyprus is easily painted as a bad guy, a swarthy, even Levantine crook which launders dirty Russian money (nearly a third of Cypriot bank deposits) for ‘dodgy’ oligarchs. This whiff of corruption (nothing new to Cyprus, or other European banks for that matter) provides the perfect pretext for treating Cyprus as a case apart. This is meant to soothe the fears of senior northern European debt holders — it is corrupt Cyprus, and not failed private risk in general, that has been targeted.

So, because it is small, and in the eyes of the Eurozone social engineers, easily contained, Cyprus has been selected to be an experiment, potentially a model for Portugal or Spain. And if it all goes horribly wrong… well, Cyprus is small and a dodgy special case, so who cares? The EU doesn’t.

March 25, 2013

The Cyprus “deal” decoded

Filed under: Economics, Europe, Russia — Tags: , , , — Nicholas @ 09:04

With a blog post entitled “THE CYPRUS HEIST GOES THROUGH: And it’s an Orwellian masterpiece“, you could say that this is an unfair summary of the situation:

Somewhere, George Orwell is spinning in his grave — although he wouldn’t be even remotely surprised by the 1984-style nonsense being hailed as a compromise by the Troikanauts and Nicosia’s embarrassed leaders.

This is the deal: the levy is called something else scrapped, and none of the deposits below €100,000 will be stolen included.

The new lunacy idea sees Laiki Bank closed. The entirety of its €4.2bn in deposits over €100,000 will be placed in a “bad bank”: why you would put healthy deposits in a bad bank eludes me, but we’re really just moving the stash around here: the bad bank’s resources will be confiscated. We’re talk a 100% haircut for all these savers.

And don’t be fooled by the Berlin propaganda about Russian money-laundering. First up, being a rich Russian doesn’t automatically make you a crook; and secondly, nowhere near all — possibly under half — are Russian anyway: UBS, several Israeli banks, a number of French banks will have depositor’s money taken out of them to pay for the ambitions of Brussels-am-Berlin.

There’s more: all the bondholders in Laiki also take a 100% haircut.

[. . .]

Entirely appropriate however was the choice of Wolfgang Schäuble to face the cameras and ‘explain’ why none of this would need the approval of the Cypriot Parliament. Just “approved by the 17 eurozone finance ministers comparatively quickly, after about two hours of further deliberations”. As to why it needed FinMin approval (but not that of the citizens’ representatives) get a load of this for jargonised bollocks:

“This plan will not require the approval of the Cypriot parliament because the losses on large depositors will be achieved through a restructuring of the island’s two largest banks and not a tax.”

Update: I think Tyler Cowen gets it exactly correct here:

The capital controls will have to be strict. What will the price of a Cypriot euro be, relative to a German euro? 50%? I call this Cyprus leaving the euro but keeping the word “euro” to save face. And yet they fail to reap most of the advantages of leaving the euro, such as having an independent monetary policy.

March 24, 2013

The domestic economy of Cyprus is slowing to a stop

Filed under: Economics, Europe — Tags: , , , , — Nicholas @ 10:09

In the Telegraph, Colin Freeman looks at how the banking crisis is impacting ordinary Cypriots and retired EU citizens in Cyprus:

Last weekend, the small Mediterranean island was plunged into the epicentre of the eurozone crisis when Brussels finance chiefs, led by Germany, demanded a levy of up to ten per cent of savers’ deposits in return for a 10bn euro bail-out of the country’s ailing banks. The move left many of Cyprus’s 60,000-strong British community facing heavy losses on retirement nest eggs — and as the week rolled on, that looked like being just the least of their worries.

On Thursday, unhappy at the Cypriot parliament’s rejection of the deal, Europe’s Central Bank then threatened to cut financial life support for the island altogether, a move that would have led to its banking sector collapsing, and savers losing not just a percentage of their money, but all of it. It was only thanks to a last-minute agreement hammered out on Friday night, which is expected to restructure the country’s banks and restrict the levy to deposits of more than 100,000 euros, that all-out chaos was averted. For now, anyway.

[. . .]

Since last weekend, when all of Cyprus’s banks were shut to stop a run on withdrawals, work has ground to a halt, as the repair man has been unable to buy in the materials he needs from suppliers, who are all now demanding cash. The job symbolises the malaise of the wider Cypriot economy, built on shaky foundations, and now in a state of paralysis, with thousands of shops, businesses and restaurants unable to operate properly because of the financial uncertainty.

“None of my food and drink suppliers are taking bank payments any more,” said Yiota Vrasida, 43, who owns a café in the winding streets of the capital, Nicosia. “We can keep going until this weekend, but that is about it.”

[. . .]

“Nobody will want to leave so much as 10 euros in any Cypriot bank any more,” said Dino Karambalis, 49, an IT worker, standing at the end of a 30-people-long queue at the Laiki Bank, where he had 90,000 euros in savings. “They say this levy is only for Cyprus, but why should anyone believe that? This is undermining confidence in the euro as a whole, and in the whole EU project itself. I was pro-European before, but not now.”

This weekend, the Cypriot parliament sought to reassure smaller savers, saying those with less than 100,000 euros would face at most a levy of less than one percent. State television also talked of a one-time charge of up to 25 percent on savings of over 100,000 euros held at the Bank of Cyprus. With that in mind, capital controls will be imposed to stop a run on the banks when they reopen next week.

But whatever new measures come in, some damage has already been done by declaring savers’ accounts to be fair game in the first place. Britain’s Business Secretary, Vince Cable, warned on Friday that it could lead Northern Rock-style runs on banks all over the eurozone in future.

March 22, 2013

Cyprus: the state of play on Friday

Filed under: Economics, Europe — Tags: , , , — Nicholas @ 08:35

In the Telegraph, Thomas Pascoe summarizes the situation in Cyprus as of Friday morning:

As it stands this morning, there is a Plan B on the table after parliament voted down the proposal that every bank deposit in the country be subject to a deduction. The new plan only affects those with deposits over €100,000; however, it will require those depositors to take a loss of up to 40pc. As part of this package, the nation’s two large banks will be saved. However, the structure of the deal requires that one of the pair, Laiki, will be split into “good” and “bad” banks, with large depositors left to chance it in the bad bank.

A word on the thinking behind it. While you and I perceive deposits as secure money (and I have argued that to touch them is an abuse of power), technocrats in Brussels take a different view. They tend to view deposits in the technical sense of being loans to banks. You give the bank your money in exchange for interest, and can call the loan at any time (provided not everyone else is doing the same thing, which is the situation now). The bank loans most of your deposit on again. When countries struggle with too much debt, those who have loaned them money get “haircuts”, or less back than they gave. Following this thinking, the EU’s argument is that if we lend money to failing banks, we too must take a haircut to keep them solvent.

[. . .]

So the compromise deal is an ugly one, involving a precedent (confiscation of deposits) which will cast a pallor over the entire European banking system. But the problems are equally great with any other solution. If the banks are left to fail, depositors lose everything except the scraps recovered by administrators. To argue that they, and the country, must be funded directly by the EU, requires the continued willingness of Germany to act against its own economic interests and support an entire continent on its shoulders, impossible without fiscal and political consolidation which no electorate would assent to at present (not that they are asked, usually).

In my opinion, there is no faster way to destroy confidence in your retail banking sector than stealing the money from depositors with no recourse. I have no idea why the European Union is so hell-bent on crushing the banks, but perhaps they have some looney-tunes notion that they can supplant the existing bank system with something directly operated by the ECB or the EU itself.

March 21, 2013

The choices for Cyprus don’t seem to include saving the banks

Filed under: Economics, Europe — Tags: , , , , — Nicholas @ 11:04

In Forbes, Tim Worstall sums up the real problem facing Cypriots:

There’s a very large portion of the European political elite who believe, take on faith (for there’s certainly no convincing real world evidence about it) that the creation of the euro is part of the inevitable creation of the European State. And as such it is entirely irreversible. It’s not just that people once in the euro shouldn’t leave it: it’s that it is simply inconceivable that anyone ever would leave it. Either wish to leave it or be allowed to leave it.

Wherein lies the danger to said European dreams and it’s tiny Cyprus that poses said danger.

As both Krugman and Yglesias point out, the Cypriot banking system is bust, gone. Even if it needn’t have happened this way having the system closed for at least a week is going to lead to bank runs when they finally reopen. The economy is most certainly going to stutter if not be deeply depressed as a result of that banking system going. Given that a substantial part of the economy is about offshore finance, and that that’s not going to survive the banking system crash, there will also, whatever else happens, be substantial declines in GDP.

It’s most certainly true that leaving the euro will cause all of those things to happen. But if they’re going to happen anyway then why not leave the euro? Why not bring back the Cyprus Pound? That is, do an Iceland?

[. . .]

But here’s the thing: there’s still that religious insistence among the federasts that the euro is irreversible, a part of the future of the politics and economy of the continent. And if Cyprus does leave and does recover without too much paid then what reason for Greece, or Spain, Portugal, to stay in? If going bust and going back to one’s own currency is, as Iceland showed (although they kept, rather than went back to), less painful that the austerity required to stay in the euro then, well, why stay in the euro?

March 18, 2013

Cyprus to offer small depositors a slightly less nasty haircut

Filed under: Economics, Europe — Tags: , , — Nicholas @ 10:05

Megan McArdle on the most recent “concession” by the Cypriot bank regulators:

Cyprus seems to have realized what I wrote yesterday: violating your deposit insurance guarantees is a better way to start a bank run than to stabilize a banking crisis. After Cypriots rushed to withdraw their money ahead of the new rules, the Wall Street Journal reports that the government has cobbled together a new proposal: small depositors will pay a 3% “tax” on their accounts (instead of 6.75%); medium depositors (those with between €100,000 and €500,000 will be taxed at the same 10% they were supposed to pay before; and those with more than €500,000 will pay 15%.

That may check the runs on the small accounts. Now the question is: what about the big ones? Will the foreign depositors view 15% as the simple cost of stashing their money out of the watchful eye of their own government? Or will they seek a new haven?

If the foreign money runs, it seems unlikely that Cyprus will be able to bail out the banks again; this desperate bank levy is, after all, what they were forced to do just to raise the $5.8 billion that the EU and the IMF demanded they contribute to the bank rescue. But the higher Cyprus raises the levy on large accounts, the more likely it is that the foreign money will flee to somewhere less shaky.

By “less shaky”, one has to assume a non-European bank…

Update: Cyprus has extended the “bank holiday” to Thursday.

Will the Cyprus bailout set the fuse to a new Great Depression?

Filed under: Economics, Europe, History — Tags: , , , — Nicholas @ 00:01

History may not repeat itself, but it’s quite likely that it paraphrases itself instead:

So, this is going to be a very sour reading of what has happened in Cyprus this weekend. It will also be a very partisan one, possibly even a partial one. But if Milton Friedman and Anna Schwartz were right in their insistence that it was actually the Federal Reserve that caused the Great Depression (which is something that Ben Bernanke himself has insisted that the Fed will not repeat) then one way of interpreting what has happened is that the European Central Bank has just set us all up for another Depression. The trigger is that “tax” of a little over 6% on all depositors.

This isn’t an analysis that you’ll be able to get all economists to sign up to. But the basic story told by Friedman and Schwartz in A Monetary History of the United States was that the 1929 crash was indeed a serious crash. But it would not have led to the Great Depression without the Federal Reserve making some serious mistakes. Two of which were to allow the intertwined collapses of both the money supply and the banking system. Given that it is the banks that create credit and thus the wider money supply they are, to a great extent, the same thing.

[. . .]

But please note the central part of Friedman’s argument. Yes, there was the crash. Yes, there would have been a deep and painful recession as a result. But the tipping of that recession into depression was a result of the cascading series of bank failures in the absence of deposit insurance: that led to the calamitous shrinking of credit and the money supply.

So let us now look at Europe and the eurozone. Certainly there’s been a crash (or even a Crash). We’ve so far avoided the depression part (although not everywhere. Greece is certainly in one, Spain possibly and looking out my window at rural Portugal I see certain signs of a reversion to a non-cash economy.) but the important question is whether we manage to continue to do so?

[. . .]

Yes, I do know, they’ve called it a tax: but here we’ve got to make reference to that duck thing. The difference between a 6% or more “tax” on your bank deposit and a failure of the previously agreed deposit insurance to protect your deposit is quackery enough that it’s a duck.

As I’ve said before the importance of this is moot at present. It depends on who believes what. If the citizenry believe that they don’t have deposit insurance any more (whether we call this a tax or a duck) then we will see more mass withdrawals from banks and we will see more bank failures. And cascading bank failures are exactly the thing that will tumble us into a new depression.

March 17, 2013

Cyprus delays emergency parliamentary session over banking haircut

Filed under: Economics, Europe, Government — Tags: , , — Nicholas @ 09:50

Apparently not all the politicians in the Cypriot parliament are on-board with the mandatory levy on savings accounts:

Cyprus’s parliament has postponed until Monday an emergency session to vote on a levy on bank deposits after signs that lawmakers might block the surprise move agreed in Brussels to help fund a bailout and avert national bankruptcy.

In a radical departure from previous aid packages, euro zone finance ministers want Cyprus savers to forfeit up to 9.9 percent of their deposits in return for a 10 billion euro ($13 billion) bailout to the island, which has been financially crippled by its exposure to neighboring Greece.

The decision, announced on Saturday morning, stunned Cypriots and caused a run on cashpoints, most of which were depleted within hours. Electronic transfers were stopped.

[. . .]

Many Cypriots, having contributed to bailouts for Ireland, Portugal and Greece — Greece’s second bailout contributed to a debt restructuring that blew the 4.5 billion euro hole in Cyprus’s banking sector — are aghast at Europe’s treatment.

Cyprus received a “stab in the back” by its EU partners, the daily Phileleftheros said.

But it and another newspapers highlighted the danger of plunging the banking system into further turmoil if lawmakers sat on the fence.

March 16, 2013

More on the Cyprus banking situation

Filed under: Business, Economics, Europe — Tags: , , , , — Nicholas @ 11:44

At Forbes, Tim Worstall explains why the mandatory levy on bank accounts is an epic facepalm:

There’s nothing particularly bad about making depositors carry some of the load of a bank failure. Indeed, it has something to recommend it: if it happens occasionally then people will take more care over where they put their money and what the banks do with it.

However, there’s a very great difference between allowing depositors without government insurance to take losses and actually reneging on the previously promised government insurance. And it’s that second that they’re actually doing here. [. . .]

Under the system until yesterday all depositors in Cypriot banks were insured up to the value of €100,000 with any one bank. Today that solemn and governmental promise has been shown to be false. And not even the European Union nor the European Central Bank are going to make them stick to it. Indeed, very much the other way around. The EU and ECB are insisting that the Cyprus authorities breach this deposit insurance provision.

As I say, there’s nothing wrong with making uninsured depositors take some of the pain. Certainly nothing at all wrong with making those with large deposits take a haircut. The problem is when government has said “we’ll insure this” and when push comes to shove they say “err, no, we won’t”. And the problem with this is that it makes all future EU deposit insurance worth that much less.

The Cyprus “rescue” includes nasty haircut for savings held in consumer banks

Filed under: Economics, Europe — Tags: , , , , — Nicholas @ 11:23

The BBC reports on the way Cypriot bank accounts are being levied as part of the “rescue”:

Cyprus may be one of the eurozone’s tiniest economies — its third smallest — but for the next 48 hours or so, it may be the single currency area’s most important.

The point is that there could be serious repercussions for other financially over-stretched economies, such as Spain’s and Italy’s, from the nature of Cyprus’s 10bn-euro (£8.7bn) bailout — which includes, for the first time in any eurozone rescue, losses imposed directly on depositors in banks.

These losses, running to almost 6bn euros, stem from an emergency levy of 9.9% on bank deposits over 100,000 euros (£86,600) and 6.75% below that.

The levy serves as a caution to lenders to banks that they should take care where they place their funds and avoid banks which overstretch themselves — as Cypriot banks did.

But precisely the same arguments — for what is known as a “bail-in” by private-sector creditors — were put by liberal-market purists at the peak of the banking crises in Ireland and Spain.

In the end, eurozone governments were terrified that if lenders to Spanish and Irish banks were punished, there would be a devastating domino effect of withdrawals of funds from banks in other weaker economies — a domino effect that would jeopardise the survival of the eurozone.

So, reckless lenders to Spanish and Irish banks were not punished.

There’s a strong possibility that savers in other European countries with weakened banking systems to draw the correct conclusion quickly … and start pulling their money out of the banking system. And also expect the EU to react with draconian currency restrictions. It’s a potential banking sauve qui peut.

February 14, 2013

Microsoft Excel: the most dangerous software on Earth?

Filed under: Business, Economics, Technology — Tags: , , — Nicholas @ 00:02

I’ve made this case in conversation several times — usually after having to forensically determine just why someone’s spreadsheet produced an unlikely answer — the greatest strength of spreadsheets is also their greatest weakness. Anyone who’s built a spreadsheet knows how easy it is to make a mistake, and how hard that mistake can be to detect after the fact. Spreadsheets are free-form: you can set up relationships on the fly, pull data from one place to plug into a different formula somewhere else. It’s literally empowering to gain that much control over your data without having to learn a full programming language.

But that flexibility and power comes at a cost: there’s no built-in error checking of your assumptions. Oh, it’ll alert you to practical problems like mis-matched data types or mechanical errors in your formula, but can’t tell you whether the operation you’re attempting makes sense. The program can’t read your mind and can’t sanity check your work.

Do a spreadsheet for your family budget and you’ll almost certainly make a minor error or two.

Make a set of inter-linked spreadsheets and you probably double the chances of error for each new spreadsheet in the set.

Make a set of inter-linked spreadsheets that require manual copy-and-paste updates and you exponentially increase the chances of error.

Then, make that manually updated set of spreadsheets have a real-world impact on vast amounts of money:

To give you and idea of how important this is here’s a great tale from James Kwak:

    The issue is described in the appendix to JPMorgan’s internal investigative task force’s report. To summarize: JPMorgan’s Chief Investment Office needed a new value-at-risk (VaR) model for the synthetic credit portfolio (the one that blew up) and assigned a quantitative whiz (“a London-based quantitative expert, mathematician and model developer” who previously worked at a company that built analytical models) to create it. The new model “operated through a series of Excel spreadsheets, which had to be completed manually, by a process of copying and pasting data from one spreadsheet to another.” The internal Model Review Group identified this problem as well as a few others, but approved the model, while saying that it should be automated and another significant flaw should be fixed.** After the London Whale trade blew up, the Model Review Group discovered that the model had not been automated and found several other errors. Most spectacularly,

    “After subtracting the old rate from the new rate, the spreadsheet divided by their sum instead of their average, as the modeler had intended. This error likely had the effect of muting volatility by a factor of two and of lowering the VaR . . .”

To translate that into the vernacular, the bank, JP Morgan, was running huge bets (tens of billions of dollars, what we might think of a golly gee gosh that’s a lot of money) in London. The way they were checking what they were doing was playing around in Excel. And not even in the Masters of the Universe style that we might hope, all integrated, automated and self-checking, but by cutting and pasting from one spreadsheet to another. And yes, they got one of the equations wrong as a result of which the bank lost several billion dollars (perhaps we might drop the gee here but it’s still golly gosh that’s a lot of money).

And it’s not just JP Morgan: every financial firm, every bank, every brokerage uses Excel (or another spreadsheet program). Multiply JP Morgan’s experiences by the number of companies to get a rough idea of how much is at risk from un-audited (possibly even un-audit-able) financial models running on spreadsheets.

January 27, 2013

Reason.tv: Two Cheers for the Coming Collapse of the U.S. Economy!

Filed under: Economics, Government, USA — Tags: , , — Nicholas @ 11:13

“At some point, holders of Treasury securities are going to recognize that these unfunded liabilities are going to affect the fiscal capabilities of the government and then you’re going to have the same situation that happened in Greece happening in the U.S.,” says Jeffrey Rogers Hummel, who is a professor of economics at San Jose State University and the author of a recent paper on the consequences of a U.S. government default. “In the short run it’s going to be painful, but in the long run it’ll be a good thing.”

Reason‘s Nick Gillespie sat down with Hummel at FreedomFest 2012 for a wide-ranging discussion on monetary policy, business cycle theory, the longevity of the welfare state, and why libertarians who rail against the Fed are like “generals fighting the last war.”

Held each July in Las Vegas, FreedomFest is attended by around 2,000 limited-government enthusiasts and libertarians a year. Reason TV spoke with over two dozen speakers and attendees.

« Newer Posts — Older Posts »

Powered by WordPress