"Suumo Scraping Spreadsheet for House Search" that allows you to compare rent, initial cost, 2 year total cost etc simply by pasting the URL of the property you want to live

ByMatthew Trentacoste

Real Estate Information SiteSumoBy simply copying and pasting the URL of the property of the property, rent · management fee · deposit · key money · brokerage fee · key exchange etc. · renewal fee · 2 years total · initial cost · age of years · area · rent / square meters of the property A spreadsheet that makes it easy to create a comparison table isTofuHas been published by.

Suumo Scraping Spreadsheet for House Search - Fascinated with Tofu
http://tofu.hatenadiary.com/entry/2017/02/19/suumo-scraping

"Suumo Scraping Spreadsheet for House Searching" is a Google spreadsheet using web scraping. What is it like? Because it is easy to understand to actually use it, first click on the URL listed on the above web page.


Then it moves to the page like the following. URL · title · memo · rent · administrative expenses · deposit · key money · brokerage fee · key exchange etc. · renewal fee · 2 years total · initial cost · age of years · area · rent / square meter items are lined up, and spreadsheet The fourth line is editable.


By saying that,SumoLook for properties in your condition on.


If there is something I think is "good" ...


Copy and paste the URL of the property page to the first row of the fourth line.


Then, various kinds of information are reflected in the sheet, and the difference with the property immediately above is obvious at a glance.


Actually checking the former page of the URL, administrative expenses, common expenses, rents, security deposits, key money, etc. were reflected properly.


According to the author TOFU 2000, the calculation formula of each item of the spreadsheet is as follows.

rent

/ Div / 1 / div / 1 / div / div / div / 1 / div / 1 / div / 2 / div [ 1] / span ")," Ten thousand yen "," ")
Administrative expense

/ Div / 1 / div / 1 / div / 1 / div / 1 / div / 1 / div / 1 / div / 1 / div / Div [2] / span ")," administrative expenses and common expense "," ")," yen "," ") / 10000

Deposit

/ Div / 1 / div / 1 / div / div / div / div / 1 / div / 2 / div [1] / div [2] / div / div [ 1] / span [2] ")," Ten thousand yen "," ")

key money

/ Div / 1 / div / 1 / div / div / div / div / 1 / div / 2 / div [1] / div [2] / div / div [ 2] / span [2] ")," Ten thousand yen "," ")

Age

Div / div / div / div / div / div / div / div / div / div / div / 1 / div / ")
area

Div / div / div / div / div / 1 / div / 1 / div / 1 / div / 1 / div / 2 / div / 2] / text () ")," m "," ")

Brokerage fee

= Rent / 2 + 1.5
Rough formula read on some site

Renewal fee

One month's rent assumption

Key exchange etc.

I'm sorry I could not scrape, please grep me.
Insurance, cleaning fee etc ...

Total cost (2 years)

= (Rent + management fee) * 24 + security deposit + key money + brokerage commission (+ key exchange etc.)

Initial cost

= (Rent + management fee) * 2 + security deposit + key money + brokerage fee (+ key exchange etc.)
I also care about the total cost, but I'd like to know how much the initial cost is. It is said that it is roughly 4.5 months worth of rent. (Source unknown)

If you apply this calculation formula to create your own spreadsheet, copy & paste the sample spreadsheet etc., you can make a comparison table when deciding the house you want to live in.


In addition, as you paste the URL, it sometimes becomes "#VALUE!". This was because there was no description of administrative expenses etc due to the property and it was impossible to calculate the total cost and initial cost using management fee.


Also, as the scraping information disappears at the end of the flight period of the property, "It is recommended to copy and back up only the value if you want to look back later".