OFX connection to Vanguard

Derek Atkins warlord at MIT.EDU
Wed Apr 18 11:29:15 EDT 2007


Have you tried with the OFX Direct Connect?  Or does the limitation
of AqBanking not support that?

-derek

"Mark Soper" <markasoper at hotmail.com> writes:

> Thanks, David!  I was able to get it to work by removing the FID.
>
> Cheers,
>
> Mark
>
> -----------------------
> Mark Soper
> markasoper at hotmail.com
> 25 Fairmont St #2
> Cambridge, MA 02139
> (617) 491-4134
> -----Original Message-----
> From: David Reiser [mailto:dbreiser at earthlink.net] 
> Sent: Wednesday, April 18, 2007 12:18 AM
> To: Mark Soper
> Cc: gnucash-user at gnucash.org
> Subject: Re: OFX connection to Vanguard
>
> Yes, make sure you don't define <FID> for Vanguard (leave it out of  
> ofx.py). Vanguard, and many other brokers, do not have an FID. Some  
> of them ignore extra info on login attempts. Vanguard fails the login  
> attempt if you send it anything more than it requires.
>
>
> On 17 Apr 2007, at 11:19:16 PM, Mark Soper wrote:
>
>> Hi -
>>
>>
>>
>> Anyone successfully connected to Vanguard via OFX?  I have tried many
>> different combinations of message and headers using ofx.py, but  
>> keep getting
>> a "400: Bad Request" error.  Any ideas would be appreciated.   
>> Details below:
>>
>> Regards,
>>
>> Mark Soper
>> --------------------------------------- urllib2 header
>> -----------------------------
>>
>> {'Content-length': 765, 'Content-type': 'application/x-ofx'}
>>
>> ----------------------------------------- ofx request
>> ------------------------------
>>
>> <?OFX OFXHEADER="200" VERSION="200" SECURITY="NONE" OLDFILEUID="NONE"
>> NEWFILEUID="NONE" ?>
>>
>> <OFX>
>> <SIGNONMSGSRQV1>
>> <SONRQ>
>> <DTCLIENT>20070417220540</DTCLIENT>
>> <USERID>********</USERID>
>> <USERPASS>**********</USERPASS>
>> <LANGUAGE>ENG</LANGUAGE>
>> <FI>
>> <ORG>The Vanguard Group</ORG>
>> <FID>5641</FID>
>> </FI>
>> <APPID>QWIN</APPID>
>> <APPVER>1200</APPVER>
>> </SONRQ>
>> </SIGNONMSGSRQV1>
>> <INVSTMTMSGSRQV1>
>> <INVSTMTTRNRQ>
>> <TRNUID>BE758D81-3935-4A32-8BE0-A55007A31A65</TRNUID>
>> <INVSTMTRQ>
>> <INVACCTFROM>
>> <BROKERID>vanguard.com</BROKERID>
>> <ACCTID>*********4345</ACCTID>
>> </INVACCTFROM>
>> <INCTRAN>
>> <INCLUDE>Y</INCLUDE>
>> </INCTRAN>
>> <INCOO>Y</INCOO>
>> <INCPOS>
>> <INCLUDE>Y</INCLUDE>
>> </INCPOS>
>> <INCBAL>Y</INCBAL>
>> </INVSTMTRQ>
>> </INVSTMTTRNRQ>
>> </INVSTMTMSGSRQV1>
>> </OFX>
>>
> Dave
> --
> David Reiser
> dbreiser at earthlink.net
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available


More information about the gnucash-user mailing list