DATA EXTRACT FROM WEBSITE(s)

  • http://www.czce.com.cn/portal/…/datawhsheet/20140508.htm


    [TABLE="class: table, width: 800, align: center"]

    [tr]


    [TD="class: td-right, align: right"]126[/TD]
    [TD="class: td-right, align: right"]4[/TD]

    [/tr]


    [/TABLE]



    http://www.barchart.com/commod…232_Futures/CT?search=CT*


    JUST 9 COLUMNS and 9 ROWS only


    [TABLE="class: datatable js, width: 100%"]
    [TR="class: datatable_header"]
    [TH="class: ds_futures--contract sort_none, align: left"]Contract[/TH]
    [TH="class: ds_last sort_none, align: right"]Last[/TH]
    [TH="class: ds_change sort_none, align: right"]Change[/TH]
    [TH="class: ds_open sort_none, align: right"]Open[/TH]
    [TH="class: ds_high sort_none, align: right"]High[/TH]
    [TH="class: ds_low sort_none, align: right"]Low[/TH]
    [TH="class: ds_previous sort_none, align: right"]Previous[/TH]
    [TH="class: ds_volume sort_none, align: right"]Volume[/TH]
    [TH="class: ds_displaytime sort_none, align: right"]Time[/TH]
    [TH="class: ds_links sort_disabled noprint, align: center"]Links[/TH]
    [/TR]

    [tr]


    [TD="class: ds_futures--contract qb_shad, align: left"]CTY00 (Cash)[/TD]
    [TD="class: ds_last qb_shad, align: right"]88.05s[/TD]
    [TD="class: ds_change qb_shad, align: right"]+0.50[/TD]
    [TD="class: ds_open qb_shad, align: right"]0.00[/TD]
    [TD="class: ds_high qb_shad, align: right"]88.05[/TD]
    [TD="class: ds_low qb_shad, align: right"]88.05[/TD]
    [TD="class: ds_previous qb_shad, align: right"]87.55[/TD]
    [TD="class: ds_volume qb_shad, align: right"]0[/TD]
    [TD="class: ds_displaytime qb_shad, align: right"]05/08/14[/TD]
    [TD="class: qb_shad noprint, align: center"][Blocked Image: http://www.barchart.com/shared/images/quote_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/chart_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/opinion_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/options_icon.gif][/TD]

    [/tr]


    [tr]


    [TD="class: ds_futures--contract qb_line, align: left"]CTN14 (Jul '14)[/TD]
    [TD="class: ds_last qb_line, align: right"]93.63[/TD]
    [TD="class: ds_change qb_line, align: right"]+0.58[/TD]
    [TD="class: ds_open qb_line, align: right"]93.05[/TD]
    [TD="class: ds_high qb_line, align: right"]93.65[/TD]
    [TD="class: ds_low qb_line, align: right"]92.92[/TD]
    [TD="class: ds_previous qb_line, align: right"]93.05[/TD]
    [TD="class: ds_volume qb_line, align: right"]289[/TD]
    [TD="class: ds_displaytime qb_line, align: right"]02:25[/TD]
    [TD="class: qb_line noprint, align: center"][Blocked Image: http://www.barchart.com/shared/images/quote_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/chart_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/opinion_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/options_icon.gif][/TD]

    [/tr]


    [tr]


    [TD="class: ds_futures--contract qb_shad, align: left"]CTV14 (Oct '14)[/TD]
    [TD="class: ds_last qb_shad, align: right"]84.44s[/TD]
    [TD="class: ds_change qb_shad, align: right"]-0.36[/TD]
    [TD="class: ds_open qb_shad, align: right"]84.80[/TD]
    [TD="class: ds_high qb_shad, align: right"]84.81[/TD]
    [TD="class: ds_low qb_shad, align: right"]84.44[/TD]
    [TD="class: ds_previous qb_shad, align: right"]84.80[/TD]
    [TD="class: ds_volume qb_shad, align: right"]7[/TD]
    [TD="class: ds_displaytime qb_shad, align: right"]05/08/14[/TD]
    [TD="class: qb_shad noprint, align: center"][Blocked Image: http://www.barchart.com/shared/images/quote_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/chart_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/opinion_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/options_icon.gif][/TD]

    [/tr]


    [tr]


    [TD="class: ds_futures--contract qb_line, align: left"]CTZ14 (Dec '14)[/TD]
    [TD="class: ds_last qb_line, align: right"]84.03[/TD]
    [TD="class: ds_change qb_line, align: right"]+0.52[/TD]
    [TD="class: ds_open qb_line, align: right"]83.50[/TD]
    [TD="class: ds_high qb_line, align: right"]84.07[/TD]
    [TD="class: ds_low qb_line, align: right"]83.50[/TD]
    [TD="class: ds_previous qb_line, align: right"]83.51[/TD]
    [TD="class: ds_volume qb_line, align: right"]134[/TD]
    [TD="class: ds_displaytime qb_line, align: right"]02:25[/TD]
    [TD="class: qb_line noprint, align: center"][Blocked Image: http://www.barchart.com/shared/images/quote_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/chart_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/opinion_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/options_icon.gif][/TD]

    [/tr]


    [tr]


    [TD="class: ds_futures--contract qb_shad, align: left"]CTH15 (Mar '15)[/TD]
    [TD="class: ds_last qb_shad, align: right"]83.05[/TD]
    [TD="class: ds_change qb_shad, align: right"]+0.35[/TD]
    [TD="class: ds_open qb_shad, align: right"]82.83[/TD]
    [TD="class: ds_high qb_shad, align: right"]83.05[/TD]
    [TD="class: ds_low qb_shad, align: right"]82.83[/TD]
    [TD="class: ds_previous qb_shad, align: right"]82.70[/TD]
    [TD="class: ds_volume qb_shad, align: right"]21[/TD]
    [TD="class: ds_displaytime qb_shad, align: right"]02:29[/TD]
    [TD="class: qb_shad noprint, align: center"][Blocked Image: http://www.barchart.com/shared/images/quote_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/chart_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/opinion_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/options_icon.gif][/TD]

    [/tr]


    [tr]


    [TD="class: ds_futures--contract qb_line, align: left"]CTK15 (May '15)[/TD]
    [TD="class: ds_last qb_line, align: right"]82.93[/TD]
    [TD="class: ds_change qb_line, align: right"]+0.42[/TD]
    [TD="class: ds_open qb_line, align: right"]82.93[/TD]
    [TD="class: ds_high qb_line, align: right"]82.93[/TD]
    [TD="class: ds_low qb_line, align: right"]82.93[/TD]
    [TD="class: ds_previous qb_line, align: right"]82.51[/TD]
    [TD="class: ds_volume qb_line, align: right"]1[/TD]
    [TD="class: ds_displaytime qb_line, align: right"]02:29[/TD]
    [TD="class: qb_line noprint, align: center"][Blocked Image: http://www.barchart.com/shared/images/quote_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/chart_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/opinion_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/options_icon.gif][/TD]

    [/tr]


    [tr]


    [TD="class: ds_futures--contract qb_shad, align: left"]CTN15 (Jul '15)[/TD]
    [TD="class: ds_last qb_shad, align: right"]82.83[/TD]
    [TD="class: ds_change qb_shad, align: right"]+0.64[/TD]
    [TD="class: ds_open qb_shad, align: right"]82.83[/TD]
    [TD="class: ds_high qb_shad, align: right"]82.83[/TD]
    [TD="class: ds_low qb_shad, align: right"]82.83[/TD]
    [TD="class: ds_previous qb_shad, align: right"]82.19[/TD]
    [TD="class: ds_volume qb_shad, align: right"]1[/TD]
    [TD="class: ds_displaytime qb_shad, align: right"]02:29[/TD]
    [TD="class: qb_shad noprint, align: center"][Blocked Image: http://www.barchart.com/shared/images/quote_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/chart_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/opinion_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/options_icon.gif][/TD]

    [/tr]


    [tr]


    [TD="class: ds_futures--contract qb_line, align: left"]CTV15 (Oct '15)[/TD]
    [TD="class: ds_last qb_line, align: right"]81.48s[/TD]
    [TD="class: ds_change qb_line, align: right"]-0.89[/TD]
    [TD="class: ds_open qb_line, align: right"]0.00[/TD]
    [TD="class: ds_high qb_line, align: right"]81.48[/TD]
    [TD="class: ds_low qb_line, align: right"]81.48[/TD]
    [TD="class: ds_previous qb_line, align: right"]82.37[/TD]
    [TD="class: ds_volume qb_line, align: right"]0[/TD]
    [TD="class: ds_displaytime qb_line, align: right"]05/08/14[/TD]
    [TD="class: qb_line noprint, align: center"][Blocked Image: http://www.barchart.com/shared/images/quote_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/chart_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/opinion_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/options_icon.gif][/TD]

    [/tr]


    [tr]


    [TD="class: ds_futures--contract qb_shad, align: left"]CTZ15 (Dec '15)[/TD]
    [TD="class: ds_last qb_shad, align: right"]80.88s[/TD]
    [TD="class: ds_change qb_shad, align: right"]-0.85[/TD]
    [TD="class: ds_open qb_shad, align: right"]0.00[/TD]
    [TD="class: ds_high qb_shad, align: right"]80.88[/TD]
    [TD="class: ds_low qb_shad, align: right"]80.88[/TD]
    [TD="class: ds_previous qb_shad, align: right"]81.73[/TD]
    [TD="class: ds_volume qb_shad, align: right"]0[/TD]
    [TD="class: ds_displaytime qb_shad, align: right"]05/08/14[/TD]
    [TD="class: qb_shad noprint, align: center"][Blocked Image: http://www.barchart.com/shared/images/quote_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/chart_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/opinion_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/options_icon.gif][/TD]

    [/tr]


    [tr]


    [TD="class: ds_futures--contract qb_line, align: left"]CTH16 (Mar '16)[/TD]
    [TD="class: ds_last qb_line, align: right"]81.05s[/TD]
    [TD="class: ds_change qb_line, align: right"]-0.76[/TD]
    [TD="class: ds_open qb_line, align: right"]0.00[/TD]
    [TD="class: ds_high qb_line, align: right"]81.05[/TD]
    [TD="class: ds_low qb_line, align: right"]81.05[/TD]
    [TD="class: ds_previous qb_line, align: right"]81.81[/TD]
    [TD="class: ds_volume qb_line, align: right"]0[/TD]
    [TD="class: ds_displaytime qb_line, align: right"]05/08/14[/TD]
    [TD="class: qb_line noprint, align: center"][Blocked Image: http://www.barchart.com/shared/images/quote_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/chart_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/opinion_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/options_icon.gif][/TD]

    [/tr]


    [tr]


    [TD="class: ds_futures--contract qb_shad, align: left"]CTK16 (May '16)[/TD]
    [TD="class: ds_last qb_shad, align: right"]81.17s[/TD]
    [TD="class: ds_change qb_shad, align: right"]-0.75[/TD]
    [TD="class: ds_open qb_shad, align: right"]0.00[/TD]
    [TD="class: ds_high qb_shad, align: right"]81.17[/TD]
    [TD="class: ds_low qb_shad, align: right"]81.17[/TD]
    [TD="class: ds_previous qb_shad, align: right"]81.92[/TD]
    [TD="class: ds_volume qb_shad, align: right"]0[/TD]
    [TD="class: ds_displaytime qb_shad, align: right"]05/08/14[/TD]
    [TD="class: qb_shad noprint, align: center"][Blocked Image: http://www.barchart.com/shared/images/quote_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/chart_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/opinion_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/options_icon.gif][/TD]

    [/tr]


    [tr]


    [TD="class: ds_futures--contract qb_line, align: left"]CTN16 (Jul '16)[/TD]
    [TD="class: ds_last qb_line, align: right"]81.02s[/TD]
    [TD="class: ds_change qb_line, align: right"]-0.75[/TD]
    [TD="class: ds_open qb_line, align: right"]0.00[/TD]
    [TD="class: ds_high qb_line, align: right"]81.02[/TD]
    [TD="class: ds_low qb_line, align: right"]81.02[/TD]
    [TD="class: ds_previous qb_line, align: right"]81.77[/TD]
    [TD="class: ds_volume qb_line, align: right"]0[/TD]
    [TD="class: ds_displaytime qb_line, align: right"]05/08/14[/TD]
    [TD="class: qb_line noprint, align: center"][Blocked Image: http://www.barchart.com/shared/images/quote_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/chart_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/opinion_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/options_icon.gif][/TD]

    [/tr]


    [tr]


    [TD="class: ds_futures--contract qb_shad, align: left"]CTV16 (Oct '16)[/TD]
    [TD="class: ds_last qb_shad, align: right"]81.08s[/TD]
    [TD="class: ds_change qb_shad, align: right"]-0.75[/TD]
    [TD="class: ds_open qb_shad, align: right"]0.00[/TD]
    [TD="class: ds_high qb_shad, align: right"]81.08[/TD]
    [TD="class: ds_low qb_shad, align: right"]81.08[/TD]
    [TD="class: ds_previous qb_shad, align: right"]81.83[/TD]
    [TD="class: ds_volume qb_shad, align: right"]0[/TD]
    [TD="class: ds_displaytime qb_shad, align: right"]05/08/14[/TD]
    [TD="class: qb_shad noprint, align: center"][Blocked Image: http://www.barchart.com/shared/images/quote_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/chart_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/opinion_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/options_icon.gif][/TD]

    [/tr]


    [tr]


    [TD="class: ds_futures--contract qb_line, align: left"]CTZ16 (Dec '16)[/TD]
    [TD="class: ds_last qb_line, align: right"]81.09s[/TD]
    [TD="class: ds_change qb_line, align: right"]-0.75[/TD]
    [TD="class: ds_open qb_line, align: right"]0.00[/TD]
    [TD="class: ds_high qb_line, align: right"]81.09[/TD]
    [TD="class: ds_low qb_line, align: right"]81.09[/TD]
    [TD="class: ds_previous qb_line, align: right"]81.84[/TD]
    [TD="class: ds_volume qb_line, align: right"]0[/TD]
    [TD="class: ds_displaytime qb_line, align: right"]05/08/14[/TD]
    [TD="class: qb_line noprint, align: center"][Blocked Image: http://www.barchart.com/shared/images/quote_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/chart_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/opinion_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/options_icon.gif][/TD]

    [/tr]


    [tr]


    [TD="class: ds_futures--contract qb_shad, align: left"]CTH17 (Mar '17)[/TD]
    [TD="class: ds_last qb_shad, align: right"]81.25s[/TD]
    [TD="class: ds_change qb_shad, align: right"]-0.75[/TD]
    [TD="class: ds_open qb_shad, align: right"]0.00[/TD]
    [TD="class: ds_high qb_shad, align: right"]81.25[/TD]
    [TD="class: ds_low qb_shad, align: right"]81.25[/TD]
    [TD="class: ds_previous qb_shad, align: right"]82.00[/TD]
    [TD="class: ds_volume qb_shad, align: right"]0[/TD]
    [TD="class: ds_displaytime qb_shad, align: right"]05/08/14[/TD]
    [TD="class: qb_shad noprint, align: center"][Blocked Image: http://www.barchart.com/shared/images/quote_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/chart_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/opinion_icon.gif] [Blocked Image: http://www.barchart.com/shared/images/options_icon.gif][/TD]

    [/tr]


    [/TABLE]

  • Re: DATA EXTRACT FROM WEBSITE(s)


    http://www.barchart.com/commodityfut.../CT?search=CT*


    I tried following code but its extract all table in sheet, i need only data not others





    Hopefully pike will help me


    Regards.
    MJI

  • Re: DATA EXTRACT FROM WEBSITE(s)


    no need for the sir


    any way its the third table

  • Re: DATA EXTRACT FROM WEBSITE(s)


    1st its in Chinese language


    Its table name is senfe



    <tr style="background-color: rgb(255, 255, 255);">


    <td>×ܼÆ</td>
    <td class="td-right">&nbsp;</td>
    <td class="td-right">&nbsp;</td>
    <!-- <td class="td-right">&nbsp;</td>-->
    <td class="td-right">&nbsp;</td>
    <td class="td-right">&nbsp;</td>
    <td class="td-right">126</td>
    <td class="td-right">4</td>
    <td class="td-right">49</td>
    <!-- <td class="td-right">&nbsp;</td> -->
    </tr>


    Blue matter related to my data


    Please provide support and oblige.


    Regards.
    MJI

  • Re: DATA EXTRACT FROM WEBSITE(s)


    I have no idea as i can not see 126


    try

  • Re: DATA EXTRACT FROM WEBSITE(s)


    <tr style="background-color: rgb(255, 255, 255);">


    <td>×ܼÆ</td>
    <td class="td-right">&nbsp;</td>
    <td class="td-right">&nbsp;</td>
    <!-- <td class="td-right">&nbsp;</td>-->
    <td class="td-right">&nbsp;</td>
    <td class="td-right">&nbsp;</td>
    <td class="td-right">126</td>
    <td class="td-right">4</td>
    <td class="td-right">49</td>
    <!-- <td class="td-right">&nbsp;</td> -->
    </tr>


    Red matter will show you 126 and 4


  • Re: DATA EXTRACT FROM WEBSITE(s)


    pike I made little change in your code


    Code
    1. For lngTable = 1 To objTable.Length - 1
    2. For lngRow = 53 To objTable(lngTable).Rows.Length - 1
    3. For lngCol = 5 To objTable(lngTable).Rows(lngRow).Cells.Length - 1


    NOW Its showing 126 4 and 49


    but problems is that it shows the same at row number 58 of the EXCEL SHEET how i put it on top of row.


    Regards.
    MJI

  • Re: DATA EXTRACT FROM WEBSITE(s)


    pike i get the data on top of row after little changes


    Code
    1. ThisWorkbook.Sheets("Sheet16").Cells(ActRw + lngRow [B]- 56[/B], lngCol [B]- 4[/B]) = objTable(lngTable).Rows(lngRow).Cells(lngCol).innerText


    But I feeling uncomfortable because if any row addition made in website my code will become useless.


    Also great PIKE why you cant understand website codes.


    If any improvement you seen please SHARE


    Regards.
    MJI