Blog Posts

How To Open .jar Files Automatically in Mac OSX

A random program that I installed reset the default application (Java) for .jar files on my Macbook, and to reset the behaviour in Mac OSX took a bit more work than I thought. Turns out the “Java Launcher” isn’t in the list of applications that you can select from, in the “Open With…” list. You’ll need to select “Open With”, choose “Other”, and browse to the following: /Library/Internet Plug-Ins/JavaAppletPlugin.plugin/Contents/Home/bin/java Ensure that it’s set to “Always Open With”, and you should

Continue Reading

Which is Better: Creatine Capsules or Creatine Powder?

Creatine monohydrate may be one of the most common muscle building supplements available out there, but there are so many questions about it. The most studied type of creatine is creatine monohydrate, and it is widely accepted for its performance and value for money. One such question is: what form of creatine is best? The most common forms of creatine are powder and capsules. No conclusive evidence exists to say which form is better, but considering that the stomach digests

Continue Reading

Multivitamin 101: How To Select the Best Multivitamin

I’ve recently been getting interested in bio-hacking, or the process of combining biology with hacking. It’s a fancy term that encompasses things like eating clean, sleeping right, adopting good posture, putting yourself in uncomfortable situations, and so on. One of the things that I’m experimenting with is with supplements, and I’m still in the process of refining what my supplement stack is. However, the core of my supplement stack has got to be a multivitamin. Why A Multivitamin Is Useful

Continue Reading

How To Buy and Sell Forex Pairs

The first currency is the base currency. The second currency is the settlement currency. E.g. for the USD/SGD pair: If you wanted to obtain Singapore Dollars (SGD), you would SELL the USD/SGD pair. If you wanted to obtain United State Dollars (USD), you would BUY the USD/SGD pair. In forex trading and in brokers such as Interactive Brokers, this would be the way you’d convert from one currency to another.

How To Use Wildcard Characters in MySQL statements

You’ll need to make use of wildcard characters to perform powerful searches in MySQL. The 2 wildcard characters that you can use in “LIKE”-queries in MySQL are: % which matches 0 or more characters _ which matches exactly one character To search for a date, you can use a query like the following, which gives you everything that happened from 10 to 19 August of 2015, between 9:01am to 9:09am. SELECT * FROM `yourTable` WHERE `datetime` LIKE ‘2015-08-1_ 09:0%’

How to correctly display CSV files (Excel 2013)

Excel 2013 has an issue displaying files in CSV format that other versions of Excel doesn’t seem to have. To fix this, you’ll just need to open the CSV file with any text editor (like Notepad), and add the following as the first line: sep=, This sets the comma (or any other character that you need) as the separator. Now just save and close the file from your text editor, and then open it with Excel 2013.

Standard Chartered (StanChart SCB) vs Saxo vs Interactive Brokers (IBKR) – Commissions Compared

I’ve been looking at several brokerages that can allow me to start investing through a lazy portfolio in Singapore, and it seems like these 3 brokerages are the most popular: Standard Chartered (or StanChart / SCB) Saxo Capital Markets Interactive Brokers I’ve created a spreadsheet of the commission charges that these brokerages charge me on ETFs on the London Stock Exchange (LSE), as follows. Note: Saxo has recently increased its commissions for counters on the LSE from a minimum of

Continue Reading

Sliding Sidebar