OFX connection to Vanguard

David Reiser dbreiser at earthlink.net
Wed Apr 18 00:18:15 EDT 2007


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



More information about the gnucash-user mailing list