Re: Graph for stocks (share market) in Open-High-Low-Close candlesticks format

[Jean Bréfort <jean brefort normalesup org>]

Le samedi 13 avril 2013 à 18:25 +0530, Vineet Deodhar a écrit :
>         > I wish to draw chart from shares data in
>         "Open-High-Low-Close" format.
>         > In other spreadsheet softwares, "stock - OHLC" format is
>         there by
>         > default (aka japanese candlesticks).
>         > In gnumeric, I did not find it.
>         
>         
>         It's called MinMax Plot. Most of classical stock plots need a
>         mix of
>         several plots in Gnumeric.
>         
>         
>
>
> I tried it. But it is not what I am talking about. (or maybe I have
> not understood how to extract the juice I require from it).
> It doesn't give 'candlestick'.
>
>
> The
> docs, http://projects.gnome.org/gnumeric/doc/sect-graphs-overview-types-minmax.shtml are also not complete 
> (work in progress).
>
>
>
>
>         >
>         > I opened one file saved by MS Excel containing candlestick
>         chart and
>         > opened it in gnueric.
>         > It shows the chart correctly. That means gnumeric can
>         display
>         > candlesticks.
>         > But .... configuration options are very limited (I can't
>         configure the
>         > source data).
>         > How do I configure it in gnumeric?
>         
>         
>         Configuration options are not so limited. Right click on the
>         chart, and
>         select Properties. In the dialog, select the Series, then the
>         Data tab.
>         There you can set the data.
>         For open/close data, use a Dropbar plot.
>         
>         Hope this helps.
>         Jean
>         
>         
>         
>
>
> Under 'open-low', it shows 'min-max'. It is confusing.
> Again, how to specify 'close'?

Why open-low? You should use low-high for the minmax plot. And for
Open-Close, use a dropbar plot (add a new plot to the chart).

> I didn't find it intuitive.
> In fact, specifying OHLC is an explicit way.
>
>
> -- Vineet
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> https://mail.gnome.org/mailman/listinfo/gnumeric-list