Re: New, small utility: find out how recently each account was updated

2025-07-26 Thread Justus Pendleton
This is a nice change that I almost suggested when I first started using needs-update. Some accounts (retirement) only update quarterly, some update monthly (rarely used transaction accounts), and some need updates every 2-3 days (cash) ... and yet others I really only need every 6-12 months (li

How to handle lots with 2 cost basis & 2 acquisition dates?

2025-07-04 Thread Justus Pendleton
I am subject to two tax jurisdictions. Due to reasons, my assets have different dates of acquisitions and thus different costs, in the two jurisdictions. Any ideas on ways to try to handle this in beancount or with outside tools helping? Here's a concrete example to show what I mean 2020-03-12

Re: Issues Transferring Lots between accounts

2025-06-27 Thread Justus Pendleton
On Saturday, June 21, 2025 at 3:43:06 PM UTC+9:30 Red S wrote: Here’s a plugin that does what you want. But more interestingly, the README on that page explains and shows you how to do it. Note that that plugin doesn't actually work

Re: predict postings (e.g. smart_importer) hook for beangulp

2025-05-24 Thread Justus Pendleton
Prabu",""), >> +smart_icici, >> .. >> ] >> >> Basically the individual importer has to be taken out and assigned a new >> name, applied hook and has to be called with new name for it to work with >> smart_importer. I'm not sure if i&

Re: Parameters in Query Directive?

2025-05-20 Thread Justus Pendleton
No, there is no way to use parameters in queries in that way. It would be a nice thing to add though, so you might check the bean-query project and see if there's already an existing request for something like that and voice your support. On Thursday, May 15, 2025 at 4:22:31 AM UTC+9:30 hhmit..

beangulp's duplicate detection, thoughts on how to make more customisable?

2025-04-03 Thread Justus Pendleton
uot;for THIS payee" use a bigger or smaller sliding window. But that's not how extract.mark_duplicate_entries expects to work at all. I could implement a hackish wrapper around similar.heuristic_comparator but not sure that's really the right place for this to live either. Cheers, Justu

Re: Anyone having issues with bean-price --update?

2025-03-31 Thread Justus Pendleton
Yes, I get the same error. I've tried --update a few times and it has never worked for me, though I don't recall if it was always that same error or something else. On Sunday, March 30, 2025 at 3:38:41 AM UTC+10:30 dannyc...@gmail.com wrote: > Hello beancounters, > > I seem to be having issues

Re: BeanCount VSCode Extension (Language Server) ran fully in browser

2025-03-23 Thread Justus Pendleton
I've been using this for a few weeks and find it slightly better that the previously existing beancount plugin for VSCode which always gave me issues autocompleting payees. Plus, the dev has been very responsive with the issues I've found, fixing them all within a day and pushing a new release

Re: predict postings (e.g. smart_importer) hook for beangulp

2025-03-09 Thread Justus Pendleton
the changes after fava supported it). There are still >>> some potential improvements to maybe drop the smartimporter hooks and use >>> standard beangulp hooks but right now it works well. >>> >>> Regards, >>> Patrick >>> >>> O

Re: predict postings (e.g. smart_importer) hook for beangulp

2025-03-07 Thread Justus Pendleton
, Stefano Zacchiroli < > za...@upsilon.cc> wrote: > >On Wed, Mar 05, 2025 at 11:09:10PM -0800, Justus Pendleton wrote: > >> I searched previous posts but couldn't find anyone that had contributed > a > >> beangulp hook that mimics the "predict

predict postings (e.g. smart_importer) hook for beangulp

2025-03-05 Thread Justus Pendleton
I searched previous posts but couldn't find anyone that had contributed a beangulp hook that mimics the "predict postings" thing from legacy smart_importer. This took me way longer than expected since I have no idea what I'm doing but it's been working for me for a few days. https://github.com

Re: beangulp adds newly extracted entries to existing entries before running hooks?

2025-03-05 Thread Justus Pendleton
leg so aren't fully valid beancount yet) have been merged into the training data. I think the right way to handle this is just track existing_entries and "newly imported and deduped entries" separately for purposes of deduplication. Cheers, Justus On Monday, March 3, 2025 at 2:3

beangulp adds newly extracted entries to existing entries before running hooks?

2025-03-02 Thread Justus Pendleton
unt in the ledger, which I am using as a proxy for "last imported date". But the most recent Balance statement I actually find will the one auto-generated by beangulp and then merged into existing_entries. Cheers, Justus -- You received this message because you are subscribed to the Goo

