Re: Closing lots when brokers report dissimilar cost basis (IBKR)

Yes, IBKR actually confirmed exactly this to me: in the opening transactions, fees get included in the cost bases. not so in the closing transactions. This seems the standard, so rather a general thing than a IBKR-specific issue. What would be the beancounter's way of handling this? I dont

Re: Closing lots when brokers report dissimilar cost basis (IBKR)

just to add, my pdf activity statements from IBKR also state those two different costs ("T.Price") in activity statements from 2022 and today, so the numbers are clearly coming from them On Saturday 13 April 2024 at 10:30:58 UTC+2 nug get wrote: > Hi everyone > I recently close

Closing lots when brokers report dissimilar cost basis (IBKR)

Hi everyone I recently closed some positions I held at InteractiveBrokers, for which i have a nice API-based ingestion pipeline to beancount. However I noted lots of "No position matches"-Errors. Turns out, the reported cost basis / Trade prices of the closed positions are very slightly off

Labeling/ marking Accounts

Hi all I started a basic tax-forecast plugin for Switzerland. One key ingredient is the providing of a list of all accounts that are subject to income and wealth taxation. My current working prototype

Re: Lot matching necessary?

Hi Dan My goal is to convert Interactive Brokers statements (their XML flex statements) to Beancount. have a look at https://github.com/Dr-Nuke/drnuke-bean/blob/master/src/drnukebean/importer/ibkr.py It's been a while, but if I remember correctly, it does the job of finding the correct lots

Re: Struggling to get padding working

Hi Dan Focusing on (a design choince?) >>The balance directives are to be intended as "start of the day balance" Out of curiousity, what is the motivation behind making balances "beginning-of-day-balances"? Would there be a point to challenge this? In my reality, bank accounts provide the

opening accounts in plugin not working consistently with Fava

Hi all anyone has the right tip for me? I made a plugin here that takes any single expense or income transaction and spreads it out over a given time period. I.e. it converts my yearly vehicle insurance

Currencies vs. bookable commodities

Hi all how does beancount differentiate between commodities where it keeps track of lots (shares) and those where it does not (currencies)? For example, I have two commodities USD and VTI (neither is the ledger base currency). Both are introduced the same way 1970-01-01 commodity USD name:

New FinPension (CH) importer

Hi all here is a new importer for the FinPension app (in Switzerland): https://github.com/Dr-Nuke/drnuke-bean/blob/master/src/drnukebean/importer/finpension.py There is some help in the readme.md to set up a running example. This has no expectation of completeness as I only use a small part of

fava, unrealized PnL (plugin) & NAV

Dear all playing with the unrealized.py plugin, with the "convert to " UI option in fava, I noticed that my net asset value changes depending on activating/deactivating the plugin. Is this intended behavior? Se the minimal example below. In this context I have not yet fully understood how

BQL: select only 1st level accounts

Dear all, I'd like to make expenses statements on my 1st level accounts, e.g. accounts that look like "Expenses:Mainaccount" but none of their child accounts. This should sum up all the values of the individual child accounts. The following query provides the total expenses of any leaf

Re: Using pandas in the importers

Hi this smells like confusion with the python interpreters. You may want to debug through your bean-commands and check whether the correct python executable is uses all the time. Also make sure the correct venv is activated all the time. Good luck! For me, WSL works very well. best On Monday,

Re: State of v3

Dear all! whats the news on the topic? especially, is there an update to >> - is there a benefit in moving to v3 right now? >> Not really so far. You can wait. You should probably wait. Thanks! Best, nugget -- You received this message because you are subscribed to the Google Groups

Re: OT: What development environments are people using?

Great thread :D I am a self-taught coding enthusiast, and my "carreer" started with matlab data processing scripts at university in the late 2000's. Hence, today I deal mostly with python. My preferred IDE is Pycharm/ IntelliJ, enhanced by jupyter for experimenting & data stuff. For beancount

replace mailing group by forum?

Dear community, As a suggestion from my side, how about replacing this mailing group by a forum? pros: - potentially build a structured knowledge base that is helpful - user-generated how-to-content - control notifications - not spamming everyone with your new topic that might be interesting

Re: InteractiveBrokers

