Re: New to ledger - how to ease in from gnucash?

2016-11-11 Thread Oon-Ee Ng
On Sat, Nov 12, 2016 at 12:03 AM, Simon Michael wrote: > On 11/10/16 11:54 PM, ngoonee.t...@gmail.com wrote: >> entering in two systems to see how I get along with ledger. I understand >> hledger is mostly syntax compatible, beancount isn't though? > > > beancount is more different but still prett

Addendum to payee discussion - what if I DO want multiple payees in a transaction?

2016-12-21 Thread Oon-Ee Ng
Referring to the excellent post here - https://groups.google.com/forum/#!msg/ledger-cli/hkCNoR4-Mjw/p-kNVAmPpngJ What comes to mind in this situation is something like this:- 2016-01-01 * "Went out for a meal with friends" Expenses:Dining25 USD Liabilities:CreditCards:AMEX100 USD

Re: Addendum to payee discussion - what if I DO want multiple payees in a transaction?

2016-12-21 Thread Oon-Ee Ng
hen the money was >> paid back. >> >> It is harder if the transaction has multiple payees though, you'd probably >> need to have tags on the account legs, which I believe has been discussed on >> this list before. >> >> On Wed, Dec 21, 2016 at 3:01 PM

Re: Addendum to payee discussion - what if I DO want multiple payees in a transaction?

2016-12-22 Thread Oon-Ee Ng
helps you disambiguate those postings from others is fair > game. > Subaccounts, metadata, whatevs. > > > On Wed, Dec 21, 2016 at 10:13 PM, Oon-Ee Ng wrote: >> >> Metadata! Yes that sounds like a good solution/workaround at this >> point. Now to go test how metadata is

Gnucash "close books" functionality, remove transactions when import to beancount?

2016-12-22 Thread Oon-Ee Ng
With Gnucash, one of the things I did every calendar year end (private accounts) was to 'close books'. In summary, what it does is create two transactions, the objective of which is to balance all incomes/expenses to zero. The period of time covered is normally a year, but configurable. Quick exam

Re: Renamed beancount-web to fava

2016-12-24 Thread Oon-Ee Ng
I'm trying to get this working with the dev version of fava, but can't run `make build-js` with this error:- for ( var item of map.entries() ) { ^^ SyntaxError: Unexpected identifier at Module._compile (module.js:439:25) at Object.Module._extensions..js (mo

Re: Gnucash "close books" functionality, remove transactions when import to beancount?

2016-12-24 Thread Oon-Ee Ng
, just like you need it. This is an > artifact of reporting. > > If that doesn't work out well for some reason, please let us know (and > please be very specific if you do so, I've thought about this a lot). > > > > On Thu, Dec 22, 2016 at 8:11 PM, Oon-Ee Ng wrote:

Re: Gnucash "close books" functionality, remove transactions when import to beancount?

2016-12-24 Thread Oon-Ee Ng
Sounds very much like using your 'pad' command on 31st December every year for each account? On Sun, Dec 25, 2016 at 5:33 AM, Martin Blais wrote: > On Sat, Dec 24, 2016 at 4:24 PM, Oon-Ee Ng wrote: >> >> Thanks Martin, that sort of confirms my thoughts on the matter.

Re: Renamed beancount-web to fava

2016-12-24 Thread Oon-Ee Ng
3.5/dist-packages/flask/app.py", line 1831, in preprocess_request func(request.endpoint, request.view_args) File "/home/ngoonee/.local/lib/python3.5/site-packages/beancount_fava-1.2.dev0-py3.5.egg/fava/application.py", line 182, in _pull_beancount_file g.beancount_file_slu

Re: Gnucash "close books" functionality, remove transactions when import to beancount?

2016-12-25 Thread Oon-Ee Ng
As of now that's not (yet) a huge concern for me starting from ground zero, but I can see how that would be (maybe?) an issue going forward. Another option would be to declare the plugins at the top of each file (there won't be a ton of files this way) in that situation? My other concern with mult

Re: Renamed beancount-web to fava

2016-12-26 Thread Oon-Ee Ng
Seems the favadev wsgi.py isn't up to date. Using the one from contrib/pythonanywhere/fava worked! On Sun, Dec 25, 2016 at 6:01 AM, Oon-Ee Ng wrote: > Got past that error by using advice from > https://help.pythonanywhere.com/pages/Node/ (used nvm to update > node/npm and added a

