Logged ·

portfolio-tracker: mastering your finances

Regrettably, from my experience with software, I discovered that there was no effective solution to assist me in managing my portfolio. This was due to either their high cost or their lack of utility. I'm not interested in applications that merely display obvious information, s…

Logged ·

Handling Floating Point Precision in Spreadsheets

I was working on a spreadsheet for financial calculations when I encountered an issue. At a certain point, I decided to create a conditional formatting to notify me when the value in a cell reached zero. The spreadsheet contained numerous rows, and depending on certain conditio…

Logged ·

Bits #6: Getting Cryptocurrency Prices in Google Sheets

Google Sheets is far better than MS-Excel (IMO) and its googlefinance() function is among one of most used features in my financial spreadsheets. Although very powerful, allowing you to get quotes in a streamlined way, it lacks support for many cryptocurrencies --and I'm not ta…