duncanb7
asked on
How to collect stream tick stock data in IE by VBA
Dear Expert,
I get one stock software Java Applet application running in IE 7, and I know a little of
internet data extraction and Java Applet programming. Now I try to use VBA to
start my project to collect the live data in every minutes into excel file format.
In the market, there is a lot of company provide this kind of service such as the following website
http://www.analyzerxl.com/qtxl.htm, but its target data extraction website is assigned in certain or destinated website address only. It is not helping me at all. SO I try to write the VBA program instead.
First of above, I will use nagviate to locate my website and activate the software application in
the IE instance or window and I found the difficuity to collect the data becase it is Java Script
for Java Applet and it is not easier than collecting table or data from HTML document using
ie.document.getelementbyta ge or Webquery Excel table. Anyone is familar with the data
collection in IE by VBA, please advise and help on it
Please advise
DUncan
I get one stock software Java Applet application running in IE 7, and I know a little of
internet data extraction and Java Applet programming. Now I try to use VBA to
start my project to collect the live data in every minutes into excel file format.
In the market, there is a lot of company provide this kind of service such as the following website
http://www.analyzerxl.com/qtxl.htm, but its target data extraction website is assigned in certain or destinated website address only. It is not helping me at all. SO I try to write the VBA program instead.
First of above, I will use nagviate to locate my website and activate the software application in
the IE instance or window and I found the difficuity to collect the data becase it is Java Script
for Java Applet and it is not easier than collecting table or data from HTML document using
ie.document.getelementbyta
collection in IE by VBA, please advise and help on it
Please advise
DUncan
Sub loginonly()
Dim myIE As SHDocVw.InternetExplorer
Set myIE = Nothing
Set myIE = CreateObject("InternetExplorer.Application")
With myIE
.Visible = True
.navigate "https://www.dowstock.com.hk/nfs/login.htm?lang=zh_US"
Call WAITING(myIE, 10)
.document.all("j_username").Value = "username"
.document.all("j_password").Value = "passwrod"
.document.all("login").Click
Call WAITING(myIE, 10)
.document.Links(50).Click ' To activate the stock live Java Applet application in the same IE
Window
Call WAITING(myIE, 11)
.ie.document,getelementby ''Try to write a code for data collection
Function WAITING(ByRef myIE As SHDocVw.InternetExplorer, state1 As Integer)
With myIE
Do Until Not .Busy And .readyState = READYSTATE_COMPLETE
' Debug.Print state1' Debug.Print .Busy ' Debug.Print .readyState
'Sleep (300)
Loop
End With
End Function
without seeing the source for that page i cannot be certain. but if the ticker data is shown by a java applet it's probably impossible to have ie retrieve it.
ASKER
It is Java Applet application data , but why impossible , it should be okay if I can read the data in
my computer. Whether the protocol data format transmit in web by Java Applet is defined by
software company? It should be same data format for client collect like IE could read
the data and shown it in IE windows no matter it is Java Applet or not
Please read the the source code of the web page and advise
Thanks
Duncan
stockfuture-1-.txt
my computer. Whether the protocol data format transmit in web by Java Applet is defined by
software company? It should be same data format for client collect like IE could read
the data and shown it in IE windows no matter it is Java Applet or not
Please read the the source code of the web page and advise
Thanks
Duncan
stockfuture-1-.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, you are right, after talking to other experts, it is impossible to extract the Applet data except
we have the actual source code of Java Applet program from the data provider that will help to know
the data format to send to the client 's computer.
we have the actual source code of Java Applet program from the data provider that will help to know
the data format to send to the client 's computer.
ASKER
Thanks for allof you to reply
the question
Duncan
the question
Duncan