Scheduled transactions and interest (compound?) calculations?

2016-12-31 Thread Oon-Ee Ng
It's the new year, and after some setup and testing I'm happily using beancount+fava. Now a few additional questions on the matters in the title:- 1. Scheduled transactions With GnuCash I had a scheduled transaction which would trigger every 19th of the month. The purpose was basically to add

Re: Releasing gnucash-to-beancount 1.0b0

2017-01-03 Thread Oon-Ee Ng
Thanks, I just did that conversion myself using a combination of scripts I found elsewhere and some manual fixes. How does your convertor work with scheduled transactions? On Mon, Jan 2, 2017 at 1:40 PM, Henrique Bastos wrote: > Hi all! > > I've been digging into beancount and I'm very impressed!

Re: Intro documentation

2017-01-08 Thread Oon-Ee Ng
Not sure if this is new (I don't remember seeing it before with your other docs), but I got this error message. Firefox on Arch Linux 64 bit. Your connection is not secure The owner of furius.ca has configured their website improperly. To protect your information from being stolen, Firefox has no

Re: Releasing gnucash-to-beancount 1.0b0

2017-01-16 Thread Oon-Ee Ng
> > I am still trying to fix my conversions for lots, cash dividends, etc... > > On Tuesday, January 3, 2017 at 9:04:02 PM UTC-6, Oon-Ee Ng wrote: >> >> Thanks, I just did that conversion myself using a combination of >> scripts I found elsewhere and some manual fixes. Ho

Showing decimals in fava

2017-01-16 Thread Oon-Ee Ng
I'm not sure if it's a function of number of accounts or filters (or lack thereoff) but I can't seem to get fava to show decimals any more. It just shows rounded amounts, which is fine most-times, but when I want to reconcile accounts and make sure I haven't missed anything it gets to be a hassle.

How do I generate cashflow reports rather than expense reports?

2017-01-24 Thread Oon-Ee Ng
I'm looking to estimate an annual/monthly budget, and the simplest way I thought of to do that was to look at my annual expense reports (I have data for almost a decade) to see trends (spending on books and education related stuff is way up due to having young children, as are spendings on food and

Re: How do I generate cashflow reports rather than expense reports?

2017-01-24 Thread Oon-Ee Ng
Darn, hit 'send' too fast! Added another paragraph below... On Wed, Jan 25, 2017 at 4:05 AM, Oon-Ee Ng wrote: > I'm looking to estimate an annual/monthly budget, and the simplest way > I thought of to do that was to look at my annual expense reports (I > have data for

Re: Showing decimals in fava

2017-01-31 Thread Oon-Ee Ng
Anyone? On Tue, Jan 17, 2017 at 5:18 AM, Oon-Ee Ng wrote: > I'm not sure if it's a function of number of accounts or filters (or > lack thereoff) but I can't seem to get fava to show decimals any more. > It just shows rounded amounts, which is fine most-times, but wh

Re: Showing decimals in fava

2017-01-31 Thread Oon-Ee Ng
f all/most/some of your > transactions in that account are missing the cents, it might think that that > particular account doesn't need cents. > > You could also check beancount and fava options, you may have modified a > tolerance option. > > On Tue, Jan 31, 2017 at 7:35 PM

What's the best way to represent multiple contributions to the same account in one transaction?

2017-02-02 Thread Oon-Ee Ng
Having just switched from Gnucash to beancount I thought I may as well record my salary properly from the payslips I keep stashed around. My previous method was just to record the final amount I received in my bank account (all deductions already done), and when tax time came to just cross check t

Re: Showing decimals in fava

2017-02-02 Thread Oon-Ee Ng
ing from the command line) show? > > > > Am 01.02.2017 um 07:31 schrieb Oon-Ee Ng : > > > > My options are very limited. Basically operating_currency, a custom > > option for fava (to use extensions), and the auto_accounts plugin. > > > > I have not modif

Re: What's the best way to represent multiple contributions to the same account in one transaction?

2017-02-02 Thread Oon-Ee Ng
them being Income:EmployerContribution:(EPF|Socso) > to Assets:(EPF|Socso). > > I don't see a problem of duplicating names here. > > On Thu, Feb 2, 2017 at 5:53 PM, Oon-Ee Ng wrote: > >> Having just switched from Gnucash to beancount I thought I may as well >> record my salary pr

