Quote from Laissez Faire:
...
(A) I have a friend who is taking a PHD in finance and is an aspiring programmer, using both VBA, MATLAB and C#, but I`m not sure if he is able to undertake the task and I would prefer to let someone I know can handle it do it from the start. I will read through all the links you guys sent me. Thanks.
...
(B) I already bought MATLAB on a student license
...
(C) It is a matter of statistical analysis and modeling of intraday price data. Automating the process of collecting daily metrics of the intraday price gyrations, volatility analysis, coding each day according to specific parameters and integrating it in a framework where it is possible to do historical queries and predictions based on this information. I expext that once completed, the model will have predictive value,
...
(D) live price data and use this as input throughout the trading day.
A. I was glad to see point A as there is a huge interest in the financial sector among college students some of whom are quite capable if not yet competent.
A previous poster made an important point that these engagements tend to be ongoing relationships as new ideas beget new ideas rather than home repair projects. There are some preconditions to success:
- You need to have the time and interest in day-to-day management. Students need alot of guidance.
- You need to be able to judge progress. I have seen this happen to other people both ways: A. Investor pays for years to someone who can't do the job and who isn't passionate about learning, and B. investor has competent talent but keeps postponing delivery to add scope until he loses faith
- You need to be able to realistically analyze the return, costs, timeliness, and risks of the project. Even if labor is open-source, it is still a business venture that can fail.
If you don't have these preconditions, consider getting the help of a project manager. At least, nail down #3 so everyone doesn't end-up predictably disappointed.
B. Matlab is a great product. It has some really great advanced parallel computing capabilities, but I would recommend starting with Scilab (free) or one of the other open-source work-alikes until you are through the proof-of-concept phase.
I have seen VBA in Excel used as a front-end to enormous system, but when people see VBA in Excel, there is a Bayesian inference that this is a modest, one-man job. Unfortunately, this often reflects more on the knowledge of the speaker than on the task.
C. EOD statistical modeling of intraday data. Both RiskMetrics and
kdb fit your description. Although I do believe that a small team of really smart, focused people can do an amazing job on a hard problem, the tail-end of UI, reports, extensible rules, workflows, and support can easily consume a battalion.
If you have a modest <$10M budget, then I would recommend spending a couple of years sitting with a few students to mutually learn how to do financial programming. This should greatly improve the ROI on the project and help you to better define the scope of the project.
D. Real-time data. The challenges of collecting and processing realtime data has been discussed on several threads. There are two things that I want to say relative to this project:
- Given the stage of this project, I would recommend downloading the market data historically using a service such as NANEX since this will allow you to validate your ideas across many symbols without incurring market data fees and with a clear migration path to realtime.
- Executing statistical analysis realtime for trading purposes is a completely different challenge from generating EOD market metrics for use in an intraday system. For example, LMAX or StreamBase. If you are building one, don't expect to get the other.
For IT projects (integration with existing software) run at companies where pulling-the-plug has career consequences, the success rate for adhoc projects (costs already budgeted) is
74% for small teams, 58% for medium-sized teams, and 40% for large teams. There is no survey for personally funded projects that have significant technological and mathematical risk being run by micro-teams in ones spare time using dispersed, multitasking, contingent talent.
You wouldn't build a house without blue-prints.
I would recommend breakout the books, with the mutual help of a college student, and treat this more like a hobby than installing flooring. If you really have the money and want to treat this like a start-up, then figure-out your management structure and write-out a business plan. You may have a billion dollar idea, but success comes from realizing a plan.
Steven