Schwab brokerage transactions - do I need ofx.py?

[DAVID REISER]

On Nov 5, 2012, at 7:32 AM, Chris Lonsberry <chris.lonsberry at gmail.com> wrote:

> I've been successful in getting most of my various bank related
> transactions, but I am stuck on Schwab Brokerage. My individual steps are
> listed below, but the wiki says "At present, OFXDirectConnect can be used
> to download transaction data from credit card and bank accounts. Investment
> transactions should still be imported from downloaded OFX files (I use
> ofx.py) via GnuCash's File>Import>Import OFX/QFX... menu option." I wanted
> to ask the list if that is still true.
> 
> If I attempt to download through the Schwab website, they only appear to
> offer csv files, which will probably require some serious massaging. Is
> ofx.py the best way to get my brokerage trasactions?
> 
> Here's what happens through "Get Transactions"
> 
> I jumped through all of the account setup hoops for the brokerage account,
> but when I tried to download transactions, I got the following result: "The
> Online Banking import returned no transactions for the selected time
> period."
> 
> If I return to the log I find:
> 
> Sending jobs to the bank(s)
> Locking user ********
> Sending request...
> Connecting to server...
> Resolving hostname "ofx.schwab.com" ...
> IP address is "162.93.228.89"
> Connecting to "ofx.schwab.com"
> Connected to "ofx.schwab.com"
> Connected.
> Sending message...
> Message sent.
> Waiting for response...
> Receiving response...
> HTTP-Status: 200 (OK)
> Response received.
> Disconnecting from server...
> Disconnected.
> Parsing response...
> Parsing response
> Status for signon request: Success (Code 0, severity "INFO")
> The server successfully processed the request.
> Status for transaction statement request: General account error (Code 2002,
> severity "ERROR")
> Account error not specified by the remaining error codes.
> Unlocking user ********
> Postprocessing jobs
> Resetting provider queues
> 
> 
> 
> Chris
> 
You don't need ofx.py specifically, but you do need a way to get the ofx file from Schwab onto your computer so the you can use gnucash's File/Import/Import OFX/QFX... menu command. Aqbanking cannot handle investment transactions. Libofx can.

The fact that you can connect to Schwab's ofx server, but are unsuccessful logging in suggests that you'd have problems getting ofx.py to work too. If Schwab's web site allows you to download ofx files after logging in, that would be your best bet.

--
Dave Reiser
dbreiser at me.com