Valuation Timing with Excel

Data analysis plays a central role in making sense of financial markets. But how can you verify the conclusions others draw, or better yet, uncover your own insights? Microsoft Excel remains one of the most powerful and accessible tools for financial data analysis, allowing anyone—from beginners to seasoned analysts—to explore data, test hypotheses, and make …

Read more

Steal ideas, not implementations

Imagine you’re a relatively small, independent trader trying to turn trading from a hobby into a serious business. If that’s you, then there are a few concepts that will help you pick the right trades to get after. This is important because picking the right trades is most of the game. First, the Market Gods …

Read more

What P&L Swings Can I Expect as a Trader?

Many beginner traders don’t realize how variable the p&l of a high-performing trading strategy really is. Here’s an example… I simulated ten different 5 year GBM processes with expected annual returns of  20% and annualized volatility of 10%. (If you speak Sharpe Ratios, I’m simulating a strategy within known Sharpe 2 characteristics.) I plotted the …

Read more

How do I know if I have an edge?

I’ve been helping a family friend with his trading. I’ve given him a simple systematic strategy to trade by hand. First, we set expectations We can plot the distribution of historic trade returns from past trading or a backtest as a histogram.   This is useful because it gives us a hint as to what …

Read more

Tesla’s inclusion in the S&P 500 – Is there a trade?

The S&P index committee recently announced that Tesla, already one of the biggest stocks listed in the country, would be included in the S&P 500. Here’s the press release: Due to TSLA’s size, it was widely expected to have entered the S&P 500 index much earlier – but S&P has some discretionary criteria it applies …

Read more

Where does FX sit in a Systematic Trading Portfolio?

You rarely meet a rich forex trader. I’ve met plenty of rich traders who trade quant factors or stat arb. Plenty of market makers, futures spreaders and volatility traders that do nicely. But I don’t think I’ve ever met a rich forex trader. Jeez man – what a downer! Don’t run away, we’re gonna turn …

Read more