Analytical Skills
The tools and methods I use, connected to the work behind them.
Finance & Markets
Develop and document the reasoning behind personal investment decisions.
Personal investment research supported by documented theses, portfolio monitoring and Quinn’s Investment System.
Company earnings analysis · sector and macro research · valuation and growth metrics · historical valuation ranges · competitive positioning · investment rationales · portfolio monitoring
Personal Investment Research →Excel & Analytical Workflows
Organize investment information and build structured analytical workflows.
Portfolio monitoring, transactions, allocation, dollar-cost averaging (DCA) plans and macroeconomic information.
PivotTables and PivotCharts · XLOOKUP and VLOOKUP · SUMIFS · IF and IFS · structured tables · conditional formatting · Analysis ToolPak regression · portfolio dashboards · FRED and macroeconomic organization
Investment research process →AI-Assisted Systems & Product Design
Design and iterate personal analytical and productivity systems using AI-assisted development.
AcademiaTrack, FlowState, Quinn’s Investment System: systems I use for university work, daily planning and investment research.
Product requirements · workflow design · analytical logic · interface decisions · testing and debugging with AI assistance · validation · iteration through daily use
Personal Analytical Systems →Economics & Econometrics
Evaluate economic questions using empirical evidence and alternative model specifications.
EC395 cigarette-demand analysis comparing OLS, fixed effects, first differences and instrumental variables.
OLS and multiple regression · robust standard errors · fixed effects · first differences · instrumental variables · diagnostic testing
Applied Econometrics →Stata
Prepare data, estimate econometric models and assess their interpretation.
Data cleaning and integration, panel-data analysis, robust and clustered inference, and IV diagnostics in EC395.
Data cleaning · merge and reshape · regression analysis · robust inference · fixed effects · first differences · instrumental variables · diagnostic testing · do-files
Econometrics case study →