Google's Candlestick charts are INCORRECT

[pubg...@gmail.com]

It doesn't matter if you are using their API or as I am trying to do create a chart in GoogleDocs their representation of candlesticks is wrong.

For example: Candlestick Charts on Google explanation where it states: " In this chart, items where the opening value is less than the closing value (a gain) are drawn as filled boxes, and items where the opening value is more than the closing value (a loss) are drawn as hollow boxes."

However, it conventional candlestick use it is the other way around eg hollow candlesticks are used where the closing value is HIGHER than the opening value. The workaround is to switch the columns which google uses for data but if they change their visualization...?

I have contacted the developers and they don't respond.

[Daniel LaLiberte]

Hi pubgapps,

I can't find any message from you about the candlesticks coloring, but in any event, while you are correct that we appear to have the filling backwards from convention, it is a small matter that is easily worked around by specifying the colors yourself, e.g. 

      candlestick: {

        fallingColor: { strokeWidth: 0, fill: '#a52714' }, // reddish

        risingColor: { strokeWidth: 1, fill: 'white' }

      }

I'm not sure if, or when, we will change the default behavior.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/f8b76f28-c6bb-4f18-8a67-f34ca4f1a15b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Daniel LaLiberte

dlaliberte@Google.com   5CC, Cambridge MA