Sheldon Xie: Financial Engineering Profile
Sheldon Xie: Financial Engineering Profile
ER Xie employed skills and technologies such as Python, SQL Server, Excel VBA, MATLAB, and R across his quant research projects. These tools facilitated data analysis, model building, and automation of complex calculations, significantly contributing to the development and testing of trading strategies, such as the statistical arbitrage strategy and the position adjustment model .
In his projects, ER Xie utilized computational statistical tests such as correlation and cointegration tests for the statistical arbitrage strategy, managed through Python, which allowed for precise pair stock trading. For equity fund performance, he used the Carhart Four-Factor Model and employed Dickey-Fuller stationarity tests and correlation tests using R, which provided significant insights into different factor impacts on performance .
ER Xie managed and improved signal generation by pre-processing and analyzing large vendor datasets and internal data, utilizing SQL Server and Python libraries like pandas, numpy, sklearn, and pyodbc. He focused on tasks such as validating, cleaning, normalizing, and loading data into databases, which were critical for refining and generating more reliable signals .
The position adjustment model developed by ER Xie was highly effective, achieving an annual return of 32.9% in back-testing using 2016 data of the CSI300. This outcome indicates strong performance and suggests that the model successfully leveraged technical and fundamental indicators such as Moving Average (MA), Price-to-Earnings (P/E) ratios, and Moving Average Convergence Divergence (MACD).
The empirical analysis conducted by ER Xie on equity fund performance using the Carhart Four-Factor Model found that the momentum factor was not significant. In contrast, the market, size, and value factors showed significance, indicating that these factors had a more substantial impact on equity fund performance on the A Share Market over the 2006-2016 period .
ER Xie's academic background in Financial Engineering from Columbia University and Nanjing University, coupled with his strong academic performance (Cumulative GPA: 91/100, Major GPA: 3.9/4.0), provided a solid foundation in both theoretical and practical aspects of finance. His honors and awards, such as the Outstanding Student and People's Scholarship, demonstrate excellence and leadership, fostering skills that are essential in his professional roles .
ER Xie's internships provided practical applications of theoretical knowledge gained through his financial engineering studies. His roles at GSA Capital Partners, UBS Business Solutions, Tianfeng Securities, and Ernst & Young involved hands-on experience with quantitative research, model development, data analysis, and automated tool creation. These experiences bridged the gap between academia and industry, enhancing his applied skills and understanding .
At UBS Business Solutions, ER Xie developed tools and automated templates in Excel VBA for tasks such as analyzing realized and implied volatility, skews, convexity, correlation, and volatility spreads. He also created automated warrant screeners, KOSPI2 pricing, and NKY-JPY analysis templates, in addition to improving old templates for data calculations .
Python played a central role in developing ER Xie's statistical arbitrage strategies by enabling the implementation of correlation and cointegration tests to identify trading pair stocks. It also facilitated the adjustment of positions and setting stop-profit and stop-loss intervals through the application of lognormal distribution models. These capabilities allowed for automated and sophisticated strategy development .
ER Xie utilized both quantitative and fundamental research methods to develop market-neutral long/short trading strategies. He employed statistical and machine learning approaches to analyze global equities, focusing on metrics like ETF flow decomposition, short interest, and competitive advantage based on ROE ranking .