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 yB2ZMF+s22F4zQAAgWs5BA (envelope-from ) for ; Mon, 10 Jan 2022 04:47:43 +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 sPc0LV+s22HyRQEAauVa8A (envelope-from ) for ; Mon, 10 Jan 2022 04:47:43 +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 622083C71B for ; Mon, 10 Jan 2022 04:47:43 +0100 (CET) Received: from localhost ([::1]:35878 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1n6leo-0001z7-7a for larch@yhetil.org; Sun, 09 Jan 2022 22:47:42 -0500 Received: from eggs.gnu.org ([209.51.188.92]:36596) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1n6lZr-00028Z-50 for emacs-orgmode@gnu.org; Sun, 09 Jan 2022 22:42:35 -0500 Received: from out1-smtp.messagingengine.com ([66.111.4.25]:45729) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1n6lZp-0006Ri-0x for emacs-orgmode@gnu.org; Sun, 09 Jan 2022 22:42:34 -0500 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 0D7A25C00E8; Sun, 9 Jan 2022 22:42:32 -0500 (EST) Received: from imap49 ([10.202.2.99]) by compute3.internal (MEProxy); Sun, 09 Jan 2022 22:42:32 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fastmail.com; h= mime-version:message-id:in-reply-to:references:date:from:to:cc :subject:content-type; s=fm1; bh=khpUFSc2COMKXUHKjX1LJjvntMf+BPz eHP8EnLWuuNc=; b=a/IlGb0Htw6ZE49q/x+s40ufUEmrSrpmUqY8dx+kJdyWQlD tpcox3pDY3k9focsf5qKZEr4Yt1R4CucTRMxJbBUTZsPFd4YlqNjZgEbAR2DDkWr S/KSWGhE932YMCGGAyqySOJKbGT51t8YIAjGsZbd3nrERDeYUXVZ9+e/4RxbO127 sSOwUdwllUQ6DnEQqnY6kZkGNo4SDQhGyG6zMl5lVbW2LpsPPotQi/A5gSyHrD6q +e5QfmQBrZaEzhvI1+6J5sWW/SYGaBFRsPY6ucon6nkU4VBID2V4gQed0FIitq+l DJUe5Jon6edmsRIG7dJtE3Dbn7w7qWeAazrGTCg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=khpUFS c2COMKXUHKjX1LJjvntMf+BPzeHP8EnLWuuNc=; b=HJ3rYrQstiGaSUjr4K0N6D kNZY1NM+MTXxMM8ZenI1t5gLa0/noM7zMaj7rpYN9p6H704LN1RrOpaJZkjNPuVn roMJxWbM7cdev/VkbLBNrjUo94f5/jqvqXkCKYACor8JPALzQFRuNjCp4h5WYr7/ garFe7YQV0IDYni1/KygYj6d/exn0UuUCAt0a0zj1NJU2mrWCOTq0KF9ulNbnw40 cJvUDqm4s+cA4iTJitL8u00jqvWroeAMY8JwgEzEujCFZOPi2lUA7Xh3XRhE5A5I j6Zm3JNIutlKgZKOZ2SNQNTlzG4gimqfFtMdsonGJmEehC0BIIXR4agHsfP4ZmLQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvuddrudegledgieegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepofgfggfkjghffffhvffutgesrgdtreerreertdenucfhrhhomhepfdfurghm uhgvlhcuuegrnhihrgdfuceoshgsrghnhigrsehfrghsthhmrghilhdrtghomheqnecugg ftrfgrthhtvghrnhepvddufeeghfeuieeitdffhffghefhgfelleffhfdtffeutdffteei vedtvdejieeinecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrh homhepshgsrghnhigrsehfrghsthhmrghilhdrtghomh X-ME-Proxy: Received: by mailuser.nyi.internal (Postfix, from userid 501) id CA772F6007E; Sun, 9 Jan 2022 22:42:31 -0500 (EST) X-Mailer: MessagingEngine.com Webmail Interface User-Agent: Cyrus-JMAP/3.5.0-alpha0-4527-g032417b6d6-fm-20220109.002-g032417b6 Mime-Version: 1.0 Message-Id: In-Reply-To: References: <137562d1-e6fe-4a68-b18b-abedef513fbd@www.fastmail.com> Date: Sun, 09 Jan 2022 22:42:11 -0500 From: "Samuel Banya" To: "Neil Jerram" Subject: Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet Content-Type: multipart/alternative; boundary=0199028f0472408792c6a3d95945f913 Received-SPF: pass client-ip=66.111.4.25; envelope-from=sbanya@fastmail.com; helo=out1-smtp.messagingengine.com X-Spam_score_int: -27 X-Spam_score: -2.8 X-Spam_bar: -- X-Spam_report: (-2.8 / 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_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, 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.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=1641786463; 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=khpUFSc2COMKXUHKjX1LJjvntMf+BPzeHP8EnLWuuNc=; b=cO6W5nYCsvAcjiAXo4EIIe3Bek/PyNhFySJBC3cTUn8V3HgPzsdiQZWcrXNCM8tIKnmYaq MIFX5ti5TLN91eUr2g4i7PCG2XkaxIwmy18Aj2HdL7Y/fYk1xnbccUoWTi9ZfJHntUgo/F uGEhc5ymOpesxMGW1LP/79QHPlEbUPRbNZrueufCsLTRrtsSYAATQdPPe1P/9wTt3iLpgw OEdgfybGkGzmNumB+lz8h2FaLsxi1COzerNPKMmzObnrslwQelH8yUC+c3vlfYIuHrAtTa PepBkrk5rUawg4uaKoK2zy7c6UuqkG8FrOfd9anDL25VJCipuxL38lvj4BiXWQ== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1641786463; a=rsa-sha256; cv=none; b=UlxpzG5YuwKaWEtqUmpB+ql3dahM235B5JkbyPvP4OHhKM9nRyhm1Pm5LhRfcknN8GlfYa Yu9XGbUkjP0KisG1gXsCQQ/HEZQG7bgEcOzEatii9Mo0F7mBs8JjJW6Algd8y7FyFaeL/v gchdaItzldJJallpRms7+TxkkYF90OV1CHTiFAJReceZNp9qjMy+VdbVNIPOEY1fZf2sFU bTlTJI3rYH3j+ERrjeOVlFlYcsGc6uPj5k355aRDWM0P4VLNYyy1WAWSJE71U78Y6UUNQg CEgqwPTvFEzmg273BDAMF37lgz58rdjOE5wws0Emt+mAZMVCONjbkiUjxMlbhw== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=fastmail.com header.s=fm1 header.b="a/IlGb0H"; dkim=fail ("headers rsa verify failed") header.d=messagingengine.com header.s=fm1 header.b=HJ3rYrQs; dmarc=fail reason="SPF not aligned (relaxed)" header.from=fastmail.com (policy=none); 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: -1.10 Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=fastmail.com header.s=fm1 header.b="a/IlGb0H"; dkim=fail ("headers rsa verify failed") header.d=messagingengine.com header.s=fm1 header.b=HJ3rYrQs; dmarc=fail reason="SPF not aligned (relaxed)" header.from=fastmail.com (policy=none); 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: 622083C71B X-Spam-Score: -1.10 X-Migadu-Scanner: scn1.migadu.com X-TUID: KN3pmKLnKvxa --0199028f0472408792c6a3d95945f913 Content-Type: text/plain Ah, Ledger is way too complicated for what it's worth. I've seen videos on YouTube about it, and every person who's praised it is pretty much too smart enough to be able to explain it in simple terms. I don't like how manual and frequent it is, and for my use case, I just download .csvs from my bank. For what I use it for, Org Mode gets close. I just needed to figure out how I can make those formulas actually work in this scenario using Emacs with Elisp itself. There's gotta be a way to do this, since its weird how the individual rows don't have individual formulas. That's the big weird thing for me personally. Sincerely, Sam On Sun, Jan 9, 2022, at 5:37 PM, Neil Jerram wrote: > > 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 >> --0199028f0472408792c6a3d95945f913 Content-Type: text/html Content-Transfer-Encoding: quoted-printable
Ah, Ledger is w= ay too complicated for what it's worth. I've seen videos on YouTube abou= t it, and every person who's praised it is pretty much too smart enough = to be able to explain it in simple terms.

I= don't like how manual and frequent it is, and for my use case, I just d= ownload .csvs from my bank.

For what I use = it for, Org Mode gets close.

I just needed = to figure out how I can make those formulas actually work in this scenar= io using Emacs with Elisp itself.

There's g= otta be a way to do this, since its weird how the individual rows don't = have individual formulas.

That's the big w= eird thing for me personally.

Sincerely,

Sam

On Sun, Jan = 9, 2022, at 5:37 PM, Neil Jerram wrote:

On Sun, 9 J= an 2022, 17:18 Samuel Banya, <= sbanya@fastmail.com> wrote:

<= div>Hey there,

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

I also save and process my bank account transactions with Org, an= d I agree that it's awesome.  The bank's own website and analysis c= apabilities are rubbish in comparison.

For what it's worth, my approach is:

- Periodically download transa= ctions 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 disp= layed 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 for= mula.  But if it was anything useful in the longer term, I'd add th= e logic to the Scheme coding instead.


So I'd agree with the r= esponse that this kind of thing is a bit too complex for Org table formu= las alone.

Best w= ishes,
     Neil

=

--0199028f0472408792c6a3d95945f913--