Re: What's the best way to represent multiple contributions to the same account in one transaction?

2017-02-04 Thread Oon-Ee Ng
;s a difference between "tax free" (after tax, > or actually tax free) and "tax deferred" payments, it's probably a good > idea to account for those separately, since for tax deferred plans (or > portions) you'll need to pay taxes as you take money out. > &

org-mode + beancount, how to quickly reorganize?

2017-02-04 Thread Oon-Ee Ng
I'm a vim user, but figured going with beancount is as good a reason as any to try emacs out (evil-mode though). Have figured some basics out, but it seems slightly inefficient (especially looking forward to a ton of entries and a growing beancount file). So my file structure (I think fairly comm

Re: org-mode + beancount, how to quickly reorganize?

2017-02-05 Thread Oon-Ee Ng
On Mon, Feb 6, 2017 at 6:45 AM, Martin Blais wrote: > On Saturday, February 4, 2017 at 3:41:17 PM UTC-5, Oon-Ee Ng wrote: >> >> I'm a vim user, but figured going with beancount is as good a reason as >> any to try emacs out (evil-mode though). >> > > Congr

Re: New to beancount - Question about alternative use - Calorie budget.

2017-03-01 Thread Oon-Ee Ng
Another way I've been toying with to abuse beancount is to keep track of car mileage. I have a dedicated app for that now, but since I input every credit card payment for petrol anyway, having a 'currency conversion' to litres (based on the moving price of petrol) as well as a 'miles travelled' cur

Balance, Pad, and 'why should I use an equity account'?

2017-04-13 Thread Oon-Ee Ng
Preamble: I'm a former Gnucash user, and my pre-2017 accounts were imported from there, now using beancount with fava as a complete replacement. Historically, I have an account called Expenses:UnaccountedExpenses which is the balancing account for things that go missing. I have two Cash accounts (

Re: Balance, Pad, and 'why should I use an equity account'?

2017-04-13 Thread Oon-Ee Ng
Another thing to note is that there's likely a fava bug (going to report it now) where balance/pad transactions don't actually update the 'target' account. Bean-web seems to handle this fine. On Fri, Apr 14, 2017 at 6:14 AM, Oon-Ee Ng wrote: > Preamble: I'm a for

Re: Balance, Pad, and 'why should I use an equity account'?

2017-04-13 Thread Oon-Ee Ng
7;re noticing is because you haven't clicked the Pad button to > show padded transactions. They exist, because they're a fundamental > concept in beancount, they're just not displayed by default. > > On Thu, Apr 13, 2017 at 3:18 PM Oon-Ee Ng wrote: > >> Another

Re: Grouping Income accounts

2017-04-14 Thread Oon-Ee Ng
First thing to note is that it's fairly trivial to convert account names (assuming you're handy with your editor, regex, sed, or any other string processing method). That being said, the main difference between Income:Type:Institution and Income:Institution:Type is what the main group is. Using '

Re: Issue #162: Include src/elisp/beancount.el in package (blais/beancount)

2017-04-16 Thread Oon-Ee Ng
Yes, that or include it in melpa/elpa. Though that would be a non-trivial additional load. On Sun, Apr 16, 2017 at 11:47 AM, Rob Smith wrote: > New issue 162: Include src/elisp/beancount.el in package > https://bitbucket.org/blais/beancount/issues/162/include- > src-elisp-beancountel-in-package

Re: Is it possible to create a Budget Account with Beancount?

2017-06-26 Thread Oon-Ee Ng
I like the Fava budget implementation, honestly. Good for visualizing how my spending is going. Fava team is really responsive too. On Sun, Jun 25, 2017 at 4:20 AM, Dominik Aumayr wrote: > Fava indeed has a budgets-feature built on top of custom directives. > You can read more about it in the he

Re: Showing decimals in fava

2017-06-28 Thread Oon-Ee Ng
Bringing this up again as it's bugging me yet again. Do I have to enter all/most of my data with 2 decimal places to get decimal output? Isn't there a way to fix the precision I want for display (both in bean-web and, I presume, in fava)? On Fri, Feb 3, 2017 at 9:56 AM, Oon-Ee Ng wrote

Re: Showing decimals in fava

