Hi all, I’ve made a little script in bash for calculating the Italian Giacenza Media Annua. Download it here.
It’s a bash script, you can run it on any major operating system (check this page for Windows).
It is based on 2 assumptions:
- Dates are in English and have one of the following formats: ISO 8601; RFC 5322; RFC 3339. For instance, valid dates are: 24 Jul 2019, 2020-07-24.
- Numbers only have the decimal dot. For instance, “3.120,49” is not valid, while “3120.49” is valid.
These requirements are met by the UK version of the Revolut app. I don’t know if switching to English language produces them. Otherwise, just edit your CSV accordingly.
I hope this helps.
I would suggest Revolut to only use ISO 8601 dates and only one decimal point for numbers with a fractional part.