[GNC] Unsuccessful aqBanking to TD AmeriTrade

David Reiser dbreiser at icloud.com
Sat Feb 22 00:02:35 EST 2020


It has been a very long time since I’ve downloaded anything from TDAmeritrade, and some of the time I used ofx.py to download a file I could import. TDAmeritrade has never made it easy to get the necessary credentials to get to the ofx data. And I vaguely remember some difficulties with aqbanking (though back then, the biggest problem was it couldn’t handle most stock transactions, whereas libofx imports could).

One thing to try is that 
>  char appVer="2200"

is almost certainly too old to work. The current appVer is something like 2700 (or maybe even higher). That version number goes up 100 each year, and any Quicken server software will block downloads from any client more than 3 to 3.5 years old. Try boosting the appVer and see if that helps. If TDA rolled their own server side software, it might not be as strict on age as Quicken is, but who knows.

DR
--
Dave Reiser
dbreiser at icloud.com





> On Feb 21, 2020, at 8:28 AM, Morris Beavers <atomicpix86 at gmail.com> wrote:
> 
> Hello Everyone,
> 
> I am trying to migrate from Windows/Quicken (successful online access) to
> Raspbian/GnuCash (failure). New GnuCash user here. I’m trying to get online
> data from TD AmeriTrade.
> 
> Hardware: Raspberry Pi 4, 4GB. Software: GnuCash Ver 3.4 Build id 3.4+
> (2018-12-30) Finance::Quote: 1.49, libaqbanking35-5.7.8-3 with plugins and
> data, libaqofxconnect7-5.7.8-3
> 
> If someone has success with online access to TD AmeriTrade please reply
> with User and Account settings or indicate what is wrong with my aqBanking
> User or Account settings.
> 
> Below are my actions to create user and account, query Account list
> (successfully?), Get Balance and Transactions (failure).
> 
> Define aqBanking User and Account.
> 
> File contents: .aqbanking/settings/users/uid%3a%3a0000000c.conf
> int uniqueId="30"
> char backendName="aqofxconnect"
> char userName="John Doe"
> char userId="xxxxxxxx5"
> char customerId="xxxxxxxx5"
> char country="us"
> char bankCode="0000000000"
> int lastSessionId="0"
> 
> data {
>  backend {
>  char bankName="TD Ameritrade"
>  char brokerId="ameritrade.com"
>  char org="ameritrade.com"
>  char fid="5024"
>  char serverAddr="https%3A%2F%2Fofxs.ameritrade.com%2Fcgi-bin%2Fapps%2FOFX"
>  char appId="QWIN"
>  char appVer="2200"
>  char headerVer="102"
>  int httpVMajor="1"
>  int httpVMinor="1"
>  } #backend
> } #data
> 
> File contents: .aqbanking/settings/accounts/uid%3a%3a00000006.conf
> char provider="aqofxconnect"
> int uniqueId="32"
> int accountType="7"
> char accountNumber="xxxxxxxx5"
> char bankCode="ameritrade.com"
> char bankName="ameritrade.com"
> char country="us"
> int user="30"
> 
> data {
>  backend {
>  int maxPurposeLines="1"
>  int debitAllowed="0"
>  } #backend
> } #data
> 
> Download account list output:
> 06:56:42 Sending request...
> 06:56:42 Using GnuTLS default ciphers.
> 06:56:42 TLS: SSL-Ciphers negotiated: TLS1.2:RSA-AES-256-GCM:AEAD
> 06:56:42 Waiting for response...
> 06:56:42 Parsing response...
> 06:56:42 Parsing response
> 06:56:42 Status for signon request: Success (Code 0, severity "INFO")
> The server successfully processed the request.
> 06:56:42 Status for account info request: Success (Code 0, severity "INFO")
> The server successfully processed the request.
> 06:56:42 Adding account xxxxxxxx5 to bank ameritrade.com
> 06:56:42 Operation finished, you can now close this window.
> 
> Match Online accounts with GnuCash accounts.
> Bank code ameritrade.com (ameritrade.com), Account xxxxxxxx5()
> Assets:Investments:JohnDoe Roth IRA xx5
> 
> Open the “JohnDoe Roth IRA xx5” account:
> Actions>Online Action>Get Balance:
> Log Messages:
> AqBanking v5.7.8.0stable
> Sending jobs to the bank(s)
> Locking user xxxxxxxx5
> 
> Prompt for Password:
> 
> Log Messages:
> Sending request...
> Connecting to server...
> Resolving hostname "ofxs.ameritrade.com" ...
> IP address is "198.200.171.142"
> Connecting to "ofxs.ameritrade.com"
> Connected to "ofxs.ameritrade.com"
> Using GnuTLS default ciphers.
> TLS: SSL-Ciphers negotiated: TLS1.2:RSA-AES-256-GCM:AEAD
> Connected.
> Sending message...
> Message sent.
> Waiting for response...
> Receiving response...
> HTTP-Status: 400 (Bad Request)
> Error parsing server response
> Unlocking user xxxxxxxx5
> Postprocessing jobs
> Job Get Balance: finished
> Resetting provider queues
> 
> Actions>Online Action>Get Transactions:
> 
> Log Messages:
> AqBanking v5.7.8.0stable
> Sending jobs to the bank(s)
> Locking user xxxxxxxx5
> 
> Prompt for Password:
> 
> Log Messages:
> Sending request...
> Connecting to server...
> Resolving hostname "ofxs.ameritrade.com" ...
> IP address is "198.200.171.142"
> Connecting to "ofxs.ameritrade.com"
> Connected to "ofxs.ameritrade.com"
> Using GnuTLS default ciphers.
> TLS: SSL-Ciphers negotiated: TLS1.2:RSA-AES-256-GCM:AEAD
> Connected.
> Sending message...
> Message sent.
> Waiting for response...
> Receiving response...
> HTTP-Status: 400 (Bad Request)
> Error parsing server response
> Unlocking user xxxxxxxx5
> Postprocessing jobs
> Job Get Transactions: finished
> Resetting provider queues
> 
> Pop-up message:
> The Online Banking import returned no transaction for the selected time
> period.
> 
> Thank you for your interest and assistance,
> 
> Morris
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



More information about the gnucash-user mailing list