2017-06-28 Thread Oon-Ee Ng
A quick script later it appears that yes, altering my beancount file to add .00 to whole number transactions 'works'. Will probably find a way to get a fava hook for that, then. On Thu, Jun 29, 2017 at 12:55 PM, Oon-Ee Ng wrote: > Bringing this up again as it's bugging me ye

Re: Envellope budgeting (was Re: Is it possible to create a Budget Account with Beancount?)

2017-07-31 Thread Oon-Ee Ng
On Tue, Aug 1, 2017 at 12:04 AM, Gour wrote: > On Sat, 24 Jun 2017 22:20:26 +0200 > Dominik Aumayr wrote: > > Hello, > > > Fava indeed has a budgets-feature built on top of custom directives. > > You can read more about it in the help pages: > > http://fava.pythonanywhere.com/example-3/help/budg

Re: Eliminate residue?

2017-11-12 Thread Oon-Ee Ng
Am not very familiar, but have you tried 3.70 instead of 3.7? On 7 Nov 2017 3:23 pm, "MetroWind" wrote: > Hi all, > > So I have this entry: > > 2017-09-09 * "" "Meals" > Expenses:Food 39.97 USD > Expenses:Taxes:Consumer 3.7 USD > Liabilities:Credit:Sapphire > > > However the context shows

Re: Eliminate residue?

2017-11-13 Thread Oon-Ee Ng
On Tue, Nov 14, 2017 at 6:12 AM, MetroWind wrote: > On Sunday, November 12, 2017 at 12:45:20 PM UTC-8, Oon-Ee Ng wrote: >> >> Am not very familiar, but have you tried 3.70 instead of 3.7? >> > > Hmm… That’s… interesting. It works! > > Thank you. > > O

Re: fava in a public server

2017-12-06 Thread Oon-Ee Ng
My fava instance is running on pythonanywhere, and we use their login feature. It's for convenience really, doubt anyone would go to the trouble of breaking in to see how much I've spent on toilet paper and diapers. Importantly, the actual beancount files are regularly synced to a private git acco

Re: Fava setup on a publicly available server

2018-02-07 Thread Oon-Ee Ng
I just sync the beancount files via git and run on my VPS a polling script to pull/push as needed. Also I use fava's plugin capabilities to commit every time an edit happens. Conflicts happen once in a while, but manually handling those aren't hard. On Wed, Feb 7, 2018 at 3:14 AM, Konstantin wro

Re: Fava setup on a publicly available server

2018-02-19 Thread Oon-Ee Ng
On Thu, Feb 8, 2018 at 4:50 PM, Stefano Zacchiroli wrote: > On Thu, Feb 08, 2018 at 12:08:40PM +0800, Oon-Ee Ng wrote: > > Also I use fava's plugin capabilities to commit every time an edit > > happens. > > Can you tell us more about this? It's the first time

Re: Unsubscribe the mailing list from issues?

2018-03-13 Thread Oon-Ee Ng
On Sun, Mar 11, 2018 at 11:05 AM, Kamal Marhubi wrote: > I get a lot of value out of seeing conversations on the mailing list, but > much less out of issue tracker updates. Could the list be unsubscribed, and > anyone interested can just subscribe to the project on bit bucket directly. > Thoughts

Re: bean-query and balance assertion

2018-05-19 Thread Oon-Ee Ng
I'm looking into this as well, has this landed (can't see it mentioned in the docs at https://docs.google.com/document/d/1s0GOZMcrKKCLlP29MD7kHO4L88evrwWdIO0p4EwRBE0/edit )? Otherwise I'll look into python scripting for this. On Sunday, March 26, 2017 at 6:35:15 AM UTC+8, Martin Blais wrote:

bean-query saved queries?

2018-09-20 Thread Oon-Ee Ng
Is there a way to save queries (without going through cat | xarg or similar)? Perhaps to a file (or in the beancount file itself)? -- 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, sen

Re: bean-query saved queries?

2018-09-20 Thread Oon-Ee Ng
Thanks! On Fri, Sep 21, 2018 at 10:38 AM Martin Blais wrote: > Use the Query directive. > > 2018-12-31 query "myquery" "select " > > You can define it over multiple lines, and summon it via > > bean-query run myquery > > > > > On

Aggregate query which includes balance

