TDA trading web page data input issues

a-drift

New Member
Joined
Oct 13, 2003
Messages
28
Hello,

I need a tool which will automatically click the correct options on a TDAmeritrade trading web page and fill in the correct figures from an Excel program, already developed. I already have the automated logon username and password done, and am loading the correct Mutual Fund trading screen via Internet Explorer.

This is the point at which I have the problem. I previously had Excel playback one of three pre-recorded nMacro screen macros, depending on whether the Excel program wanted to Buy, Sell or Exchange. This worked great UNTIL TDA began noodling with the TDA web page... adding messages, changing mesaages, removing messages... which changed the screen locations of several input fields and click locations, causing the nMacro playbacks to fail.

I did some research on IE control macros in Excel, on this site and many others, but I can't afford to spend all of the time required to learn 100% of this in order to apply 5% of that knowledge to this solution. So, at this point, I'm seeking some free advice from anyone on a free, fast and reliable solution.
 
Last edited by a moderator:

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
A bit more info, and a couple of additional questions regarding my previous post:

I have already developed an automated swing trading system in Excel, which decides whether to buy, sell or exchange mutual funds at 5 minutes before maket close on a daily basis, but I don't have a reliable way to actually enter and execute the trade information via TDAmeritrade's trading web site.

Assuming my situation might be shared by others, has anyone already developed an IE control macro which searches the "frequently-changing" TDA webpage for the locations of the click-positions and data entry positions before actually performing the clicks and data entries? Or, is searching for these locations not even possible with an Excel IE control macro?

Also, the nMacro screen macro program I use performs absolute cursor positioning on the screen, causing their executions to click at the wrong spots and not enter data into the fields IF the TDA webpage has changed due to the insertion, change or removal of messages. Does anyone know of any another screen macro program which uses relative cursor positioning by searching for matching patterns on the screen?

Lastly, I found a product called TraderXL, which "seems" to execute certain trades directly with TDA instead of sending the trade data via their website. Does anyone have any experience with this Excel product?
http://www.analyzerxl.com/traderxl_for_td_ameritrade.htm

Thank you...
 
Upvote 0

Forum statistics

Threads
1,225,525
Messages
6,185,469
Members
453,296
Latest member
zashue22

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top