Back to projects

02 · April 2026 · Independent project

Portfolioanalytics.

My Excel trading model, rebuilt to run live in the browser. Every day it pulls a year of prices for ten stocks, runs the same maths as the workbook, and picks a stock of the day. You can run it on any company, too.

Live prices · return · volatility · Sharpe · drawdown · 55/45 score

Why today’s pick

Check any stock

Try:

An educational model built from my trading workbook, not investment advice.

How a signal is made

  1. PullA year of daily closing prices for the stock.
  2. Measure1-year return, annualized volatility, Sharpe ratio (4% risk-free) and maximum drawdown.
  3. ScoreFinal score = 55% return score + 45% risk score, out of 5.
  4. DecidePasses, Watch or Weak screen, plus the first risk limit it breaks.

Risk limits

Risk-free rate
4%
Target annual return
10%
Maximum volatility
35%
Maximum position weight
20%
Maximum drawdown
−30%
Minimum Sharpe
0.75

Portfolio map

Workbook snapshot · 10 holdings · 1Y return vs. volatility

Portfolio weights

AAPL18.1%
MSFT14.2%
GOOGL11.3%
NVDA10.2%
AMZN8.4%
TSLA8.1%
XOM7.9%
KO7.8%
JPM7.1%
JNJ6.9%

Every position stays under the 20% cap. The add/swap tester re-computes return, volatility and 1-day 95% VaR for a candidate before it enters the book.