Date: prev next · Thread: first prev next last

2012 Archives by date, by thread · List index

Re: [libreoffice-users] Fw: Help request on CALC charts' features

Viral Orpe <viral.orpe -AT- yahoo.com>
Thu, 11 Oct 2012 09:05:15 -0700 (PDT)

Hi Tom :)

Thanks for bringing the copy-right to my attention.

Although stock markets here are quite old - 
 
    http://www.bseindia.com/
    "... Established in 1875, BSE Ltd. (formerly known as Bombay 
    Stock Exchange 
Ltd.), is Asia’s first Stock Exchange and one 
    of India’s leading 
exchange groups...."

- compared to the western-world % wise very few people are acquainted 
with them. I started but a few years ago. NSE is relatively younger and
more tech savvy and darling of the Foreign Institutional Investors (FIIs).

Point is: As the copyright suggests, Stock Exchanges, Regulators here 
are very lenient particularly towards "retail investors / traders" (me!) 
But it is an important practice to go through the copy right notice(s)
of whatever you do. 

BTW, NSE looking for a charting solution from me is not happening :) 
Thanks for the encouragement though. 

And interesting read on the LSE!   


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 <tomdavies04@yahoo.co.uk>
To: Viral Orpe <viral.orpe@yahoo.com>; "users@global.libreoffice.org" 
<users@global.libreoffice.org> 
Sent: Thursday, October 11, 2012 6:06 PM
Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features


Hi :)
The copyright notice is on 
http://www.nseindia.com/copyright.htm
and says 
"Copyright 
Except as specifically permitted herein the Exchange is the 
owner of copyright in all information featured on this website and no 
portion of the information on this website may be reproduced on or 
transmitted to or stored in any other website or in other form of 
electronic retrieval system or by in any other form or by in any other 
means.

Visitors or users may view, print 
copies in hard copy and download the information for personal, 
non-commercial or educational purpose without in any way amending, 
altering, deleting or modifying any part of the information and provided full acknowledgement that 
the information originated from NSE's website is given in the copy of the material. Contents may be 
displayed 
provided successful linking to, redirection to NSE's website is 
acknowledged. Information may be used for commercial purpose after 
obtaining prior permission of the Exchange. Visitors or users must 
inform third party that material may not be copied or reproduced in any 
way. "

So i think it's probably fine for you to use but just let people who access the charts know where 
the data is from.  If you are going to use the the charts commercially then probably best to just 
let them know and ask permission.  Who knows, they might want you to put your charts on their 
website!  Not sure if they would pay you for it but if they do want your charts then definitely ask 
for a decent salary!  If they want to do it themselves then perhaps neogtiate some sort of 
royalties.  

Goodl luck and regards from
Tom :)

________________________________
From: Viral Orpe <viral.orpe@yahoo.com>
To: "users@global.libreoffice.org" <users@global.libreoffice.org> 
Sent: Thursday, 11 October 2012, 11:33
Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features

Hi Tom :)

Yahoo screen-shot was used as an example since Yahoo is omnipresent. 

You are most probably right about the yahoo data but I don't think they give out any data 

- just charts with the limited options that are on offer - chart type , data range, and a bouquet 

of indicators. 

I take my data from the Exchange itself - The National Stock Exchange (NSE), India. 
And do my own calculations - in CALC - to extract some meaning out of it. 

http://www.nseindia.com/index_nse.htm

Under the products tab one gets daily data called "Bhav-copy" (translates to "Rate Sheet") 

Around 7 p.m. every evening they diligently load the day's activities in .csv (which I use) 

and .dbf (? database) format which I just download in case one day I use a DB.
Some data is available only for the day and not for past days, that has to be collected and stored
away before it gets overwritten the next day!

I am worried that one day these exchanges will start asking for money for this or older data.

For example, a few years ago I think I could not get the London Metal Exchange' historical 
data for Copper, and Gold prices - to get a glimpse of what happened when in the past. 
I am collecting my stock exchanges daily data ever since!!

Thanks for the concern

though,

Much appreciated,

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 <tomdavies04@yahoo.co.uk>
To: "users@global.libreoffice.org" <users@global.libreoffice.org>; Viral Orpe 
<viral.orpe@yahoo.com> 
Sent: Thursday, October 11, 2012 10:56 AM
Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features


Hi :)
Draw also has some sort of layers function but i'm not sure they are as easy to use as Gimp.  Gimp 
is excellent but  keeping the chart in LibreOffice increases the chance of keeping the information 
dynamic rather than as a series of static files.  

Lamp uses MySql (sadly i've not heard of anyone using the non-Oracle drop-in replacement called 
MariaDb) which is a database back-end.  Could that pull in the data you use but do it 
automatically and dynamically rather than as snapshots?  Base can supposedly read and present the  
data stored in MySql/MariaDb databases.  Other

modules, such as Writer, can use various "data sources", i think the F4 key.  Can Draw?  Can Base 
use the original data rather than trying to pull the data into a MySql databse?


All that sounds like a complete nightmare to organise but
i've already been very impressed with how fast you've managed to pick up new tools and get them 
doing something intriguingly unusual.  Getting good-enough results fast is great.  

There might be a copyright issue with using Yahoo's data but presumably they get it their original 
data from a public source and then maybe do a few actions to the data to present it differently?  
Can you get to the original source and do your own set of calculations or do you have permission 
to use Yahoo;s info or is that not a concern at the moment?  (prolly best NOT to answer those.  
It's just something to consider)
Regards from
Tom :)  


--- On Wed, 10/10/12, Viral

Orpe <viral.orpe@yahoo.com> wrote:

From: Viral Orpe <viral.orpe@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, 17:58

Hi :)

I was able to overlap two charts in gimp as well as calc. Hurrraahhhh :)

* Adjusted axis on both charts - major, minor ticks to match each other. 

* Scales (rather everything) "Automatic"  is unmarked - in case we need to

scale data ranges later.


* Made the top one completely transparent before moving on top of first. 


In gimp one can be sure that they don't "slide" - ever.

Not sure if there is a facility for that in calc - don't really expect. 

Just pinging in case anyone has any ideas. 

Objects once placed may move - e.g. one justified left other to center etc. - on their own
with some remote change elsewhere in the sheet.


The charts are now 100 times more helpful. No kidding!

Thanks a lot

to everybody who chipped in with their suggestions.


 
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: Viral Orpe <viral.orpe@yahoo.com>
To: "users@global.libreoffice.org" <users@global.libreoffice.org> 
Sent: Wednesday, October 10, 2012 9:18 PM
Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features

Hi :)


I have added

the Yahoo finance image illustrating the overlap of the basic


candlestick chart and line chart and bar chart to my facebook page.
Album: LibreCALC_Query
File: z.png


Hope that clarifies. 
 
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: Viral Orpe <viral.orpe@yahoo.com>
To: "users@global.libreoffice.org" <users@global.libreoffice.org> 
Sent: Wednesday, October 10, 2012 6:29 PM
Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features

Hi rost52 :)

Yes, That's right.
That is the one I am using. 

Problem is: 
I want to add some indicators on it too. 
Like say the average of the past 3 months - which will be a line chart.  

I have uploaded two

screenshots (.png) of the file I am using on my facebook page.

They are made "public" under the album "Libre_CALC_Query"
I don't use fb often so if

you find any trouble downloading them please do not

fight with FB. Just let me know. In all probability it will be some mistake from my side. 

I might make it three screen-shots with one example from yahoo finance in a couple of hours.
Got to move out of this chair now!!!:)


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: rost52 <bugquestcontri@online.de>
To: users@global.libreoffice.org 
Sent: Wednesday, October 10, 2012 6:01 PM
Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features

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.

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 <tomdavies04@yahoo.co.uk>
To: users@global.libreoffice.org; rost52 <bugquestcontri@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 <bugquestcontri@online.de> wrote:

From: rost52 <bugquestcontri@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+help@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+help@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+help@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+help@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+help@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+help@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

Context

Re: [libreoffice-users] Fw: Help request on CALC charts' features (continued)
- Re: [libreoffice-users] documentation for LO base · Wolfgang Keller
- Re: [libreoffice-users] documentation for LO base · Hank Alper

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.