ilgizar / ilgizar-candlestick-panel Goto Github PK

My query:

"q=SELECT first("ltp") AS "open", last("ltp") AS "close", min("ltp") AS "low", max("ltp") AS "high", difference(last("vtt")) AS "volume" FROM "ZFeedFull" WHERE ("symbol" =~ /^BANKNIFTY20JULFUT$/) AND time >= 1594957500000ms and time <= 1594979999000ms GROUP BY time(5m) fill(linear)"

If I change panel to graph, I get data:

My grafana version is 6.4

I use the 5.0.0 version now
Datasource is influxdb for all queries
I have undefined is not an object (evaluating 'this.panel.seriesOverrides') on safari macOS

and

TypeError: Cannot set property '0' of undefined
    at CandleStickCtrl.refreshColors (http://localhost:3010/public/plugins/ilgizar-candlestick-panel/candlestick_ctrl.js:285:53)
    at CandleStickCtrl.onDataReceived (http://localhost:3010/public/plugins/ilgizar-candlestick-panel/candlestick_ctrl.js:263:18)

on chrome macOS

[EDIT] Can you give me a working json panel? it may help to debug. thx

Thanks

Hi,
I have missing plots in the graf
same version of grafana
see the tooltip in the following screenshot

Thanks

I am using simpleJson data source for indicators seems that there is no alias for the metrics coming from this data source.
see here

[EDIT] - I have the same problem with influxdb datasource indicators

[EDIT1] - Do you think it is related to grafana version? I'm using Version 4.6.3 (commit: 7a06a47)

undefined is not an object (evaluating 'this.panel.aliasColors[this.series[i].alias]')

Stack trace

refreshColors

onDataReceived
onDataReceived@[native code]
emit@http://localhost:3010/public/build/vendor.2305a8e1d478628b1297.js:15:520753
emit@http://localhost:3010/public/build/app.5331f559bd9a1bed9a93.js:1:29221
handleQueryResult@http://localhost:3010/public/build/0.be20b78823b4c9d93a84.js:7:19864
[native code]
u@http://localhost:3010/public/build/vendor.2305a8e1d478628b1297.js:43:68723
http://localhost:3010/public/build/vendor.2305a8e1d478628b1297.js:43:69128
$digest@http://localhost:3010/public/build/vendor.2305a8e1d478628b1297.js:43:74825
$apply@http://localhost:3010/public/build/vendor.2305a8e1d478628b1297.js:43:76645
http://localhost:3010/public/build/vendor.2305a8e1d478628b1297.js:43:72703
i@http://localhost:3010/public/build/vendor.2305a8e1d478628b1297.js:43:21875
http://localhost:3010/public/build/vendor.2305a8e1d478628b1297.js:43:23333

Hello.

I am using this plugin with the version Grafana 7.0.3 and no data were displayed. Did someone manage it to display some data with this plugin, which was the latest working Grafana version? Other graphs are loading my queries.

Thank you.
Regards
Chris

I'm trying to get candlesticks to work with the plugin 'mongodb-grafana':
https://github.com/JamesOsgood/mongodb-grafana

I have a mongodb query like this:

db.5b8f88f33345af4961e38a62.aggregate( [
{"$match": {"symbol": "ES", "interval": "15m"} },
{"$sort": {"dts": 1}},
{"$project": {"name": "ES backtest", "ts": "$dts", "value": {"open": "$Open", "high": "$High", "low": "$Low", "close": "$Close"}, "_id": 0}}
])

But the chart isn't displaying anything (no error either).

I assume I need to provide "name", "ts" (timestamp), and "value" as per instructions for the mongodb-grafana. Is the approach I'm taking correct? Any tips on getting this to work?

NOTE: I did get something like this working w/o candlesticks:

db.5b8f88f33345af4961e38a62.aggregate( [
{"$match": {"symbol": "ES", "interval": "15m"} },
{"$sort": {"dts": 1}},
{"$project": {"name": "ES backtest", "ts": "$dts", "value": "$Close", "_id": 0}}
])

Any help is much appreicated.

how to manually install this plugin with grafana-cli plugins install ?

It would be really nice to have the shared crosshair like in graph panel
thanks

I'm not sure where to enable volume in the latest version of Grafana. Did the option disappear?
I definitely have the volume data in my InfluxDB and it is also one of the queries I run. Where can I enable the option to show volume?

Wondering if this repo is death or will it be actively maintained in the future?

It would be great to be able to pick colours for indicators.
Thanks

Hi,
When using a single point metric like
SELECT min("rate") FROM "trades" WHERE "currencyPair" =~ /^$pairs$/ AND $timeFilter
which returns only one data, the tooltip disappears.

Thanks

Hi
Thanks for adding the feature.
There is a bug when you add indicators the options list get mixed up, see screenshots below

Before

After adding

It would be nice to have annotations in the panel
Thanks

The starting point is where the tooltip for the moving average is displayed.

I'm trying to replace my conventional graph panel with this awesome canclestick panel (thanks alot for it!). It works really well. The only thing I'm missing is the ability to show all configured indicators as legend like in a conventional graph panel.
This would allow for easy understanding which line is which indicator and also would enable the user to hide certain indicators selectively.

e.g.:

In the second graph I can hide indicators selectively and immediately know which line is which indicator.

Is the same possible somehow with the candlestick panel? If not, would this be a feature considered for a future version?

According to the pictures I need something like a display option to deny null values but I could not find it on that plugin.

Also I notified that when we have massive data the candles does not appear to be consistent.

I am trying to get the plugin working but the query is where i get stuck. could you add a screenshot of the Metrics tab so I can see why no datapoints are being displayed.

When there is missing data the plugin draws funny looking candles like here - https://imgur.com/a/oBRxSnJ instead of just not drawing anything or drawing a simple straight line. The plugin should not create candles where data doesn't exist.

Installation from the source shows that the plugin is unsigned. Is it possible to do official release and signing the plugin according to Grafana instructions?

It would be great to be able to select bars/line/dots for the indicators/volume.
Thanks you, your plugin is kind of a revolution for my crypto dashboards. :)

Hi ilgizar

I can't try the panel.

Plugin Error
Unable to dynamically transpile ES module A loader plugin needs to be configured via SystemJS.config({ transpiler: 'transpiler-module' }). Instantiating http://localhost:3000/public/plugins/ilgizar-candlestick-panel/module.js Loading plugins/ilgizar-candlestick-panel/module

I tried to install the plugin first copying the folder of git, and in the by other hand
grafana-cli --pluginUrl https://github.com/ilgizar/ilgizar-candlestick-panel/archive/master.zip plugins install ilgizar-candlestick-panel

It doens't work me

I'm using docker-compose like

grafana:
    image: grafana/grafana:5.1.2
    volumes:
        - ./grafana/etc:/etc/grafana
        - ./grafana/var/lib:/var/lib/grafana
        - ./grafana/var/lib/plugins:/var/lib/grafana/plugins
        - ./grafana/var/lib/provisioning:/var/lib/grafana/provisioning
        - ./grafana/var/log:/var/log/grafana
    links:
        - influxdb:influxdb
    environment:
        - GF_INSTALL_PLUGINS=grafana-clock-panel,briangann-gauge-panel,natel-plotly-panel,grafana-simple-json-datasource
    ports:
        - 3000:3000
    depends_on:
        - influxdb
    privileged: true

Any sugestion?

Thank you

I think it should be aligned with the bar graph (I think you center the box and they dont in the bar graph)
see screenshot below

Thanks

I dont know why but boxes are two wide
see screenshot
I'm using Grafana Version 4.6.3 (commit: 7a06a47)

As we usually look at the fresh values comping from the right it makes more sense to have the price on the Y2 axis, like in exchanges mkt.
As always, really appreciate what you're doing.
Thanks

Grafana version: 5.2.1
Installation steps:

1. Download zip file.
2. Unzip to grafana/5.2.1/share/grafana/public/app/plugins/panel (mac OS).
3. restart grafana.

The error message is:
Plugin Error
Fetch error: 404 Not Found Instantiating http://localhost:3000/public/app/plugins/panel/ilgizar-candlestick-panel/module Loading app/plugins/panel/ilgizar-candlestick-panel/module

BTW, the official installation document is about official plugin, but I am confused why referred to this one in README.MD

@ilgizar @JamesGalt

Cloned today
Grafana 5.0.4
Fails with the error below when adding to a dashboard.

Plugin Error
Unexpected token , Instantiating http://0.0.0.0:3000/public/plugins/ilgizar-candlestick-panel/candlestick_ctrl.js Loading http://0.0.0.0:3000/public/plugins/ilgizar-candlestick-panel/module.js Loading plugins/ilgizar-candlestick-panel/module

Hello,

Could you please add your repo to grafana plugins repository so that I could use your panel in grafana cloud?

Thanks

This, this is a great plugin and it works quite well. It would be nice if there was a way to better separate the candlesticks from the volume though because they tend to run into each other quite a bit, as in here - https://imgur.com/a/0DCUXjg. Also would be nice to support some annotations, horizontal lines for levels, etc. Kudos on the great work so far.

I would like to know if the candlesticks would work with other database than Influx. Wondering if it can be used with Postgres or Timescale db.