In my opinion, to develop any sort of 'quantitative' model, the tools required increase in complexity exponentially along with the strategy.
Creating a simple screen for stocks that moved above their 200DMA but below their 50DMA? Excel will do fine.
Trying to write custom back testing software? You sure as hell better have some programming experience. Hell, to increase the speed of my back testing software, I utilize Amazon's EC2 system to distribute tasks. There isn't a formula for that in Excel.
Let me paraphrase Bookstaber in his most recent book, The Demon of Our Own Design, when he says that you would never expect someone with any sort of financial experience to apply to a university for a teaching job in the sciences based solely on their 'mental capabilities' proven by their experience. The same goes the other way around -- how does a physicist or mathematician, with absolutely no economics experience, have any leg to stand on when developing models? Sure, the complex 'math' helps, but without a fundamental understanding of the market, it is futile.
A real mix is needed. Software Engineering skills are required for building strong, reliable software. Computer Science skills are required for developing fast algorithms. Economics/Finance is required for actually understanding why the edge makes sense.
Sometimes you might get lucky, where your edge exploits a hole in the concept of the market, and not economics -- in which case, the market can be treated like any other sort of 'unknown' for mathematicians -- but those sorts of exploits are rarer than rare.
In my extremely humble opinion, to be a well rounded quant developer, you need all the skills. On the other hand, being a jack of all trades makes you a master of none. If you can afford it, having a team works best -- those who can conceptually design the models and those who can implement them best.
-C
Creating a simple screen for stocks that moved above their 200DMA but below their 50DMA? Excel will do fine.
Trying to write custom back testing software? You sure as hell better have some programming experience. Hell, to increase the speed of my back testing software, I utilize Amazon's EC2 system to distribute tasks. There isn't a formula for that in Excel.
Let me paraphrase Bookstaber in his most recent book, The Demon of Our Own Design, when he says that you would never expect someone with any sort of financial experience to apply to a university for a teaching job in the sciences based solely on their 'mental capabilities' proven by their experience. The same goes the other way around -- how does a physicist or mathematician, with absolutely no economics experience, have any leg to stand on when developing models? Sure, the complex 'math' helps, but without a fundamental understanding of the market, it is futile.
A real mix is needed. Software Engineering skills are required for building strong, reliable software. Computer Science skills are required for developing fast algorithms. Economics/Finance is required for actually understanding why the edge makes sense.
Sometimes you might get lucky, where your edge exploits a hole in the concept of the market, and not economics -- in which case, the market can be treated like any other sort of 'unknown' for mathematicians -- but those sorts of exploits are rarer than rare.
In my extremely humble opinion, to be a well rounded quant developer, you need all the skills. On the other hand, being a jack of all trades makes you a master of none. If you can afford it, having a team works best -- those who can conceptually design the models and those who can implement them best.
-C

)