A few years ago I got fascinated with Monte Carlo simulations after this application appeared in my 401k plan. At the time they had this “what if” calculator where you enter your age and then the amount you plan to save yearly in the 401k. You’d have to select how you wanted to invest [...]
It’s no secret that I use TraderXL Pro to download the majority of my Stock, Future, and Forex data that I use for RapidMiner modeling. I use the BulkquotesXL module because it’s able to download daily and weekly data from Yahoo and daily price data from the PiFin data source. Usually it downloads the data [...]
Early last year I worked hard on building an Excel based Algorithmic Trading System (ATS) and I made considerable headway using TraderXL Pro and Yahoo real time quotes before I got distracted by the birth of my son. It’s since been ignored and sitting in a directory on my computer but I’m considering continuing its [...]
Building an asset trend following system is quite easy to do if you’ve read my tutorials. You gather your data, assign trend values (UP, DOWN), and then run it through a classification algorithm like YALE’s IBK operator. Doing this is what some people call Fuzzy trend analysis and its quite easy to do if [...]
For those of you who don’t like using YALE, now called RapidMiner, I offer you neural nets in Excel. A few years ago I came across a slow, but really cool neural net application written in Excel by a PhD student, Angshuman Saha. I’ve used this little spreadsheet to make quicky models and [...]
Hi there! This is one my most popular posts and I would love it if you became an RSS Reader!
The inspiration for my S&P500 Volatility Timing model came from rereading portions of Mandelbrot’s book, The (Mis)Behavior of Markets, and trolling around the Internet for Nassim Taleb’s research work on risk. I think both [...]
Today I wanted to share with you a part of the algorithmic back end to my ETF Trend System. Note, I said “part“, I’m not giving away all my secrets. It’s written completely in Excel, incredibly simple, and is a macro that you can import. The system works by using something called linear [...]
