Financial chart

[rocuinneagain]

1. How are you trying to plot the data? table, bar, line etc. ?
2. Are you seeing an error? Why do you say it cannot be plotted?

 

Common components to chart:

• Data Grid – KX Dashboards
• Canvas Chart – KX Dashboards

[davidcrossey]

A few things here;

1. You won’t see any bars as your open/high/low/close prices are all the same value. In your test data you need a range of prices over the course of a day (for example), then you would take the first/max/min/last (OHLC) per date
2. The documentation appears to be a little misleading with “Time” column. It should be a timestamp.

Here is a mock example I’ve just put together and a data source for reference

Data Source

n:10000; t:([]Date:n?.z.p;price:n?100f;Volume:n?100f); delete price from update Open:first price, Close:last price, High:max price, Low:min price, Volume:sum Volume by `date$Date from t

Hope this helps

[mshk]

Hi,

I am trying to plot candlestick chart.

There is no error but nothing is showing up.

Please see the screen below or advise the steps?

thank you

[davidcrossey]

Do you have any data coming back through your data source “temp”?

[mshk]

Hi,

Using the same data source, it can show on canvas chart but not on ChartIQ.

Why is this so?

[mshk]

Hi,

Yes,

Please see from my screenshot below. It shows the executed results from data source temp.

 

[davidcrossey]

ChartIQ requires a separate licence to run.

Generally you should utilise the custom financial chart, or alternatively canvas charts/chartGL which both have candlestick charts built in.

[mshk]

Noted with thanks!