«

»

Jan 06

Database of HDB resale flat prices in Excel format

Is anybody interested in a table containing HDB Resale Transactions listings, but made in Excel and including 140.000+ flats transacted last 6+ years?

FREE sample containing transactions listings for ONE town + Most expensive flats + Statistics

Buy the complete database with 26 towns

Each package contains 3 files:
Original: 26 sheets, 1 flat = 2 rows (as copied from HDB website).
Enhanced: 26 sheets, 1 flat = 1 row, added colors, filter and sort macros.
Enhanced & towns merged: one sheet containing all 26 towns.
Partial purchases (transactions of one town) can be arranged, just contact me!

Database with HDB resale transactions since April 2008 to December 2013, contains 149930 records. Data copied from HDB website (this job took about 20 hours) and compiled in Excel for purpose of research and analysis. More details.

Add to cart

Database with HDB resale transactions since July 2012 to December 2014, contains 43329 records. Do you want to have it updated to current month? Contact me and I will copy additional months for additional fee of $50. More details.

Add to cart

Why I made this HDB database and selling it?

On 1 April 2009, HDB improved its Resale Flat Prices e-service, now showing last 1 year instead of last 3 months, also added flat model beside floor area.
I copied the listings for 1 year (April 2008 – March 2009) in Microsoft Excel, initially just for purpose of personal analysis, for example estimate average apartment size nationwide and per town, and showing the results of analysis in HDB Statistics page. Later I decided to update the database regularly.

I have posted it for sale on website in August 2012 because, while monitoring website traffic, I noticed 2 people searching on Google exactly the text shown on HDB Statistics page “I copied HDB Resale Transactions for one year in Microsoft Excel to make calculations”, probably they were trying to find the original Excel file, or possible other source of Statistics page (thinking that the Statistics were not mine but copied from elsewhere). The only way to get the Excel was to contact me.
So, some people may be interested in it, I posted the Excel database for sale.

I am aware that the XLS table can be used by agents for a detailed analysis of HDB flat prices drop and rise, which is not possible in web version, or it can be even converted to CSV or SQL and used in websites by people who intend to make profit.
Due of the size of database, Microsoft Excel runs slowly, I am spending about 20 hours each time I update the XLS file, regardless if I update every month or once per year. Time is money!
So I am selling it at a price that may be out of reach for private people. Update frequency depends by you, if you want frequent updates you should pay my time.
If you want just to view HDB flat prices (but only for last 1 year), you can do this for FREE on HDB website.

Note: HDB changed its e-service on 10 March 2014, now showing Resale Registration Date instead of Resale Approval Date, causing flats to jump from one month to another, some prices are different, also the storey is shown in ranges of 3 floors instead of 5. This cause some incompatibilities with previous database.
So I decided to sell the database April 2008 – December 2013 (149930 records) and start a new database 2013-present, overlapping 1 year (23476 records as July 2014).
Feel free to combine them if you want to have a messy database.

1 comment

3 pings

  1. printing books

    Howdy! Would you mind if I share your blog with my zynga group?
    There’s a lot of folks that I think would really enjoy your content.
    Please let me know. Thank you

  1. HDB interesting facts, crazy things less known about HDB | Teoalida's Website

    […] HDB Database of resale flat prices […]

  2. Singapore HDB Statistics, facts & figures | Teoalida's Website

    […] HDB Database of resale flat prices […]

  3. HDB history, photos and floor plan evolution 1930s to 2010s | Teoalida's Website

    […] HDB Database of resale flat prices […]

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>