Re: [sqlite] use sqlite to count macd value

On 20 Jun 2013, at 2:04am, YAN HONG YE 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 functi

[sqlite] use sqlite to count macd value

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? thank you! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

[sqlite] use sqlite to count macd value

DIFF : EMA(CLOSE,SHORT) - EMA(CLOSE,LONG); DEA  : EMA(DIFF,M); MACD : 2*(DIFF-DEA), COLORSTICK; I wanna use sqlite to count macd value, have any idea? thank you! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman