This page has been archived and commenting is disabled.
Excel Breakdown Of All Discount Window Users Between March 2008 - 2009
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
»
- 26744 reads
- Printer-friendly version
- Send to friend
- advertisements -
+$26,000,000,000,000
I second Chindit13 on your nomiprins.com suggestion, way to go Escrava.
Big Ugly Numbers. Where did all that money finally land? In bankster's pockets?
Check Nomi out in "Plunder,the crime of our time" (which is a MUST watch) She's incredible, Hulkster's in love, hope she likes green! (which apparently she does)
http://plunderthecrimeofourtime.com/
I spent less than 10 minutes looking at this and cant take any more today. Truly overwhelming. Book marked and will have another go at it tomorrow. Gonna shut down the computer and take a walk.
August 1988 - Ron Paul on Federal Reserve
http://www.youtube.com/watch?v=Fhop1Xl_0dY
Nice work Tyler! Double dip is very near.
Excellent clip. Thank you!
Bill Cooper was on to these guys a LOOOONG time ago. Worth a listen....
http://www.youtube.com/watch?v=FIlTHmE9e_c
Lend freely, on any collateral, at below market rates. The Bernak Rule
WHAT ARE YOU PREPARED TO DO?
The thing about Ron Paul is that when he questions the Fed (Bernanke) with, what appear to be off the wall, bizarre questions and allegations, he many times comes across as a kook/conspiracy theorist... and then, magically, the fucking questions turn out to be rooted in reality!
Reality really is stranger than fiction when it comes to the Fed/Wall Street/Bernanke/TT Timmy/Congress, etc.
agreed.
This is one of my favorite clips (never seen the Bernank lie worse):
http://www.youtube.com/watch?v=ncw39IADHa4
Ron asks Benocide direcltly about intervention in Europe during the crisis in Greece, asks about FED invovled in buying debt or taking part discussions with foreign central banks.
Turns out, exactly like you said, VERY MUCH SO ROOTED IN REALITY.
Good work. Hopefully Ron Paul has this spreadsheet now.
...FUCK YOU BEN BERNANKE...
Just incase he reads zerohedge
Billy Ray Valentine: Yeah. You know, it occurs to me that the best way you hurt rich people is by turning them into poor people.
Coleman: You have to admit, sir, you didn't like it yourself a bit.
When I was growing up, if we wanted a Jacuzzi, we had to fart in the tub.
END THE FEDERAL TREASON RESERVE
ROAST ITS CONTENTS.
Sounds tasty.
I remember watching this thing for almost all of 2008 and it would be a huge thing when it would print 12 billion on a day. Mostly it would hover in the 7 to 8 billion range but during holidays and emergencies it would pop 10 and 12 billion in one day. Those were the good old days.
http://www.321gold.com/fed/temp_bank_res.html
Awesome job to the crowdsourcers for putting this together and to TD for making it happen.
When the documents came out from the Fed, it felt like an unusable 'big data' dump that said, "FU, here's your data; good luck figuring it out."
Well, we're figuring it out.
I hope someone will be able to make the link with the failed banks and the +1000 banks that have been put on the watch list.
I assume that this would indicate some of their failed attempts to keep the banking system going.
jal
Guys, this is just the first appetizer if you look back in ten years. The worst is yet to come before the WWIII gets started.
NO WAY…
ARAB BKG CORP NY BR
Went to the window 35 times,
Total Loans: 14,305,000,000
“The Central Bank of Libya owns 59.3% of ABC and the Kuwait Investment Authority has a 29.6% stake in the bank. “
Arab Banking Corporation not subject to asset freeze by US or UN
http://www.arabbanking.com/En/AboutABC/Media/Press/Pages/ArabBankingCorporationnotsubjecttoassetfreezebyUSorUN.aspx
Board of directors.
http://www.arabbanking.com/En/AboutABC/Management/Pages/Directors.aspx
And it just gets more hilarious when you hear how the Libyan rebels already established a "new central bank of libya".
What's Wrong With The Capitalistic System ?
There is so little understanding of how shareholders vote, and who votes their shares and the inter-relationship between the Board of Directors of U.S. Companies, that the average citizen who may indeed hold shares in company's like TransOcean that they don't even know where to start to correct the problem. And the sad thing is that the lack of education on these matters is by design.
So in other words, the top executives are somehow protected from liability, the company may loose and be sued and fined but because it is a serperate entity it does not translate through to the EXECUTIVES and they are protected by various laws and liability insurance, EVEN THOUGH they were the ones who made the DECISIONS that Created the DISASTER, everyone, including the public, taxpayers, the shareholders loose, and yet they benefit handsomely ?
*******************************************
Transocean hails ‘best year’ in safety, gives execs bonuses, despite Gulf spill Tags:The company that owns the now-infamous Deepwater Horizon, the oil rig that caused immeasurable damage to the Gulf, recently applauded itself for the "best year in safety performance in our Company's history." The company, Transocean Ltd., rewarded its executives millions in bonuses for the achievement, according to the annual report it released yesterday.
Lawl just $15,760,004,161,955 in 1 year?!? Must love digital age!
How much interest does FED charge? Lets quicly calculate how much money they "made" off these loans.
Sun blaster. You should spend more time using your fine mind, as opposed to deficit spending.
I'll let people more interested and much smarter about these things examine the data. My take away Tyler's reportage is that a big chuck of the world's financial system teetered on the verge of collapse, and the FED stepped in. The alternative, at that moment was, do nothing and massive world wide bank failures? Who wants to be responsible for that, or that chaos that ensues?
I separated out those with FORI tag (foreign banks). Then I sorted those by name, then added up the totals for each. Here they are.
ALLIED IRISH BKS NY BR...........................5,000,000
ARAB BKG CORP NY BR......................14,305,000,000
BANCO ITAU SA NY BR............................98,000,000
BANCO SANTANDER SA NY BR.................485,000,000
BANK OF CHINA NY BR...........................523,189,000
BANK OF MONTREAL CHICAGO BR.............385,000,000
BANK OF NOVA SCOTIA HOU BR...................1,000,000
BANK OF NOVA SCOTIA SF AGY................796,000,000
BANK OF SCOTLAND PLC NY B..............42,800,000,000
BANK OF TAIWAN LA BR............................31,000,000
BAYERISCHE LANDESBANK NY BR...............500,000,000
CALYON NY BR...................................6,000,000,000
CATHAY UNITED BK LA AGY.......................80,000,000
CHANG HWA CMRL BK LA BR....................204,000,000
CHIBA BK NY BR...........................................10,000
COMMERZBANK AG NY BR....................12,352,800,000
COMMONWEALTH BK OF AUS NY B.............100,000,000
DEPFA BK PLC NY BR......................2,552,830,000,000
DEXIA CREDIT LOCAL NY BR............2,762,625,000,000
DNB NOR BK ASA NY BR................................500,000
E SUN CMRL BK LA BR................................6,500,000
ERSTE BK OESTERREICHISCH NY BR.......5,900,000,000
ERSTE GROUP BK NY BR......................14,930,000,000
EUROHYPO AG NY BR................................12,000,000
FIRST CMRL BK LA BR..............................139,500,000
FIRST CMRL BK NY AGY..............................40,000,000
FORTIS BK SA/NV NY BR.........................7,509,000,000
HSH NORDBK AG NY BR..........................8,787,000,000
HUA NAN CMRL BK LA BR...........................111,000,000
INTESA SANPAOLO SPA NY BR.....................140,000,000
LAND BK OF TAIWAN LA BR.........................343,000,000
LANDESBANK HESSEN-THURIN NY................650,000,000
LANDESBK BADEN WUERTTEMB NY.............8,085,000,000
LLOYDS TSB BK PLC MIAMI AGY............................2,000
MEGA INTL CMRL BK CO NY BR....................130,000,000
MEGA INTL CMRL BK LA BR.........................103,065,000
MITSUBISHI UFJ TR & BKG NY BR..........................1,000
NATIXIS NY BR.........................................100,000,000
NORDDEUTSCHE LANDESBANK NY......................100,000
NORINCHUKIN BK NY BR.........................26,001,000,000
ROYAL BK OF SCOTLAND PLC NY B............15,500,000,000
SHINKIN CENTRAL BK NY BR.....................3,080,000,000
SUMITOMO MITSUI BKG NY BR.......................10,000,000
SUMITOMO TR BKG NY BR...............................3,000,000
SVENSKA HANDELS AB PUBL NY BR...................1,000,000
TAIWAN CO-OP BK SEATTLE BR......................24,000,000
p.s. Thanks for the tip Ying-Yang.
But we have to be careful totalling up the loans for a single entity.
Check the due date, in many cases it is a day later and you get the same amount the next day; looks like they are rolling over loans to a new one each day.
(see Royal Bank of Scotland 7 - 8th Oct 2008)
Love and Rockets - Yin and Yang and the Flowerpot Man
thanks!
Question Tyler. Can we tie any of this recent data dump to the US funding of Libyan rebels?
http://www.foxnews.com/us/2011/03/11/approved-40-billion-200-private-arms-sales/
There is more behind my question. Wish to start here first.
How many banks that received these loans defaulted on them and what was the total amount of the defaults?
Everybody already knows that the system is a joke, and Bernanke a crook.
But as long as the average American gets his daily dose of fluoride, Justin Bieber and Victoria's Secret shows, he will gladly keep voting for the current 'elites' and place them in total, absolute control...
*LOL*
Nerdy libertarians need to deal with it. Nothing's ever going to change.
I'm ready to bet $10k that a new puppet Democrat/Republican will be elected in 2012, and that the Ben Bernank will end his life in tranquillity, wealth and freedom.
Learn it, love it, trade it.
And now that we have all this information...Bitch, bitch, bitch a bit more and nothing gets done.
Bitch, bitch bitch
Call me when the fight starts.
Yeap, all the dog and pony show and nothing is being done to restore order. Time to hang the bastards and their family to restore order and return the loot to the people they stole from. Citizens of USA.
"If the American people ever allow private banks
to control the issue of their money,
first by inflation and then by deflation,
the banks and corporations that will
grow up around them (around the banks),
will deprive the people of their property
until their children will wake up homeless
on the continent their fathers conquered.
Thomas Jefferson
When we take your government cheesewizz away, we expect you to become part of this solution. This is how it will happen... we are going to take the socialism out of your life & you will squeal like the banking pig's.
You will be contacting us first.. Bitching about something???
"This is how it will happen... we are going to take the socialism out of your life & you will squeal like the banking pig's."
Yes we can ;-)
Does anyone have an in particular analysis they want done but don't have the tools? I'm a stat programmer but in pharma, not finance - so I wouldn't know what to look for. But if you point me in a direction, I could upload into my system and see what I can find.
It's interesting to see how many withdrawals by the major banks are in nice round numbers, to the nearest 500 million or so. No specific need or allocation, just another slug of cheap cash for – oh, whatever short term speculative investment opportunity comes along.
it really is as bad as we thought
"Everybody already knows that the system is a joke, and Bernanke a crook.
But as long as the average American gets his daily dose of fluoride, Justin Bieber and Victoria's Secret shows, he will gladly keep voting for the current 'elites' and place them in total, absolute control..."
And food. Don't forget the food. As long as most of the western world has food on the table (entertainment and some sort-of health care option), then they will not cause a stir. As long as the majority has these things, food, entertainment, reasonable health, then they will not revolt, they will not vote for change. Educated people who see the fraud and corruption for what it is, will only be pissing in the wind, and might actually be cast as villians if the monetary system comes crashing down (serious deflation) and food becomes scarce. As things are going, as long as there is no hyper-inflation in the U.S. (not yet), then the masses will be ok with the corrupt FED/Gov/Banks. I don't like it, you don't like it, but if money printing and pocket-lining keeps the "system" afloat (even if just barely), then there will be no changes/revolt. I don't think it can last, but it has lasted A LOT longer than most would have expected.
you are way too naive to consider a system as corrupted as this could be changed by a Voting system. Barring a revolution, NOTHING will change!
My thoughts exactly! Any vote, no matter which party, is a vote for the status quo.
Now comes the sorting. Someone with time on their hands will do it for us lazier types please.
This request is above my aptitude. Can someone pull together all the banking data to show contributors. My angle; US Executive, Legislative, and Judical connections on personal funding contributions within the Central Bank Ponzi scam.
Your help will be greatly appreciated.
http://www.guardian.co.uk/world/2011/apr/03/us-bank-mexico-drug-gangs
How a big US bank laundered billions from Mexico's murderous drug gangsAs the violence spread, billions of dollars of cartel cash began to seep into the global financial system. But a special investigation by the Observer reveals how the increasingly frantic warnings of one London whistleblower were ignored
....
"Wachovia had my résumé, they knew who I was," says Woods. "But they did not want to know – their attitude was, 'Why are you doing this?' They should have been on my side, because they were compliance people, not commercial people. But really they were commercial people all along. We're talking about hundreds of millions of dollars. This is the biggest money-laundering scandal of our time.
"These are the proceeds of murder and misery in Mexico, and of drugs sold around the world," he says. "All the law enforcement people wanted to see this come to trial. But no one goes to jail. "What does the settlement do to fight the cartels? Nothing – it doesn't make the job of law enforcement easier and it encourages the cartels and anyone who wants to make money by laundering their blood dollars. Where's the risk? There is none.
"Is it in the interest of the American people to encourage both the drug cartels and the banks in this way? Is it in the interest of the Mexican people? It's simple: if you don't see the correlation between the money laundering by banks and the 30,000 people killed in Mexico, you're missing the point."
Woods feels unable to rest on his laurels. He tours the world for a consultancy he now runs, Hermes Forensic Solutions, counselling and speaking to banks on the dangers of laundering criminal money, and how to spot and stop it. "New York and London," says Woods, "have become the world's two biggest laundries of criminal and drug money, and offshore tax havens. Not the Cayman Islands, not the Isle of Man or Jersey. The big laundering is right through the City of London and Wall Street.
"After the Wachovia case, no one in the regulatory community has sat down with me and asked, 'What happened?' or 'What can we do to avoid this happening to other banks?' They are not interested. They are the same people who attack the whistleblowers and this is a position the [British] Financial Services Authority at least has adopted on legal advice: it has been advised that the confidentiality of banking and bankers takes primacy over the public information disclosure act. That is how the priorities work: secrecy first, public interest second."
....
$100B to australia, tks buddies. when your dollar is completely shot we might repay it.
http://www.reuters.com/article/2011/03/31/us-usa-fed-lending-europe-idUSTRE72U6NJ20110331
Dexia, Depfa woes led them to seek Fed loans(Reuters) - European banks Dexia and Depfa made some of the worst possible business decisions, including forays into bond insurance, and were forced to repeatedly ask the Federal Reserve for emergency loans at the height of the financial crisis.
According to Fed data released on Thursday, loans to the two foreign banks accounted for nearly half of all borrowing on October 29, 2008, the day that central bank's discount window lending peaked at $111 billion.
Franco-Belgian Dexia and Dublin-based Depfa, a subsidiary of German-based Hypo Real Estate, continued to tap the Fed's emergency facilities for billions of dollars in short-term loans weeks after they were bailed out by the European governments in the fall of 2008.
At the time, Dexia was the world's largest lender to municipalities and owned a U.S. bond insurance subsidiary, Financial Security Assurance, which guaranteed riskier securities linked to subprime mortgages.
Short-term financing problems at Depfa, which also specialized in government and infrastructure lending, forced its parent, Hypo Real Estate, to seek help from the German government.
Both Dexia and Depfa borrowed at short-term rates to finance long-term lending and ran into problems when credit markets froze.
Dexia even had exposure to Bernard Madoff's $65 billion investment fraud, though that was indirectly through partially collateralized lending operations to funds that were exposed to Madoff investments.
Dexia has since sold its bond insurer to Assured Guaranty Ltd.
(Reporting by Rachelle Younglai; Editing by Padraic Cassidy)
http://ftalphaville.ft.com/blog/2011/03/25/527911/florence-and-the-derivatives-machine/
Florence and the derivatives machine [updated]Posted by John McDermott on Mar 25 19:27.
....
Between 2001 and 2008, 525 Italian municipalities conducted 1,000 interest rate swaps valued at a total of €35bn — corresponding to about one-third of total Italian municipal debt. FT Alphaville and the FT took a long look last year at Italy’s history of using these derivatives to try to lower borrowing costs.
The problem: when eurozone rates rose, municipalities borrowing costs rose, too. Cue funding difficulties. The additional, alleged problem: banks not adhering to their fiduciary duties when selling these complex problems. A familiar story.
But unlike, say, the city of Milan, which took four investment banks to court over the allegedly fraudulent sale of interest-rate swaps, Florence took a different step and, like Pisa, just stopped paying.
http://blogs.ft.com/money-supply/2011/03/31/who-used-the-feds-discount-window/
March 31, 2011 6:16 pm by Robin Harding 1 1We’re working our way through the Fed’s data dump but our crack coding team have extracted enough that we have a sense of the big users of the discount window. CAUTION: We can’t vouch for the complete accuracy of this scrape.
The biggest day for the discount window was the 29th October 2008 when lending stood at $110bn. Here’s who had the money:
dexia credit local ny br .. 26.5 b
depfa bk plc ny br .. 24.6 b
wachovia bk na .... 15.0 b
etc... see link
Just proves the point that fiat money is not worth the cotton it is printed on. More zero's please...
I am moving at least half my toilet paper money into PM's immediately.
remember there is a big difference between a note
in hand vs a bank credit...hence bank runs... should
things develop along those lines. and negotiation
is essential.
We're going to catch these (2) Two anti democracy fellas in the 69 position.
http://www.soros.org/newsroom
http://www.mauricestrong.net/
How you ask? Monies that were sent to politicians that you voted for. This is global, not isolated to the EU, UK or US.
The Central Banking computer forensics will be the white rabbit.
Thrill Kill Kult - A Daisy Chain 4 Satan
http://www.youtube.com/watch?v=uN0yI-ambNY
Some people live on the government drug.
Considering that the official story is that "foreigners" buy more than 40% of US Treasuries. I have no problem the Fed gave them emergency loans.....
The question is Whose emergency was it?
I’m not really sure what’s news or surprising here, why this seems to be raising the temperature (or the fact that a random 171 banks borrowed a whopping $1,000)??? We know the Window has been active the past few years, the TBTF have been frequent participants, that foreign banks are borrowing…. If you didn't realize it, foreign banks with domestic branches are allowed by law to borrow at the window *
I enjoy ZH. A lot. But this constant look under the bed for some boogie man is getting old. The villain is right in front of you, not hidden in Bernanke’s beard or the Fed’s balance sheet.
Where are the articles focused on the subtleties of ‘financialization’, the REAL boogie man in the room??? Everyone needs to put down what they’re reading and pick-up material like “The Death of Capital” (for starters) and maybe the tone of the discussion around here will change a bit. Eye’s forward, folks. Stop looking under your bed for bad guys as the issues and solutions are just not that easy. Stop yelling about how gold is going to save you. Get a real, fundamental grasp of the problem that creates a situation like TBTF, the Fed, the fact that since the 1940s, the share of national income coming from manufacturing has declined by approx. two-thirds while the share attributable to FIRE (finance, insurance and real estate) has doubled....
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
* 4. Eligibility to Borrow
By law, depository institutions that maintain reservable transaction accounts or nonpersonal time deposits (as defined in Regulation D) may establish borrowing privileges at the Discount Window. Eligibility to borrow is not dependent on or related to the use of Federal Reserve priced services.
U.S. branches and agencies of foreign banks that hold reserves are eligible to borrow under the same general terms and conditions that apply to domestic depository institutions. Foreign banks with more than one branch or agency operating in the United States may have access to the Discount Window in more than one Reserve District. Any Discount Window loans to those branches or agencies will be made by the Reserve Banks where the borrowing branches or agencies maintain accounts. Reserve Banks coordinate and monitor lending to such branches and agencies on a nationwide basis.
Bankers' banks, corporate credit unions, and other financial institutions are not required to maintain reserves under Regulation D, and so do not have regular access to the Discount Window. However, the Board of Governors has determined that such institutions may obtain access to the Discount Window if they voluntarily maintain reserves.
Ah yes- 2005 counter party price squeeze losses on defaulted foriegn bonds used for physical delivery. I wonder if those assets went off at full face at the discount window years later?
Thanks so much for making this data accessible! I was about a third of the way through it when I saw that it was already compiled by the wonderful people at Zero Hedge.
Do you know whether any of the loans in this Excel data are TAF or TSLF funds in disguise? I admit that I know very little about TAF and TSLF, I just knew that info on the programs was to be released in the PDFs.
Thanks!
His mother was, so he could have been born is fucking Iran and he'd still be american. Wake the fuck up...
bad credit personal loans