2018-09-20 Thread Oon-Ee Ng
I'm not sure if this is a bug or intended behaviour, so seeking advise here first. SELECT QUARTER(date) as quarter, last(balance) FROM date > 2017-12-31 WHERE account ~ 'Assets:Banking|Assets:Cash' GROUP BY quarter ORDER BY quarter, DESC What it returns is the balances assuming that it starts at

Re: Documentation is now read-only

2018-11-27 Thread Oon-Ee Ng
On Thu, May 10, 2018 at 11:29 AM Martin Blais wrote: > On Wed, May 9, 2018 at 8:29 AM, Martin Michlmayr wrote: > >> * Martin Blais [2018-03-24 00:35]: >> > BTW, here's what the current automated conversion results looks like in >> > your static skeleton: >> > http://furius.ca/tmp/beancount-docs

Sorting of bean-extract output

2018-11-28 Thread Oon-Ee Ng
The output is sorted by day, but within the day outputs aren't sorted (or, rather, they're sorted by line number). Is this reliable behaviour (as-in, should I expect it to change at some point)? The current source file for importing that I'm working on lists transaction in reverse chronological or

Re: Sorting of bean-extract output

2018-11-28 Thread Oon-Ee Ng
On Thu, Nov 29, 2018 at 11:53 AM Martin Blais wrote: > On Wed, Nov 28, 2018 at 10:00 PM Oon-Ee Ng wrote: > >> The output is sorted by day, but within the day outputs aren't sorted >> (or, rather, they're sorted by line number). Is this reliable behaviour >> (a

Nose tests for ingest - do they work OOTB?

2018-11-28 Thread Oon-Ee Ng
I've modified the utrade example in https://bitbucket.org/blais/beancount/src/4c79f94e0858/examples/ingest/office/importers/utrade/?at=default Basically I'm using the structure recommended in 'Importing external data', so I have:- mainfolder -> importers -> tng -> *everything here* tng is the nam

Re: Sorting of bean-extract output

2018-11-28 Thread Oon-Ee Ng
On Thu, Nov 29, 2018 at 2:06 PM Daniele Nicolodi wrote: > On 28/11/2018 20:53, Martin Blais wrote: > > The current source file for importing that I'm working on lists > > transaction in reverse chronological order (I want chronological, in > > this case) but also has a reference numbe

Re: Nose tests for ingest - do they work OOTB?

2018-11-29 Thread Oon-Ee Ng
ted. > Switch to pytest. > > > On Thu, Nov 29, 2018 at 12:56 AM Oon-Ee Ng wrote: > >> I've modified the utrade example in >> https://bitbucket.org/blais/beancount/src/4c79f94e0858/examples/ingest/office/importers/utrade/?at=default >> >> Basically I'

Re: Nose tests for ingest - do they work OOTB?

2018-11-29 Thread Oon-Ee Ng
On Thu, Nov 29, 2018 at 10:15 PM Martin Blais wrote: > On Thu, Nov 29, 2018 at 4:05 AM Oon-Ee Ng wrote: > >> Thanks, that worked. I've run into a simple problem which may or may not >> be a bug. >> >> If there's non python files in the same directory

More than one input file for importers

2018-12-18 Thread Oon-Ee Ng
A e-wallet I've just started to use provides two different PDF files. One lists transactions with minimal details, the other lists a subgroup of transactions with full details. Background - the ewallet is linked with an RFID system used for convenient toll payments at the myriad tolled highways in

Re: More than one input file for importers

2018-12-25 Thread Oon-Ee Ng
>From an accounting perspective, not important at all, since as you rightly pointed out they'd all be the same account. >From an audit perspective, quite important, as that's data which can be used for verification if/when there are double or missed charges. I'd just do without them, but since th

Re: More than one input file for importers

2019-01-09 Thread Oon-Ee Ng
ay have to > figure some stuff out, but that's how I'd do this. > Thanks, something I'll keep in mind, but doesn't make sense (time-wise) to go down this route just yet since I have something working well enough for my needs. > Cheers, > > > > > On Wed, Dec

Re: Newcomer question: How to manage recurring expenses with Beancount?

2019-09-10 Thread Oon-Ee Ng
I use fava's "budget". So for example I have these:- 2017-01-01 custom "budget" Expenses:Automobile:Petrol "yearly" 5000 MYR 2018-01-01 custom "budget" Expenses:Automobile:Petrol "yearly" 7000 MYR 2019-01-01 custom "budget" Expenses:Automobile:Petrol "yearly" 6000 MYR Which allows me to set my an

Auto-balance manually/automatically?

2019-10-01 Thread Oon-Ee Ng
I just had to spend half an hour trolling through a whole bunch of transactions to find the unbalanced one. The account itself has relatively frequent transactions of varying amounts, and had been last checked a month or so ago. Unfortunately the nature of the account is that I don't have a runnin

Fava - automatic balance

2019-10-23 Thread Oon-Ee Ng
Is there any support in fava for running a script/function automatically at set intervals? I have a few use-cases for this, but the one which comes to mind most is automatically generating balance statements for a set of accounts every week/month. -- You received this message because you are sub

Re: Fava - automatic balance

2019-10-27 Thread Oon-Ee Ng
I'd prefer something in fava because that's what I'm running on pythonanywhere, and cron could potentially interrupt the git hooks I also use (I prefer git to borg for this purpose). On Thu, Oct 24, 2019 at 9:19 PM Justus Pendleton wrote: > Do you need something in fava? I just use cron to achie

Re: Payslip Transaction question

2019-12-31 Thread Oon-Ee Ng
Why not just:- 2020-01-20 * "Salary Deposit" Asset:Account:Checking 1880 EUR Expenses:Taxes 870.00 EUR Income:Employer:Salary:Gross-2400.00 EUR Income:Employer:Salary:BonusSpecific -350.00 EUR

Re: BQL query for transfers between assets?

2020-02-13 Thread Oon-Ee Ng
Just wanted to pop in and say "thank you very much". I found this while searching for a way to restrict my queries to only certain types. In my case it was that my prepaid card has a limit on how much it can be topped up from credit card sources, and I'm targeting to hit that limit every month to

Grouping BQL columns

2020-02-14 Thread Oon-Ee Ng
I have this query:- SELECT year, month, account, sum(cost(position)) WHERE account ~ 'Assets:Banking:Institution:*' and joinstr(other_accounts) ~ 'Liabilities:CreditCards' GROUP BY year, month, account ORDER BY year, month, account DESC Works just peachy, and returns 4 columns. Can I

Re: Grouping BQL columns

2020-02-23 Thread Oon-Ee Ng
Anyone? On Sat, Feb 15, 2020 at 9:31 AM Oon-Ee Ng wrote: > I have this query:- > > SELECT > year, month, account, sum(cost(position)) > WHERE > account ~ 'Assets:Banking:Institution:*' > and joinstr(other_accounts) ~ 'Liabilities:CreditCards'

Re: Grouping BQL columns

2020-02-26 Thread Oon-Ee Ng
YMONTH(date), account, sum(cost(position)) > WHERE > account ~ 'Assets:Banking:Institution:*' > and joinstr(other_accounts) ~ 'Liabilities:CreditCards' > GROUP BY YMONTH(date), account > ORDER BY YMONTH(date), account DESC > > > > > On

DATE(year, month, day) isn't the same as date in BQL

2020-02-26 Thread Oon-Ee Ng
A simple query like SELECT date as d, last(balance) works just fine. I would expect the following to do the same thing:- SELECT DATE(year, month, day) as d, last(balance) But it errors out with an AttributeError: 'datetime.date' object has no attribute (get_positions). What am I doing w

Re: GROUP by financial year

2020-03-16 Thread Oon-Ee Ng
Fairly common for some organizations to have financial years starting on (say) 1st August or something similar. Sometimes to sync up with regulatory requirements, sometimes so that bonuses/promotions hit a particular period of the year, sometimes due to expected peak dates for a particular industry

Best practice for adding a currency to a current single-currency system

2020-10-01 Thread Oon-Ee Ng
Hi all, I've got more than a decade of records in a single currency. I've just started a bank account in a foreign country (with a different currency) for investment purposes, so now I suddenly have to look at using more than one commodity in a way I haven't before. First, let me summarise what I

Re: Best practice for adding a currency to a current single-currency system

2020-10-02 Thread Oon-Ee Ng
Thanks Martin! On Sat, Oct 3, 2020 at 11:17 AM Martin Blais wrote: > > On Thu, Oct 1, 2020 at 10:49 PM Oon-Ee Ng wrote: > > > Or is it better (especially for income/expenses accounts) to just declare >> them as multi-currency:- >> 2020-10-02 open Income:InterestIn

Re: Learning path for Emacs beancount mode

2020-10-22 Thread Oon-Ee Ng
If you're coming from vim, the evil-mode really helps. spacemacs is one option for that (emacs has crazy customization possibilities, it can be easier to start from a fixed base). This is diametrically opposed to starting from vanilla emacs, but for vim-familiar users its probably less jarring. O

Re: replace mailing group by forum?

2021-01-31 Thread Oon-Ee Ng
On Mon, Feb 1, 2021 at 2:38 AM nug get wrote: > Dear community, > As a suggestion from my side, how about replacing this mailing group by a > forum? > > pros: > - potentially build a structured knowledge base that is helpful > - user-generated how-to-content > - control notifications > - not spam

Does the fava dockerfile work?

2021-02-21 Thread Oon-Ee Ng
On my x64 machines I've been using yegle's nice and slim docker images, never had an issue. However I've been trying to get fava up on my Raspberry Pi, and yegle's images can't build on ARM due to the base being used (which is fine, space efficiency for the vast majority of users who are on PC is

Re: Does the fava dockerfile work?

2021-02-23 Thread Oon-Ee Ng
faster to build. > > This post has a bit more context: > "Using Alpine can make Python Docker builds 50× slower" > https://pythonspeed.com/articles/alpine-docker-python/ > > On Sun, Feb 21, 2021, 7:36 PM Oon-Ee Ng wrote: > >> On my x64 machines I've been u

Bean-price sources doesn't have Google?

2021-03-02 Thread Oon-Ee Ng
Hi, the bean-price documentation gives an example for getting prices from Google but that source doesn't exist (at least in my V2 install, and doesn't seem to exist in the beanprice standalone GitHub repo either). I'm not sure which source is "better" (and for my holdings I've found yahoo to be ea

