[open-economics] Credit union failures

[Velichka Dimitrova]

Hey Anders,

That's great, I think with these columns we could generate a similar
visualisation - it is not too much or too detailed information.

As about the list provided by the EBA, do you know of any previous
versions, which can help us identify discrepancies - banks which were
listed earlier but did not appear in the list as of June 2012?


On Mon, Dec 10, 2012 at 8:46 PM, Anders Pedersen <anderspeders at gmail.com>wrote:

> Hi All,
>
> I agree that the spreadsheet is a bit crowded. We have lots of columns and
> many of them are still incomplete.
>
> At the Open Interest day in London, we discussed some ideas for
> visualizations - like this one:
> http://graphicsweb.wsj.com/documents/Failed-US-Banks.html.
>
> For such a visualization we would need data on these columns. As
> suggestedI have updated these with *a star * *in the googledoc:
> "Date of failure"
> "City and country of operation"
> "Home country"
>
> With regards to amounts, it is difficult to find reliable data on
> bailouts, state aid and government losses. I would suggest that we use the
> size of the bank as the indicator. In the tracker we have a columns named:
> "Total assets of balance sheet of bank at time of failure."
>
> We would then be able to generate a chart indicating some proportional
> differences between the size of the failures (ie. local credit union vs.
> RBS).
>
> The link for the Failed Bank Tracker is still:
>
> https://docs.google.com/spreadsheet/ccc?key=0AkitojFFyvjCdC1lcmRhRU9WWExSdmJ6OFpySExzb3c#gid=0
>
> Finally, in other bank news, the EBA has finally published the first list
> of registered "credit institutions" within the EU. The full list of some
> +7,000 banks, registered with national financial regulators (like FSA) is
> available here:
> http://www.eba.europa.eu/Publications/credit-institutions-register.aspx
>
> Best,
> Anders
>
> On Sun, Dec 9, 2012 at 11:20 PM, Velichka Dimitrova <
> velichka.dimitrova at okfn.org> wrote:
>
>> Hey Anders,
>>
>> Since we have quite a lot of columns already, I am wondering whether we
>> could put a star for the fields which we definitely need for this type of a
>> visualisation, I guess this would be the date and the main city of
>> operation?
>>
>> Do we need the amount that the bank received in state aid / for how much
>> it was sold in a public auction? That would be the size of the bubble I
>> guess, but probably we won't be able to complete this information for all
>> entries?
>>
>>
>> On Mon, Nov 26, 2012 at 4:18 PM, Anders Pedersen <anderspeders at gmail.com>wrote:
>>
>>> Hi John,
>>>
>>> That is great!
>>>
>>> During this weekend at the OKFN Hackdays in London more joined the work
>>> got involved in the update of some the failed bank data.
>>>
>>> We were pointed us to this visualization, which could be a
>>> useful template for a European failed banks map:
>>> http://graphicsweb.wsj.com/documents/Failed-US-Banks.html
>>> (on the left side you can choose "Value of assets at time of failure")
>>>
>>> Based on this visualization we have added a new column to the data set
>>> called: "Total assets of the bank at the time failure". The purpose of this
>>> column would be to enable us to visualize the proportional differences of
>>> the individual bank failures (ie. the difference between Northern Rock and
>>> a tiny local bank). The source would ideally be a financial statement from
>>> the bank before its failure, like an annual report or a quarterly
>>> statement.
>>>
>>> Let me know what you think.
>>>
>>> Best,
>>> Anders
>>>
>>> On Mon, Nov 26, 2012 at 10:16 AM, John Levin <john at anterotesis.com>wrote:
>>>
>>>> about
>>>
>>>
>>>
>>> _______________________________________________
>>> open-economics mailing list
>>> open-economics at lists.okfn.org
>>> http://lists.okfn.org/mailman/listinfo/open-economics
>>> Unsubscribe: http://lists.okfn.org/mailman/options/open-economics
>>>
>>>
>>
>>
>> --
>> Velichka Dimitrova
>> Coordinator of the Open Economics Working Group
>> Open Knowledge Foundation
>> http://okfn.org | http://openeconomics.net
>>
>>
>>
>>
>>
>


-- 
Velichka Dimitrova
Open Economics Project Coordinator
Open Knowledge Foundation
http://okfn.org | http://openeconomics.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/open-economics/attachments/20121214/8364d18f/attachment-0001.html>