Re: OFX Importer for Investment Accounts

Heh. Then you'll be glad to know the mystery resurfaced :) Vanguard again... After sprinkling a bunch of print's, it looks like a Vanguard 401(k) simply doesn't have available cash. (Which makes sense). The transactionbuilder *mostly* handles that error, but in libtransactionbuilder/investmen

Re: OFX Importer for Investment Accounts

Great! I'm not sure what made it work -- I only touched code that is run after an exception occurs (not what makes it occur) -- but I'm glad it's works for you now. Feel free to post here or open bugs on github if you run into other issues or have feature requests. On Sunday, June 14, 2020 at

Re: OFX Importer for Investment Accounts

Thanks for the update. Now everything worked fine! Extraction ran perfectly. On Sun, Jun 14, 2020 at 8:47 PM Red S wrote: > I've added: > 1) more specific error checking. > 2) A Vanguard test case in the examples directory > > This might help you get up and running. > > To try it out: > *pip ins

Re: OFX Importer for Investment Accounts

I've added: 1) more specific error checking. 2) A Vanguard test case in the examples directory This might help you get up and running. To try it out: *pip install --upgrade beancount-reds-importers* On Saturday, June 13, 2020 at 2:46:08 AM UTC-7, Red S wrote: > > I can't see anything that's amis

Re: OFX Importer for Investment Accounts

I can't see anything that's amiss. Unfortunately, this is difficult to debug further without trying to reproduce this using your input file, which is hard to do since it contains private information. You could try downloading this file, renaming it to OfxDownload.qfx, setting your account_numbe

Re: OFX Importer for Investment Accounts

Hi, I'm not a software engineer so might be slow in figuring this out so I appreciate all your help and creating this importer. I'm still not able to figure out the issue. Here is what I'm doing: bean-extract jonathan.import ~/staging/OfxDownload.qfx > ~/staging/OfxDownload.qfx.extract In tha

Re: OFX Importer for Investment Accounts

Also: are you importing the correct file with your maps? Or are you importing the example file that ships with the package by accident? -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from i

Re: OFX Importer for Investment Accounts

Looks like your fund info is not being imported. I'm unable to tell what the problem is without looking at your entire output. If you can anonymize and send the output, I can help. If you want to find the problem by yourself, add this after line 15 here: https://www.github.com/redstreet/beancoun

Re: OFX Importer for Investment Accounts

@Red: I think I've entered all the tickers but I still get this error... Error: cusip_map and ticker_map not found for: ['9...', 9...', etc]. thanks On Wednesday, June 3, 2020 at 7:49:52 AM UTC+12, Jonathan Goldman wrote: > > Yes that is working now. Thanks! > > I'm now trying to debug the tick

Re: OFX Importer for Investment Accounts

Yes that is working now. Thanks! I'm now trying to debug the ticker issue. I have been adding tickers in my file to the fund_info.py file but it doesn't appear to be registering them. That is I put the new ticker in the CUSIP map and in the ticker_map but I still get an error for all tickers th

Re: OFX Importer for Investment Accounts

1. Rename your file to OfxDownload.qfx. I'll fix it later so this is not a requirement. 2. Set the account number in your import file you posted: see the default of '123456'. 3. Then, first run bean-identify and ensure it works before running bean-extract Let me know if that worked. -- You r

Re: OFX Importer for Investment Accounts

Thanks so much for starting this project. I'm trying to get your importer working but I must have done something wrong as I don't get any extracted content And here is what I get when I invoke bean-extract: bean-extract my.import ~/staging/20180706-20200106--1578348252.ofx ;; -*- mode: beancou

Re: OFX Importer for Investment Accounts

It's now on PyPI: *pip install beancount-reds-importers* See the examples directory in the installed files, or on github (eg: /usr/lib/python3.6/site-packages/beancount_reds_importers/example/my.import) On Wednesday, April 29, 2020 at 4:15:08 PM UTC-7, Red S wrote: > > I've cleaned it up and ch

Re: OFX Importer for Investment Accounts

I've cleaned it up and checked it in to a repo here . It should have enough to import multi-account Vanguard qfx files mostly out of the box. See the README . My t

Re: OFX Importer for Investment Accounts

The built-in importer may well not. I recall an older email thread in which Martin mentioned merging in bits of ledgerhub into the main project, but it may be the case that the ofx_invest importer wasn't part of that. I'd love to take a look at anything you are willing to share. I'm not a programm

Re: OFX Importer for Investment Accounts

Does the built-in ofx importer handle investment transactions (eg: buy/sell stocks/funds)? I built my own generic investment ofx importer on top of ofxparse, and I've been using it for years. It works for a number of brokerages including the case you describe, vanguard with multiple real accoun