From: Daniele Nicolodi <firstname.lastname@example.org> To: email@example.com Subject: Re: org-tables with monetary amounts Date: Fri, 9 Oct 2020 18:14:08 +0200 [thread overview] Message-ID: <firstname.lastname@example.org> (raw) In-Reply-To: <email@example.com> Hello Christian, thank you for your input. calc support for units indeed covers the basics of working with currencies. I gave it a spin on some notes I have been working on recently. While some things work very nicely, other are a bit ugly. It is a good start and I'll explore this approach more. On 24/09/2020 11:17, Christian Moe wrote: > Now, with the Calc command to simplify units, you can add dollars to > euros and get the result in whichever currency comes first in the > algebraic expression > > | 3 USD | 4 EUR | 6.58 EUR | > #+tblfm: $3=usimplify($2+$1) > > | 3 USD | 4 EUR | 7.6511628 USD | > #+tblfm: $3=usimplify($1+$2) Having to explicitly use usimplify() is a bit too verbose. It would be ideal if this could be somehow be implicit. > I don't use this functionality, so I don't have answers to all the > questions you'll now have -- including how to get the desired precision > without lopping off the currency unit in the last example! Having the desired fixed precision is quite important for this to be useful. In y recent tests I had to drop the units (currencies) to achieve this. It would be nice to find a way to avoid it. > There are ways to enter user-defined units permanently. But exchange > rates change, so to use this functionality on a daily basis, you'll want > to have some kind of function to pull exchange rates and update the > currency unit definitions in the Calc init file. Computations usually refer to a specific point in time, thus this is npt a big problem in practice. I already have scripts to pull exchange rates at a given date. These can the be inserted as a property that can be easily references from the computations. > Apart from `usimplify', most Calc functions on units appear (?) to be > missing corresponding algebraic versions that you can use in Calc > expressions in Org tables, which limits the usefulness. > > Org tables don't seem to have any specific formula syntax for leveraging > Calc unit operations apart from what happens to work out of the > box. This might be an area for improvement, though I'm not sure what to > ask for. I don't understand what you mean in the two paragraphs above. Can you please clarify, maybe with examples? Thank you. Cheers, Dan
next prev parent reply other threads:[~2020-10-09 16:21 UTC|newest] Thread overview: 18+ messages / expand[flat|nested] mbox.gz Atom feed top 2020-09-22 14:57 Daniele Nicolodi 2020-09-22 23:25 ` Nicholas Savage 2020-09-23 9:37 ` Russell Adams 2020-09-23 16:55 ` Eric S Fraga 2020-09-25 11:20 ` Daniele Nicolodi 2020-09-25 11:57 ` Alan Schmitt 2020-09-23 21:26 ` Nick Dokos 2020-09-24 9:17 ` Christian Moe 2020-09-24 11:47 ` Eric S Fraga 2020-10-09 16:14 ` Daniele Nicolodi [this message] 2020-10-12 8:22 ` Christian Moe 2020-10-12 9:43 ` Eric S Fraga 2020-10-13 7:10 ` Derek Feichtinger 2020-10-14 7:38 ` Christian Moe 2020-10-15 20:02 ` Daniele Nicolodi 2020-09-25 9:25 ` Neil Jerram 2020-09-25 11:35 ` Daniele Nicolodi 2020-09-26 18:38 ` Neil Jerram
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox Avoid top-posting and favor interleaved quoting: https://en.wikipedia.org/wiki/Posting_style#Interleaved_style List information: https://www.orgmode.org/ * Reply using the --to, --cc, and --in-reply-to switches of git-send-email(1): git send-email \ --firstname.lastname@example.org \ --email@example.com \ --firstname.lastname@example.org \ --subject='Re: org-tables with monetary amounts' \ /path/to/YOUR_REPLY https://kernel.org/pub/software/scm/git/docs/git-send-email.html * If your mail client supports setting the In-Reply-To header via mailto: links, try the mailto: link
Code repositories for project(s) associated with this inbox: https://git.savannah.gnu.org/cgit/emacs/org-mode.git This is a public inbox, see mirroring instructions for how to clone and mirror all data and code used for this inbox; as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).