Market Data Analysis Project

Discussion created by AnneAdams on Jan 13, 2013
Latest reply on Jan 14, 2013 by LyndsayHowarth

A professor in School of Medicine at Stanford asked if I could post the following. He isn't looking for FileMaker per se as much as he is someone with programming skills, interest, and possibly experience who is capable of putting this together.




"I require expertise to write a program that will allow access to data on individual stock funds, primarily index funds, and permit analysis of possible "buy" and "sell" signals on these funds, based on simple moving averages (MA) over time. On looking online, there seem to be many sites where the daily close prices I am interested can be downloaded prior to analysis. The approach would involve determining the usefulness of "signals" based on reversal in direction of one or more MA's: if a plot of one or more MA's starts to trend up, that is taken as a "buy" signal, and the opposite is true for a "sell" signal. For any stock index fund, the program would evaluate a wide range of such possible "signals" and determine how many trades were indicated, when the signals were given, and determine the individual gains/losses on the indicated trades and the overall improvement that might be attained by such approaches over a "buy and hold" strategy.


The reason this approach is practical is that there are very low fee funds that can readily be traded at little or no cost into and out of markets. Also, once the best approach using MA's is determined, there are a wealth of online charting tools that can be used to implement the approach in practise.


It would seem a wide range of languages might be suitable- I have seen that many use Matlab for such purposes."




I'll pass on initial responses and he will take over from there.







Anne Adams

Wellspring Data