Hi :) Thanks! :) That made a lot of sense. It's vaguely reminiscent of error-bars but does show tons more information. Even at a quick glance you can get quite a lot from it once you know to look for white/hollowed areas. Regards from Tom :)
--- On Wed, 10/10/12, Viral Orpe <viral.o...@yahoo.com> wrote: From: Viral Orpe <viral.o...@yahoo.com> Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features To: "users@global.libreoffice.org" <users@global.libreoffice.org> Date: Wednesday, 10 October, 2012, 13:10 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. Dan: === 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: https://en.wikipedia.org/wiki/Candlestick_chart 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. Steve: ==== 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! Thanks, Regards, 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 <tomdavie...@yahoo.co.uk> To: users@global.libreoffice.org; rost52 <bugquestcon...@online.de> 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 <bugquestcon...@online.de> wrote: From: rost52 <bugquestcon...@online.de> Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features To: users@global.libreoffice.org 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, > regards, > Viral Orpe > > p.s. > *Vaulting Ambition :) > http://www.shakespeare-online.com/plays/macbeth/soliloquies/blow.html > > (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: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted