|
Sub 低价涨幅()
Sheets("升").Range("W11") = "收盘价" '更换:涨停封单额(元)2021.12.10
Sheets("升").Range("X11") = "流通亿" '更换:a股流通市值(元)2021.12.16
Sheets("升").Range("Y11") = "竞价/昨成"
Sheets("升").Range("Z11") = "开盘金亿" '更换:竞价金额(元)2021.12.16
For r = 12 To Range("Q12").CurrentRegion.Rows.Count
dm = Cells(r, 17).Value
Debug.Print dm
If Val(dm) = sh000001 Then
Url = "http://qt.gtimg.cn/q=" & dm
Else
If Val(dm) < 600000 Then
Url = "http://qt.gtimg.cn/q=sz" & dm
Else
Url = "http://qt.gtimg.cn/q=sh" & dm
End If
End If
With CreateObject("msxml2.xmlhttp")
.Open "GET", Url, False
.send
sp = Split(.responsetext, "~")
If UBound(sp) > 2 Then
'Cells(r, 4).Value = sp(32) & "%"
Cells(r, 23).Value = sp(3) '当前价格
Else
End If
End With
Next
End Sub
|
|