Explore the research behind our trading, plus some just-for-fun stuff....

Posted on Jun 09, 2020 by Robot James
No Comments.

In this post, we explain how to use SQL to extend back ETF price data with total return data from mutual funds or indexes.   On Zero to Robot Master Bootcamp, we teach how to build a portfolio of three automated systematic trading strategies. One of them is a long term Risk Premia Harvesting strategy which trades asset class ETFs....

Posted on Jun 08, 2020 by Robot James
1 Comment.

Nearly everyone starts trading with unrealistic expectations. "If I make a 0.5% returns every day I can make over $100k in a year on 20k of starting capital." 0.5% return every day sounds realistic, right? Wrong. Let's sense check that... If we could make 0.5% returns every day... then our 20k would be worth: $123,000 in a year $759,000 in...

Posted on Jun 04, 2020 by Robot James

In the Robot Wealth Pro Community, we've started doing weekend "quant-teasers" where we discuss the solutions to quant problems. Here is a recent one... Why aren’t calls more expensive than puts for an asset which is more likely to go up than down? We have an asset trading at $100 for which the distribution of future returns is a known...

Posted on Jun 03, 2020 by Ajet Luka

In the world of Big Data, there are lots of tools and technologies to choose from. Choosing the "right" one depends on the things that you are building and the problems you are trying to solve. Trading firms have skilled teams that monitor and deploy data pipelines for their organisation and the technical overhead that comes with that. Firms invest...

Posted on Jun 02, 2020 by Kris Longmore
No Comments.

Holding data in a tidy format works wonders for one's productivity. Here we will explore the tidyr package, which is all about creating tidy data. In particular, let's develop an understanding of the tidyr::pivot_longer and tidyr::pivot_wider functions for switching between different formats of tidy data. In this video, you'll learn: What tidy data looks like Why it's a sensible approach...

Posted on Jun 01, 2020 by Kris Longmore
1 Comment.

Anyone that's been around the markets knows that the monthly release of the United States Department of Labor's Non-Farm Payrolls (NFP) data can have a tremendous impact, especially in the short term. NFP is a snapshot of the state of the employment situation in the US, representing the total number of paid workers, excluding farm employees and public servants. We...

Posted on May 29, 2020 by Robot James
No Comments.

Here's a round-up of our new articles this week. They cover crash protection, sloppy, noisy regressions, and data-munging skills. Finding Options for Effective Crash Protection Large capital losses can be devastating to your trading account. A couple of weeks ago, we explained how you can use SPY put options to protect your portfolio against severe market downside. If you're prepared to...

Posted on May 28, 2020 by Kris Longmore
No Comments.

When data is too big to fit into memory, one approach is to break it into smaller pieces, operate on each piece, and then join the results back together. Here's how to do that to calculate rolling mean pairwise correlations of a large stock universe. Background We've been using the problem of calculating mean rolling correlations of ETF constituents as...

1 2 3 12