Thread: How i get data from following web source to excel sheet

https://www.theice.com/marketdata/re...rtCenter.shtml

I need data of daily settlement of Cotton No.2 from above website to excel sheet i mentioned following page source code kindly help me thanks in advance.

CATEGORY NAME is DAILY SETTLEMENTS <option value="18" selected="true">
MARKET NAME is ICE FUTURE U.S. <option value="NYB" selected="true">
REPORT NAME is ICE FUTURE U.S. <option value="102" selected="true">
PRODUCT CODE is COTTON NO.2 <option value="CT">
THEN CLICK SUBMIT BUTTON and REQUIRED DATA will come automatically.

<form id="rForm" name="rForm" action="/marketdata/reports/ReportCenter.shtml" method="post">
<label for="categories"> <select id="categories" name="categoryId">
<option value="18" selected="true">
<select id="markets" name="marketName">
<option value="NYB" selected="true">
<select id="reports" name="reportId">
<option value="102" selected="true">
<select name="commodity.commodityCode">
<option value="CT">
<input name="iceFuturesUs" value="Submit" type="submit"/>

Hi,

I followed your advice and ran the report. Once it generated I highlighted it, opened an Excel sheet, copied the report and on Excel went Paste Special and chose HTML. That did the trick. If you then do not want the website format on the Excel sheet, you can copy that report and go Paste Special and choose Values. I have attached the sheet to show you.

Hope this helps

I followed your advice..

What advice are you referring to? Hopefully you both haven't been discussing this outside of the forums....