Home > Software engineering >  How to use VBA programming input date on the page, query and read relevant data, deposited in the lo
How to use VBA programming input date on the page, query and read relevant data, deposited in the lo

Time:10-09

Website: http://www.cffex.com.cn/fzjy/ccpm/
In "date" column input: input date
The query results example:

Contract: IF1405 deal date: 20140506

Volume ranked the rankings on sale amount pay ranking
League members referred to as "volume than the previous trading day ranking member referred to as a pay increase or decrease quantity more or less than the previous trading day league members referred to as a sale quantity more or less than the previous trading day
Haitong futures, 98716-11707, 1 6148 27 guotai junan 1 citic futures in 9205-766
Guotai junan 2 77520 5644 587 2114 2 haitong futures 2 haitong futures in 8480-361
3 3, 59858-1531 citic citic futures futures 3 gf futures 5140-23, 4830-112
4 gf futures 4 yongan futures 4094-325-4, 53843-9313 Great Wall 3699-780
5 Great Wall 53117 2577 galaxy futures futures 3360-392 3972-432-5 wealth
6 hing card futures in 52742-7311 3202 443 3185, 978, 6 guotai junan shenyin wanguo
Mid July 7, 49484-4719 Beijing everbright futures 7 everbright futures, 2411, 1141, 3129-245
Guangfa futures on the 8th of shenyin wanguo 47946 3010 2762 14 8 2140 68 galaxy futures
9 44352 1986 9 everbright nanhua futures futures futures 1946 178 2256 149 9 guosen
10 33050 2742 galaxy futures Shanghai topix 10 futures 1614 hing card 30, 1881-102
11 the easy futures 11, 30827-2624 1742-49 11 Shanghai nanhua futures topix 1589-104
12 merchants futures 12 Great Wall 29714-690 1679 211 1494 269 12 yongan futures
Yongan futures 13, 28530-459 China merchants futures 13, 1677, 158, 13 lu 1426-177
the futuresBeijing mid - 26084-950-14 of 14 zheshang 14 shenyin wanguo futures 1615 333 1344 14
15 the lu 15 essence futures futures 24815 2753 1337 723 1029 207
15 nanhua futures16 citic built for 24642, 1760, 16 guosen futures citic built for the 1325 469 1025 138
17 zhejiang zhongda 17, 22431-2541 the lu 17 merchants futures futures 1288 112 998-100
18 18 citic built for Shanghai topix 22062-2168 1273 954 788 182 18 kam tai futures
19, 21042, 11054 great futures, futures 1215 19 cic day qi 909 44 269
Shanghai mid - 20400-1744-20 hing card 1113, 64, 20 zhejiang zhongda 888 futures 53
Amounted to 821175-17761, 52165, 3011, 52853, 670



CodePudding user response:

Check the XMLHTTP information yourself
  •  Tags:  
  • VBA
  • Related