1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| dim tablo,tablo2(20,7)
Set DemandeFichier = CreateObject("Microsoft.XMLHTTP")
DemandeFichier.Open "POST", "https://europeanequities.nyx.com/pd/stocks/data?formKey=nyx_pd_filter_values:1006ef55d4998cc0fad71db6a6f38530", False
DemandeFichier.setRequestHeader "Accept", "application/json, text/javascript, */*"
DemandeFichier.setRequestHeader "Accept-Encoding", "gzip , deflate"
DemandeFichier.setRequestHeader "Content-Type", "application/x-www-form-urlencoded; charset=UTF-8"
DemandeFichier.setRequestHeader "Content-Length", "231"
DemandeFichier.setRequestHeader "Cache-Control", "no-cache"
DemandeFichier.setRequestHeader "Accept-Language", "fr,fr-fr;q=0.8,en-us;q=0.5,en;q=0.3"
DemandeFichier.setRequestHeader "Connection", "keep-alive"
DemandeFichier.setRequestHeader "Host", "europeanequities.nyx.com"
DemandeFichier.setRequestHeader "Pragma", "no-cache"
DemandeFichier.setRequestHeader "Referer", "https://europeanequities.nyx.com/fr/equities-directory"
DemandeFichier.setRequestHeader "User-Agent", "Mozilla/5.0 (Windows NT 6.0; rv:29.0) Gecko/20100101 Firefox/29.0"
DemandeFichier.send "sEcho=5&iColumns=7&sColumns=&iDisplayStart=60&iDisplayLength=20&iSortingCols=1&iSortCol_0=0&sSortDir_0=asc&bSortable_0=true&bSortable_1=false&bSortable_2=false&bSortable_3=false&bSortable_4=false&bSortable_5=false&bSortable_6=false"
resultat = Replace(DemandeFichier.responseText, "[", vbCrLf)
tablo = Split(resultat, vbCrLf)
Z = 0
For i = 2 To UBound(tablo)
tablo2(Z, 0) = Split(Split(tablo(i), "\u003e")(1), "\")(0)
tablo(i) = Split(Split(tablo(i), "/div\u003e"",""")(1), "]")(0)
tablo2(Z, 1) = Split(tablo(i), """,""")(0)
tablo2(Z, 2) = Split(tablo(i), """,""")(1)
tablo2(Z, 3) = Split(tablo(i), """,""")(2)
tablo2(Z, 4) = Split(tablo(i), """,""")(3)
tablo2(Z, 6) = Replace(Split(tablo(i), """,""")(5), Chr(34),"")
On Error Resume Next
tablo2(Z, 5) = Split(Split(tablo(i), "\u003e")(1), "\")(0)
Err.Clear
Z = Z + 1
Next
GetObject(, "Excel.Application").Workbooks("itwoo.xls").Worksheets(1).Range("A64").Resize(UBound(tablo2), 7) = tablo2 |
Partager