H
HC
Hello,
There is this page that lists out the past transaction records of houses:
http://proptx.midland.com.hk/unit/index.jsp?est_id=E00005 (it's in Chinese)
If you click on a particular house, the past transaction records of that
house is shown.
I want to be able to extract the past transaction data and make charts to
visualise the price trend of the houses. Now, I'm only able to use the
"stupid" method of clicking on all the houses and typing in manually the
transaction records in Excel and then chart the data.
I wish to be able to extract the data to Excel automatically. I have
studied the underlying jsp pages and it seems that the site uses
http://proptx.midland.com.hk/unit/unit_tx.jsp to show the data.
I have tried typing in
http://proptx.midland.com.hk/unit/unit_tx.jsp?unit_id=U000146982 to see any
information will come up, but there's nothing in the page.
I'm totally stuck. As I want to monitor the trend of a number of
developments, it will be very tedious to type up all the transactions in
Excel. It seems the website has sort of exposed the data, but I just can't
find a way to get the data out, at least one house at a time.
I want to do webquery in Excel and then extract the data to a proper table.
Hope some experts can point me in the right direction.
Regards and thanks in advance,
HC
There is this page that lists out the past transaction records of houses:
http://proptx.midland.com.hk/unit/index.jsp?est_id=E00005 (it's in Chinese)
If you click on a particular house, the past transaction records of that
house is shown.
I want to be able to extract the past transaction data and make charts to
visualise the price trend of the houses. Now, I'm only able to use the
"stupid" method of clicking on all the houses and typing in manually the
transaction records in Excel and then chart the data.
I wish to be able to extract the data to Excel automatically. I have
studied the underlying jsp pages and it seems that the site uses
http://proptx.midland.com.hk/unit/unit_tx.jsp to show the data.
I have tried typing in
http://proptx.midland.com.hk/unit/unit_tx.jsp?unit_id=U000146982 to see any
information will come up, but there's nothing in the page.
I'm totally stuck. As I want to monitor the trend of a number of
developments, it will be very tedious to type up all the transactions in
Excel. It seems the website has sort of exposed the data, but I just can't
find a way to get the data out, at least one house at a time.
I want to do webquery in Excel and then extract the data to a proper table.
Hope some experts can point me in the right direction.
Regards and thanks in advance,
HC