Blog Archives

A Simple Shiny App for Monitoring Trading Strategies – Part II

August 7, 2014
By

This is a follow up on my previous post “A Simple Shiny App for Monitoring Trading Strategies“.  I added a few improvements that make the app a bit better (at least for me!). Below is the list of new features : A sample  .csv file (the one that contains the raw data) A “EndDate”  drop

Read more »

A Simple Shiny App for Monitoring Trading Strategies

June 25, 2014
By
A Simple Shiny App for Monitoring Trading Strategies

In a previous post I showed how to use  R, Knitr and LaTeX to build a template strategy report. This post goes a step further by making  the analysis  interactive. Besides the interactivity, the Shiny App also solves two problems : I can now access all my trading strategies from a single point regardless of the instrument traded.

Read more »

Date formating in R

April 18, 2014
By

As I often manipulate time series from different sources, I rarely come across the same date format twice. Having to reformat the dates every time is a real waste of time because I never remember the syntax of the as.Date function. I put below a few examples that turn strings into standard R date format.

Read more »

Using Genetic Algorithms in Quantitative Trading

March 14, 2014
By

The question one should always asked him/herself when using technical indicators is what would be an objective criteria to select indicators parameters (e.g., why using a 14 days RSI rather than 15 or 20 days?). Genetic algorithms (GA) are well suited tools to answer that question. In this post I’ll show you how to set

Read more »

Using CART for Stock Market Forecasting

February 28, 2014
By
Using CART for Stock Market Forecasting

There is an enormous body of literature both academic and empirical about market forecasting. Most of the time it mixes two market features: Magnitude and Direction. In this article I want to focus on identifying the market direction only. The goal I set myself, is to identify market conditions when the odds are significantly biased

Read more »

A million ways to connect R and Excel

February 11, 2014
By

In quantitative finance both R and Excel are the basis tools for any type of analysis. Whenever one has to use Excel in conjunction with R, there are many ways to approach the problem and many solutions. It depends on what you really want to do and the size of the dataset you’re dealing with. I

Read more »

Overnight vs. Intraday ETF Returns

January 25, 2014
By

I haven’t done much “googling” before posting, so this topic might have been covered elsewhere but I think it’s  really worth sharing or repeating anyway. A lot has been written about the source of  ETF returns (some insights might be found here). In a nutshell some analysis found that the bulk of the return is made

Read more »

Introduction to R for Quantitative Finance – Book Review

January 10, 2014
By
Introduction to R for Quantitative Finance – Book Review

I used some spare time I had over the christmas break to review a book I came across: Introduction to R for Quantitative Finance. An introduction to the book by the authors can be found here. The book targets folks with some finance knowledge but no or little experience with R. Each chapter is organised around a

Read more »

Financial Data Accessible from R – part IV

December 13, 2013
By

DataMarket is the latest data source of financial data accessible from R I came across. A good tutorial can be found here. I updated the table and the descriptions below. Source R Package Free Access Available on CRAN Provider url Yahoo, FRED, Oanda, Google Quantmod Yes Yes Quantmod Quandl Quandl Yes Yes Quandl TrueFX TFX

Read more »

Evaluating Quandl Data Quality – part II

December 2, 2013
By
Evaluating Quandl Data Quality – part II

This post is a more in depth analysis of Quandl futures data vs. Bloomberg data. Since my last post Quandl has updated its futures database to 200+ contracts from 68 contracts originally. For practical reasons, I limit myself here to the initial list of 60+ contracts. I’m still comparing the “Front Month” contract between the

Read more »