duncanb7
asked on
URL address replace input form input for TAB key
dear Experts,
I have one stock placement order input form from bank account provided. I would like to do VBA code
to access the placement html page after login in my bank account from VBA automation programming.
After login, I navigate https://online-banking.com./cgi-bin/ibnkprdhk/ist/order/orderPlacement.do?BV_UseBVCookie=Yes&sell=B%7C66921%7C1000%05123 in vba code
sell=B, where B means BUY or S mean SELL for select radio button in the input form for stock order
66921 means for stock name number in the input form
1000 means for lot size for stock in the input form.
The edit of stock number of 66921 and lot size of 1000 is okay in URL bar and no problem at all and it is shown in the
input form of placement order html page
But the question when I try to input stock price in URL address bar like 123 that is not shown in the form and
then I put %05 or %09 for simulating TAB key before stock price of 123 that is still not shown up too.
It is shown into lot size input box of the form instead of price box like this as follows
OrderForm
========
Order TYPE : o BUY or o SELL
Stock code: 66921
Stock Lots: 1000 123
Price:
Any suggestion for simulate TAB key code in URL bar ? And I am using IE7 in windows vista
Why, I'm NOT using DOM's getelementbyName("price")= 123 in vba because I could like to speed up
submit form speed instead of too much coding for input each single input field in the input form like, ordertype,
stocknum, stocklotsize, stock prize.
Please advsie
Duncan
I have one stock placement order input form from bank account provided. I would like to do VBA code
to access the placement html page after login in my bank account from VBA automation programming.
After login, I navigate https://online-banking.com./cgi-bin/ibnkprdhk/ist/order/orderPlacement.do?BV_UseBVCookie=Yes&sell=B%7C66921%7C1000%05123 in vba code
sell=B, where B means BUY or S mean SELL for select radio button in the input form for stock order
66921 means for stock name number in the input form
1000 means for lot size for stock in the input form.
The edit of stock number of 66921 and lot size of 1000 is okay in URL bar and no problem at all and it is shown in the
input form of placement order html page
But the question when I try to input stock price in URL address bar like 123 that is not shown in the form and
then I put %05 or %09 for simulating TAB key before stock price of 123 that is still not shown up too.
It is shown into lot size input box of the form instead of price box like this as follows
OrderForm
========
Order TYPE : o BUY or o SELL
Stock code: 66921
Stock Lots: 1000 123
Price:
Any suggestion for simulate TAB key code in URL bar ? And I am using IE7 in windows vista
Why, I'm NOT using DOM's getelementbyName("price")=
submit form speed instead of too much coding for input each single input field in the input form like, ordertype,
stocknum, stocklotsize, stock prize.
Please advsie
Duncan
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Dear,
I am found similar case when we download yahoo finance history data like
http://finance.yahoo.com/q/hp?s=%5EDJI&a=09&b=1&c=1928&d=02&e=3&f=2011&g=d
we can progam the http path's a,b,c name variable in its html document to locate what we want
the exact data with program startdate and enddate without input the any variable in the form
shown in the website.
This should be doing the same for me to do program order at my
bank website from name variabel in its html
like
<input type="radio" name="instructions" id="instructions" value="B" />
<input type="text" id="symbol" name="symbol" maxlength="5" value=""/>
<input class="inputMedium" type="text" id="quantity" maxlength="18" name="quantity" value=""/>
<input class="inputMedium" type="text" id="price" name="price" value=''/>
SoI try, I try this https://online-banking.com./cgi-bin/ibnkprdhk/ist/order/orderPlacement.do
BV_UseBVCookie=Yes&instruc tion=B&sym bol=66921& quantity=1 000&price= 123, but it still fail, Any idea and Suggestion
Please advise
Duncan
I am found similar case when we download yahoo finance history data like
http://finance.yahoo.com/q/hp?s=%5EDJI&a=09&b=1&c=1928&d=02&e=3&f=2011&g=d
we can progam the http path's a,b,c name variable in its html document to locate what we want
the exact data with program startdate and enddate without input the any variable in the form
shown in the website.
This should be doing the same for me to do program order at my
bank website from name variabel in its html
like
<input type="radio" name="instructions" id="instructions" value="B" />
<input type="text" id="symbol" name="symbol" maxlength="5" value=""/>
<input class="inputMedium" type="text" id="quantity" maxlength="18" name="quantity" value=""/>
<input class="inputMedium" type="text" id="price" name="price" value=''/>
SoI try, I try this https://online-banking.com./cgi-bin/ibnkprdhk/ist/order/orderPlacement.do
BV_UseBVCookie=Yes&instruc
Please advise
Duncan
duncan,
As I said, the program to capture the address and web page is not a trivial task.
I don't have time to write this but here is an option (to basically create a custom browser) :
Download VB.Net Express from microsoft.com
Create a new project.
Add a Web Browser control
Add a textbox for the address (if desired)
Set the Web Browser to Navigate to the desired location; if it changes, you can capture the address property.
when the DocumentLoaded even fires, you can dig into the document to locate the specific field that you want to put the data into
activate the web browser submit function if desired.
This can also be done with Excel VBA, but locating the field and pushing data into it is significantly harder.
As I said, the program to capture the address and web page is not a trivial task.
I don't have time to write this but here is an option (to basically create a custom browser) :
Download VB.Net Express from microsoft.com
Create a new project.
Add a Web Browser control
Add a textbox for the address (if desired)
Set the Web Browser to Navigate to the desired location; if it changes, you can capture the address property.
when the DocumentLoaded even fires, you can dig into the document to locate the specific field that you want to put the data into
activate the web browser submit function if desired.
This can also be done with Excel VBA, but locating the field and pushing data into it is significantly harder.
ASKER
Dear rspahitz,
Act4ally I have already sent all input into order form with DOM 's method, but why I want to
program the order input at URL address because want to speed it up. From the stocck data
vendor company, I have seen their software can beable to many transaction almost at the same
time within 1s for like 20 orders in the market. Do you think they are using C++ or Jave that is
much faster than VBA ?
p=123
Do until price =130
.document.all("symbol").Va lue = 66921
.document.all("quantity"). Value = 1000
.document.all("price").Val ue = 123
.document.all("submitbutto n").Click
p=p+1
lopp
Act4ally I have already sent all input into order form with DOM 's method, but why I want to
program the order input at URL address because want to speed it up. From the stocck data
vendor company, I have seen their software can beable to many transaction almost at the same
time within 1s for like 20 orders in the market. Do you think they are using C++ or Jave that is
much faster than VBA ?
p=123
Do until price =130
.document.all("symbol").Va
.document.all("quantity").
.document.all("price").Val
.document.all("submitbutto
p=p+1
lopp
ASKER
Dear rspahitz,
Act4ally I have already sent successfully all input into order form with DOM 's method, but why I want to
program the order input at URL address because want to speed it up. From the stocck data
vendor company, I have seen their software can be able to finsih many transactions almost at the same
time within 1s for like 20 orders in the market. Do you think the faster speed they can make because
they are using C++ or Jave that isbmuch faster than VBA ? Any more suggestion is welcome
p=123
Do until price =142
.document.all("symbol").Va lue = 66921
.document.all("quantity"). Value = 1000
.document.all("price").Val ue = 123
.document.all("submitbutto n").Click
p=p+1
lopp Accept and Award Points Accept as Solution
Act4ally I have already sent successfully all input into order form with DOM 's method, but why I want to
program the order input at URL address because want to speed it up. From the stocck data
vendor company, I have seen their software can be able to finsih many transactions almost at the same
time within 1s for like 20 orders in the market. Do you think the faster speed they can make because
they are using C++ or Jave that isbmuch faster than VBA ? Any more suggestion is welcome
p=123
Do until price =142
.document.all("symbol").Va
.document.all("quantity").
.document.all("price").Val
.document.all("submitbutto
p=p+1
lopp Accept and Award Points Accept as Solution
C++ is probably much faster than VBA; Java maybe/maybe not.
However, most of this will be controlled by the speed of your internet connection to the server, your ISP, and their server. Using VBA to update the contents of a webpage will probably be quite fast unless it's a very complex page.
As for using the address to send the information, unless the hosting site supports it, it will never work. If they simply don't accept the information you send, it will never get processed.
(I will be gone until Monday. If you need additional help, you can try to add a low-point question and ask experts to look at this further.)
However, most of this will be controlled by the speed of your internet connection to the server, your ISP, and their server. Using VBA to update the contents of a webpage will probably be quite fast unless it's a very complex page.
As for using the address to send the information, unless the hosting site supports it, it will never work. If they simply don't accept the information you send, it will never get processed.
(I will be gone until Monday. If you need additional help, you can try to add a low-point question and ask experts to look at this further.)
ASKER
Thanks for your reply
ASKER
I have tried sell=B%7C66921%7C1000%7C12
ANd I am interesting the program to intercept the browers and grab the data out of the address, but how to detect the address when I sumbit the order form and I found the .LocationURL doesn't change at all once I click order submit button.
Please advise
Duncan