[GNC] Vanguard OFX Access

[Kalpesh Patel]

Sadly Vanguard does not offer OFX formatted download. They only provide QIF,
in one account or individual mutual fund accounts,  or CSV format - very
limited formats. Even with QIF format it is a hit or miss in importing to
GNC and CSV formatted requires good deal of post-processing  

 

If you are brave enough and know Python programming, you can try fine free
product call PocketSense
(https://sites.google.com/site/pocketsense/home/msmoneyfixp1) which allows
you to connect to their servers to download OFX formatted file. I hope to
get to GNC Python bindings to see if I can get it to work with (modified)
PocketSense.

 

 

------------------------------

 

Message: 6

Date: Thu, 20 Jan 2022 21:18:08 -0800

From: john <jralls at ceridwen.us <mailto:jralls at ceridwen.us> >

To: Matt Corallo <gculuvs at mattcorallo.com <mailto:gculuvs at mattcorallo.com> >

Cc: gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> 

Subject: Re: [GNC] Vanguard OFX Access

Message-ID: <EFB0FD80-C28F-43B2-8C46-54B94393B9D6 at ceridwen.us
<mailto:EFB0FD80-C28F-43B2-8C46-54B94393B9D6 at ceridwen.us> >

Content-Type: text/plain;             charset=us-ascii

 

 

 

> On Jan 20, 2022, at 3:04 PM, Matt Corallo <gculuvs at mattcorallo.com
<mailto:gculuvs at mattcorallo.com> > wrote:

> 

> Hi!

> 

> I'm trying to do an OFX/Quicken DirectConnect connection to Vanguard from
GNUCash. Per a recent discussion on GitHub[1] for this to work, login has to
happen via a URL, which then points to a different URL for transaction and
account requests. In order for the second request to work, the poster there
claims it has to come with a cookie which was returned from the first
request.

> 

> From what I can tell, there is no way to get GNUCash to make the first
request, take the cookie, and feed it into the second. Am I missing
something or is this a missing feature (or a bug?).

> 

> I asked on the AQBanking list, but that forum seems to be substantially
less active and less maintained.

> 

 

You're right. The HTTPS handshake with the cookie is called OFX WebConnect
and AQBanking doesn't support that. Your best option is to download your
transactions as an OFX file from Vanguard's website and import it.

 

Regards,

John Ralls

 

 

 

------------------------------