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: beancount -*-
Here is my.import file:
#!/usr/bin/env python3
"""Import configuration."""
import sys
from os import path
sys.path.insert(0, path.join(path.dirname(__file__)))
from beancount_reds_importers import vanguard
from fund_info import *
# Setting this variable provides a list of importer instances.
CONFIG = [
# Investments
#
--------------------------------------------------------------------------------------
vanguard.Importer({
'main_account' : 'Assets:US:Investments:Vanguard:Brokerage',
'account_number' : '123456',
'transfer' : 'Assets:zero-Sum-Accounts:Transfers:Bank-Account'
,
'dividends' : 'Income:Taxable:Dividends:Brokerage',
'cg' : 'Income:Taxable:Capital-Gains:Brokerage',
'fees' : 'Expenses:Brokerage-Fees:TradIRA',
'rounding_error' : 'Equity:Rounding-Errors:Imports',
'fund_info' : fund_info,
}),
]
On Thursday, April 30, 2020 at 9:44:46 PM UTC+12, Red S wrote:
>
> 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 checked it in to a repo here
>> <https://github.com/redstreet/beancount_reds_ingestor>. It should have
>> enough to import multi-account Vanguard qfx files mostly out of the box.
>> See the README
>> <https://github.com/redstreet/beancount_reds_ingestor/blob/master/README.md>
>> .
>>
>> My test infrastructure is unfortunately dependent on my personal files.
>> So I'm unable to share it for now, without a fair amount of work.
>>
>> Let me know your experience.
>>
>> On Sunday, April 26, 2020 at 4:15:36 PM UTC-7, Jacob Hannan wrote:
>>>
>>> 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
>>> programmer, let alone a python programmer, so I'm mainly working from
>>> examples.
>>>
>>> Thanks!
>>>
>>> -JH
>>>
>>> On Sun, Apr 26, 2020 at 12:32 PM Red S <[email protected]> wrote:
>>>
>>>> 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 accounts. I've been
>>>> wanting to share my ofx importers, and will do so shortly.
>>>>
>>>> It solves a number of issues including:
>>>> - stock and fund transactions including buys and sells (lot matching,
>>>> however, is left to the user)
>>>> - special handling of money market transactions (price conversions)
>>>> - customizable for each brokerage house, to account for ofx
>>>> differences, filenames, etc.
>>>> - produces balance assertions
>>>> - handles commissions, fees
>>>> - produces price entries (many brokerages include ticker prices of all
>>>> active tickers in the account on the date of download, in addition to of
>>>> course, the prices gleaned from transactions)
>>>> - available cash computation
>>>> - cusip to fund matching (some brokerage houses identify funds only by
>>>> cusip or other custom tickers in the ofx)
>>>>
>>>>
>>>>
>>>> On Sunday, April 26, 2020 at 7:16:04 AM UTC-7, [email protected] wrote:
>>>>>
>>>>> Hello, all.
>>>>>
>>>>> Can anyone point in the direction of some examples on setting up the
>>>>> built-in OFX importer for investment accounts? I have it working fine for
>>>>> regular bank accounts (where there is one account number), but I'm not
>>>>> sure
>>>>> how to configure it for accounts that have multiple "subaccounts." For
>>>>> example, when I export transactions from Vanguard, I'm exporting for 5
>>>>> real
>>>>> accounts (4 IRA accounts and one brokerage account) and a larger number
>>>>> of
>>>>> funds under each one.
>>>>>
>>>>> In looking through the documentation and old email threads, I can't
>>>>> tell if this is something one accomplishes in the ".config" file using
>>>>> the
>>>>> built-in importer or if I need to write a custom importer for investment
>>>>> accounts. Old emails reference a ofx_invest importer that was part of
>>>>> ledgerhub, but I know that is discontinued.
>>>>>
>>>>> Thanks in advance!
>>>>>
>>>>> -JH
>>>>>
>>>> --
>>>> You received this message because you are subscribed to a topic in the
>>>> Google Groups "Beancount" group.
>>>> To unsubscribe from this topic, visit
>>>> https://groups.google.com/d/topic/beancount/JtE9JLQY3Og/unsubscribe.
>>>> To unsubscribe from this group and all its topics, send an email to
>>>> [email protected].
>>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msgid/beancount/54d2b408-e27f-44bb-a439-0eaf093646bf%40googlegroups.com
>>>>
>>>> <https://groups.google.com/d/msgid/beancount/54d2b408-e27f-44bb-a439-0eaf093646bf%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>>
--
You received this message because you are subscribed to the Google Groups
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/288728e6-7b18-4599-bed4-b3bf72efa261%40googlegroups.com.
