Financial chart

[MSHK]

Hi 

I am trying to use financial chart.

My data sources are set up and the executed results are as attached in File 1.

Please advise why it cannot be plotted?

[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

[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,

Yes,

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

[davidcrossey · Accepted solution]

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

Preview

Hope this helps

[MSHK]

Hi,

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

Why is this so?

[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!