CafeF_Foreign
store Ticker !csvLine
store FloorCode !csvLine
store Date !csvLine
store BuyVolume !csvLine
store BuyValue !csvLine
store SellVolume !csvLine
store SellValue !csvLine
store CurrentRoom !csvLine
store TotalRoom !csvLine
store SoHuu !csvLine
csvSave Foreign #DeleteAfterExport
selectWindow tab=open https://www.hsx.vn/Modules/Rsde/Report/ForeignTradingReportIndex?fid=4eade9cd9f9b472ebdc235a0d4a6407e
pause 3000
executeScript d=new Date(); var m=((d.getMonth()+1)<10)?'0'+(d.getMonth()+1):(d.getMonth()+1); var dd=d.getDate(); if (dd<10) {dd='0'+dd;} return dd+"."+m+"."+d.getFullYear(); d1
executeScript d=new Date(); m=((d.getMonth()+1)<10)?'0'+(d.getMonth()+1):(d.getMonth()+1); return m+"/"+d.getDate() + "/" + d.getFullYear(); d2
type id=dateFrom ${d1}
type id=dateTo ${d1}
click xpath=//*[@id="foreignTradingCriteria"]/div[2]/input
pause 10000
storeText xpath=//*[@id="Mua"]/td[2] VNIndexbuyvol1
storeText xpath=//*[@id="Bán"]/td[2] VNIndexsellvol1
storeText xpath=//*/table[@id="valueGrid-grid"]/*/tr[@id="Mua"]/td[2] VNIndexbuyval1
storeText xpath=//*/table[@id="valueGrid-grid"]/*/tr[@id="Bán"]/td[2] VNIndexsellval1
executeScript return Number (${VNIndexbuyvol1}.replace(/[^0-9]/g,'')); VNIndexbuyvol3
executeScript return Number (${VNIndexsellvol1}.replace(/[^0-9]/g,'')); VNIndexsellvol3
executeScript return Number (${VNIndexbuyval1}.replace(/[^0-9]/g,'')); VNIndexbuyval3
executeScript return Number (${VNIndexsellval1}.replace(/[^0-9]/g,'')); VNIndexsellval3
store VNINDEX !csvLine
store 10 !csvLine
store ${d2} !csvLine
executeScript return (${VNIndexbuyvol3}) !csvLine
executeScript return (${VNIndexbuyval3}*10000) !csvLine
executeScript return (${VNIndexsellvol3}) !csvLine
executeScript return (${VNIndexsellval3}*10000) !csvLine
csvSave Foreign #DeleteAfterExport
open https://hnx.vn/co-phieu-etfs/du-lieu-thi-truong-ny-kq-giao-dich.html
pause 5000
click xpath=//*[@id="end"]
pause 10000
storeText xpath=//*[@id="_tableDatas"]/tbody/tr[last()]/td[2]/span HNXbuyvol1
storeText xpath=//*[@id="_tableDatas"]/tbody/tr[last()]/td[3] HNXbuyval1
storeText xpath=//*[@id="_tableDatas"]/tbody/tr[last()]/td[4] HNXsellvol1
storeText xpath=//*[@id="_tableDatas"]/tbody/tr[last()]/td[5]/span HNXsellval1
executeScript return Number (${HNXbuyvol1}.replace(/[^0-9]/g,'')); HNXbuyvol1a
executeScript return Number (${HNXbuyval1}.replace(/[^0-9]/g,'')); HNXbuyval1a
executeScript return Number (${HNXsellvol1}.replace(/[^0-9]/g,'')); HNXsellvol1a
executeScript return Number (${HNXsellval1}.replace(/[^0-9]/g,'')); HNXsellval1a
store HNX-INDEX !csvLine
store 2 !csvLine
store ${d2} !csvLine
store ${HNXbuyvol1a} !csvLine
store ${HNXbuyval1a} !csvLine
store ${HNXsellvol1a} !csvLine
store ${HNXsellval1a} !csvLine
csvSave Foreign #DeleteAfterExport
select xpath=//*[@id="cboIndex"] label=HNX30
click xpath=//*[@id="btn_search"]
pause 15000
click xpath=//*[@id="end"]
pause 20000
storeText xpath=//*[@id="_tableDatas"]/tbody/tr[last()]/td[2]/span HNX30buyvol2
storeText xpath=//*[@id="_tableDatas"]/tbody/tr[last()]/td[3]/span HNX30buyval2
storeText xpath=//*[@id="_tableDatas"]/tbody/tr[last()]/td[4]/span HNX30sellvol2
storeText xpath=//*[@id="_tableDatas"]/tbody/tr[last()]/td[5]/span HNX30sellval2
executeScript return Number (${HNX30buyvol2}.replace(/[^0-9]/g,'')); HNX30buyvol2a
executeScript return Number (${HNX30buyval2}.replace(/[^0-9]/g,'')); HNX30buyval2a
executeScript return Number (${HNX30sellvol2}.replace(/[^0-9]/g,'')); HNX30sellvol2a
executeScript return Number (${HNX30sellval2}.replace(/[^0-9]/g,'')); HNX30sellval2a
store HNX30-INDEX !csvLine
store 2 !csvLine
store ${d2} !csvLine
store ${HNX30buyvol2a} !csvLine
store ${HNX30buyval2a} !csvLine
store ${HNX30sellvol2a} !csvLine
store ${HNX30sellval2a} !csvLine
csvSave Foreign #DeleteAfterExport
open https://hnx.vn/co-phieu-etfs/du-lieu-thi-truong-uc-kq-giao-dich.html
pause 5000
click xpath=//*[@id="end"]
pause 10000
storeText xpath=//*[@id="_tableDatas"]/tbody/tr[last()]/td[2]/span UPCoMbuyvol3
storeText xpath=//*[@id="_tableDatas"]/tbody/tr[last()]/td[3]/span UPCoMbuyval3
storeText xpath=//*[@id="_tableDatas"]/tbody/tr[last()]/td[4]/span UPCoMsellvol3
storeText xpath=//*[@id="_tableDatas"]/tbody/tr[last()]/td[5]/span UPCoMsellval3
executeScript return Number (${UPCoMbuyvol3}.replace(/[^0-9]/g,'')); UPCoMbuyvol3a
executeScript return Number (${UPCoMbuyval3}.replace(/[^0-9]/g,'')); UPCoMbuyval3a
executeScript return Number (${UPCoMsellvol3}.replace(/[^0-9]/g,'')); UPCoMsellvol3a
executeScript return Number (${UPCoMsellval3}.replace(/[^0-9]/g,'')); UPCoMsellval3a
store UPCOM-INDEX !csvLine
store 11 !csvLine
store ${d2} !csvLine
store ${UPCoMbuyvol3a} !csvLine
store ${UPCoMbuyval3a} !csvLine
store ${UPCoMsellvol3a} !csvLine
store ${UPCoMsellval3a} !csvLine
csvSave Foreign #DeleteAfterExport
localStorageExport Foreign.csv #DeleteAfterExport