KX Community

Wind

I have found the ema function from the kxforums.com. But there issome error. Maybe because of the difference between K and Q. Cananybody help change the function for Q?/ the original function for exponential moving average[code:1]\ema:{a:2%x+1;b:1-a;...

Wind

I have fetched data from kdb+ in MATLAB. But the datetime column inkdb+ has become the java.sql.Date, which could not be convert to timeseries in matlab.Any suggestions very appreciated.

Wind

Received: by 10.100.216.12 with SMTP id o12mr122018ang.27.1236238769981; Wed, 04 Mar 2009 23:39:29 -0800 (PST)Date: Wed, 4 Mar 2009 23:39:29 -0800 (PST)X-IP: 221.223.74.134User-Agent: G2/1.0X-Google-Token: Kprb3gwAAAAApLZjCBLZAsw1OktPz3giX-HTTP-UserA...

Wind

Hi Krishna,n:20g:{1+((+\)x) bin (y?1.)}"acgtBDHKMNRSVWY"g[.27 .12 .12 .27,10#.02]3*nThis should work in q.

Wind

I tried Xi and Attila's methods. All are perfect q codes.Thanks again.On Apr 10, 11:26�pm, Xi Chen wrote:> if just want the first one as intial value, one can �use> ewma:{{y+x*z-y}[x:2%1+x]\[y]}> Xi>> On Fri, Apr 10, 2009 at 9:30 AM, Attila Vrabecz w...

Wind

I copied Nial's ema function directly. It works well and is exactlywhat I need.Thanks Niall and Aaron.On Apr 10, 11:46�am, Niall Dalton wrote:> Untested, but something like ema:{[x;y]b:1-a:2%x+1;c:(sum x#y)%x;> ((x-1)#0n),c,c{[a;b;c;d](a*d)+b*c}[a;b]...

Wind

Great. That works well.Thanks AttilaWindOn Mar 5, 4:35�pm, Attila Vrabecz wrote:> (`sym`date,x) xcol b> is enough if x is already a symbol> � Attila>> On Thu, Mar 5, 2009 at 8:18 AM, Charlie Skelton,Kx wrote:> > yes> > q)(`sym`date,`$string x) xcol b...

Wind

User-Agent: G2/1.0X-Google-Token: IcwdSgwAAAB2kL17PGMo2fE_zLf7HU61X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US) AppleWebKit/525.19 (KHTML, like Gecko) Chrome/1.0.154.48 Safari/525.19,gzip(gfe),gzip(gfe)Message-ID: <5b71ad80-8866-4...

KX Community

User Statistics

User Activity

exponential moving average function for Q

How to convert java.sql.Date to Matlab format

How to rename the column name of a table according to a variable

Re: What does the following snippet do?

Re: exponential moving average function for Q

Re: exponential moving average function for Q

Re: How to rename the column name of a table according to a variable

Re: Which's the best GUI tool for Kdb+?