Get data from cells on a webpage

Pedroski · 01-18-2016, 09:16 AM

Don't know where to start with this one, so I thought I would ask here.

My son needs to get the data from the last column of this webpage for a project:

http://www.jisilu.cn/data/sfnew/#tlink_3

This column is dynamically updated. It seems to consist just of dates, like 2017-06-16 .

How to download/get just this column from the webpage??

Any tips? Maybe a bash script??

jdkaye · 01-18-2016, 03:38 PM

It would help if one could read Chinese. There may be an indication on the webpage about how to do what you want (or even just download the spreadsheet) but all this requires an ability to read Chinese. Do you or your son read Chinese?
jdk

Pedroski · 01-18-2016, 05:08 PM

Chinese is not the problem, we live here in Nanjing.

The thing is, I am not a computer person. I could probably do this in a Libre Office spreadsheet, but this a an html page, probably written using javascripts.

The dates are the times when bonds mature or come up for renewal.

Maybe you have a tip where I might better ask this question?

NGIB · 01-18-2016, 05:13 PM

Just highlight the data (start at the first column, hold down the left button and drag). When all is highlighted, right click and "copy", open a blank spreadsheet and hit "paste". Delete columns you dont want. Just did it, worked fine...

Pedroski · 01-18-2016, 06:12 PM

Thanks a lot, that's a good start! I'll tell him.

He's just doing some practical training in the winter break. The Shanghai Stock Exchange apparently closes at 11:30 until 13:00. In the break they play Texas Hold'em Poker. My son is an ace at that years of experience at pokerstars!