The Average Investor's Blog

A software developer view on the markets

Archive for March, 2010


Posted by The Average Investor on Mar 18, 2010

All the tools I am using at the moment are free of charge. The one that comes to mind first is R. It’s a language for statistical computing which comes with a decent GUI. R comes with some time series support out of the box, but there are plenty of packages (R extensions are called packages) which provide powerful functionality. I remember using all of the following (in order of decreasing use):

  • quantmod
  • zoo
  • xts
  • tseries
  • TTR
  • agricolae
  • SuppDists
  • RSQLite
  • rJava

The best part is that I don’t feel like I need any other language at this point! I have considered trying to speed up some R simulations by coding them in C++, but I can wait a few days for them to finish if necessary:).

For small scripts I use Python – it’s a great language which I discovered recently and I am trying to learn.

And of course, I use spreadsheets and documents (Microsoft Office and OpenOffice) to summarize my results.

The other important part is data. My main source is Yahoo Finance. Let me first say, that in my opinion it’s one of the best sites on the Internet in terms of both design and content! It also has a lot of historical data. R comes with at least two interfaces to load historical data from Yahoo transparently, and so does most of other software I have used.

Another low cost data source is EODDATA. I have purchased access to some of their data.

And that’s all for tonite!


Posted in R, Uncategorized | 2 Comments »

The Case Against Fundamental Investing

Posted by The Average Investor on Mar 16, 2010

Right now I don’t care about fundamental trading, but it hasn’t always been the case …

When I first developed interest in the markets, it was, in fact, the fundamental investing that attracted my attention. It was so sound: a business is evaluated and via some quantitative method, a “fair” share price is determined. A position is taken depending on the relation between the “fair” price and the actual price. Elegant, right?

WRONG! It never worked for me, and it’s not that I didn’t try. Why?

Ignoring the possibility that I am one of the dumbest people on the planet (and there is not much I can do if it is true), I came to a few reasonable explanations, each of them weighing against the fundamental approach.

First, it’s me against the cohorts of analysts, institutional investors, etc. Why would I have any chance of doing better then them?!

I know, I know, the little guy has so many chances to beat the pros, in fact there is plenty of literature confirming this fact. Well, despite all my efforts, I didn’t manage to take advantage of it.

Second, are all these smart analysts doing good enough? True, there is always someone who’s predictions did well last year. However, I noticed that the heroes are different, most of the faces keep changing almost every year. I couldn’t help it, but to start asking myself where are the heroes of yesterday?

Last but not least, the base of the fundamental systems, the financial statements, are such a unreliable source of information. It’s hard to find even a single S&P 500 company which uses the same accounting practices for more than 10 years. It was certainly beyond me to develop strategies and conclusions based on such fickle information.

In my disappointment, I slowly started experimenting with technical approaches. It was a liberating feeling – it was as if I was hearing and seeing things with my own senses! A year later I realized that I might not be alone: “Fundamental trading gave me ulcers.” – James Simons. That was it for me.

Posted in Strategies | Leave a Comment »

%d bloggers like this: