OFX connection to Vanguard

[Dave Reiser]

Derek Atkins wrote:
> Have you tried with the OFX Direct Connect?  Or does the limitation
> of AqBanking not support that?

ofxdirectconnect will connect and download, but aqbanking doesn't yet 
handle securities transactions. (non-reinvested dividends and interest 
work, but not buys and sells)

> 
> -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.
>>
>>
> 


-- 
David Reiser
dbreiser at earthlink.net