Query to group by month starting on arbitrary day of the month

2021-04-04 Thread Oon-Ee Ng
Currently grouping by month (or year) gives primacy to the first day of the month/year as the cut-off point. Is there a way to arbitrarily select a different cut-off point? So for example my credit card statement may get generated on the 15th of each month. For a particular card I may need to know

Re: Query to group by month starting on arbitrary day of the month

2021-04-04 Thread Oon-Ee Ng
On Sun, Apr 4, 2021 at 3:34 PM Oon-Ee Ng wrote: > Currently grouping by month (or year) gives primacy to the first day of > the month/year as the cut-off point. Is there a way to arbitrarily select a > different cut-off point? > > So for example my credit card statement may get g

Which currency exchange rate price source to use?

2021-04-26 Thread Oon-Ee Ng
I've tried out https://github.com/xuhcc/beancount-exchangerates so far, and can't figure out installation for https://github.com/tarioch/beancounttools Exchangerates gives me output looking like this:- 2021-04-27 price USD:CURX. CUR instead of (what I think is supposed to be) the correct

Re: Which currency exchange rate price source to use?

2021-05-07 Thread Oon-Ee Ng
l for the price > lookup might be something else > > > Regards, > > Patrick > On 27.04.2021 05:17, Oon-Ee Ng wrote: > > I've tried out https://github.com/xuhcc/beancount-exchangerates so far, > and can't figure out installation for > https://github.com/tarioc

