Candlestick Chart

Yes, I did. Did you? More info: https://developers.google.com/chart/interactive/docs/gallery/candlestickchart

Yes, with the google example.

[gdoc key=”https://docs.google.com/spreadsheets/d/1BRCq_ZwBzO_oP4kRcU91id4qhyZzQ5Flvvp5qX6HKos/edit#gid=0″ query=”select B,cc,cd,ce,cf” chart=”candlestick” ]

Why don’t you show me your code?

First off, column identifiers are case-sensitive, so there is no such thing as a cc column. You mean CC. Second, after you fix the column ID casing, you’ll see that the plugin reports a visible error: “All data columns targetting the same axis must be of the same data type. Column #2 is of type number but expected type is string”

You need to ensure your Google Query is returning data in the correct data format for your chosen (candlestick) chart type.

For example, using your own sheet, this works:

[gdoc key="https://docs.google.com/spreadsheets/d/1BRCq_ZwBzO_oP4kRcU91id4qhyZzQ5Flvvp5qX6HKos/edit#gid=0" query="select B,CD,CE,CF,CG" chart="candlestick"]

Though I don’t think that’s the data you actually want to use. However, the plugin does load this data into a Candlestick chart correctly.

Meitar,

How can I apply the different configurations:
https://developers.google.com/chart/interactive/docs/gallery/candlestickchart#configuration-options

For example if I wanna set the “candlestick.fallingColor.fill” to red. How do I incorporate that into my code?

[gdoc key=”https://docs.google.com/spreadsheets/d/1BRCq_ZwBzO_oP4kRcU91id4qhyZzQ5Flvvp5qX6HKos/edit#gid=0″ http_opts='{“timeout”:30}’ query=”select B,CC,CD,CE,CF limit 14″ chart=”candlestick” use_cache=”no” chart_height = 400 chart_width = 800 chart_font_size =12 chart_colors=”green orange” chart_h_axis ='{“slantedText”: true, “slantedTextAngle”:25}’ chart_v_axis= ‘{“format”:”#.##%”}’ style='{“candlestick.fallingColor.fill”: “red”}’ ]

Thanks

How can I apply the different configurations

Asked and answered many times. Once again:

1. See a full list of the available chart customization attributes on the Other Notes page.
2. Read the “How do I customize my chart?” section of the FAQ.
3. Refer to the Google Charts API documentation for the specific chart you are using for more details.
4. Translate the configuration options available in the API to shortcode attributes, described in detail in the FAQ linked earlier.

style='{“candlestick.fallingColor.fill”: “red”}’

This isn’t even close to the syntax of the other chart attributes, I don’t know why you think it would work.

You probably want chart_candlestick='{"fallingColor": {"fill": "red"}}'. The dots are object notation, one object nested inside another, which is also described and has examples shown in the Google API docs.

Hope this helps.