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