Results 1 to 4 of 4

How i get data from following web source to excel sheet

Threaded View

  1. #1
    Registered User
    Join Date
    11-03-2011
    Location
    KARACHI
    MS-Off Ver
    Excel 2003
    Posts
    3

    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"/>
    Last edited by MJI; 11-14-2011 at 01:28 PM. Reason: wrong explanation

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1