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