I also made a IB importer, based on the FLex Query API: https://github.com/Dr-Nuke/drnuke-bean https://www.interactivebrokers.com/en/software/singlefunds/topics/flexqueries.htm >> report of all balance-affecting transactions. without looking it up, i believe the flex query allows this. Hope

Re: importer: postings with price & cost

sorry to bother you, i finally found my way via https://github.com/jbms/beancount-import/blob/master/beancount_import/source/ofx.py the trick is to use the position.CostSpec() function. happy coding! On Monday, 6 April 2020 12:20:31 UTC+2, nug get wrote: > > Dear all > i am st

importer: postings with price & cost

Dear all i am struggeling with importing stock trades, with the cost & price. Can you help me? here is where I am so far: postings=[ data.Posting(Account, quantity, None, price, None, None), results in a postings

Split yearly bill to monthly: scheduled transactions? chronjob?

Dear all, does beancount have a scheduled transaction creator or has anyone implemented something like it? For example a chronjob that inserts some predefined transaction every first day of the month? I'd like to smooth out yearly bills over the 12 months, like in the following way:

Re: debugging importer

Thanks to both of you, you made me look at the right places. I had to slightly adjust the expected header format. I got it working, finally! yey! best, nugget On Wednesday, 4 March 2020 06:29:29 UTC+1, Red S wrote: > > Search for 'def extract' in siddhanth's importer, and insert a few print >

debugging importer

Dear all, how can I debug an importer? I got the example from https://bitbucket.org/blais/beancount/src/default/examples/ingest/office/ working, but transferring this to my Bank's (DKB) statements using https://github.com/siddhantgoel/beancount-dkb leaves me with only the header line ";; -*-

Re: Docker container for beacount

> "Docker Toolbox" which also runs on windows 10 home edition. > > I've had issues with docker toolbox where I then needed to use the ip > address that is used in the virtualbox (192.168.99.100) instead of > localhost > > Regards, > > Patrick > On 20.12.2019

Re: sorting transactions

UTC+1, Martin Blais wrote: > > You will want to write a little python script. > I would operate on source code, not on the data structures, so you keep > the original formatting and metadata and comments > > On Fri, Dec 20, 2019, 06:59 nug get > > wrote: > >> Is

Re: Docker container for beacount

ng more compact/properly versioned, you can > try https://hub.docker.com/r/yegle/fava > > On Tue, Nov 26, 2019 at 2:25 PM Jason Chu > > wrote: > >> Check out https://github.com/beancount/fava/tree/master/contrib/docker . >> It should have everything you need. >> >>

sorting transactions

Is there a feature that would allow me to sort the transactions in my files, for example by date, or specific accounts? Thanks! Background: I migrated my 3 years of Gnucash records to beancount. It's all one long list of transactions sorted by date. I'd like to separate my cash and bank

Re: Pad & balance Parent and Child Account: balance failed

Thanks Justus, your answer really puts it into context, which indeed helps me. On Friday, 29 November 2019 02:54:07 UTC+1, Justus Pendleton wrote: > > On Friday, November 29, 2019 at 7:01:27 AM UTC+7, nugget wrote: > >> What would be the clean way of balancing both accounts other than >>

Pad & balance Parent and Child Account: balance failed

with the following minimal example i get an error on balancing the parent account: 2000-01-01 open Assets:Parent CHF 2000-01-01 open Assets:Parent:Child CHF 2000-01-01 open Equity:Opening-Balance CHF 2000-01-01 open Expenses:Expenses CHF ;get random amounts on the accounts 2010-01-01 *

Docker container for beacount

Hello, is there a "official standard docker container" around here, or could someone set it up, such that I just plug it in and have everything installed? This would circumvent all the hassle i had and still having. It should contain all the beancount and related ackages like the importers,

Beancount user experience: tutorials / minimal examples / how-to for unix beginners?

Dear all, I like the beancount idea, but i am a Unix beginner and as such I want to strongly discourage any other unix beginner to go for beancount before there is a DPU (dumbest possible user )-proof tutorial. I'll try to list some pains I had (and still having). If there is anyone who'd

bean-price: how to do unrealized gains?

Dear all, I am in a (long...) process of setting up my new beancount ledger, based on 2 years of gnucash accounting history. Finally, I want to integrate my VTI holdings to my ledger, and I could not so far figure out how I use bean-price to get current market prices and according net worth (or