Re: how to transfer Lots/cost basis from wallet to wallet

2021-04-10 Thread Martin Blais
It doesn't do that for you. It can book against the existing lots (e.g. with FIFO) but on the opening side (WalletB) it won't know to fill in the corresponding average cost basis. If you do this a lot, you'll have to automate with a script. I think eventually some features need to be built for

Re: transaction costs:

2021-04-10 Thread Martin Blais
Beancount won't be able to work out the booking automatically this way, too many unknown numbers to fill in. On Sat, Apr 10, 2021 at 10:08 AM david e wrote: > wouldn't it be correct to add the transaction costs in its own account > into the transaction, and thereby beancount is able to list

Re: OT: Cryptocurrencies exchange recommendation

2021-04-07 Thread Martin Blais
I've also heard of DeriBit. Binance not available to US residents unfortunately. CME has futures, which are available through TD and Tastyworks. Tasty is a fair bit more hip about it actually - they have a dedicated UI for trading them (long only, no options). They're also introducing NFT tokens

Re: Marking stock options with beancount

2021-04-06 Thread Martin Blais
Search on the mailing-list I'm pretty sure this came up before. I'd have recognized call options using a unique symbol at zero cost and 6.19 is the strike. Then on exercise reducing them while simultaneously opening a position in the company at the current value, reducing the cash account by the

Re: transaction costs:

2021-04-06 Thread Martin Blais
There's no facility to do this. You can write a script to handle the separation by processing the stream of transactions yourself. On Tue, Apr 6, 2021 at 3:16 PM david e wrote: > I am wondering about how to book transaction costs correctly. as I am > doing ethereum tx, I have to track cost

Re: decimal

2021-04-06 Thread Martin Blais
ot;EUR:0.01", it balance > well. with option "inferred_tolerance_default" "EUR:0.0005" , it does not > balance anymore ... > > 2019-09-30 * "Achat" "" > Assets:Titre:PEE0.7996 PEEB {125.055 EUR, 2019-09-30} > Assets:Titre:PEE2.4955 PE

Re: decimal

2021-04-05 Thread Martin Blais
Precision selected for BQL is a bit of a mess. Just another reason why it needs a rewrite. This is really gnawing at me, but I just don't have the cycles to rewrite it Try this in the meantime: option "inferred_tolerance_default" "EUR:0.0005" On Mon, Apr 5, 2021 at 4:08 PM francois PEGORY

Re: Marking stock options with beancount

2021-04-04 Thread Martin Blais
Hi Tuomas, I don't understand your terminology. "Marking" is the process of valuing active positions for the purpose of calculation unrealized P/L. I think you mean "exercise." On Sun, Apr 4, 2021 at 6:49 AM Tuomas Salmi wrote: > > Recently my employer let me to mark some stock options I had

Re: Investments and beanbuff

2021-04-04 Thread Martin Blais
On Sun, Apr 4, 2021, 01:34 redst...@gmail.com wrote: > A number of things. >> >> The slowness is one thing, but like you said, won't be an issue with the >> C++ version. >> The other thing is, for this type of import, usually you need multiple >> steps of import.You have the intra-day or nightly

Re: transaction-level metadata

2021-04-03 Thread Martin Blais
No you're right, the docs on the query tool is insufficient. That tool needs to be generalized and rewritten from scratch. I'm always amazed how much usage this, well, basically what is a prototype, has gotten. On Sat, Mar 27, 2021 at 5:11 PM wrote: > Re, > > On Sat, Mar 27, 2021 at 10:01:39PM

Re: Beanborg

2021-04-02 Thread Martin Blais
Consider doing it integrated well with beangulp. I won't have time to work on it, but I think it's worth making this easy and now common On Fri, Apr 2, 2021, 07:01 Martin Michlmayr wrote: > * redst...@gmail.com [2021-04-02 01:27]: > > Unrelated to the above: have you considered releasing your

Re: Booking date vs Value/Purchase/Trade date

2021-04-02 Thread Martin Blais
This is a known issue, see the settlement dates proposal, is being handled in the c++ rewrite, see v3 design doc. Also lots of history on the mailing list. Currently you either fudge the dates or skip the occasional balance assertion that doesn't want to cooperate. It's unsatisfying but I've been

Re: Beanborg

2021-04-01 Thread Martin Blais
On Thu, Apr 1, 2021 at 6:09 AM Luciano Fiandesio wrote: > Hi, try to answer some of the questions: > > > I'm wondering if your import scripts can be used for building investment > transactions? > I'm not sure, I don't track my investments using beancount. I wish I could > give a better answer.

Re: Investments and beanbuff

2021-04-01 Thread Martin Blais
On Thu, Apr 1, 2021 at 1:27 AM redst...@gmail.com wrote: > *Apologies, meant to start a new thread:* > Awesome, thanks for sharing beanbuff. March seems to be the #ingest month > :). > It's due to Daniele's active involvement in basically taking it over and giving it a good solid revamping.

Re: Beanborg

2021-03-31 Thread Martin Blais
Great stuff Luciano, thank you for sharing, I'll definitely have a good look at it when I find a bit of time. Red: Related to investments, I'm in the process of cleaning up and building common data structures specifically for trading accounts, in a new repo called "beanbuff". Find related codes

Re: Duplicate detection during import

2021-03-30 Thread Martin Blais
Dedup detection is definitely far from perfect and was just something I tried at the time. In the new version - beangulp, which Daniele is driving - dedup can be done by importer. I think that per-importer custom dedup is best. For example, any importer that has a unique ID per transaction should

v3 Booking Redesign

2021-03-26 Thread Martin Blais
Hi, Lately I've been giving thoughts on redesigning the interpretation of reducing postings syntax in Beancount. Here's a new doc: http://furius.ca/beancount/doc/v3-booking https://docs.google.com/document/d/1H0UDD1cKenraIMe40PbdMgnqJdeqI6yKv0og51mXk-0/view Comments and feedback welcome, --

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

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