On 20 Jun 2013, at 2:04am, YAN HONG YE <yanhong...@mpsa.com> wrote: > DIFF : EMA(CLOSE,12) - EMA(CLOSE,26); > DEA : EMA(DIFF,9); > MACD : 2*(DIFF-DEA); > > I wanna use sqlite to count macd value, have any idea?
You cannot calculate moving average inside SQLite, because table rows do not appear to aggregate functions in any set order. You will have to calculate these values in your programming language. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
