Hi,Is any fast and simple method for good charting from kdb+ base ?For example I have some formula with data calculation as RSI,ATR,Stochfrom OHLC or ticks and want to fast preview for some time series orall with scroll option.studioForKdb+ and qpad have some option but is to simple and not veryuser/analyst friendly.Looking something like this example:http://img.nopaste.pl/upload/performance%20monthly\_4f1831605ec84.jpg(https://picasaweb.google.com/115099029813395778077/TimelyPortfolio02)http://timelyportfolio.blogspot.com/2012/01/r-in-axys-impossible-dream.htmlR or matlab for this moment is to complicate to use in my opinion whenI planing do my calcs in q.But maybe some smart sugestions ?
http://timelyportfolio.blogspot.com/2012/01/r-in-axys-impossible-dream.htmlR){kind=link}
Am 19.01.2012 16:14, schrieb reptile:> Hi,>> Is any fast and simple method for good charting from kdb+ base ?As far as i know there is no built-in chart function in kdb+/q anymore.So you need to use external charting tool like matlab, r , j, flex, … .> For example I have some formula with data calculation as RSI,ATR,Stoch> from OHLC or ticks and want to fast preview for some time series or> all with scroll option.>> studioForKdb+ and qpad have some option but is to simple and not very> user/analyst friendly.> Looking something like this example:> http://img.nopaste.pl/upload/performance%20monthly\_4f1831605ec84.jpg\> (https://picasaweb.google.com/115099029813395778077/TimelyPortfolio02)> http://timelyportfolio.blogspot.com/2012/01/r-in-axys-impossible-dream.html\>> R or matlab for this moment is to complicate to use in my opinion whenIt is not really that complicate. In matlab you need to load a java file, built the connection to kdb+ and afterwards you need to query the data.> I planing do my calcs in q.> But maybe some smart sugestions ?>
How about amcharts provided by Chris available on code.kx?
http://code.kx.com/wsvn/code/contrib/cburke/amcharts/
I’m facing a similar issue.
My plan is to use the plotting, graphing and charting features of A+ and of J.
If working with J, don’t miss http://code.kx.com/wiki/Cookbook/IntegratingWithJEspecially "QJ: J Engine within Kdb+ " would be interesting if wishingto call it from within Q.On 19 Jan, 21:37, Tom Szczesny <tav…> wrote:> I’m facing a similar issue.> My plan is to use the plotting, graphing and charting features of A+ and of> J.>> On Thu, Jan 19, 2012 at 2:50 PM, Bartosz Kaliszuk <>>>>>>>> bartosz.kalis...@gmail.com> wrote:> > How about amcharts provided by Chris available on code.kx?> >http://code.kx.com/wsvn/code/contrib/cburke/amcharts/>> > On Thu, Jan 19, 2012 at 4:14 PM, reptile <my.rept…> wrote:>> >> Hi,>> >> Is any fast and simple method for good charting from kdb+ base ?>> >> For example I have some formula with data calculation as RSI,ATR,Stoch> >> from OHLC or ticks and want to fast preview for some time series or> >> all with scroll option.>> >> studioForKdb+ and qpad have some option but is to simple and not very> >> user/analyst friendly.> >> Looking something like this example:> >>http://img.nopaste.pl/upload/performance%20monthly_4f1831605ec84.jpg> >> (https://picasaweb.google.com/115099029813395778077/TimelyPortfolio02)>> >>http://timelyportfolio.blogspot.com/2012/01/r-in-axys-impossible-drea...>> >> R or matlab for this moment is to complicate to use in my opinion when> >> I planing do my calcs in q.> >> But maybe some smart sugestions ?>> >> –> >>
Submitted via Google Groups</my.rept…></tav…>
Thanks for attention !Looks I must back to matlab.. :)The main problem is in TA tools.. I like some V/H lines or trends oncharts.I doing fast calcs,examples on data and I’m not sure that matlab isbest solution.I see potential tool/soft in this case (maybe as product).On this moment I using multicharts and ASCI mapping for data as constkdb buffors in csv.On 21 Sty, 13:35, Lindqvist <lindqvist.h…> wrote:> If working with J, don’t misshttp://code.kx.com/wiki/Cookbook/IntegratingWithJ>> Especially "QJ: J Engine within Kdb+ " would be interesting if wishing> to call it from within Q.>> On 19 Jan, 21:37, Tom Szczesny <tav…> wrote:>> > I’m facing a similar issue.> > My plan is to use the plotting, graphing and charting features of A+ and of> > J.>> > On Thu, Jan 19, 2012 at 2:50 PM, Bartosz Kaliszuk <>> > bartosz.kalis...@gmail.com> wrote:> > > How about amcharts provided by Chris available on code.kx?> > >http://code.kx.com/wsvn/code/contrib/cburke/amcharts/>> > > On Thu, Jan 19, 2012 at 4:14 PM, reptile <my.rept…> wrote:>> > >> Hi,>> > >> Is any fast and simple method for good charting from kdb+ base ?>> > >> For example I have some formula with data calculation as RSI,ATR,Stoch> > >> from OHLC or ticks and want to fast preview for some time series or> > >> all with scroll option.>> > >> studioForKdb+ and qpad have some option but is to simple and not very> > >> user/analyst friendly.> > >> Looking something like this example:> > >>http://img.nopaste.pl/upload/performance%20monthly_4f1831605ec84.jpg> > >> (https://picasaweb.google.com/115099029813395778077/TimelyPortfolio02)>> > >>http://timelyportfolio.blogspot.com/2012/01/r-in-axys-impossible-drea...>> > >> R or matlab for this moment is to complicate to use in my opinion when> > >> I planing do my calcs in q.> > >> But maybe some smart sugestions ?>> > >> –> > >>
Submitted via Google Groups</my.rept…></tav…></lindqvist.h…>
> Looks I must back to matlab.. :)> I doing fast calcs,examples on data and I’m not sure that matlab is> best solution.the best solution is often a combination of tools that each do theirfunction well.it seems that you have time-series data that you wish to plot, so iwould recommend number crunching in q, exporting this data via csv: q)save :trade.csv / http://code.kx.com/wiki/Cookbook/UsingKdbif you have table names: q)ts:cumulativereturnmonthlyreturndrawdown1drawdown2drawdown3you can export your tables: q)save {“S”$“:”,x,“.csv”}each string ts /untestedyou can automate the whole process so that a script runs and exportsyour numbers from q and then launches matlab to produce your plot.ta, jack.
Hi everyone,just discovered that you can start matlab as a Component Object Model (COM) server. So you can send directly data and cmd to matlab from q and use the plot functions there.Very coolRegards,KimAm 19.01.2012 16:14, schrieb reptile:> Hi,>> Is any fast and simple method for good charting from kdb+ base ?>> For example I have some formula with data calculation as RSI,ATR,Stoch> from OHLC or ticks and want to fast preview for some time series or> all with scroll option.>> studioForKdb+ and qpad have some option but is to simple and not very> user/analyst friendly.> Looking something like this example:> http://img.nopaste.pl/upload/performance%20monthly\_4f1831605ec84.jpg\> (https://picasaweb.google.com/115099029813395778077/TimelyPortfolio02)> http://timelyportfolio.blogspot.com/2012/01/r-in-axys-impossible-dream.html\>> R or matlab for this moment is to complicate to use in my opinion when> I planing do my calcs in q.> But maybe some smart sugestions ?>