Xinjing Guo

Financial Data Analyst @Finovax

NY, US

Credit Spread Analysis Tool (Python, FRED/Quandl APIs): Built a Python pipeline to retrieve daily yield data for U.S. Treasury and corporate bonds, calculate credit spreads, and visualize 10+ years of trends using Plotly. Supported credit risk assessment and valuation analysis- ETF Autocorrelation & Stationarity Screener (Tushare): Automated the retrieval of all A-share ETF tickers and their historical data. Developed functions to filter ETFs with strong autocorrelation and non-stationary closing prices using ADF tests, helping identify candidates for quantitative strategies- Equity Trend Analysis Dashboard (Yahoo Finance): Collected 5+ years of historical data for 11 major U.S. stocks. Implemented technical indicators (50/200-day moving averages, RSI, MACD) and built interactive Plotly dashboards to identify buy/sell signals and monitor market momentum- S&P 500 Sectoral Metrics Study: Analyzed the 11 GICS sectors to identify key valuation metrics (e.g, PE for Tech, FFO/P for REITs). Retrieved data for top 5 companies in each sector by market cap and ranked them based on the most recent quarterly data using Python and Yahoo Finance API- High-Correlation Stock Screener (DJIA & Nasdaq-100): Developed a script to identify constituents of DJIA and Nasdaq-100 with strong historical price correlation (r > 0.7) to their respective indices over 3 years, aiding in systematic risk exposure analysis and hedging strategy- US ETF Analytics Pipeline: Created a two-part Python tool to dynamically retrieve a complete list of US ETF tickers and download one year of OHLCV data from Yahoo Finance. Integrated error handling, missing value detection, anomaly alerts, and visual diagnostics for data quality validation.

University of Toronto

Bachelor, Double Major with Economics & Statistics

NYU Tandon School of Engineering

Master's degree, Management of technology

Father John Redmond Catholic Secondary School

High School Diploma, High School Curriculum