From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id oKzbJ1XWbV8nZwAA0tVLHw (envelope-from ) for ; Fri, 25 Sep 2020 11:36:53 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id eNqnI1XWbV86ewAAbx9fmQ (envelope-from ) for ; Fri, 25 Sep 2020 11:36:53 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 18AC194060E for ; Fri, 25 Sep 2020 11:36:52 +0000 (UTC) Received: from localhost ([::1]:40798 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kLm1z-0006Ah-Tg for larch@yhetil.org; Fri, 25 Sep 2020 07:36:51 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:59658) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kLm1N-00068v-Jv for emacs-orgmode@gnu.org; Fri, 25 Sep 2020 07:36:13 -0400 Received: from grinta.net ([109.74.203.128]:38908) by eggs.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kLm1J-0000O6-NB for emacs-orgmode@gnu.org; Fri, 25 Sep 2020 07:36:13 -0400 Received: from black.local (unknown [185.159.156.4]) (Authenticated sender: daniele) by grinta.net (Postfix) with ESMTPSA id A124AE53E4; Fri, 25 Sep 2020 11:36:01 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=grinta.net; s=2020; t=1601033767; bh=5RAdQGx2U4RyiiZy0CyFML9BPbblyqK1YjXeAwknk3I=; h=Subject:To:Cc:References:From:Date:In-Reply-To:From; b=KqwcJrNeX3PKwJ0CMKH3VP8CoT3nwCdN6hEgRsQVbRBYU9M01K6o4M+uT1d0nVviH y0RRTcKTdouQ0FrN45Fe30ahrsxxB+HemZ9zof4xaGMmVnZDUVmxFrDuE23sZoQu3w 1/xndVpshz3LkaekQoEzFwvaioWoh1hADWzwXTrkTWg15k38g3kZjPAGf4vGBbKsIM Bt7vKf+bYQKCd0oAXXfigUNryJzelOBpIDPyYkCoQ960fRceHU/eQo6/xGJUYl+TSE wSjL1l5vuy052e8/vY9OFXhHKsG0AGMLTja4NJOEFdc9CHHviJPsqMEQYUtnrI6H0R 9H5slFwnCBZKA== Subject: Re: org-tables with monetary amounts To: Neil Jerram References: <3444a52f-36a7-6e9d-46b9-272dddc7a3ef@grinta.net> From: Daniele Nicolodi Message-ID: <02f504f7-c438-fe9a-b606-8534b66b356f@grinta.net> Date: Fri, 25 Sep 2020 13:35:55 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:68.0) Gecko/20100101 Thunderbird/68.12.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 7bit Received-SPF: pass client-ip=109.74.203.128; envelope-from=daniele@grinta.net; helo=grinta.net X-detected-operating-system: by eggs.gnu.org: First seen = 2020/09/25 07:20:47 X-ACL-Warn: Detected OS = Linux 2.2.x-3.x [generic] [fuzzy] X-Spam_score_int: -22 X-Spam_score: -2.3 X-Spam_bar: -- X-Spam_report: (-2.3 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, NICE_REPLY_A=-0.238, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: Org Mode List Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=fail (rsa verify failed) header.d=grinta.net header.s=2020 header.b=KqwcJrNe; dmarc=none; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Spam-Score: -0.01 X-TUID: Sql+CxJQhXtG On 25/09/2020 11:25, Neil Jerram wrote: > Aside: Perhaps I'm misunderstanding them, but none of the open source > tools, including (h)ledger, seem to be of much help here. > - They focus on data entry and reconciliation, which I don't need as I'm > happy to download and use OFX files from my bank. I don't think the focus of ledger (or hledger, or beancount) is on data entry. Actually beancount even has an ingest framework to deal with importing data from bank statements and other sources. > - They don't offer anything intelligent and automated for automatically > categorizing transactions. For beancount there is smart_importer https://github.com/beancount/smart_importer and it is not difficult to hack your own. I indeed use my own tool based on a simple machine learning algorithm implemented by scikit-learn (Python). > - They don't have a sophisticated representation of a budget, and > reporting against that. I am not sure what you mean by "sophisticated representation of a budged". Once you categorize expenses in a (hierarchical) set of expenses accounts it is trivial to use something like beancount to check the balances against a budget. > Do you know of a good forum (other than this!) for discussing such points? The ledger-cli and the beancount mailing lists may be the right places to discuss the use of these tools. > I've attached mine, in case you read Scheme and there's more detail in > there that is of interest. My use case is very different, thus something external to org-mode is not really useful. Maybe an example would clarify what my use case is. I am working on a research proposal where I need to provide details about funding allocation in a few different categories over a certain amount of years. In my document this is an org-table. Right now I have two choices to edit the table: - have monetary amounts in the cells (example "123.00 EUR") and do the match externally, - do the math in the org-table, specify the right formatting for all computed cells, and still have to post-process it to add the currency symbols to the input cells. Either solution is sub-optimal. It would be nice if org-tables could support monetary fields as they support time fields. Cheers, Dan