Excel Breakdown Of All Discount Window Users Between March 2008 - 2009

Tyler Durden's picture

Tired of poring through thousands of PDF files from the Fed's Bloomberg FOIA release? Curious why Ron Paul said that he "was surprised and deeply disturbed ... to learn the
staggering amount of money that went to foreign banks" and is planning to hold a hearing
over emergency loans to the branches of non-U.S.
banks? Then here is the excel file for you: the following publicly shared google docs spreadsheet contains the complete Discount Window loan origination data from March 14, 2008 through March 16, 2009. We offer it so that anyone who wishes to perform their own analysis on the primary data can do so (and needless to say banks noted as FORI in the markstat entity type are foreign borrowers). 

Discount Window spreadsheet link

Since the flood of requests appears to have taken down Google Docs, here is a direct download link to the spreadsheet in Ods format.

And a link for the same file in Xls format

h/t Doug

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
vast-dom's picture

nice one Tyler.

i could host a PDF as zip/rar file if you'd like. Better to dl it methinks. 


In Fed We Trust's picture

I noticed right off the bat, JP Morgan seems to be at the window every other day for average of 25 billion. I think the discount window is for overnight loans, but come on, if your in line every other day for the same amount, that's more like a revolving line of credit. 

What would be interesting to see, is how the forgien banks used the money they received from the fed. I know they dont publish "positions" of each bank at the end of the quarter, but I would be very curious to know that they were all betting the same direction and the same markets. As if the money leant by the fed, had strings attached, inline with the feds agenda, like letting Lehman fail.

Ying-Yang's picture

Thanks Tyler....

A link to the FED's primer on their discount window scam, ahh sorry, their Payment Risk System.


Wanted to brush up on the regulations before digesting where discount window loans for $15,760,004,161,955 are backed by "performing or investment grade assets" (really?) in exchange for digital dinero.

This is just from March 08 to March 09. 

Tyler... since the FED is private, do we know if these loans were repaid by their maturity dates or something else?

carbonmutant's picture

These little nuggets are what make ZH such a treasure.

rocker's picture

Thanks ZH & Tyler.  The other day you put one out that I used the PDF version which also worked well.

This time I used the attachment in the window. Looks much nicer now. Either way, we now know that we most likely paid the banksters for a lot of crap that is worthless. "I will not monetize" the Benanke. LOL 

redpill's picture

The amounts by Origination Month:

Mar-08 $314,603,859,472
Apr-08 $594,483,596,500
May-08 $321,617,819,000
Jun-08 $176,898,428,000
Jul-08 $52,451,029,612
Aug-08 $45,343,165,850
Sep-08 $1,574,142,741,955
Oct-08 $3,772,730,119,087
Nov-08 $2,286,486,699,431
Dec-08 $2,549,226,873,128
Jan-09 $1,844,943,188,050
Feb-09 $1,418,439,291,157
Mar-09 $808,637,350,713

macholatte's picture

Pardon my ignoramous, please.

This enquiring mind wants to know why the FED did this. Seriously. Is it because it's the bank for the reserve currency or some other reason?

If China became the reserve currency bank, would it be expected to bail out deadbeats like, say, the USA?


I don't oppose all wars. What I am opposed to is a dumb war. What I am opposed to is a rash war.
Barack Obama
/  /   /
Widowmaker's picture

Two words:

Record fucking-bonuses.

rocker's picture

We the People Paid for All those bonuses. Including the 100 million Lloyd Blankfein, (Blackass), got.

When will we put them in Jail?  They cried and lied to garnish themselves. Saving a cartel is not saving the economy. 


blindfaith's picture

Thank you Tyler for, again, being the man infornt.

MY BIG QUESTION is...great, now we see (in hind sight) what this criminal group did until March 2009.

I WANT TO KNOW what they have done since then and are doing now.

THIS CONGRESS MUST DISOLVE THE FED...no excuses anymore to allow a de-facto private enterprise to run and ruin this Nation.

blindfaith's picture

From Reuters:

"Data the Fed was required by courts to disclose on Thursday showed the U.S. branches of foreign-headquartered financial firms had made extensive use of the central bank's emergency lending discount window during the severe financial crisis that froze financial markets in the fall of 2008."

NOTICE that is says "firms" meaning shells.  HOW did THIS help Americans???????

I think the Fed and it members are traitors to America and more dangerous than ANY terrorist group real or imaginary .

G-R-U-N-T's picture

Thanks Tyler.

Quick question: How much has been payed back and at what interest rate?


DoChenRollingBearing's picture

The link did not work for me.

I'll try again.

Sabibaby's picture

Got it! Open Office Document. Save and spread. Lets make sure this goes viral!

DoChenRollingBearing's picture

OK, I finally got it!

It's a real eyeopener and I just sent off to 18 friends.

I wonder where all that money has gone.........

sabra1's picture

wasn't there a Link on the Mod Squad?

knukles's picture

He didn't work either.

Buckaroo Banzai's picture

Pete, Link, and Julie, IIRC

Captain Benny's picture

Awesome compilation document!  Thanks for posting.

doggings's picture

hmm, doesnt look too good

Google Docs

We're sorry.
The spreadsheet at this URL could not be found. Make sure that you have the right URL and that the owner of the spreadsheet hasn't deleted it.

