Title: Candlestick Chart
Last modified: September 1, 2016

---

# Candlestick Chart

 *  Resolved [glatze1001](https://wordpress.org/support/users/glatze1001/)
 * (@glatze1001)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/candlestick-chart/)
 * Hi,
 * Did you ever check if candlestick charts really work. What is the order:opne,
   high, low, close?
 * Cheers
    Roberto
 * [https://wordpress.org/plugins/inline-google-spreadsheet-viewer/](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/candlestick-chart/#post-7634633)
 * Yes, I did. Did you? More info: [https://developers.google.com/chart/interactive/docs/gallery/candlestickchart](https://developers.google.com/chart/interactive/docs/gallery/candlestickchart)
 *  Thread Starter [glatze1001](https://wordpress.org/support/users/glatze1001/)
 * (@glatze1001)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/candlestick-chart/#post-7634678)
 * Yes, with the google example.
 * [gdoc key=”[https://docs.google.com/spreadsheets/d/1BRCq_ZwBzO_oP4kRcU91id4qhyZzQ5Flvvp5qX6HKos/edit#gid=0&#8243](https://docs.google.com/spreadsheets/d/1BRCq_ZwBzO_oP4kRcU91id4qhyZzQ5Flvvp5qX6HKos/edit#gid=0&#8243);
   query=”select B,cc,cd,ce,cf” chart=”candlestick” ]
 * Why don’t you show me your code?
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/candlestick-chart/#post-7634689)
 * 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](https://developers.google.com/chart/interactive/docs/gallery/candlestickchart#data-format).
 * 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.
 *  Thread Starter [glatze1001](https://wordpress.org/support/users/glatze1001/)
 * (@glatze1001)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/candlestick-chart/#post-7634768)
 * Meitar,
 * How can I apply the different configurations:
    [https://developers.google.com/chart/interactive/docs/gallery/candlestickchart#configuration-options](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&#8243](https://docs.google.com/spreadsheets/d/1BRCq_ZwBzO_oP4kRcU91id4qhyZzQ5Flvvp5qX6HKos/edit#gid=0&#8243);
   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
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/candlestick-chart/#post-7634779)
 * > 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](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/other_notes/).
    2. Read the “How do I customize my chart?” section of [the FAQ](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/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.
    5. > style='{“candlestick.fallingColor.fill”: “red”}’
    6. This isn’t even close to the syntax of the other chart attributes, I don’t know
       why you think it would work.
    7. 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.
    8. Hope this helps.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Candlestick Chart’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/inline-google-spreadsheet-viewer.
   svg)
 * [Inline Google Spreadsheet Viewer](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/)
 * [Active Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [Meitar](https://wordpress.org/support/users/meitar/)
 * Last activity: [9 years, 10 months ago](https://wordpress.org/support/topic/candlestick-chart/#post-7634779)
 * Status: resolved