Re: Retirement planning

2024-09-04 Thread Justus Pendleton
TPAW Planner[1] has a pretty good philosophy and Ben Mathew is very responsive to feedback and questions about "why does it do this" on the Bogleheads forum[2]. >From the designer's description: Following the lifecycle model, TPAW combines a "total portfolio" perspective with amortization base

Re: Strategy for multi currency

2024-08-25 Thread Justus Pendleton
FWIW, I have income and expenses in three countries (and three currencies) and have to file taxes in all three and I've never seen a point in having subcategories per-country for either expenses or income. The hard part with any kind of accounting is that your account structure needs to reflect

Re: Loving beangulp

2024-05-27 Thread Justus Pendleton
On Wednesday, May 22, 2024 at 9:59:14 AM UTC+7 Red S wrote: Mini rant: I’d love for anyone who writes an importer to come to the same realization Felipe did, and *write it using the beangulp API*. I have several written several importers. I've never looked at moving them to beangulp. Because

Re: [ANN] beangrep - grep-like filter for Beancount

2024-05-13 Thread Justus Pendleton
This is pretty great! I often need to find some previous transaction and don't remember where it is across multiple beancount files. I'll do a grep, which really just tells me which file(s) and line(s) to look at. Then I need to switch to an editor to actually see more context. Anyway, a few th

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

2024-05-13 Thread Justus Pendleton
On Sunday, May 12, 2024 at 9:13:46 PM UTC+7 nugget@gmail.com wrote: What would be the beancounter's way of handling this? I dont know anything better than manually resolving the "No position matches" errors one at the time by matching and correcting the cost bases. Since my personal investm

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

