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 _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list