Tips for importing CSVs in GnuCash

Condensing some information so that others can benefit from my experience with importing CSVs into GnuCash. Having several banks means some difficulty in getting a proper overview of your finances. Hence, I use GnuCash to import all transactions and get a good overview of my finances. Getting the data into GnuCash is quite tedious though. Banks don’t typically provide API access. So every once in a while, I log on to each bank, one by one, and download exported transactions.

Read more

The biggest update to Feeder so far

Just a placeholder so far. Needed a known blog to test a few things with. Animated images! And at long last animated in the reader itself! Text formatting A link to Gitlab. Some inline code formatting. And then A code block with some lines of code should be scrollable if one very very long line with many sssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss A table! Table 1. This table demonstrates the table rendering capabilities of Feeder’s Reader view.

Read more

How to setup Transmission-daemon over a Wireguard VPN

Quick post to immortilize the configuration to get transmission-daemon working with a wireguard tunnel. If you don’t have a wireguard tunnel, head to https://mullvad.net/en/ and get one. Transmission config First, the transmission config is really simple: #/etc/transmission-daemon/settings.json { […] "bind-address-ipv4": "X.X.X.X", "bind-address-ipv6": "xxxx:xxxx:xxxx:xxxx::xxxx", "peer-port": 24328, "rpc-bind-address": "0.0.0.0", […] } I also run the daemon using the following service for good measure:

/etc/systemd/system/transmission-daemon.service [Unit] Description=Transmission BitTorrent Daemon Under VPN After=network-online.


Read more

A comparison between fixed and variable interest rates

The data I am using is originally from SwedBank and all data and code is available at GitLab. The data contains interest rates at 5 years fixed term, 2 years fixed term, and 3 months fixed term (also called variable rate in Sweden) for those dates when any rate was changed. The first rates are from 1989-11-01 and the last are from 2018-02-12. Example of the data: 5y 2y 3m Date 1989-11-22 13.

Read more

Reduce the size of images even further by reducing number of colors with Gimp

In Gimp you go to Image in the top menu bar and select Mode followed by Indexed. Now you see a popup where you can select the number of colors for a generated optimum palette. You’ll have to experiment a little because it will depend on your image. I used this approach to shrink the size of the cover image in the_zopfli post from a 37KB (JPG) to just 15KB (PNG, all PNG sizes listed include Zopfli compression btw).

Read more