UPDATED post to add note at bottom that alerts that Excel 2007 required to manipulate data in Excel file; also included link to download compatibility pack from Microsoft to allow viewing of file in earlier version of Microsoft Excel.
I went back and found additional HECM data available on the HUD Neighborhood Watch website. (My earlier post on Oregon HUD/FHA HECM data now available is HERE).
To illustrate the kind of HECM data available HERE is a new Excel worksheet with HUD/FHA HECM loan level data for all lenders with more than 100 loans from April 1,2007-March 31, 2008 (This includes ALL Oregon cities (not just MSA's). The six lenders with more than 100 loans during this period accounted for about half of all 2,306 HUD/FHA HECM loans endorsed in Oregon.
The first worksheet in the Excel workbook is a pivot table which shows loan counts by city. If you double click the "count" number in the second column, a new worksheet is created showing the loan level detail for all loans in that city, including interest rate, and the value range of the loan.
The last worksheet in the Excel workbook is a summary worksheet (no loan level data available) that shows the total loans by lender for the one year April 07-March 08 period).
NOTE: To manipulate data in file you need Excel Office 2007. If you use an earlier version of Excel you MAY be able to use the free MS compatibility pack to view this document. More information on the compatibility pack from MS is HERE.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment