Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

Candlestick charts

The wikipedia link was helpful.
I think that what you want to use is called in Calc chart type "stock". There are 4 different sub type shown. The second from left looks very much like the chart in the wiki link.

On 10.10.2012 21:10, Viral Orpe wrote:
Hi :)

Thanks for all the responses....

I have tried to respond collectively here.

/* ******************** */

  Miguel Ángel:
About overlapping several charts
I got similar idea but not overlapping in calc itself but using gimp.
I came across gimp some time last week and it had some concept like layers.
I have added a transparent layer and copied two charts - with same axis scales,
ranges - on each layer.

I am not very conversant with gimp though so right now I can only jump from
one layer to another and see two charts one-by-one. My charts themselves
have opaque background so transparency of layers is not helping. Still a
work in progress, I must say. Will keep you posted once I get what I need -
first in gimp and then in calc.

Thanks a lot for your inputs.

About using Databases:
Thanks Dan, you are absolutely right about wondering why not databases?!
I was thinking the best way to do what I do is using LAMP - particularly since
I have to ultimately work on data that is 245 days/year, 12 years till now, 1000+
entries everyday, each entry has say 8-10 sub-entries and at least two such sets
of data! (Equity, derivatives, & Commodity)
(365 - 52x2weekends - 16 holidays = 245 days/year!)

But this is my first week with Linux! I can't possibly get into MySQL and hope to
get it rightly done without crashing my system a thousand times. Right now, I have this
one machine working. I hope to resurrect an old system and do all the LAMP/ sys-admin
type of work (tweaking!) on it before moving the whole thing to a powerful machine.

The calc charting is a short term solution before I get (and I hope I get it ultimately)
the whole LAMP thing going. (I had been using MS XP and Excel for couple of years for
this purpose, I can't believe my own madness/inertia/procrastination!)
In fact I have noted your suggestion of linking the database files to calc and then making
charts from it. That way I can use a database even before I get in to the A & P of LAMP.

Dan, rost52, Tom:
About Candlestick charts:
Candlestick charting is a Japanese charting technique for stocks, commodities,
currencies. One candlestick represents the Open-High-Low-Close values for a
given interval. The interval can be anything from minutes to years but is constant
for a chart. It is an excellent visual representation that is extremely quick to grasp.
Inferences are made based on a single candle or multiple candles seen together.

Further info:

Check the various candlestick patterns and their interpretations.
*** The Japanese have shown great imagination in naming the patterns!

Just to check how a candle stick chart looks, please go to yahoo finance and look for
a technical analysis/ charting link (mostly you can just click any chart you see: NASDAQ/
DAX etc). Choose "Basic Tech Analysis" under charts. Set the range to 6 months and select
type as "candle".

I will try to find a way to get a real life example .ods or screen-shots on the net somewhere.

The chartmaster software - was it open-source?
May be I should search for similar charting software in open source domain.
Unfortunately till now I have found myself to be "we didn't start the fire" types :P
Someone, somewhere has always gone way ahead before me!
In any case, if I find something open-source I can be sure of tweaking it (on my
own machine) to my desire/ caliber/ patience! May be add a little but not reinvent!

Viral Orpe :)
Processor  : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz
Memory     : 4GB, DDR3
OS            : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686)
LibreOffice : LibreOffice 3.4.3  OOO340m1 (Build:302)


  From: Tom Davies <>
To:; rost52 <>
Sent: Wednesday, October 10, 2012 1:46 PM
Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features
Hi :)
I assumed he meant a bar-graph but made it sound more interesting.
Regards from
Tom :)

--- On Wed, 10/10/12, rost52 <> wrote:

From: rost52 <>
Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features
Date: Wednesday, 10 October, 2012, 2:32

Could you possibly post somewhere an example of a candle stick chart?

On 2012-10-10 02:52, Viral Orpe wrote:
Hi :)

Thanks for your time and replies.
I could stop fighting calc to show me the chart as a single worksheet!

I was charting the stock market data (available in daily doses to be bunched neatly in weekly, 
monthly, quarterly, yearly batches) in candlestick form.
Both Excel and Calc do not allow any other lines on the candlestick charts (moving averages, e.g.).
It robs the ease of analysis (and make me dependent on some websites that offer it - currently for 
free :) but I never liked the dependence)

I read somewhere* what Shakespeare wrote of vaulting ambition :)
Since, I have no spur to prick my intent, as of today I can't start vaulting onto tweaking CALC 
source code to add a new chart type.

But, it would be fun and a taste + test of the Linux promise of free(dom)!
Hope I reach the promised land one day.

Any pointers are welcome.

again, thanks for your time,
Viral Orpe

*Vaulting Ambition :)

(spur: I know just C, data structures, and presently am learning shell scripting.
Nothing about Linux kernel/ internals and have never written software in a
professional team)


snip <<<<<<<<<<<<<<

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.