In this section I will be including Excel spreadsheets, Python or R scripts, and Matlab scripts which are useful in illustrating certain market concepts or performing relevant calculations.
Trading Order Out of Chaos
In this section I will be including Excel spreadsheets, Python or R scripts, and Matlab scripts which are useful in illustrating certain market concepts or performing relevant calculations.
Table of Contents
ToggleThis XLS accompanies the article on Effects of Lunar Phases and Solar Eclipses on Currency Markets. It includes the relevant astronomical data as well as the currency data and the backtest so that you can experiment with the data yourself.
This spreadsheet goes in tandem with the article on Trading Like a Hedge Fund Manager. The charts are replicated in here, as well as the calculations, so you can follow along. The data is taken from finance.yahoo.com for the ETF products SPY, AGG, and GSG. Kelly betting is applied to maximize the returns.
High Frequency trading has become both the poster-boy and the scapegoat over the last couple of years in trading circles. It’s been seen as a sure-fire way of making money, as well as a sneaky way the flash-boys tax all the other participants in the market. In this article I want to cover some of the basics of High-Frequency Trading, as well as how it applies to trading from your “Living Room.” An example of such trading from your own private realm is the following P&L chart showing profits i… Read more
EURUSD tick data for the period 10th January 2016 to 15th January 2016. Zip file contains CSV files for each day. The format of the CSV files are: Local Time, Server Time, Server Time Milliseconds, Bid, Ask. The time resolution is in seconds. This means that there can be multiple quotes per second.
EURUSD tick data for the period 6th January 2016 to 8th January 2016. Zip file contains CSV files for each day. The format of the CSV files are: Local Time, Server Time, Server Time Milliseconds, Bid, Ask. The time resolution is in seconds. This means that there can be multiple quotes per second. Local Time is GMT+0 Server Time is GMT+1
“Greed is good”, but one shouldn’t always assume that the counterparty won’t notice. Last Wednesday, 27th January 2016, was FOMC day, news event day, and the markets went ape. Following on from the previous articles the idea was to continue to exploit the observed quote outages and extract value. Turns out that (presumably as expected), brokers aren’t that slow on their feet. I was moved from B-book status (i.e. rookie / loser status) to A-book status. Let’s just say that exces… Read more
This XLS shows the calculations which were performed in the Kelly Criteria article. The data included are the SPY ETF historical prices as well as the backtest results from the London Breakout Strategy applied to the EURUSD. Here you can see how to calculate the optimal leverage on your favourite asset class or your favourite trading strategy. Please read the article to see what the caveats are and what riding out a full Kelly might possibly lead to.