Build an ETF Trend System in Excel

Posted on Mi 16 Mai 2007 in Tutorials • Tagged with ETF, Excel, Finance, Quant, Tutorials • 3 min read

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 …


Continue reading

Financial Asteroids & Their Effects on Trends

Posted on Do 10 Mai 2007 in Stocks • Tagged with Biology, Trends, Finance, Quant • 2 min read

Several years ago, when I was living in New Mexico, I had a girlfriend who used read very esoteric books about cutting edge theories on biology, evolution, and astronomy. We were talking about "what-if" scenarios one day and the conversation drifted to some called "punctuated equilibrium." It was explained to …


Continue reading