edit ok the second ones fine, amazing ZH can stand up to the load and Google can't, awesome job with the site Tyler.

EagleProjets's picture

I done a little calculation and 34.8% goes ouside U.S border. :)

PragmaticIdealist's picture

34.8% of the total value to 467 foreign banks (under 3% of all banks)

PragmaticIdealist's picture

34.8% of the total value to 467 foreign banks (under 3% of all banks)

cswjr's picture

Looks like $2.76 trillion to Dexia -- a banking consortium.  Another $2.56T to Depfa -- a German-Irish bank out of Dublin.  Next highest is Bank of Scotland at $42.8 billion.

That's total borrowing, occurring over many transactions in the first two instances.  Still, that's insane.  Depfa I understand the funding needs.  I wonder what Dexia's deal was.


Ying-Yang's picture

Good catch cswjr,

The Irish and Scottish banks caught my eye too. We know Ireland is a tax haven for offshore profits is it a stretch that the FED had to keep global corporations' investments in Ireland whole?

Amish Hacker's picture

I think the answer is yes, if by "investments" you mean derivative contracts to which Irish and Scottish banks were shaky counterparties.

Caviar Emptor's picture

Dexia was threatened when germany's Hypo Real Estate was taken under by the government. That set off a chain of dominos across Europe, especially in Ireland, Iceland and Belgium. 

The scale of the discount window borrowings was dwarfed by the Fed's emergency programs which supplemented the discount window. 

Taken together this was nothing short of a Marshall Plan scale bailout. Conducted outside the system of checks and balances of the US government. But instead of going toward reconstructing a country it all went to patching up failed banks without reforms and without allowing new entrants, ideas and competition to reinvigorate the system. 

These unsurprising revelations only underscore that there really is an international cartel of bankers who bonus themselves just by buying up each other's worthless paper

blindfaith's picture



The Federal Reserve, all its members and associates are....traitors

Criminal charges must be brought to bear or this government is an accomplice. 

 Knowingly or unknowingly, the FED declared a war against the American people, and the safety and security of the solvency of America for the benefit of FOREIGN interests. 

This is an enemy more dangerous than any our citizens have ever faced in any war at any time.

They betrayed us like spys, sold us like slaves, lied to us, and intend to bankrupt the USA, and criple its citizens...just what an real enemy would do.

We put bank robbers in jail, don't we?  These criminals in banks and wall street are robbers, no less. 

Justice must be done.  I call on you Mr President, the watchdog of the nations interests, to do what we the people expect and demand you to do...protect this nation from enemys.

rocker's picture

The Morgue's Jamie Diamon wants to let you know how he feels about this. Last week he said we seem to do this every 5 to 7 years.  Anybody counting.  Prediction: He will be a future FED Chairman. That's the reward a crook gets. I could not agree more. When will we put them in jail? 

Encroaching Darkness's picture

Wow, it bogged down immediately. Thanks for the second link, get to it shortly.

Appreciate good info currently delivered; fabulous job, Tyler!

I can see the darkness so much more clearly now....

blazen's picture

excellent job

BTW did you notice (while reading the spreadsheet) message popping up EVERY half a second or less (at the time I'm writing this) "SHARING anonymous user XXXXXX opened this spreadsheet", XXXXXX being random anon-user id assigned by google ? America must be educating itself pretty intensively. I would pin that post to ensure even more education for a few next days

blindfaith's picture

No it is not a random ID.  Everyplace you go on the net leaves a cookie, some permanent some not, or your individual Intel chip number has been logged from your computer thru your ISP.  There is no such thing as anominous...look at the ADs right here on ZH...ever wonder why ads for some business near you is popping up?????

SolidSnake961's picture

trillions of dollars and noone in the msm even mentions this???

Dolar in a vortex's picture

Wow, thanks to who ever did the work.

ss123's picture

Haven't been able to get past the first page of the spreadsheet yet, but I already see a lot of JPM and Bank of NY.

Let me guess, JPM used the money for Bear Stearns and Lehman mostly... according to them.

Tyler Durden's picture

A lot of the JPM and BoNY borrowings are for Tri-party repo, to subsequently lend out money to PDCF facility borrowers (named in Borrower 2 column). JPM and BoNY are the only two tri party clearers.

jkruffin's picture

So, is this why the FED claims no knowledge of who got what, when , why and how? They just filtered trillions to a couple crooks like JPM, BNYM, GS and let them funnel it down?  I'm not sure I totally understand this Tri-party repo deal.

JonNadler's picture

SO JPM and BoNY were making a  profit passing the money they were getting at zero %?


Was all this money repaid? Do we know how long it tokk to pay it back?


Inquiring sheeple want to know

Goatboy's picture

Using Google Refine could make something useful out of this.

Judge Judy Scheinlok's picture

"Since the flood of requests appears to have taken down Google Docs"

Or the CIA realized what document they were hosting...

ss123's picture

Managed to grab the Excel download ok. Try that.

knukles's picture

I'll bet the under.  No flood, rain, storm, snow, heat, cold, hail, sleet.... they gots lots of computing power.... especially when they need it.

And remember, within hours of the "attack" on Google by the Chinese, Hillary herself was standing tall in the saddle defending... Google... on the basis of free speech.  No other ISP... just Google.  I can connect the dot.