Re: Extensions to currency syntax

2021-03-23 Thread Martin Blais
I think the problem is ordering and character-set. $ comes before the number, not after. I'm not sure if the change would be trivial but there are numbers in a number of different places which would all be affected (e.g. balance checks, costs, etc.). The other is that using Flex I didn't have

Re: Released 2.3.4 (v2 branch) --- Was: [beancount/beancount] Bump v2 to next minor version. (#639)

2021-03-20 Thread Martin Blais
Fixed On Sat, Mar 20, 2021 at 8:50 PM Aaron Lindsay wrote: > Thanks, Martin! > > FYI - I just noticed it doesn't look like github has a tag for this > release yet. > > -Aaron > > On Mar 20 14:36, Martin Blais wrote: > > 2021-03-20 > > > > - Fixed #6

Re: Extensions to currency syntax

2021-03-20 Thread Martin Blais
On Sat, Mar 20, 2021 at 4:28 PM Daniele Nicolodi wrote: > On 20/03/2021 19:26, Martin Blais wrote: > > > This is new syntax. This introduces a small change that removes > ambiguity. > > A flag is not either one of !

Re: A beancount plugin that adds checks for balance expressions

2021-03-20 Thread Martin Blais
Added to contribs doc https://docs.google.com/document/d/1Z37bQ45wDtjTPaMQ_x-f33p1trH9fNosEAUgbQXwp30/edit#heading=h.brr21bvog6kj On Thu, Mar 18, 2021 at 3:49 PM Di Weng wrote: > Hi everyone! > > I made a small plugin for checking balances against the simple expressions > combining multiple

Released 2.3.4 (v2 branch) --- Was: [beancount/beancount] Bump v2 to next minor version. (#639)

2021-03-20 Thread Martin Blais
2021-03-20 - Fixed #639: Released 2.3.4. 2021-01-09 - Fixed bug in booking that assumed number is set on cost. I did this while running booking manually on entries freshly created on an importer (never ahd done that before, will be customary in v3). 2021-01-08 - Fixed recently

Extensions to currency syntax

2021-03-20 Thread Martin Blais
In my continuing strategic diversification efforts I have a growing number of futures and futures options transaction flow and the symbology has been giving me some trouble lately. To address this, I just introduced a backward incompatible change to the v3 syntax which may warrant your attention.

Re: A beancount plugin that adds checks for balance expressions

2021-03-18 Thread Martin Blais
I love it! On Thu, Mar 18, 2021, 15:49 Di Weng wrote: > Hi everyone! > > I made a small plugin for checking balances against the simple expressions > combining multiple accounts. Here are a few examples: > > ``` > plugin "beancount_balexpr.balexpr" > > 1990-01-01 open Assets:A USD > 1990-01-01

Re: Starting (Trading) Journal: To Pad Or Not To Pad?

2021-03-11 Thread Martin Blais
On Wed, Mar 10, 2021 at 11:37 AM david e wrote: > Hello, as I recently discovered Beancount and decided to use it for > tracking my trading activities (and also my most important private > financial accounts) I have to get started somehow (as a non-dev). Welcome! > > As described in the

Re: Trading: 1) How To Report Trading Lots & 2) Trade Analysis

2021-03-11 Thread Martin Blais
On Thu, Mar 11, 2021 at 7:39 AM david e wrote: > update: > > in the meantime I just found a way to implement the script "SELECT …" into > my file.bean and run it via the query prompt. this works great after I > removed the WHERE line. > > Now I am wondering if there is a way to run this script

Re: How to contribute to V3?

2021-03-09 Thread Martin Blais
Hi Tomasz, The timing isn't great for C++ contributions, after Xmas I left the new core library in the middle being written for the core data structures from scratch and I have about a million ideas for improvements based on 10 years of usage of the v2 branch... that just lives inside my head

Re: Trading: 1) How To Report Trading Lots & 2) Trade Analysis

2021-03-08 Thread Martin Blais
On Mon, Mar 8, 2021 at 9:32 AM 'David E' via Beancount < beancount@googlegroups.com> wrote: > Hello, I am very new to Beancount as I want to keep track of my trading > activities and generate reports with FIFO settings. I love the tool so far > and the community around it. > > 1) > To get

Re: Tracking different cost basis methods for different countries?

2021-03-04 Thread Martin Blais
On Thu, Mar 4, 2021 at 4:01 PM James Cook wrote: > Hi list, > > I file taxes in both the US and Canada, for which I have to calculate > capital gains differently: > > a) In Canada I'm deemed to have bought most of my assets on the date I >moved here. There's no such fiction on my US taxes. >

Re: Tracking different cost basis methods for different countries?

2021-03-04 Thread Martin Blais
It's here: https://github.com/beancount/beancount/tree/average_booking_rollback I was going to merge it but it had significant impact on performance so I rolled it back and moved it to this branch. (All the booking will be reimplemented in v3 in C++, and simplified substantially, with much of the

Re: Bean-price sources doesn't have Google?

2021-03-02 Thread Martin Blais
I think the importer stopped working when changes were made to the site. If you'd like to build a new importer, please send a PR. On Tue, Mar 2, 2021 at 7:40 PM Oon-Ee Ng wrote: > Hi, the bean-price documentation gives an example for getting prices from > Google but that source doesn't exist

Re: Newbie: How to manage option trades?

2021-02-28 Thread Martin Blais
rd and Schwab importers or adopting your >> Ameritrade importer for them. >> >> On Saturday, February 13, 2021 at 5:13:01 PM UTC-5 b...@bben.us wrote: >> >>> Good point about the price directive. I agree with your recommendation. >>> Seems like the best way

Re: Multipliers

2021-02-28 Thread Martin Blais
unt wrote: > I'm curious to hear a bit more about what gets ugly with modeling futures > in the present system. Resolving mark to market seems like a challenge. > > On Sun, Feb 28, 2021, 08:02 Martin Blais wrote: > >> FYI. >> I added a section on multipliers in the v

Multipliers

2021-02-28 Thread Martin Blais
FYI. I added a section on multipliers in the v3 goals: https://docs.google.com/document/d/1qPdNXaz5zuDQ8M9uoZFyyFis7hA0G55BEfhWhrVBsfc/edit#heading=h.b30u633jlv5x -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and

Re: error message in beangrow

2021-02-22 Thread Martin Blais
Please file a ticket On Mon, Feb 22, 2021 at 1:23 PM kprab...@gmail.com wrote: > Dear Martin, > > Is the code in for beangrow in https://github.com/beancount/beangrow > working currently for v2. > When i try to run the code, i'm getting the below error message in > Beancount 2.3.3... > >

Re: Calculating Portfolio Returns

2021-02-20 Thread Martin Blais
Move to https://github.com/beancount/beangrow/issues/6 On Mon, Dec 28, 2020 at 6:44 AM redst...@gmail.com wrote: > I have a case that doesn't produce the desired output: a transfer out of > an account, in-kind. This gets categorized as an ASSET_OTHERASSET. I'm not > sure I understand the

Re: beancount.ingest is no more. Long live beangulp!

2021-02-19 Thread Martin Blais
Thank you for doing this! On Fri, Feb 19, 2021 at 7:20 PM Daniele Nicolodi wrote: > On 02/02/2021 07:20, Martin Blais wrote: > > Hi, > > > > Part of v3 plans is thinning out the repository. > > I've just moved the beancount.ingest directory from beanco

Re: Beancount Balance Assertion for Sum of accounts

2021-02-17 Thread Martin Blais
Further, it usually makes more sense to treat buy/sell on commodities in separate transactions. This then allows you to eventually compute returns See http://furius.ca/beancount/doc/returns On Wed, Feb 17, 2021 at 9:58 AM Daniele Nicolodi wrote: > On 17/02/2021 09:28, David Karapetyan wrote:

Re: Assets recorded in lots

2021-02-14 Thread Martin Blais
Best is to write a script, you'll have full control. - Create an inventory - Iterate over directives, skip non-transactions, iterate over postings - Filter the postings you're interested in - Add them to the inventory At the end, iterate over the inventory and print On Mon, Feb 15, 2021 at 2:29

Re: Net worth over time examples?

2021-02-14 Thread Martin Blais
Here's the script: https://github.com/beancount/beanlabs/blob/master/beanlabs/compensation/net-worth-over-time.py - It's not sufficient to add to an inventory because you'll need to convert to market value - Furthermore, one needs to convert all market values to a single currency. The script does

Re: How to handle stocks/shares conversions due to company merging?

2021-02-14 Thread Martin Blais
+1 On Sun, Feb 14, 2021 at 9:14 PM redst...@gmail.com wrote: > I do this. The date spec allows the original date to be retained: > > 2020-02-02 * "Convert" > Assets:Stock-Options -12.000 ORNG {12.12 USD, 2009-01-02} > Assets:Stock-Options -17.123 ORNG {14.14 USD, 2009-02-23} > ;

Re: Frustration

2021-02-14 Thread Martin Blais
On Sun, Feb 14, 2021 at 3:12 PM Dustin Farris wrote: > the sheer volume of work here is an aspect of your "problem" > that I feel should be identified in it's own right, and addressed. > > > ☝️I’m glad to hear you say that — I couldn’t tell if I’m just doing it > wrong or if 25+ really is a lot.

Re: Newbie: How to manage option trades?

2021-02-13 Thread Martin Blais
rade). >>> >>> I will play around with this! >>> >>> On Tuesday, December 29, 2020 at 1:16:10 PM UTC-8 tinot...@gmail.com >>> wrote: >>> >>>> Hi, >>>> >>>> I count only the money in my account and control the sum of p

Re: Newbie: How to manage option trades?

2021-02-13 Thread Martin Blais
ound with this! >> >> On Tuesday, December 29, 2020 at 1:16:10 PM UTC-8 tinot...@gmail.com >> wrote: >> >>> Hi, >>> >>> I count only the money in my account and control the sum of possible >>> assignments. I don't have an "entity

Re: State of v3

2021-02-13 Thread Martin Blais
> On Sat, Feb 13, 2021, 04:40 Martin Blais wrote: > >> >> >> On Sat, Feb 13, 2021, 05:57 redst...@gmail.com >> wrote: >> >>> >>> I noticed a few posts of late mentioning tidbits about the state of v3. >>> Given I haven't been fo

Re: Additions to the CSV importer

2021-02-13 Thread Martin Blais
On Sat, Feb 13, 2021 at 3:15 PM Daniele Nicolodi wrote: > On 13/02/2021 20:12, kuba jamro wrote: > > From my perspective, it would be nice if there was at least one fully > > maintained importer to help people start and in my mind that's a coin > > toss between CSV and OFX. > > I agree that it

Re: State of v3

2021-02-13 Thread Martin Blais
On Sat, Feb 13, 2021, 05:57 redst...@gmail.com wrote: > > I noticed a few posts of late mentioning tidbits about the state of v3. > Given I haven't been following v3 closely, would someone be kind enough to > help me and perhaps others understand: > > - what is the overall development state of

Re: Additions to the CSV importer

2021-02-12 Thread Martin Blais
On Fri, Feb 12, 2021 at 12:00 PM kuba@gmail.com wrote: > Hi all, > > I'd like to unpack the comment from Dan regarding additions to the CSV > importer > > > > > > *Also, if anything, I expect the CSV importer in beangulp to > becomesimpler, and not to gain new features. It was intended as an

Re: beancount.ingest is no more. Long live beangulp!

2021-02-12 Thread Martin Blais
On Fri, Feb 12, 2021 at 11:55 AM kuba@gmail.com wrote: > Hi all, > > On Friday, 12 February 2021 at 02:20:11 UTC+1 bl...@furius.ca wrote: > >> On Thu, Feb 11, 2021 at 6:23 PM kuba@gmail.com >> wrote: >> >>> Thank you both, >>> >>> Martin for the beangulp documentation and Dan for the

Re: beancount.ingest is no more. Long live beangulp!

2021-02-11 Thread Martin Blais
On Thu, Feb 11, 2021 at 6:23 PM kuba@gmail.com wrote: > Thank you both, > > Martin for the beangulp documentation and Dan for the clear instructions. > > As a result I've managed to convert one of my scripts quite easily. > > However on running the extract command, I am immediately hit with

Re: beancount.ingest is no more. Long live beangulp!

2021-02-11 Thread Martin Blais
int (all code >> outside the beancount repo will use a single import just like numpy, and >> that probably will break any circumstancial compatibility with v2 for >> projects that migrate to that api). >> >> >> >> >> On Tue, Feb 2, 2021, 01:28 Marti

Re: Frustration

2021-02-08 Thread Martin Blais
If you work like that you can also use the "location" column in bean-query in combination with Emacs to jump around the selected transactions, e.g. with "next-error". On Mon, Feb 8, 2021 at 7:43 PM Justus Pendleton wrote: > On Monday, February 8, 2021 at 12:28:16 AM UTC+7 dustin...@gmail.com >

Re: Frustration

2021-02-07 Thread Martin Blais
On Sun, Feb 7, 2021 at 10:24 AM Dustin Farris wrote: > I've been using beancount for a little over a year to manage my personal > finances as well as some side self-employment accounting. I have twice > gotten frustrated to the point of trying other products (specifically > Personal Capital,

Re: Tracking after-tax vs pre-tax 401k contributions

2021-02-06 Thread Martin Blais
I do the same thing; I use OFX for the 401k (I think I say "quicken, to separate accounts"), and CSV for the Roth. Four subaccounts in the 401k. There's still a fair bit of rounding issues in assertions, but at the four digits level, and I use the ~ syntax on the Balance directive to disregard

Re: Loss reported as profit

2021-02-02 Thread Martin Blais
One important design decision in beancount (an idea borrowed from Ledger originally) is to do away with credit accounts and debit accounts. Income, liabilities and equity accounts all normally have negative signs, so that is correct. (It's a bit like programmers counting from zero and not one).

Re: beancount.ingest is no more. Long live beangulp!

2021-02-02 Thread Martin Blais
that migrate to that api). On Tue, Feb 2, 2021, 01:28 Martin Michlmayr wrote: > * Martin Blais [2021-02-02 01:20]: > > - Nothing changed in v2, everything is still there. > > If you want things stable, stick with v2. > > Since beangulp creates transactions on stdout, is it possi

beancount.ingest is no more. Long live beangulp!

2021-02-01 Thread Martin Blais
Hi, Part of v3 plans is thinning out the repository. I've just moved the beancount.ingest directory from beancount to a new repository. Announcing: https://github.com/beancount/beangulp In keeping with all things of the bean (beanthings?), this one becomes "beangulp". I hope you like the name,

Re: Accounting for year-end income

2021-02-01 Thread Martin Blais
SGTM On Mon, Feb 1, 2021 at 10:03 AM Aaron Stacy wrote: > Hi everyone, I'd like to account for 2020 income at the end of the year > that didn't show up in my bank account until 2021. > > Typically I use the date funds are available in my account as the > source-of-truth for reconciling income

Re: replace mailing group by forum?

2021-02-01 Thread Martin Blais
On Mon, Feb 1, 2021 at 6:54 AM Kirill Goncharov wrote: > I suggest switching to beancount/docs as a primary documentation source. > Everyone will be able to contribute to it, and no additional services will > be needed. Also, sooner or later gdoc conversion pipeline will stop working > so it's

Re: replace mailing group by forum?

2021-01-31 Thread Martin Blais
Some people do the Discord thing. I find it too distracting. I don't have the time. Plus it's hit-or-miss when you show up whether the right people happen to me there or not. We probably should have some way for people to add / edit a shared KB. We've been working with Gdocs so far, not just me,

Re: beanprice Error: Trim end date is before start date

2021-01-31 Thread Martin Blais
PM Ghanashyam Prabhu wrote: > Interesting that it was working a week before. I am not an expert at > debugging python but I'll give it a try. > > On Sat, 30 Jan 2021 at 19:03, Martin Blais wrote: > >> There's a bug in beanprice. >> This looks related to code submitted f

Re: beanprice Error: Trim end date is before start date

2021-01-30 Thread Martin Blais
There's a bug in beanprice. This looks related to code submitted from a PR a little while ago that I copied over when I moved the repo. A test is still missing: https://github.com/beancount/beanprice/commit/b2685fea866a8696f9d5c25e851d30b62d6a02a2 On Sat, Jan 30, 2021 at 5:29 PM Ghanashyam

bean-doctor context upgrades (now works with invalid transaction!)

2021-01-30 Thread Martin Blais
Beancount users! I've just fixed a long-standing bug that's been driving me crazy and that has a high impact on usability, I need to bring this to your attention. In fact, this fix is so important I've decided to make an exception on new code in v2 and put it in that branch so you can all enjoy

Announcing: beangrow

2021-01-27 Thread Martin Blais
I just moved the returns code related to this: http://furius.ca/beancount/doc/returns from beanlabs/returns ( https://github.com/beancount/beanlabs/tree/59d1bdf2f1c2e7f53785f6b3301ea91dda1cf3e5/beanlabs/returns ) to a new, dedicated repository at https://github.com/beancount/beangrow No

petl (Was: Re: Visidata)

2021-01-25 Thread Martin Blais
Here's another absolute source of joy: petl https://petl.readthedocs.io/en/stable/ While I like Pandas, I find its various attempts to leverage Python syntax difficult to remember and I always fumble with dataframes and indices. A while ago I wanted something more predictable, using just regular

Re: Recording Transaction Fees

2021-01-22 Thread Martin Blais
See the v3 doc, there's an item for solving that. https://docs.google.com/document/d/1qPdNXaz5zuDQ8M9uoZFyyFis7hA0G55BEfhWhrVBsfc/edit# It's not 100% obvious the right way to do it - adjusting the cost basis with a plugin / scan of the entries will make it more difficult to match against a

Re: How to transfer lots between accounts and how to query lot information?

2021-01-22 Thread Martin Blais
https://github.com/beancount/beancount/issues/614 On Fri, Jan 22, 2021 at 9:14 AM Martin Blais wrote: > This "transfer with cost" problem is becoming a FAQ for crypto users. > We're going to have to implement something automatic eventually. > > > > On Tue, Jan 19

Re: How to transfer lots between accounts and how to query lot information?

2021-01-22 Thread Martin Blais
t;>>> 18078.87 USD >>>>>>>> Assets:US:Crypto:Coinbase:Cash-3500.00 USD >>>>>>>> Assets:US:BofA:Checking-256.48 USD >>>>>>>> >>>>>>>> ;; All the below transactions are purc

Re: Requesting recommendation for tracking capital gains

2021-01-19 Thread Martin Blais
and reconciled a ton of errors I had made in recording. I need to write a doc on it) On Tue, Jan 19, 2021, 00:06 Ghanashyam Prabhu wrote: > Got it, I have updated the changes. I now understand the capital gains > recording concept. > > > On Mon, 18 Jan 2021 at 18:55, Mart

Re: How to transfer lots between accounts and how to query lot information?

2021-01-18 Thread Martin Blais
This looks all wrong, see other thread. To buy BTC at Coinbase, the money all comes from your Coinbase:Cash account. Transfers from your bank are separate transactions. Reflect what's actually going on in the account On Mon, Jan 18, 2021 at 8:35 PM Ghanashyam Prabhu wrote: > I had a similar

Re: Recommendation on beancount for Crypto transactions

2021-01-18 Thread Martin Blais
+1 On Mon, Jan 18, 2021 at 7:33 PM Ben Blount wrote: > Income accounts are negative. Your transaction should be > 2020-11-26 * "Coinbase" "Sell BTC at Coinbase" > Assets:US:Crypto:Coinbase:BTC -0.22712412 BTC {} @ 16539.50 USD > Assets:US:Crypto:Coinbase:Cash 3756.53 USD >

Re: Requesting recommendation for tracking capital gains

2021-01-18 Thread Martin Blais
On Mon, Jan 18, 2021 at 7:23 PM Ghanashyam Prabhu wrote: > I am currently maintaining a beancount ledger file for tracking my crypto > transactions and I'd like to seek advice on the workflow especially when > recording capital gains from these transactions. Below is an example. > > Let's say I

Re: Custom script that iterates postings with `open on` and `close on` dates

2021-01-17 Thread Martin Blais
e query from above ...' > ast = Parser().parse(text) > compiled = compile(ast, TargetsEnvironment(), > FilterPostingsEnvironment(), FilterEntriesEnvironment()) > columns, results = execute_query(compiled, entries, options) > > Thanks again for taking the time to help! > > On Sat,

Re: Questions about changes in equity account

2021-01-17 Thread Martin Blais
On Sun, Jan 17, 2021 at 4:33 AM Jason Zhang wrote: > Hello everybody, > > I searched the beancount docs and Google Group and didn't find exactly > what I needed, so maybe someone here can help me. > > What is the best way to work with retained earnings? I see that the > account

Re: Custom script that iterates postings with `open on` and `close on` dates

2021-01-16 Thread Martin Blais
If you're only interested in income just filter the date interval you need. The "close" operation is essentially there to ensure that the balances of the assets/liabilities accounts are correct when you filter out transactions from the past, i.e., it just inserts a transfer from all of the past's

Re: Per posting effective dates plugin

2021-01-16 Thread Martin Blais
In v3 you'll be able to insert a date in front of a posting and have the difference automatically inserted & removed to/from a transfer account. For the equal split case, it should be pretty straightforward to build a plugin to do just what you describe below. On Sat, Jan 16, 2021 at 10:10 AM

Re: Rental P

2021-01-12 Thread Martin Blais
>From a high level - and I don't have time to dig too deep into the details right now - it's a matter of handling accounts differently depending on the scenario you desire to implement. For instance, you could have completely separate ledgers for each of the entities, but if you want joint

Re: Rental P

2021-01-12 Thread Martin Blais
IIRC that's something that can be built on top of Beancount, that can probably be build with some juggling of accounts. Here's the doc: https://docs.google.com/document/d/1nf_yCiLuewVCEjkXq9Kd9SqbZGWqcs0v0pT5xQnkyzs/edit Probably doesn't have to be part of the core. On Tue, Jan 12, 2021 at 9:35

Re: Can I make a balance assertion about market value? (I think not)

2021-01-08 Thread Martin Blais
Exactly what I'd say. There's no built-in way to do it, and I also don't see it as useful: if you've asserted the number of units and your price points are in the file correctly, I don't see how this helps very much. In the VLT it would be super fun for balance assertions to be completely

Re: Why am I getting the No position matches error?

2021-01-04 Thread Martin Blais
://github.com/beancount/beancount/issues/602 >> >> On Mon, Jan 4, 2021 at 11:36 AM Martin Blais wrote: >> >>> On Mon, Jan 4, 2021 at 10:40 AM Peter wrote: >>> >>>> To be frank, I think I don't fully understand your reply to the problem. >>>

Re: Why am I getting the No position matches error?

2021-01-04 Thread Martin Blais
https://github.com/beancount/beancount/issues/602 On Mon, Jan 4, 2021 at 11:36 AM Martin Blais wrote: > On Mon, Jan 4, 2021 at 10:40 AM Peter wrote: > >> To be frank, I think I don't fully understand your reply to the problem. >> > > Just showing how to debug the issu

Re: Why am I getting the No position matches error?

2021-01-04 Thread Martin Blais
On Mon, Jan 4, 2021 at 10:40 AM Peter wrote: > To be frank, I think I don't fully understand your reply to the problem. > Just showing how to debug the issue. > > The context of the first transaction is just fine, yes. > The only USDT lot in the Assets:Crypto:USDT:Binance account is reduced

Re: Balance Assertions on Income and Expense a/c

2021-01-04 Thread Martin Blais
This is a nice idea but ther'es a lot of more pedestrian stuff to come before. I think you can easily write a script to do this right now. Just create an instance of Inventory, iterate through the subset of transactions relevant for you, accumulate all their postings in there and check that

Re: PIVOT BY clause not supported yet (2.3.1)?

2021-01-03 Thread Martin Blais
I know. Send me a patch? On Sun, Jan 3, 2021 at 2:51 AM Altynbek Isabekov < altynbek.isabe...@gmail.com> wrote: > I had to come up with a workaround for interval summaries: > > https://www.isabekov.pro/multiperiod-hledger-style-reports-in-beancount-pivoting-a-table/ > > Having "PIVOT BY period"

Re: Capital Gains Report

2021-01-03 Thread Martin Blais
The right thing to do is to have the reduction code log matching ids on the augmenting and reducing lots, so that a single pass over the entries can then gather all the trades (combinations of augmenting and reducing lots) from any subset of transactions. I've been getting by on custom scripts so

Re: Upper/lowercase functions for BQL

2021-01-03 Thread Martin Blais
You got it Merged On Sun, Jan 3, 2021, 03:34 redst...@gmail.com wrote: > Hello Martin, > Would you have concerns about adding these to BQL? Or is there a way to do > this (via SUBST?) that I'm not aware of? > > This is handy when grouping by description (eg: expense analysis) and > wanting to

Re: InteractiveBrokers

2020-12-31 Thread Martin Blais
ModuleNotFoundError: No module named 'beanlabs' >>> On Thursday, December 31, 2020 at 12:57:58 AM UTC+7 bl...@furius.ca >>> wrote: >>> >>>> >>>> https://github.com/beancount/beanlabs/tree/master/beanlabs/importers/ibkr >>>> >>

Re: InteractiveBrokers

2020-12-30 Thread Martin Blais
wrote: >> >>> I care :) >>> >>> On Wed, 30 Dec 2020 at 09:47, Martin Blais wrote: >>> >>>> No idea. >>>> >>>> Happy to share this importer if anyone cares. >>>> >>>> >>>> >>>>

Re: How to transfer lots between accounts and how to query lot information?

2020-12-30 Thread Martin Blais
On Wed, Dec 30, 2020 at 1:39 AM redst...@gmail.com wrote: > On Tuesday, December 29, 2020 at 10:02:15 PM UTC-8 bl...@furius.ca wrote: > >> On Wed, Dec 30, 2020 at 12:55 AM redst...@gmail.com >> wrote: >> >>> That makes sense. I was thinking of a system where >>> plugin/booking/interpolation

Re: InteractiveBrokers

2020-12-30 Thread Martin Blais
https://github.com/beancount/beanlabs/tree/master/beanlabs/importers/ibkr On Wed, Dec 30, 2020 at 4:11 AM Adrian Utrilla wrote: > I care :) > > On Wed, 30 Dec 2020 at 09:47, Martin Blais wrote: > >> No idea. >> >> Happy to share this importer if anyone cares. &g

Re: InteractiveBrokers

2020-12-30 Thread Martin Blais
No idea. Happy to share this importer if anyone cares. On Wed, Dec 30, 2020 at 3:26 AM Ben Blount wrote: > Are these apis only available for IBKR Pro? > > On Wed, Dec 30, 2020, 00:12 Martin Blais wrote: > >> Thank you! >> >> And actually, for the recor

Re: InteractiveBrokers

2020-12-30 Thread Martin Blais
single table including a balance column. >> >> On Wed, Dec 30, 2020 at 1:17 AM Martin Blais wrote: >> >>> Thx Martin. >>> I was hoping to find something that works without having to access the >>> API. >>> >>> >>> On Wed, Dec

Re: InteractiveBrokers

2020-12-29 Thread Martin Blais
Thx Martin. I was hoping to find something that works without having to access the API. On Wed, Dec 30, 2020 at 1:10 AM Martin Michlmayr wrote: > * Martin Blais [2020-12-30 00:56]: > > Does anyone here have an importer for Interactive Brokers? > > https://github.com/tarioch

Re: How to transfer lots between accounts and how to query lot information?

2020-12-29 Thread Martin Blais
Is this a bug, or am I using the >>>>> plugin wrong? >>>>> >>>>> Balances before transaction >>>>> >>>>> Assets:Binance:XYZ100 XYZ {2 EUR, 2020-12-25} >>>>> Assets:Binance

Re: How to transfer lots between accounts and how to query lot information?

2020-12-29 Thread Martin Blais
2-25 * "Binance" "Sell 120 XYZ" >>>> Assets:Binance:XYZ -120 XYZ {4 EUR, 2020-12-25} ; -480 EUR >>>> Assets:Binance:EUR 480 EUR ; 480 EUR >>>> >>>> >>>> Basis: (-480 EUR) >>>

InteractiveBrokers

2020-12-29 Thread Martin Blais
Does anyone here have an importer for Interactive Brokers? They don't seem to have any way to download a single table report of all balance-affecting transactions. Best I can find is their "activity report" which has the information scattered over multiple subtables embedded in a single table.

Re: How to transfer lots between accounts and how to query lot information?

2020-12-29 Thread Martin Blais
> * Assets:Binance:XYZ -120 XYZ {4 EUR, 2020-12-25} >> >> * Assets:Binance:EUR 480 EUR >> >> >> On Saturday, December 26, 2020 at 5:17:08 PM UTC+1 bl...@furius.ca wrote: >> >>> Here, re

Re: Newbie: How to manage option trades?

2020-12-29 Thread Martin Blais
On Tue, Dec 29, 2020 at 11:24 AM Tuno Tunante wrote: > Hi, > > What I'm doing (I did the last yesterday) is like that: > > 2020-12-28 * "TD" "Sell Put MO 15 JAN 2021 Strike 40 @0.40" #Option #Put # > MO #Sell > Income:Options:TD -40.00 USD > Expenses:Comission:TD 0.67 USD > Assets:Account:TD

Re: Newbie: How to manage option trades?

2020-12-28 Thread Martin Blais
On Mon, Dec 28, 2020 at 5:47 PM Rajath Agasthya wrote: > Hi all, > > First of all, thanks to all the contributors (especially Martin) for this > wonderful tool! I'm new to double entry accounting and Beancount, but I'm > blown away at how simple yet powerful this tool is, especially when >

Re: Why are there too many missing numbers in this transaction?

2020-12-28 Thread Martin Blais
BTW, I don't recommend using plugins.book_conversions, that was just a POC, not supported. It's actually gone in v3. On Mon, Dec 28, 2020 at 2:16 PM Martin Blais wrote: > Never mind; done > https://github.com/beancount/beancount/issues/598 > > > On Mon, Dec 28, 2020 at 2:15

Re: Why are there too many missing numbers in this transaction?

2020-12-28 Thread Martin Blais
Never mind; done https://github.com/beancount/beancount/issues/598 On Mon, Dec 28, 2020 at 2:15 PM Martin Blais wrote: > The inference code has limits. > However, this is one which seems like it should have been > resolvable, since you declared FIFO (there are two lots matching).

Re: Why are there too many missing numbers in this transaction?

2020-12-28 Thread Martin Blais
The inference code has limits. However, this is one which seems like it should have been resolvable, since you declared FIFO (there are two lots matching). Can you file a ticket? Thx On Mon, Dec 28, 2020 at 11:32 AM Peter wrote: > Hi, > > I'm still trying to figure out, how to account my

/experiments -> beanlabs

2020-12-27 Thread Martin Blais
Just a quick note on v3 progress that may affect some of you: I moved the vast majority of the scripts/prototypes under /experiments outside of the code Beancount repo. This is performed on the stable (v2) branch and on the development (master) branch. Moving this code out of the repo is in line

Re: Couple of questions on BeanQueryLanguage

2020-12-27 Thread Martin Blais
On Sun, Dec 27, 2020 at 8:55 AM Peter wrote: > Hi, > > I'm trying to figure out how to use BQL properly. I ran into some cases > where I don't know what I am doing wrong: > > *Properly use the WHERE clause* > *==* > > I tried to select all lots which market value is

Re: Calculating Portfolio Returns

2020-12-26 Thread Martin Blais
Hey Thanks Red! That's a really nice summary of your user journey. I'm glad to see others picking this up and using it. On Sat, Dec 26, 2020 at 3:00 AM redst...@gmail.com wrote: > This is fantastic, thanks for sharing, Martin. I typed up a review of my > experiences with it. See the doc here

Re: How to transfer lots between accounts and how to query lot information?

2020-12-26 Thread Martin Blais
Here, refined further to show how it's leveraging the reduction spec: https://github.com/beancount/beancount/blob/master/experiments/plugins/transfer_lots_test.py Maybe this should be part of the builtin plugins. Love my little plugin system On Sat, Dec 26, 2020 at 11:14 AM Martin Blais

Re: How to transfer lots between accounts and how to query lot information?

2020-12-26 Thread Martin Blais
Here, that's what I meant: https://github.com/beancount/beancount/commit/9e6e8f8c3793982a6de5af5321e3026d326f8170 This plugin does what you want (I think). On Sat, Dec 26, 2020 at 10:29 AM Martin Blais wrote: > On Wed, Dec 23, 2020 at 11:11 PM Justus Pendleton > wrote: > >&g

Re: How to transfer lots between accounts and how to query lot information?

2020-12-26 Thread Martin Blais
On Wed, Dec 23, 2020 at 11:11 PM Justus Pendleton wrote: > On Wednesday, December 23, 2020 at 11:03:44 AM UTC+7 bl...@furius.ca > wrote: > >> Short answer is: no, but that's quickly becoming a FAQ from crypto users. >> It could be designed, but that would be a new feature. >> > > I only use Spec

Re: How to transfer lots between accounts and how to query lot information?

2020-12-22 Thread Martin Blais
Short answer is: no, but that's quickly becoming a FAQ from crypto users. It could be designed, but that would be a new feature. On Tue, Dec 22, 2020 at 4:25 PM Tobias H wrote: > Is there a way to automatically transfer lots from one account to another > using FIFO and keeping the prices paid?

Re: bean-price --update feature

2020-12-20 Thread Martin Blais
ate a new >> change in the new repo. >> >> >> On Sun, Dec 20, 2020 at 1:20 PM Martin Blais wrote: >> >>> Vivek, the repository has moved to >>> https://github.com/beancount/beanprice >>> Would you like to resubmit it there? >>> >>

Re: bean-price --update feature

2020-12-20 Thread Martin Blais
Had a quick look; updating the branch in v2 isn't trivial (I deleted and revived beanprice during the move by accident). I'll merge manually the changes to ops/lifetimes.py and create a new change in the new repo. On Sun, Dec 20, 2020 at 1:20 PM Martin Blais wrote: > Vivek, the repository

Re: bean-price --update feature

2020-12-20 Thread Martin Blais
Vivek, the repository has moved to https://github.com/beancount/beanprice Would you like to resubmit it there? On Sun, Dec 20, 2020 at 12:48 PM vive...@gmail.com wrote: > Hi Ghanashyam, > Yes, during the migration from bitbucket to github Martin Blais moved it > to > https:

Re: Why doesn't this plugin error give a stack trace?

2020-12-13 Thread Martin Blais
Fixed (in v2). https://github.com/beancount/beancount/commit/628acbfa42d6c0f3b2cd47bd0eae44b4f8b4b0db On Sun, Dec 13, 2020 at 6:45 PM Martin Blais wrote: > That's indeed not consistent behavior and ought to be fixed. > I filed a ticket to look into it, ideally we'd want to get th

Re: Why doesn't this plugin error give a stack trace?

2020-12-13 Thread Martin Blais
That's indeed not consistent behavior and ought to be fixed. I filed a ticket to look into it, ideally we'd want to get the same behavior. https://github.com/beancount/beancount/issues/588 On Tue, Dec 8, 2020 at 8:55 PM James Cook wrote: > I've noticed that sometimes when plugin code triggers

Re: Beancount - V3: G... - @beancount@googlegroups.com I added ...

2020-12-12 Thread Martin Blais
n perform these > operations. I just updated my parser to closely align to the grammar parser > in the latest beancount master. > On Saturday, December 12, 2020 at 1:10:51 PM UTC-5 Martin Blais (Google > Docs) wrote: > >> Martin Blais added a comment to the following document >> Beancou

Beancount - V3: G... - @beancount@googlegroups.com I added ...

2020-12-12 Thread 'Martin Blais (Google Docs)' via Beancount
Martin Blais added a comment to the following document Beancount - V3: Goals & Design (https://docs.google.com/document/d/1qPdNXaz5zuDQ8M9uoZFyyFis7hA0G55BEfhWhrVBsfc/edit?disco=HcFQNNg=5fd507a8=comment_email_document_dm=false) Martin Blais | Added in Dec 2020 after comments and

Re: v3: Allow different dates for different legs of transactions?

2020-12-06 Thread Martin Blais
I'll make it configurable, and separate by sign (though you could provide the same account name to have both postings go to the same place.) On Sun, Dec 6, 2020 at 4:11 PM Chary Chary wrote: > Martin, > > I agree with you, that it needs to be under Assets and/or Liabilities. In > this case

<    1   2   3   4   5   6   7   8   9   10   >