2024-05-08 Thread Justus Pendleton
This is (probably, I've never looked at what FlexQuery reports) IBKR adding the transaction costs to the cost basis (which is how US tax accounting works). So when you buy something it will have a (very slightly) higher cost basis than whatever the order execution said. On Saturday, April 13, 2

Re: Beanhub-forms, an open-sourced tool for defining custom-form and inserting transactions generated from a template

2024-05-08 Thread Justus Pendleton
Thanks for this, it is pretty nifty. I do an international wire transfer every few months and I always need to scroll through my beancount file to remember the exact format for everything I need to enter (intermediate bank transfer fees, receiving wire transfer fees, the transfer goes exits one

Re: Moving assets between accounts and preserve cost basis?

2023-12-23 Thread Justus Pendleton
This may not help you but I figure I'll mention it here since moving cost basis came up. A few years I wrote a plugin to (try to) do this. "It worked for me" but a user soon reported an issue. You can't ever use the {} syntax. https://github.com/hoostus/beancount-asset-transfer-plugin/issues/1

Re: Indonesian beancounters?

2022-03-12 Thread Justus Pendleton
I'm in SE Asia but I'm not sure that me being in Vietnam helps you much. Overall I'd say that if you can speak English, there's no reason not to just have conversations on this list. It isn't like it is a high traffic list and there's already been plenty of non-American posters over the years (

Opening, closing, then opening an account again

2022-01-15 Thread Justus Pendleton
This is admittedly a fairly trivial edge case with an easy workaround but given that v3 is under development, I figured I'd bring it up. Right now beancount doesn't allow you to close an account and then reopen it. (Only one open directive is allowed.) Should it? This is the scenario I ran into

Re: merge between two funds

2021-09-16 Thread Justus Pendleton
here again about so people can help you out. Cheers, Justus On Wednesday, September 15, 2021 at 3:26:09 AM UTC+7 pfranc...@gmail.com wrote: > recently, one fund was merge into another fund. > how to implement it in beancount knowing that i want to keep the price and > the time when it

Re: transferring inventory from one account to another

2021-09-10 Thread Justus Pendleton
Here's a plugin I quickly threw together to do this. There are a few things in the code I'm not 100% sure about, so consider this a beta and let me know if it seems like it is doing the right thing or not for you. https://github.com/hoostus/beancount-asset-transfer-plugin It uses a custom direc

Re: Moving from GnuCash

2021-06-09 Thread Justus Pendleton
On Wednesday, June 9, 2021 at 4:51:48 PM UTC+7 aakashm...@gmail.com wrote: > It's *extremely* common *in the US*, where I'm going to surmise Brandon is > from. A commercial US accounting package that didn't know about checks > would be laughed out of the room. > Good thing beancount isn't a com

Re: multiple commodities in expenses

2021-05-04 Thread Justus Pendleton
On Monday, May 3, 2021 at 1:37:47 PM UTC+7 jrgo...@gmail.com wrote: > Building on the example discussed, is it best to then have separate > accounts for each currency you operate it? For example: > > Expenses:Restaurants:Canada CAN > Expenses:Restaurants:US USD > In general, with beancount, the

Re: Extensions to currency syntax

2021-03-23 Thread Justus Pendleton
On Sunday, March 21, 2021 at 1:26:56 AM UTC+7 bl...@furius.ca wrote: > - Any of the A-Z characters are now supported, but they require new syntax. > Before this change, only the PSTCURM characters were supported. > Now all characters are supported, BUT YOU HAVE TO QUOTE THEM, like this: > Is

Re: Frustration

2021-02-08 Thread Justus Pendleton
On Monday, February 8, 2021 at 12:28:16 AM UTC+7 dustin...@gmail.com wrote: > The headers I’ve created in my journal are per-institution-account (e.g. > fidelity 401k) with sub-headers by year and then by month. You might want to reconsider whether this level of organization (or any organizati

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

2020-12-23 Thread Justus Pendleton
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 ID booking so I might be missing something but isn't moving lots just

Re: Programmatically Rewriting Ledgers

2020-12-01 Thread Justus Pendleton
On Tuesday, December 1, 2020 at 11:26:13 AM UTC+7 bl...@furius.ca wrote: > One question that will remain is what to do with comments immediately > preceding and/or following a transaction. Those are often associated with > the transaction and slicing and dicing files to put them back together >

Re: Asserting closing balance?

2020-11-18 Thread Justus Pendleton
On Tuesday, November 17, 2020 at 12:35:59 PM UTC+7 bl...@furius.ca wrote: > Here, solved your problem by allowing Balance directives after closure: > > https://github.com/beancount/beancount/commit/12f0e87012fbb5ef7ee11d12bcb6d0c9944ac587 > > Read commentary and patch for justification. > This se

Re: Asserting closing balance?

2020-11-15 Thread Justus Pendleton
On Sunday, November 15, 2020 at 12:30:55 AM UTC+7 James Cook wrote: > This is a minor issue, easy to work around, but I'm wondering if I'm > missing something. > There's an open issue for this and last year I implemented a variant of it https://groups.google.com/g/beancount/c/3ItOYS9DJx4/m/ENDo

Re: Beancount v3 - Constraints & budgeting

2020-07-25 Thread Justus Pendleton
On Saturday, July 25, 2020 at 12:53:26 PM UTC+7 bl...@furius.ca wrote: > Other question: How does forecasting interact with budgeting? Is it > necessary? > I'm not the best person to try to answer this since I don't do forecasting like this. But there's definitely some overlap between them. A b

Re: Proposal on Cost Basis by Mark Lodato

2020-07-22 Thread Justus Pendleton
On Wednesday, July 22, 2020 at 3:53:33 PM UTC+7 Andrzej wrote: > > As one point of data, I would like to track both adjusted and unadjusted > cost basis (in scripts, so it can be some low level representation). > FWIW, I'm in a similar situation due to needing to deal with multiple tax jurisdict

Re: Querying event status as of certain date (more automation, categorizing based on home/away status)?

2020-07-21 Thread Justus Pendleton
It's not a perfect fit but the tag stack is intended for this kind of use case. It isn't perfect because it relies on file position instead of a date. And you'd need a plugin to filter transactions with that tag and rewrite the accounts. There's a divert_expenses plugin that already does someth

Automation being the key to success (aka Know Thyself) featuring ofxclient and Selenium WebDriver

2020-07-16 Thread Justus Pendleton
I'm somewhat amused that you don't have time to spend five minutes once a month downloading CSV files but you have the many, many hours required to investigate, implement, and write about your alternative that saves five minutes a month :) Your approach won't work with any institution that has

Re: Predicted cashflow analysis to power low balance alert

2020-07-15 Thread Justus Pendleton
On Wednesday, July 15, 2020 at 2:50:06 AM UTC+7, Ben Blount wrote: > How would I then ask beancount to give me predicted balances over the next > 31 days? > I don't know if it is the best way but this is how iterate over balances using the beancount API (i.e. python code): https://github.com/h

Beancount v3 - Constraints & budgeting

2020-07-06 Thread Justus Pendleton
The v3 goals & design document expresses an openness to some kind of support for budgeting semantics. Beancount does not support budgeting constraints explicitly, but I think it > would be possible to extend the balance assertion semantics to cover this. > > The current balance assertions check

Re: Beancount v3

2020-07-04 Thread Justus Pendleton
On Saturday, July 4, 2020 at 1:34:50 PM UTC+7, Martin Blais wrote: > > Hi, > Today I'm starting development on Beancount v3. > I'm excited to see (hopefully, fingers crossed!) more active development on beancount restarting. Even though performance hasn't been an issue for me and beancount work

Re: Is there any Beancount user that uses the hi_IN locale?

2020-06-30 Thread Justus Pendleton
On Monday, June 29, 2020 at 11:34:09 PM UTC+7, Martin Blais wrote: > One of the things we might want to do for v3 is make it possible to > specify the locale within Beancount itself (insulating it from its > environment) and perhaps bring back the checks (simply removing the commas > works). OT

Re: Beancount Revisited

2020-05-19 Thread Justus Pendleton
On Sunday, May 17, 2020 at 10:01:12 AM UTC+7, Runar Petursson wrote: > > My real mental block was around how to organize my beans. Single file? > Where do I put new transactions? What about staging transactions from > imports? Auto-match/tag/payee? What about other entities (wholly owned > c

Re: Envelope Plugin for Fava

2020-05-13 Thread justus
(YNAB) so I'll take another more detailed look later. Cheers, Justus -- 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 beancount+unsubscr...@googlegrou

Re: Investment tools for fava

2020-03-23 Thread Justus Pendleton
On Monday, March 23, 2020 at 3:40:11 AM UTC+7, Red S wrote: > > One area that is missing in fava today is investment tools. > I wouldn't mind a bit more investment related stuff in the beancount/fava universe. Rebalancing: > >- consider plugging into a rebalancing tool (example1 ><

Re: New Fava extension: Tax loss harvester

2020-03-11 Thread Justus Pendleton
On Tuesday, March 10, 2020 at 10:32:32 AM UTC+7, Red S wrote: > > I recently shared > a > beancount tool for identifying tax loss harvesting opportunities. This is > the fava plugin version. Starting a new thread for this because th

Re: New tool: Tax loss harvester for beancount

2020-03-09 Thread Justus Pendleton
On Tuesday, March 10, 2020 at 8:30:06 AM UTC+7, Red S wrote: > Meanwhile, I'm working on a fava plugin version. I'm considering > continuing further development only on the fava version, given it's > additional effort to maintain both. Curious: do you use fava, and would you > prefer having thi

Re: New tool: Tax loss harvester for beancount

2020-03-09 Thread Justus Pendleton
On Sunday, March 8, 2020 at 7:54:03 AM UTC+7, Red S wrote: > > I cleaned up a tool I've been using to find opportunities to do tax loss > harvesting from my beancount file, and am sharing it here > . > Nice work! I have a similar script

Re: Per posting effective dates plugin

2020-03-04 Thread Justus Pendleton
On Monday, March 2, 2020 at 6:57:23 AM UTC+7, Red S wrote: > > Good use cases I hadn't thought of. I use my zerosum > > > plugin for some of those use cases, but depending upon one's preference to > dedup their inge

Re: Per posting effective dates plugin

2020-03-01 Thread Justus Pendleton
On Sunday, March 1, 2020 at 4:09:52 AM UTC+7, Red S wrote: > > I find being able to specify different dates for different legs (aka > postings) of a transaction to be valuable. > Very cool. I have (relatively) frequent need for this as well. There are, unfortunately, all kinds of financial trans

Re: Balancing in all possible units

2020-02-18 Thread Justus Pendleton
On Monday, February 17, 2020 at 3:19:36 AM UTC+7, Mark Lodato wrote: > > Upon further reading, it seems that rounding error should be considered > one type of "commission," and beancount does not properly handle > commissions as noted in the docs >

Re: Balancing in all possible units

2020-02-12 Thread Justus Pendleton
On Wednesday, February 12, 2020 at 11:50:02 AM UTC+7, Martin Blais wrote: > Maybe we can come up with some other heuristic to relax the tolerance in > terms of USD, so that the maximum of a list of tolerance values (in USD) > gets used in the current check. I'd be inclined to consider even a >

Re: bean-price --update feature

2020-01-19 Thread Justus Pendleton
On Monday, January 20, 2020 at 5:14:13 AM UTC+7, Andrzej wrote: > Alternatively, does anyone know if there a tool that does something > similar but is outside of beancount main repository? (I'm not a fan of > maintaining my own fork of beancount for this patch) > Vivek mentioned in his original

Re: Bean-query DATE() function not working

2020-01-19 Thread Justus Pendleton
On Saturday, January 18, 2020 at 10:43:15 PM UTC+7, Andrzej wrote: > > When I try to run a date() function it doesn't work in bean-query. > Instead, I get following error: > > beancount> select day(DATE('2019-05-01')) limit 10; > ERROR: Invalid type for argument 0 of Day: found 'beancount.cor

Re: Newbie Questions (2) before I dive in,...please!

2020-01-04 Thread Justus Pendleton
1. None of that is possible with beancount/fava. 2. Yes, that is possible. -- 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 beancount+unsubscr...@googlegroups.com. T

Re: Track cost/value of external portfolio

2019-12-17 Thread Justus Pendleton
On Tuesday, December 17, 2019 at 5:02:30 AM UTC+7, Patrick Ruckstuhl wrote: > > I'm looking at how I can track an "external" portfolio in an easy way. > With external I mean that I can add money to it and see it's current total > value but not dig into the details of how it is invested. I guess

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

2019-11-28 Thread Justus Pendleton
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 > hardcoding a transaction and changing it everytime some historic > transactions pops up? > I would suggest not to use nested accounts like you have in your examp

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

2019-11-22 Thread Justus Pendleton
On Thursday, November 21, 2019 at 8:36:16 PM UTC+7, nug get wrote: > > then Gnucash and going for beancount now, with an account history of about > 3 years. > Out of curiosity, why would you switch from gnucash to beancount? I think the reality is that beancount is implicitly targeting a very ni

Re: bean-price: how to do unrealized gains?

2019-11-20 Thread Justus Pendleton
On Wednesday, November 20, 2019 at 4:59:58 AM UTC+7, nug get wrote: > > I could not so far figure out how I use bean-price to get current market > prices > The screenshot you have shows you getting the current market prices. bean-price fetches the current market prices. It prints them to stdout.

Re: Beancount with large journals

2019-11-20 Thread Justus Pendleton
On Tuesday, November 19, 2019 at 10:07:43 PM UTC+7, huy...@gmail.com wrote: > But every time I insert a new transaction [...] > > I don't know if it's relevant but I'm using beancount fava. > Having to wait 1-2 seconds after each transaction you enter would make anyone frustrated. That said, it

Re: Issue #406: Cannot distinguish between tag and string (blais/beancount)

2019-11-01 Thread Justus Pendleton
On Thursday, October 31, 2019 at 10:14:32 PM UTC+7, mpra wrote: > > Is this a bug or am I missing something? > It looks like a bug. The lexer just turns tags into strings. The comment even says "The tag string itself. For now we don't need an object to represent those; keeping it simple." Whic

Re: Document directives rendered at the end of the day

2019-10-29 Thread justus
On Tuesday, October 29, 2019 at 7:21:33 AM UTC+7, Daniele Nicolodi wrote: > > I don't understand what issue this patch is solving. I have read the > mailing list thread, but I am still confused. > The patch simply implements an open request from a user that I found in the issue tracker. > 2

Fava - automatic balance

2019-10-24 Thread Justus Pendleton
Do you need something in fava? I just use cron to achieve this. I do a bunch of stuff in my "update.sh" Run bean-price, run importers, run bean-format (because I have OCD), look for vacation transactions that aren't tagged with the name of the vacation, look for flagged transactions (to make su

Re: Some commodity prices are not updated by bean-price.

2019-10-20 Thread Justus Pendleton
On Saturday, October 19, 2019 at 3:09:56 PM UTC+7, timoth...@gmail.com wrote: > > DEBUG : Ignoring currency with no metadata: GBX > > DEBUG : Currencies in primary list: > DEBUG : CAD /EUR > DEBUG : EUR /USD > DEBUG :

Re: Document directives rendered at the end of the day

2019-10-20 Thread Justus Pendleton
On Monday, April 11, 2016 at 6:13:46 AM UTC+7, Martin Blais wrote: > > > https://bitbucket.org/blais/beancount/issues/118/create-a-balance_end-directive > To get my feet wet with parser changes, I took a stab at implementing this in https://bitbucket.org/blais/beancount/pull-requests/137/impleme

You Need A Budget 5 (YNAB5) importer

2019-10-07 Thread Justus Pendleton
With Mac OS X Catalina no longer running 32-bit apps[1], it was time to me to begrudging upgrade from You Need A Budget 4 to You Need A Budget 5. This necessitated a total rewrite of the importer I wrote over 2 years ago[2]. The good news is that YNAB's new cloud-based app has a fully functiona

Re: Auto-balance manually/automatically?

2019-10-02 Thread Justus Pendleton
On Tuesday, October 1, 2019 at 3:33:37 PM UTC+7, Oon-Ee Ng wrote: > Is there a way to script an auto-balance? Something as simple as "Find the > balances of this list of accounts and insert a balance statement for all of > them on date X"? > Maybe I'm not understanding what you're asking for bu

Re: What is the best way to connect dividend posting with the stock that pays it ?

2019-09-29 Thread Justus Pendleton
On Monday, September 30, 2019 at 12:06:58 AM UTC+7, timoth...@gmail.com wrote: > > When you say : "I put the symbol in the accoutn name". Does this means > that you have a seperate income:Dividend account per stock ? > Keep in mind that you are, quite literally, getting paid from a different pa

spending control chart script

2019-09-22 Thread Justus Pendleton
Yesterday I put together a script to generate a "process control chart" of spending relative to portfolio size and figured I would share it. Here's the github repo: https://github.com/hoostus/beancount-control-chart It has some command line options, which are hopefully self-explanatory. The id

Re: bean-price --update feature

2019-09-21 Thread justus
Vivek, This looks interesting. The one thing I note is that it is based on the "commodity lifetime". Does that mean that start date is the date used when the commodity is defined? So if I define a commodity as 1976-08-31 commodity VFINX then it will try to fetch every daily price from 1976 up

Re: custom price fetcher: is it possible to specify a commodity ticker explicitly?

2019-08-21 Thread Justus Pendleton
On Monday, August 19, 2019 at 3:22:10 PM UTC+7, gabriele renzi wrote: > > On Mon, Aug 19, 2019 at 2:18 AM Justus Pendleton > wrote: > >> I could not check as I could never get bean-price to run on my ledger >>> file, due to the same error >>> reported here

The end of Mercurial on Bitbucket

2019-08-21 Thread Justus Pendleton
https://bitbucket.org/blog/sunsetting-mercurial-support-in-bitbucket Admittedly Martin has until June 1, 2020, to decide what to dobut I figure I'd post now to see what his initial thoughts are -- You received this message because you are subscribed to the Google Groups "Beancount" gro

Re: custom price fetcher: is it possible to specify a commodity ticker explicitly?

2019-08-18 Thread Justus Pendleton
On Saturday, August 17, 2019 at 8:45:33 PM UTC+7, rff...@gmail.com wrote: > > Maybe this already works for prices defined as metadata for commodities? > Yes, it works for prices defined as metadata for commodities. > I could not check as I could never get bean-price to run on my ledger > file,

Re: Retaining cost bases through conversions

2019-07-09 Thread Justus Pendleton
On Saturday, July 6, 2019 at 5:06:35 AM UTC+7, Red S wrote: > > I'll definitely be scripting this. My original question was to see if > there are built in semantics I'm missing before I go off and script. Sounds > like there isn't. > You should definitely share your script when you're done. I've

Re: beancount.prices.sources.iex.IEXError: Invalid response (403): Forbidden

2019-06-19 Thread Justus Pendleton
On Tuesday, June 18, 2019 at 12:20:00 AM UTC+7, matthe...@gmail.com wrote: > What's the go-to price sources these days? I'm guessing that Yahoo and > Google sources don't work anymore. What should I migrate to? > Yahoo works fine. -- You received this message because you are subscribed to the

Re: journal functions: compute running average in balance / apply filter only to printing output

2019-05-27 Thread Justus Pendleton
On Monday, May 27, 2019 at 1:45:18 PM UTC+7, frea...@gmail.com wrote: > >1. Option --display in ledger-cli allows to select a period of time to >which the output should be limited. This only affects the printing of >results but does not apply a filter for selecting the data from the

Re: Tracking utilities (electricity/gas/water) with real-world meter readings

2019-05-22 Thread Justus Pendleton
On Thursday, May 23, 2019 at 1:00:12 PM UTC+7, bean...@qwfp.nl wrote: > > On Wednesday, 22 May 2019 16:04:43 UTC+2, Justus Pendleton wrote: >> >> On Wednesday, May 22, 2019 at 12:24:10 PM UTC+7, bean...@qwfp.nl wrote: >>> >>> (though I had a fun week "

Re: Tracking utilities (electricity/gas/water) with real-world meter readings

2019-05-22 Thread Justus Pendleton
On Wednesday, May 22, 2019 at 12:24:10 PM UTC+7, bean...@qwfp.nl wrote: > > (though I had a fun week "importing" 6 years of YNAB history (read: > re-recording real transactions from January 1st, 2019, and using YNAB's > reporting features to eyeball 5.5 years of percentage-distributed > categori

Re: Portfolio returns calculator

2019-05-20 Thread Justus Pendleton
ning and end month (as some institutions do) > I thought I already did that. Maybe I only thought about it but didn't actually do it :) Cheers, Justus -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this

Re: Asset Allocation

2019-05-03 Thread Justus Pendleton
There's an existing script that does this, or something very like it at least, so looking at how it works is probably the best place to start https://groups.google.com/d/topic/beancount/O34K2lBYSGg/discussion -- You received this message because you are subscribed to the Google Groups "Beancou

Re: Moving assets with cost basis

2019-05-01 Thread Justus Pendleton
On Thursday, May 2, 2019 at 12:48:34 AM UTC+7, Zhuoyun Wei wrote: > One thing surprises me is that the receiving broker (InteractiveBrokers, > to be exact) does not preserve the cost basis. In its PDF statement and the > TWS, the cost basis of the inbound positions is the price when IBKR > rece

Re: Separate files

2019-05-01 Thread Justus Pendleton
On Thursday, May 2, 2019 at 8:07:37 AM UTC+7, Alen Šiljak wrote: > > A quick question regarding the current statet of multiple (or include) > files and Beancount. > There's no actual question in your post that I can see. I keep things split into 9 files, so if you have a question about it, I'm

Re: Moving assets with cost basis

2019-05-01 Thread Justus Pendleton
On Wednesday, May 1, 2019 at 4:16:48 PM UTC+7, Zhuoyun Wei wrote: > 2019-01-01 * "ACATS" > Assets:BrokerA:Positions -10 ADSK {100.00 USD, 2017-02-01} > Assets:BrokerA:Positions -20 ADSK {110.00 USD, 2017-03-01} > Assets:BrokerB:Positions30 ADSK {170.00 USD, 2019-01-01

Re: Question on best practices (using different account vs payee)

2019-03-13 Thread Justus Pendleton
On Tuesday, March 12, 2019 at 5:28:49 PM UTC+7, mpl...@gmail.com wrote: They are pretty clearly payees so I'dtreat them as payees unless there's a preponderance of evidence that the account approach offers tangible benefits. > 2019-02-04 * "FreelancerName1" "QuickPay with Zelle payment to

Re: Help query market value balance on specific date, and total deposits/withdrawals for ROR calc

2019-02-06 Thread Justus Pendleton
On Wednesday, February 6, 2019 at 10:38:05 AM UTC+7, igor.s...@gmail.com wrote: > > The reason I'm working on these queries is I'd like to compute time valued > rate of returns (example spreadsheet if someone's interested > https://www.bogleheads.org/wiki/Calculating_personal_returns). If anyon

Re: Portfolio returns calculator

2019-01-20 Thread Justus Pendleton
On Sunday, January 20, 2019 at 11:16:14 PM UTC+7, Patrick Ruckstuhl wrote: > > Two things that I found necessary/helpful: > Yeah, as I worked on this and thought about I realised it is pretty hard to make something that is totally universal because of issues like the ones you point out. A posti

Re: Round-trip commissions affecting Adjusted proceeds and costs, e.g. for creating Schedule D Form 8949

2019-01-19 Thread Justus Pendleton
On Sunday, January 20, 2019 at 9:20:01 AM UTC+7, adam...@gmail.com wrote: > > What do other people do? > I just track it explicitly and resign myself to the fact that beancount's definition of cost basis is slightly different from what the IRS thinks. 2018-12-31 * "Sell HOOL" Assets:Schwab -1

Portfolio returns calculator

2019-01-18 Thread Justus Pendleton
Here's my take at a script that will calculate the money-weighted return for a portfolio (i.e. the XIRR function in spreadsheets). https://github.com/hoostus/portfolio-returns All it does it output a single number -- the rate of return. The only real work this script does is crawl through beanc

bean-bake zip files aren't actually compressed

2019-01-03 Thread Justus Pendleton
What compression algorithm should the zipfiles that bean-bake creates use? I noticed today that zip files created by bean-bake aren't actually compressed. This appears to be a result of 71abb59ec78f where the reliance on an external zip program was replaced with the python zipfile module. The Z

Re: returns.py & --date-begin/--date-end

2018-12-19 Thread Justus Pendleton
On Wednesday, December 19, 2018 at 10:19:26 AM UTC+7, Martin Blais wrote: > > If I were you I'd restart from scratch, perhaps using the same three sets > of accounts in order to extract inflows and outflows, but I'd just produce > the cashflows and compute the annualized IRR instead of attempting

returns.py & --date-begin/--date-end

2018-12-17 Thread Justus Pendleton
I recently started trying out Martin's returns.py[1] and have 1 observation & 1 question. 1) It seems a bit prickly about needing price entries and doesn't really work well unless you have them in all the right places. In particular, it doesn't seem to use prices from the transactions themselve

Re: Questions about price sources

2018-11-30 Thread Justus Pendleton
On Thursday, November 29, 2018 at 10:09:22 PM UTC+7, Patrick Ruckstuhl wrote: > > I would like to have a local price database. I do this with beancount > files with price directives. What I'm now looking at is how to update this > price files. They basically contain one entry per day and are upd

Re: How can i distribute amounts between several accounts based on set % or ratio?

2018-11-29 Thread Justus Pendleton
On Friday, November 30, 2018 at 7:27:11 AM UTC+7, mpl...@gmail.com wrote: > > Let say i have transactions going into account Expenses:Rent, and i would > like 60% of total go to Expenses:Rent:Personal and 40% to > Expenses:Rent:Business, > what's the best way to do it? > I think the best way is

Re: Questions about price sources

2018-11-29 Thread Justus Pendleton
On Thursday, November 29, 2018 at 6:49:30 PM UTC+7, Patrick Ruckstuhl wrote: > > Not really I'm accessing different markets which have different times and > some don't have a price every day, so the price date might be a previous > day. > Sure, I do that, too. I'm still not seeing the problem.

Re: Questions about price sources

2018-11-28 Thread Justus Pendleton
On Wednesday, November 28, 2018 at 5:43:07 AM UTC+7, Patrick Ruckstuhl wrote: > 3) I'm planing to fetch prices on a daily basis and write them out as > price directives so that if a price source disappears I still have all the > previously fetched prices, does that make sense? Any easy way to

Re: Announcing beancount-import: powerful, semi-automatic transaction import

2018-10-10 Thread Justus Pendleton
On Wednesday, October 10, 2018 at 6:31:24 AM UTC+7, Martin Blais wrote: > > BTW you should consider using a ^link for that; they were designed for > that purpose. > When there's a unique transaction id available from the files I import, I > always add them as a link. > Could you explain that a b

Re: Announcing beancount-import: powerful, semi-automatic transaction import

2018-10-06 Thread Justus Pendleton
On Saturday, October 6, 2018 at 5:58:32 PM UTC+7, Jeremy Maitin-Shepard wrote: > > One thing I'm unclear on is what sort of workflow you want to have. > > From the documentation of your beancount-ynab project, it sounds like you > manually enter transactions into YNAB, and then periodically impo

Re: Announcing beancount-import: powerful, semi-automatic transaction import

2018-10-06 Thread Justus Pendleton
On Friday, October 5, 2018 at 6:52:57 AM UTC+7, Jeremy Maitin-Shepard wrote: > > - it includes metadata in imported entries that allow it to reliably > associate entries in the journal with external data, so that you don't need > to manually track what has already been imported. > Can you give

Re: beancount with day+time

2018-09-01 Thread Justus Pendleton
On Saturday, September 1, 2018 at 5:46:24 AM UTC+7, MacGregor wrote: > > It shouldn't be the prerogative of accounting software to limit that a > user cannot have two transactions in the same day that involve the same > asset/commodity. > This works perfectly fine in beancount. (I've done it.) H

Re: New project: baskets

2018-08-29 Thread Justus Pendleton
On Friday, August 24, 2018 at 11:15:02 AM UTC+7, Martin Blais wrote: > > However, ETF issuers always provide some way for you to download the > detailed list of holdings since they're marketing to the investor, they're > trying to convince you to use those as investment vehicles. Like those > we

Re: Alphavantage

2018-08-17 Thread Justus Pendleton
Their website says the rate limit is five calls per minute. Is it really that low? -- 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 beancount+unsubscr...@googlegrou

  1   2   >