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 <jra...@ceridwen.us <mailto:jra...@ceridwen.us> > To: Matt Corallo <gcul...@mattcorallo.com <mailto:gcul...@mattcorallo.com> > Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> Subject: Re: [GNC] Vanguard OFX Access Message-ID: <efb0fd80-c28f-43b2-8c46-54b94393b...@ceridwen.us <mailto:efb0fd80-c28f-43b2-8c46-54b94393b...@ceridwen.us> > Content-Type: text/plain; charset=us-ascii > On Jan 20, 2022, at 3:04 PM, Matt Corallo <gcul...@mattcorallo.com <mailto:gcul...@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 ------------------------------ _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
