[GNC] Vanguard OFX Access

[John Ralls]

Kalpesh,

If PocketSense downloads OFX files you don't need to do anything with the GnuCash bindings. Just use File>Import>Import OFX/QFX on the downloaded file.

Besides, the importers aren't accessible from the python bindings.

Regards,
John Ralls


> On Jan 21, 2022, at 3:08 PM, Kalpesh Patel <kalpesh.patel at usa.net> wrote:
> 
> 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
> 
> 
> 
> 
> 
> 
> 
> ------------------------------
> 
> 
> 
> 
> 
> 
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.