Need help finding the right tutor?

When do you want to start?
What is your name?
What is your postal code?
What is your email address?
What is your phone number?
Have you received tutoring before?

Thanks! You'll be called typically within 24 hours by the tutor or company you contacted.

Featured By
Frank tutors in Toronto, Canada

Frank S.

Private tutor in Toronto, Canada

Education

MBA from U of T CFA Charter Holder Passed CSC with license Bachelor and Master degrees in Engineering

Experience

University finance courses and Canadian Securities Course (CSC): Introductory Finance, Managerial Finance, advanced finance, Business Finance, Corporate Finance, Securities Valuation, International Financial Management, Derivatives a) NPV, IRR, payback period, WACC, EBIT, EBITDA, CAPEX, CCA, , FCFF, FCFE, DDM, Golden Growth Model, EV/EBITDA b) options, forwards, futures, swaps, Black-Sholes model, binomial tree, trading strategies (bull/bear spreads, stradle etc) c) bond pricing, principal, yield, coupon rate, maturity, duration, Macaulay Duration, convexity d) unlevered and levered value of a company, CCA, tax shield, , M&M theories, capital structure, dividend policy, leasing, merger & acquisition e) CAPM, Fama-French model, HML, SMB, variance, standard deviation, covariance, Beta, Alpha, risk free rate f) FX trading, OANDA platform, purchase price parity, market order, limit order, take profit, stop loss order etc. VBA/Excel/Access, Python, Day Trading FX and Futures using 5min chart. 1. VBA courses: a) OMIS6350/OMIS3670 Advanced Spreadsheet Modelling & Programming for Business b) ECO2508H Advanced Financial Risk Management c) FIN731 Financial Modelling II d) MGFD60 Financial Modeling & Trading Strategies e) Spreadsheet-Based Decision Support Systems for Business f) Graduate Level Advanced Excel Modelling in VBA 2. Excel VBA Access tutoring and developing: I can either teach you how to use VBA or develop VBA codes for your projects. a) extract data from different sources to establish database: EOD files (xls, csv, txt, pdf), MS Access (SQL), Bloomberg, internet websites or from source codes (like Yahoo) etc. b) manipulate within database: strings, numbers, web links, images, pivot tables/pivot charts c) build models either quantitative or customized to perform statistical/financial analysis on the raw data d) generate customized daily/monthly/quarterly reports to client's need e) connect to Outlook to extract data from specific emails or send out emails with customized content/pictures/attachments f) any process automation connecting among internet web pages, Excel, Access, Outlook, Word, PDF and Bloomberg etc. 3. Python: I can show you Python with exactly the same things as in VBA 4. I can show you how to trade daily 5min charts in FX and futures market. Below are the techniques: A, trend line and patterns B, pivot levels C, stats on daily moving range D, entry, exit and stop levels E, scalp and swing If you have a strategy, I can also help you build trading systems to generate buy and sell signal by either VBA or Python.

Availability

Weekends at any time, Weekdays in the evening

Can Meet

Up to 10 minutes away for no additional charge

Hobbies

Application of programming in financial projects. Exploring Python now to automate anything that is doable.

Show More

Inquire About This Tutor

Thanks!

Most tutors respond within 48 hours.

Feel free to contact other tutors while you wait.

If this is your first request, please check your email (including your spam folder) to finish setting up your account!