cancel
Showing results for 
Search instead for 
Did you mean: 

Financial chart

MSHK
New Contributor III

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?

1 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

davidcrossey_1-1649221461484.png

Preview

davidcrossey_0-1649221386480.png

Hope this helps

View solution in original post

8 REPLIES 8

rocuinneagain
Contributor II
Contributor II
  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:

MSHK
New Contributor III

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

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

MSHK
New Contributor III

Hi,

Yes,

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

 

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

davidcrossey_1-1649221461484.png

Preview

davidcrossey_0-1649221386480.png

Hope this helps

MSHK
New Contributor III

Hi,

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

Why is this so?

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
New Contributor III

Noted with thanks!