Since he graduated from McGill University with a Ph.D. in Finance, Dr. Yuxing Yan has been teaching various Finance courses, such as Option Theory, Financial Modeling, Portfolio Theory, Corporate Finance, and Introduction to Financial Databases to both undergraduate and graduate students at seven different universities: two Canadian universities, one Singaporean university, and four American universities.
Dr. Yan has also been active doing research, and his work has been published in numerous publications including the Journal of Accounting and Finance, Journal of Banking and Finance, Journal of Empirical Finance, Real Estate Review, Pacific Basin Finance Journal, Applied Financial Economics, and Annals of Operations Research. His research areas include investment, market microstructure, and open source finance. He is an expert on SAS, R, Matlab, C, and Python. He also worked as a technical director at Wharton Research Data Services (WRDS) for eight years. At WRDS, he debugged over several hundred programs for WRDS users. Recently, he introduced R to his Financial Modeling and Quantitative Financial Analysis courses. He has just finished the first draft of a textbook titled Financial Modeling using R, which is based on his teaching notes.
In addition, he is an expert on financial data. When teaching at NTU in Singapore, he offered a course called Introduction to Financial Databases to doctoral students. When working at WRDS, he answered thousands of questions related to financial databases and helped update CRSP, Compustat, IBES, and TAQ (NYSE high-frequency database) several times. In 2007, together with S.W. Zhu, he published a book titled Financial Databases.