Intel Became My Lastest Holding after TSM

Date: 10/08/2020 How Intel Comes to My Radar? Following the news of TSM, the largest holding in my portfolio, I saw several articles on Intel announces delay in its 7nm CPUs, and AMD CPUs outperform Intel ones benefiting from the use of TSM’s most advance process node technology (5nm). After the announcement, Intel stock price …

Predicting House Price in Hong Kong #4

Date: 26 July 2020 In #3, I faced difficulty in having a lot of missing values in the property transaction data. After searching the web, I found that Centaline claimed they have spent 10 million HKD to fill the missing values. Maybe, I should try scraping data from Centaline. Luckily, I have scrapped Centaline data …

Scraping Yahoo Finance Data into Google Sheet

Sample Google Sheet: https://docs.google.com/spreadsheets/d/1pu1VmBKFvtdJPb78eYNooHaVAucff8_9blQPUUWoW2k/edit?usp=sharing Very often, data on websites is in presentation format instead of a nicely formatted table. This makes analysis difficult. Therefore, the first step of doing any real-world data analysis is to gather data in a nice format (usually table). If you don’t know any programming, the task will be difficult. But, …

Predicting House Price in Hong Kong #2

In part 1, we have talked about scraping transactional data of apartments. In part 2, let’s talk about splitting data into a training set and testing set. Why we need to split? The short answer is we want to prevent overfitting/memorizing and hope that the model trained can generalize into unknown cases. For example, if …