|
楼主 |
发表于 2024-3-8 20:43
|
显示全部楼层
以下脚本是我几年以前下载同样网站数据抓取的(忘记了作者名字),最近因为散户大家庭的数据经常断更没有更新,才想起来以前有这么一个文件,以前是可以运行抓取到数据的,现在发现脚本失效了,看看哪位大神能帮忙修改一下?脚本如下:
Sub 查股网个股历史DDX数据1()
On Error Resume Next
Columns("A:A").NumberFormatLocal = "@"
[a1:x1] = Split("代码,开盘(元),收盘(元),最高,最低,涨幅,成交量(万元),通吃率,BBD(万元),DDX,DDX3日,DDX5日,DDX10日,DDX60日,DDY,单数比,小单差,小单流入(万元),中单差,中单流入(万元),大单差,大单流入(万元),特大单差,特大单流入(万元)", ",")
Dim temp
With CreateObject("Microsoft.XMLHTTP")
.Open "GET", "http://ddx.gubit.cn/js/astocksuggest.js" & p, True
.Send
Do Until .ReadyState = 4
DoEvents
Loop
temp = Split(.responsetext, "~")
With CreateObject("internetexplorer.application")
.Visible = True
For k = 1 To UBound(temp)
.Navigate "http://ddx.gubit.cn/ddelist.html?code=" & Format(Split(temp(k), "`")(0), "000000") & "&bdate=2012-09-14&edate=2012-09-27"
Do Until .ReadyState = 4
DoEvents
Loop
n = Range("b65536").End(xlUp).Row
Set r = .Document.getElementByid("sjtableright").Rows
For i = 1 To r.Length - 2
For j = 0 To r(i).Cells.Length - 1
Cells(i + n, j + 2) = r(i).Cells(j).innerText
Next j
Next i
m = Range("b65536").End(xlUp).Row
Range(Cells(n + 1, 1), Cells(m, 1)) = Format(Split(temp(k), "`")(0), "000000")
Set r = Nothing
Next k
.Quit
End With
End With
Cells.Font.Size = 9
Cells.Columns.AutoFit
End Sub |
|