Non members : To receive news from HKSFA
Please register here
Forgot password
Intermediate Investment Analytics & Data Visualization with R - Module 2 [Complete] Event Code: 170527W
Date 27-May-2017
Time 08:15 a.m. - 1:00 p.m.
Venue 14/F, BOC Group Life Assurance Tower, 136 Des Voeux Road Central, Hong Kong
Speaker(s) Mr. Mark C. Hoogendijk, CFA, CAIA
Managing Director
E8 Consulting Asia
Fee HKSFA Member(s) at HK$1,850.0/person
CFA Candidate(s) at HK$2,350.0/person
Guest(s) and Non-member(s) at HK$2,350.0/person
This seminar is qualified for 3.5 CPT hour(s), 3.5 CE hour(s), 3.5 RBV CPD hour(s)
Remarks
  • Only Visa and Master Card are accepted for online payment.
  • Participants are expected to bring their laptop / notebook.

Event Details
These 5 half-day / module courses are a direct extension of the “Investment Analytics & Data Visualization with R” course, which successfully ran already thrice in the last 18 months. The course will build upon the acquired skill sets of the previous introductory course and focus on Advanced Data Mining techniques required for portfolio and risk management of large portfolios. Topics also include Derivatives Pricing and Simulation, Portfolio Back-Testing, Machine Learning and creating Portfolio / Risk Dash-Boards with automated month-end reports. The modules are great for expanding ones understanding of the R language, whilst learning more about Portfolio & Risk Analytics together with Data Visualization.
 
All modules are based on up-to-date and historical market prices focusing on Stocks, ETF’s, FX Rates and Macro-Economic Indicators. Packages such as dplyr, tidyr, tibble and purrr will be used for fast Data Manipulation, required for the amount of data that will be analyzed.  (The modules will work with a database of 4700 stocks including historical price data, balance-sheet data, option data, splits and dividends and calculated technical indicators).
 
Basic understanding of R is required. This course is a beginner to intermediate level course for R.
Similar to previous modules, all code will be shared and provided to the participants. Full overview of available online materials will be shared too. Including an overview of additional financial packages to be used for further Portfolio Analytics. Participants are expected to bring their laptops / notebooks.   

Course Overview
  • Module 1: Intermediate Data Mining. Building your portfolio database.  Running Performance & Risk Analytics over a 4700 large stock database. Adding technical indicators to the database. 
  • Module 2: Fundamental Stock Analysis in R.  Running a selection model based on Fundamentals, building screeners and capturing the outcomes in powerful visuals and tables.
  • Module 3: Option Pricing & Option Backtesting in R. Back-testing plain vanilla option hedging strategies on portfolios over multi-period timeframes including re-balancing.
  • Module 4:  The Efficient Frontier, back-testing the Efficient Frontier, and implementing the Black-Litterman model. Efficient Frontier with own moment functions.
  • Module 5: Introduction to Machine Learning for Finance.

Module 2: Fundamental Stock Analysis with R.  Dashboards continued


Summary:
This module is a combination of learning Fundamental Stock Analysis within
R, creating overview tables for Sectors, stock score-cards based on Fundamentals, and plotting the results in easy to interpret graphics. Therefore learning to work with packages such as dplyr for Data Manipulation, further extending your knowledge of ggplot2 and plotly for graphics and working with large Data Sets.

 

    Session 1:  Fundamentals for one Stock

  • Building a summary of the Macro-Economic Environment, looking at GDP, Inflation, FX Rates, Interest Rates and Productivity Numbers
  • Data Manipulation of Balance-sheet, Cash-Flow & Income Statement numbers

o   Calculating P/E, P/B, Free Cash Flow per Share, ROE, ROA, Debt/Equity, Current Ratio, Quick Ratio, Gross Profit Margins, Buy-Backs etc.

o   Putting it all together in one overview. Plotting the results over time.

 

    Session 2: Fundamentals Screening for Sectors & Indices

  • Creating a score card based on Sector comparison
  • Building a screener for fast initial stock selection
  • Incorporating own models by creating functions in R

o   Exploring the Discounted Free Cash Cash Flow model

*Rating: Intermediate

(Material presented will have technical elements requiring a working knowledge of the subject to make full use of the presentation.)  

 
The training will be complemented with a list of research, reference materials and R Scripts to provide the participants with a solid  understanding of Portfolio Analytics, DataManipulation and Data Visualization with the open source software R.
 
 
About the Instructor
 
Mr. Mark C. Hoogendijk, CFA, CAIA
Managing Director
E8 Consulting Asia
 
Mr. Mark C. Hoogendijk is an established derivatives and investment professional with more than 17 years’ experience. His expertise lies within Risk Analysis of Investment Portfolios, Asset & Liability Management, and Capital Management.
 
Over the 13 years here in Asia, he has worked closely with insurance companies, Pension Funds and Asset Managers in Hong Kong, Taiwan, Singapore, Malaysia and Australia understanding their needs, conducting risk analysis and finding viable and suitable hedging strategies for their existing investment portfolios.
 
The first 12 years of his career, Mark worked within the Financial Markets division of large financial institutions such as ABN AMRO, BNP Paribas and Credit Suisse. Since 2012, Mark has been working as an Investment & Risk Consultant with E8 Consulting Asia, focusing on Investment, Risk & Derivative analytics with open source software, such as R.
 
Mark has a Masters in Chemical Engineering from the University of Technology, Delft, Netherlands. He is a CFA & CAIA charterholder and a member of the Hong Kong Society of Financial Analysts.