|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub 基金持仓()
- Dim url, js, n
- url = "http://data.eastmoney.com/aspx/data.aspx"
- url = url & "?name=RptOrgFundPositions&reportDate=20140630" '这里控制数据的日期
- url = url & "&page=1" '这里控制数据是第几页
- url = url & "&pageSize=10000" '这里控制数据一次可以提取多少股票
- url = url & "&sortType=2&sortRule=-1&jsname=suwenkai&changeType=All%20&rt=46964581"
-
- Call get_url(url)
- End Sub
- Sub QFII持仓()
- Dim url, js, n
- url = "http://data.eastmoney.com/aspx/data.aspx"
- url = url & "?name=RptOrganizationPositions&orgType=QFII&reportDate=20140630" '这里控制数据的日期
- url = url & "&page=1" '这里控制数据是第几页
- url = url & "&pageSize=10000" '这里控制数据一次可以提取多少股票
- url = url & "&&sortType=2&sortRule=-1&jsname=suwenkai&changeType=All%20&rt=46964634"
-
- Call get_url(url)
- End Sub
- Sub 社保持仓()
- Dim url, js, n
- url = "http://data.eastmoney.com/aspx/data.aspx"
- url = url & "?name=RptOrganizationPositions&orgType=SocialInsuranceFund&reportDate=20140630" '这里控制数据的日期
- url = url & "&page=1" '这里控制数据是第几页
- url = url & "&pageSize=10000" '这里控制数据一次可以提取多少股票
- url = url & "&&sortType=2&sortRule=-1&jsname=suwenkai&changeType=All%20&rt=46964634"
-
- Call get_url(url)
- End Sub
- Sub 券商持仓()
- Dim url, js, n
- url = "http://data.eastmoney.com/aspx/data.aspx"
- url = url & "?name=RptOrganizationPositions&orgType=Securities&reportDate=20140630" '这里控制数据的日期
- url = url & "&page=1" '这里控制数据是第几页
- url = url & "&pageSize=10000" '这里控制数据一次可以提取多少股票
- url = url & "&&sortType=2&sortRule=-1&jsname=suwenkai&changeType=All%20&rt=46964634"
-
- Call get_url(url)
- End Sub
- Sub 保险持仓()
- Dim url, js, n
- url = "http://data.eastmoney.com/aspx/data.aspx"
- url = url & "?name=RptOrganizationPositions&orgType=Insurance&reportDate=20140630" '这里控制数据的日期
- url = url & "&page=1" '这里控制数据是第几页
- url = url & "&pageSize=10000" '这里控制数据一次可以提取多少股票
- url = url & "&&sortType=2&sortRule=-1&jsname=suwenkai&changeType=All%20&rt=46964634"
-
- Call get_url(url)
- End Sub
- Sub 信托持仓()
- Dim url, js, n
- url = "http://data.eastmoney.com/aspx/data.aspx"
- url = url & "?name=RptOrganizationPositions&orgType=Intrust&reportDate=20140630" '这里控制数据的日期
- url = url & "&page=1" '这里控制数据是第几页
- url = url & "&pageSize=10000" '这里控制数据一次可以提取多少股票
- url = url & "&&sortType=2&sortRule=-1&jsname=suwenkai&changeType=All%20&rt=46964634"
-
- Call get_url(url)
- End Sub
- Public Sub get_url(url)
- Set js = CreateObject("scriptcontrol")
- js.Language = "jscript"
- With CreateObject("msxml2.xmlhttp")
- .Open "get", url, False
- .send
- js.addcode (.responsetext)
- slen = js.eval("suwenkai.data.length")
- For i = 0 To slen - 1
- s = js.eval("suwenkai.data[" & i & "]")
- ar = Split(s, ",")
- Cells(i + 2, 1) = CStr(i + 1)
- Cells(i + 2, 2).Resize(1, UBound(ar)) = ar
- If Val(ar(6)) > 0 Then
- Cells(i + 2, 9) = "增仓"
- ElseIf Val(ar(6)) = 0 Then
- Cells(i + 2, 9) = "不变"
- Else
- Cells(i + 2, 9) = "减仓"
- End If
- Next
- End With
- End Sub
- Sub 清除数据()
- Range("a2:i65536").ClearContents
- End Sub
复制代码 |
评分
-
2
查看全部评分
-
|