Giter Site home page Giter Site logo

stanchiangtw / schroders-nccu Goto Github PK

View Code? Open in Web Editor NEW
0.0 1.0 0.0 5.99 MB

Portfolio Construction, BackTesting and Comparison of Taiwan electric vehicle industry based on ESG Score and Emission Score

R 0.40% Jupyter Notebook 99.60%
esg electricvehicle emissions portfolio msci eikon taiwan

schroders-nccu's Introduction

Schroders x NCCU (ESG Sustainable Finance and Innovation Competition)

Files

  • 0050.xlsx -> 0050 Monthly accumulated returns

  • 00850.xlsx -> 00850 Monthly accumulated returns

  • 00878.xlsx -> 00878 Monthly accumulated returns

  • Eikon_ESG_Data.xlsx -> Eikon Historical ESG data of Taiwan listed companies

  • ESG 永續金融與商品創新 期末報告_第八組.pdf -> Presentation of "Electric Vehicle and Low Emissions Portfolio"

  • Fund.xlsx -> Historical Net Value for the individual benchmark

  • MSCI.xlsx -> Historical MSCI ESG Scores for individual portfolio constituents

  • Portfolio Statistical Analysis.r -> Hypothesis Test for portfolio and similar funds using R

  • Portfolio Statistical Analysis.rmd -> R markdown of Hypothesis Test for portfolio and similar category funds

  • Portfolio.ipynb -> Portfolio Construction, BackTesting and Comparison using JupyterNotebook (Python)

  • price.xlsx -> Historical MSCI ESG Scores, Closing Prices and Market Values for individual portfolio constituents

  • T4812A.xlsx -> T4812A Monthly accumulated returns

  • TAIEX.xlsx -> Historical TAIEX Closing Prices

  • TAIEX_Month.xlsx -> TAIEX Monthly returns

Information

  • Database: TEJ+, Thomson Reuters Eikon, MSCI ESG Research

  • Market: Taiwan Stock Market

  • Theme: Electric Vehicles

  • Benchmark Index: Taiwan Capitalization Weighted Stock Index (TAIEX)

  • Similar Category Funds: Yuanta Taiwan Top 50 ETF (0050), Yuanta FTSE4Good TIP Taiwan ESG ETF (00850), Cathay MSCI Taiwan ESG Sustainability High Dividend Yield ETF (00878), TCB Mobility and Innovation Fd TWD (T4812A)

  • Listing: Taiwan Stock Exchange (TWSE) Listed (TSE)

  • Duration: 201701~202012

  • Rebalance Frequency: Every Year

  • Frequency: Month

  • Weighting: MSCI ESG Score Weighting

  • Screening: Thematic ESG Screening

  • Programming: Python 3.9.0 64-bit

  • IDE: Jupyter Notebook with Visual Studio Code

Screening Principles

  1. Filter Thomson Reuters Eikon ESG Data to obtain the companies with ESG Scores and Emission Scores

  2. Filter out the companies that belong to the electric vehicle industry

  3. Rank Eikon Emissions Scores in ascending order

  4. Filter out the companies with low Emission Score

  5. Rank Eikon ESG Score in descending order and MSCI ESG Score in descending order

  6. Filter out the companies with high ESG Score

  7. Obtain historical closing prices, market values and MSCI ESG Scores of individual portfolio constituents based on the results above

schroders-nccu's People

Contributors

stanchiangtw avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.