Python-based Automated Stock Investment Profit Calculator

I completed this program independently in 2025 summer, inspired by knowledge gained in Dr. Bret Staudt Willet’s course, Learning and Web Analytics.

This self-contained Python program was designed to automate the calculation and visualization of long-term investment profits. The core functionality centers on applying the First-In, First-Out (FIFO) accounting principle to personal trading records, supporting flexible timeframes and data granularity.

The program effectively integrates two distinct data sources: 1, Historical Chinese stock market data, imported via the akshare Python library. 2, Personal trading records, imported from an Excel file. By combining market price charts with trading records, the program offers essential context for evaluating past trading decisions and refining future investment strategies.

This project demonstrates skills in Python data engineering, including data acquisition and integration from Python libraries and local files, algorithmic calculation using financial principles, and data visualization for strategic analysis.

Tools: VS Code, Python, Excel

Python-based Automated Computer Control System via On-Screen Image Recognition

This annotation summarizes a non-assignment project completed independently in 2025 summer, inspired by knowledge gained in Dr. Bret Staudt Willet’s course, Learning and Web Analytics.

This Python program implements an automated computer control system by leveraging on-screen image recognition. The system uses pre-set images as visual input signals to execute specific, user-defined commands, a function achieved primarily through the pyautogui Python library.

The application offers significant flexibility for computer interaction. My personal implementation involved setting up game images to automatically achieve goals in games without manual intervention. This prototype functionality extends to industrial applications, such as detecting unqualified products on production lines or automatically selecting items based on visual criteria. It serves as a proof of concept for applying basic machine vision to specific real-world objectives.

In this project, I demonstrated my competency in independently designing and developing a Python program with a specific goal and connecting it to the principles of computer vision and system automation.

Tools: VS Code, Python

R-based Monte Carlo Simulation for European Call Option Pricing

I complete this code practice independently in 2025 fall. This R program uses the Monte Carlo method to simulate the stock price under the risk-neutral measure (Geometric Brownian Motion) and estimate the price of a European call option.

This simulation demonstrates my competency in utilizing R programming and the Monte Carlo method to evaluate financial expectations derived from a stochastic process.

Tools: R, R Studio

The instrument service project involved providing complex service and maintenance for specialized laboratory instruments, including a liquid nitrogen plantsystem, an ultra-high pressure emulsion system and other precision lab equipment in food and electronic industries. The work required a deep understanding of instrument calibration, troubleshooting, and analysis principles to ensure equipment accuracy and minimize downtime.

This project demonstrates my professional skills in investigating and applying emerging technologies in innovative fields, including nano-emulsion materials and thin-film conductive coatings. It also reflects my experience in project management and needs assessment for clients, conducting professional technical interviews, and engaging in international trade and multicultural collaboration with instrument manufacturers from various countries, including the U.S. and the EU. In addition, I am familiar with international trade protocols and industrial safety standards.

In Investment Advice Project, I served as an Investment Advice Professional, offering personalized financial consultation and strategy development for clients. My responsibilities included conducting thorough financial analysis, creating diversified investment portfolios, and advising on risk management strategies tailored to individual client goals and risk tolerance.

This experience demonstrates my competency in client consultation and needs assessment, the development of data-driven investment strategies, fact-driven reasoning among market factors , and communication skills.

In Rural Solar-powered house project, I completed designing and implementing both the construction of an independently designed rural house and installing a standalone, off-grid solar power system.

The scope of the project included designing the system, managing a team of 15 builders throughout the construction process, supervising implementation, and calculating key engineering parameters for both the building and the solar power system. This involved determining optimal power load, selecting and sizing photovoltaic panels, batteries, and inverters, and completing all wiring and installation in accordance with safety and efficiency standards.

This project demonstrates comprehensive skills in strategic planning (including economics analysis, ROI evaluation, systematic design and engineering, and setting clear goals, objectives, and incentives), project management (focused on cost, efficiency, and training management), and team performance (including leadership, collaboration, and rigorous evaluation and improvement).