Re: Which currency exchange rate price source to use?

2021-05-07 Thread Oon-Ee Ng
or > beanprice. I was thinking to move my price fetchers there and planning to > fix it as part of the move. But I haven't heard back anything on my pr for > almost a month, so I should probably enhance them in my repo. Which ones > are you most interested? > > Regards, >

Re: Which currency exchange rate price source to use?

2021-05-08 Thread Oon-Ee Ng
..) do you want to use? > > On May 8, 2021 2:56:00 AM GMT+02:00, Oon-Ee Ng > wrote: >> >> Well I don't really suggest you accommodate my own currency since I may >> possibly be the only beancount user there. Really should be something we >> specify ourselves

Why is lineno required when creating Transactions in an importer?

2021-05-08 Thread Oon-Ee Ng
So creating a new Transaction looks something like the below:- meta = data.new_metadata(file.name, lineno) txn = data.Transaction( meta, date, self.FLAG, None, description, data.EMPTY_SET, data.EMPTY_SET, [ data.Posting(ac

bean-query run QUERY where QUERY contains a space

2021-05-21 Thread Oon-Ee Ng
Is the above possible? If my query looks like this:- 2021-01-01 query "Card Statement Spend" SELECT . It shows up in fava and fava can run it to get the appropriate numbers and graphs, but I can't run `bean-query "run Card Statement Spend"`. I will get the error as below:- ERROR: Syntax erro

Re: bean-query run QUERY where QUERY contains a space

2021-05-23 Thread Oon-Ee Ng
I'm using zsh on Linux... On Sat, May 22, 2021 at 6:07 AM Daniele Nicolodi wrote: > On 21/05/2021 23:45, redst...@gmail.com wrote: > > It runs fine, I use this all the time. > > > > $ cat b.bc > > plugin "beancount.plugins.auto_accounts" > > > > 2021-05-09 * "Just a check" > > Assets:Bank -100

Currency conversions - Equity:Opening-Balances or Equity:Conversions?

2021-07-05 Thread Oon-Ee Ng
I have a few transactions (listed below) converting from SGD to USD:- 2020-11-15 * "Purchase USD with SGD" Assets:Equities:IBKR:USD 7848.00 USD @@ 10577.93 SGD Expenses:Bills:BankCharges 2.00 USD Assets:Equities:IBKR:USD -2.00 USD Assets:Equities:IBKR:

Re: Currency conversions - Equity:Opening-Balances or Equity:Conversions?

2021-07-09 Thread Oon-Ee Ng
a. > > > On Wednesday, July 7, 2021 at 2:49:15 AM UTC+1 bl...@furius.ca wrote: > >> @@ vs @ doesn't change anything but the multiplier. @@ will automatically >> calculate the rate based on the total amount, it doesn't change the opening >> balances or conversio

Fava - restrict display till 'up to today'

2021-08-22 Thread Oon-Ee Ng
Fava's date restriction can easily do 'this year' or 'this month' or a specific year/month etc. Is there any facility for further restricting this to 'up till today'? For example I have various future transactions recorded (mainly credit card bills which can be queued up to be automatically paid o

Re: Fava - restrict display till 'up to today'

2021-08-27 Thread Oon-Ee Ng
Thanks, that works! On Mon, Aug 23, 2021 at 4:12 PM redst...@gmail.com wrote: > Yes. Type "year - day" (or "2019 - day" etc.) in the time bar at the top. > And select the "Daily" display. > > On Sunday, August 22, 2021 at 6:17:50 PM UTC-7 Oon-Ee Ng wrot

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

2022-02-05 Thread Oon-Ee Ng
Looking at this now, and what I have so far is something like this:- bean-query account.bean "select date, LAST(balance) from OPEN on 2022-01-01 WHERE account ~ 'Assets:Checking' and date <= 2022-01-31" This gives me the last balance of the day for each day (dates are one offset due to how it wor

Re: scripting: Is there a function to get value of an account on a given date?

2022-08-16 Thread Oon-Ee Ng
These scripts - do they rely on beancount v3? I'm still on 2.3.5 here On Sun, Nov 28, 2021 at 12:06 AM Martin Blais wrote: > Here, just for you: > > https://github.com/beancount/beanlabs/blob/master/beanlabs/scripts/scan.py#L38 > > > On Sat, Nov 27, 2021 at 10:35 AM Martin Blais wrote: > >> Che

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

2023-02-03 Thread Oon-Ee Ng
Still have the same query (same time of the year so I'm revisiting the same thing). Last year I just manually calculated the monthly averages through copy pasting and the inserting the 'skipped' dates. On Sun, Feb 6, 2022 at 10:55 AM Oon-Ee Ng wrote: > Looking at this now,

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

2023-02-14 Thread Oon-Ee Ng
= df.resample("D").ffill() # Fill days without balances print(filled_df.to_string()) # Balance of every day (for error checking) average_balances = filled_df.resample("M").mean() print(average_balances) # Monthly Average Balance for the last 6 months) On Sat, Feb 4, 2023 at 9:05 AM Oon

Org-mode tables in beancount files?

2023-11-07 Thread Oon-Ee Ng
I've only really used spacemacs for python and beancount for years now, but recently decided to check org-mode out a bit more. Is it possible to have org-mode tables in beancount files? Based on https://groups.google.com/g/beancount/c/L7hUAforJcQ/m/9p_Fp6jqBAAJ?utm_medium=email&utm_source=footer&p