From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp12.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id OOxKBPlj22FpxwAAgWs5BA (envelope-from ) for ; Sun, 09 Jan 2022 23:38:49 +0100 Received: from aspmx1.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp12.migadu.com with LMTPS id YCDyAPlj22HScAEAauVa8A (envelope-from ) for ; Sun, 09 Jan 2022 23:38:49 +0100 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 B163138377 for ; Sun, 9 Jan 2022 23:38:48 +0100 (CET) Received: from localhost ([::1]:35834 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1n6gpr-0006CG-AX for larch@yhetil.org; Sun, 09 Jan 2022 17:38:47 -0500 Received: from eggs.gnu.org ([209.51.188.92]:55476) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1n6gom-00067F-P7 for emacs-orgmode@gnu.org; Sun, 09 Jan 2022 17:37:44 -0500 Received: from [2a00:1450:4864:20::52f] (port=39652 helo=mail-ed1-x52f.google.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1n6gol-0000cJ-7k for emacs-orgmode@gnu.org; Sun, 09 Jan 2022 17:37:40 -0500 Received: by mail-ed1-x52f.google.com with SMTP id c71so34806482edf.6 for ; Sun, 09 Jan 2022 14:37:38 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=In7qmZ0lXVUnyApg471pXfIZkTXEvZGtZYZAQybQt4g=; b=ZI92diOVOJr2xiyZYswoOowPwzbSjO+x4HwSOrI3fO+0PKXqtTWpM/o3wegtLBRpzw zir/b2tpk1MKeOedN+0ckeQCCE72oPGi+am4oOwg3CnCEJWNyF4DMtcjgsCgu9Au4c8N +ll5lJ+2m11vfARVR1A+qymH1IVJ/X9XT6ZeUNi2WvN2SBSLI035l0g7sch5Pxg7GdBr pUy3W0r81/lBa9zTH+wONgHMnJbynn83JXbCP7+ysUiPN3VbeRFEddjVa0k1Nt7K0HOa ieS/PPNlx3nl957nRVkY3xyYE+fOKxtZXU5hz5bQP1eLZbQcaNPRwq66XMqSnv233U2J 6WMw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=In7qmZ0lXVUnyApg471pXfIZkTXEvZGtZYZAQybQt4g=; b=3II/KngHQ5fD4PdrGZg6ZlBNKsV1CnnKcflDXv3b7PjEWfCzl1mGVml6BqRNW87fTR d02b9CrOYuwMlBPySWAV/ozBAYxjMQhICiBEBXZC5Qvg8Q+pvMVWIcBZ/sz5sQ2EHYAM 1xPehWjFRG4znfavfv2u2zY8QgkqjkVZIBwoGhsj9WEp8rh+kX1/In3VsA7dJ3I6hj40 HGEpoDEoRtcodzT/6RQnybm6Uf+Qt4Zkt7vbuqeMJvgvvdeHSqE2bwOBttjhHcm8cegb 1PFYonPwbui+/D+cnvrCjvRR/2mOl3hY/LymvMloWBdv5vdldRs5GBb62r83knqAsRtQ NVoA== X-Gm-Message-State: AOAM53353KcpIR8UC9kUVTH/KD/Bu7curZy2Aqyt3m6XXVqyyzyF/Thc yNk84V64lLDRMJLn1nbNKGkyCn1KBbolLfO8PC4= X-Google-Smtp-Source: ABdhPJwUbiKwG8z6d8lroC5Ukmj1tcLedsSxBXNfykRJRu2DUbV5BSU4OXuKlKMaUN9vGnNMRRd8Xmswc2a7cF7CGCU= X-Received: by 2002:aa7:d74b:: with SMTP id a11mr3413535eds.214.1641767857081; Sun, 09 Jan 2022 14:37:37 -0800 (PST) MIME-Version: 1.0 References: <137562d1-e6fe-4a68-b18b-abedef513fbd@www.fastmail.com> In-Reply-To: <137562d1-e6fe-4a68-b18b-abedef513fbd@www.fastmail.com> From: Neil Jerram Date: Sun, 9 Jan 2022 22:37:26 +0000 Message-ID: Subject: Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet To: Samuel Banya Content-Type: multipart/alternative; boundary="000000000000ecce4805d52ddd3b" X-Host-Lookup-Failed: Reverse DNS lookup failed for 2a00:1450:4864:20::52f (failed) Received-SPF: pass client-ip=2a00:1450:4864:20::52f; envelope-from=neiljerram@gmail.com; helo=mail-ed1-x52f.google.com X-Spam_score_int: -12 X-Spam_score: -1.3 X-Spam_bar: - X-Spam_report: (-1.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, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RDNS_NONE=0.793, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=no autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: Charles Berry Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN X-Migadu-Country: US ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1641767928; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=In7qmZ0lXVUnyApg471pXfIZkTXEvZGtZYZAQybQt4g=; b=ofJW/qMRl+OdICUnTLyw9NOaheCM9IPAwZMGA66JjlSi8HkrBRnvWs1zNnZt5SN67RJLte s3940+v1uqI1dWFDm7fVv4tjcivuPT+KIoRfWRJoT3wHjHLTV/ydvKFmDbxGOdQ9dmegb0 Qz5v7SoC8LZUN5Jb8bw0AGiWfj0+96Burz/ZuoAVjDy3YLqJD3Q4x4Gx3oWCGb2AM9gjV5 v75uvHkBS1X/tjHEKVCDPP2fU48fXeEJie/NDcqqdeCn4d6oJRR7Wi9sqtlZDLeiGSzxr4 9Vz4zvmRZewH5Fq74FtA/oB8/KT8NjAC08BZhmrY47kiFvIIv9dOwOju1dO5Pw== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1641767928; a=rsa-sha256; cv=none; b=lSLnTiN3oqqGHz1ene60hOq7DaVGrcBucX+Zw02W867kDfqUh/sXjuL5Z1rOcKQ0mqOKAz Lt5u7yHhwyWk0Xm5qkHc6sS095f/20Xe/5u0gp6tUKKpnq0+TGYLq+QrEDvdI7wwrnj8G6 5eLK4q13nT5SdKMRZZLIdUB6MhMkCaFfj8VcjS3wcZGxWHKwHVR2T7ZyobFMmyPZaDATGN HShv6UJz6Gw573LjJZ+ai3BNYDG9HDQdayGo4yLY/Qkc0i0eljP7MkZR+KVe4UAwU7tPOt dTXU3Y1OWoZidQ94uA1ri5b14NV0iEqWSVDwamk4mpnsTIhuuxjXOAu6TrcBwg== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=ZI92diOV; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" X-Migadu-Spam-Score: -5.81 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=ZI92diOV; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" X-Migadu-Queue-Id: B163138377 X-Spam-Score: -5.81 X-Migadu-Scanner: scn0.migadu.com X-TUID: TF5hHSxSMc4u --000000000000ecce4805d52ddd3b Content-Type: text/plain; charset="UTF-8" On Sun, 9 Jan 2022, 17:18 Samuel Banya, wrote: > Hey there, > > So I've been managing my finances via an org doc that basically has tables > that list all the expenses from my bank account, which has been awesome on > some respects. > I also save and process my bank account transactions with Org, and I agree that it's awesome. The bank's own website and analysis capabilities are rubbish in comparison. For what it's worth, my approach is: - Periodically download transactions when available (in OFX format, but that's not important). - Use Org and Babel with Scheme code to run arbitrary analyses over those, with the results displayed in Org tables. - Sometimes there are cases when I need an additional computation on one of the output tables, and I can do that with an Org spreadsheet formula. But if it was anything useful in the longer term, I'd add the logic to the Scheme coding instead. So I'd agree with the response that this kind of thing is a bit too complex for Org table formulas alone. Best wishes, Neil > > --000000000000ecce4805d52ddd3b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

On Sun, 9 Jan 2022, 17:18 Samuel Banya, <sbanya@fastmail.com> wrote:
Hey there,

So I've been managing my finances via an org doc that basically = has tables that list all the expenses from my bank account, which has been = awesome on some respects.

I also save and process my bank account tr= ansactions with Org, and I agree that it's awesome.=C2=A0 The bank'= s own website and analysis capabilities are rubbish in comparison.

For what it's worth, my appr= oach is:

- Periodically = download transactions when available (in OFX format, but that's not imp= ortant).

- Use Org and B= abel with Scheme code to run arbitrary analyses over those, with the result= s displayed in Org tables.

- Sometimes there are cases when I need an additional computation on one= of the output tables, and I can do that with an Org spreadsheet formula.= =C2=A0 But if it was anything useful in the longer term, I'd add the lo= gic to the Scheme coding instead.

So I'd agree with the response that t= his kind of thing is a bit too complex for Org table formulas alone.
<= div dir=3D"auto">
Best wishes,
=C2=A0 =C2=A0 =C2=A0Neil

--000000000000ecce4805d52ddd3b--