On Tue, Mar 27, 2012 at 3:02 PM, Simon <turne...@gmail.com> wrote: > select closing_price, moving_average( funky_oscillator( closing_price ) )...
There is a moving average calculation in SQLite here but given the complexity you might prefer to do the analytical portion in your program: http://code.google.com/p/sqldf/#Example_16._Moving_Average It would be nice if sqlite had sql windowing functions to simplify these sorts of calculations. -- Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users