Download table to excel [Solved]

1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)
Loading...
Go back to All Questions Login or Register
Solved1194 views
0

Hi Cave, great Job on your site!

I would ask about if it’s possible with your tools, recover daily tables from this site: http://www.cmegroup.com/trading/equity-index/us-index/e-mini-sandp500_quotes_settlements_options.html and put on excel spreadsheets.

My problem is that there are 3 combobox:

Type: American options
Expiration: Jun 2016
Trade date: Friday, 26 May 2016

When change values in this combobox the table in the bottom obviously change.

How can capture all tables for every choices?

Thx in advance

0

These are your GET params:

For first link:
optid=133

Second link:
monthYear=EZM16
strategy=DEFAULT
tradeDate=05/26/2016
pageSize=500
_=146464944059

Just play with all configurations to learn how to set these values in the URL. You can download the results to Excel using HTTP Requests (see link below). Use Regex to extract data:
http://analystcave.com/excel-scraping-html-regular-expression-continued/

0

Hi Massimiliano,

for this page it is very easy indeed. Just look that the GET Params of the Web Page change, when you change any of the combo boxes. All you need to do is save all the GET Params alternative values and you can swap the values in the URL of the Web Page.

All you need to do is check how best to scrape the results – if a simple HTTP Request will do or if you need to do Browser scraping.

Simply the best place to learn VBA!

Error: Please enter a valid email address

Error: Invalid email

Error: Please enter your first name

Error: Please enter your last name

Error: Please enter a username

Error: Please enter a password

Error: Please confirm your password

Error: Password and password confirmation do not match