Posts

Shift-share Analysis Package I developed During my career, I often have to deal with compositional & within group effects. For instance, the employment rate fell by 3% across 2 period. How much of it is due to an increase in employment rate within the sub-group and how much of it is due to compositional shift (for example ageing population). A formal way to explain these effects is known as shift-share analysis.

CONTINUE READING

I wrote an automated email notification code to send out my daily ETF watchlist in csv - an extension of my ETF watchlist project here. I figured out that people will not visit my site. So why not blast out the watchlist instead:) And if you are interested in the code. Here you go. #Steps for sending watchlist library("rJava") library('mailR') source("./R/emails.R") # Write the content of your email msg <- paste("Hey there, I'm sending this ETF watchlist that is updated as of ", "\n", as.

CONTINUE READING

Naming Conventions in R. Let’s call it JR Notations. ‘Naming conventions’ is a huge thing in many programming languages/ paradigms/ communities. But it’s noticeably absent in the R programming community. With some inspiration from the Hungarian Notation, here’s a blue-print that I came up with while working on a major R project over the last 2 months. Drumroll please… 1. Naming conventions for R scripts F_ for R scripts that contains functions.

CONTINUE READING

Finally I had some time to sit down to work on the interactive app. From what was an hideous app to a somewhat Minimum Viable Product (MVP) version of an app. (Shhh…I’m not really a User Interface, UI person). This serves as a compass for me to visualize the potential returns given the % fall from 52 week high. See my linkedin article here for further explanation on why I think this is a good indicator.

CONTINUE READING

Updated ETF watchlist project While watching a world cup match today, I updated my ETF watchlist project (you may click here if you haven’t seen it yet) You may find the github code here. In the revision, I parallelized the crawling - essentially tapping on all the cores in my machines. To create your own watchlist. Follow these steps, Install R and R studio. In Mac or Linux, type the following in command line git clone https://github.

CONTINUE READING

Updated ETF watchlist project While watching a world cup match today, I updated my ETF watchlist project (you may click here if you haven’t seen it yet) You may find the github code here. In the revision, I parallelized the crawling - essentially tapping on all the cores in my machines. To create your own watchlist. Follow these steps, Install R and R studio. In Mac or Linux, type the following in command line git clone https://github.

CONTINUE READING

Warren Buffett the sage It’s always interesting to understand investment gurus’ thought process. And one of the ways is to look at their companies’ balance sheet. Warren Buffett, the Sage & CEO of Berkshire, in recent decade has always been known to hoard cash. And before the 2008 crisis, he held cash level of 40-50% relative to its equity - probably trying to stay out of the overvalued market and waiting for the right opportunity to swoop in for a ‘BIG CATCH’.

CONTINUE READING

Hey it’s the world cup season - Tapping into a Machine Learning based paper Once again as a Singaporean citizen, there’re no other choices but to place my bets in Singapore pools. Betting in SG is not my preferred way to grow my wealth because of the crazy ~15% spread in Sg pools. In international sites, the spread is usually close to 3-5%. Oh well, that’s illegal. But because this is the world cup season, I decide to make some small punts!

CONTINUE READING

Here’s a true story. And it happens on 1 faithful night during the wee hours… when I was inspired to write a statement of purpose for my Msc Georgia Tech application. I am currently an analyst, working in Korn Ferry Institute, a research and analytics arm of Korn Ferry. At the same time, I’m ‘juggling’ my work-study-life balance as a Part-Time student, studying Post-Graduate Diploma Computer Science in University of Adelaide.

CONTINUE READING

Finding value in Singapore Pools Of all places, this is the last place I expect to find value. But I found it - supposedly! I compared the Singapore Pools Odds against Fivethirtyeight blog probabilities of teams’ winning various leagues. The spread in Singpore Pools is often insane. In a typical 1X2 game, the odds is around 15% - as compared to a spread of 3% in overseas betting houses - which btw is illegal in Singapore.

CONTINUE READING