Discussion:
documentation for LO base
(too old to reply)
Tom Davies
2012-10-04 11:13:03 UTC
Permalink
Hi :)
Some 3rd party guides can be found listed on the LO Publications page
https://wiki.documentfoundation.org/Documentation/Publications#Base
but i agree with Dan that the Getting Started chapter about Base, the first 2 chapters of the official guide
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide
and the Faq
https://wiki.documentfoundation.org/Faq
are probably the best places to start. 

I think the guide that you are thinking of, by Andrew Pitonyak, is his excellent macro guide?  I'm not sure he has done one for Base but if he has and if we haven't listed it then it would be excellent to add or if there are other guides by other people then they might be good to add too.  Some 3rd party guides cost money and/or if you want to buy the official LO guides in printed form then they can be bought from Lulu (as linked to from the Publications page). 

Regards from
Tom :) 
________________________________
Sent: Thursday, 4 October 2012, 11:29
Subject: Re: [libreoffice-users] documentation for LO base
As well as existing guides by Andrew Pitonyak and others.
Mark
--
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+***@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
Walther Koehler
2012-10-04 16:42:05 UTC
Permalink
Hi,

When I open a document in writer (by menu/open or recently used or new), it
opens a frame with full window size. bingo.

When I open the same document via a basic makro using
loadComponentfromUrl(sURL, "_blank", 0, args())
it opens in a frame maximised vertically but not horizontally.

All further open commands (menu/open AND basic) give the same reduced window
frame. I assume that somehow an internal variable has been changed by the
loadComponentfromUrl command.

of course I fiddled around with the parameters/args() of loadComponentfromURL
and the KDE windows configuration, does "_blank" start a new (wrong) parent
frame?, never Problem up to 3.4.

Any idea?

Walther
--
For unsubscribe instructions e-mail to: users+***@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
Tom Davies
2012-10-04 18:26:22 UTC
Permalink
Hi :)
Hopefully someone more experienced will give a decent answer but until then it might be worth acquiring Andrew Pitonyak's Macro Guide
https://wiki.documentfoundation.org/Documentation/Publications#Programmers

There are a few chapters and things in official documentation (and therefore free) but i suspect you have already gone through those. 
Regards from
Tom :) 
________________________________
Sent: Thursday, 4 October 2012, 17:42
Subject: [libreoffice-users] loadComponentfromUrl
Hi,
When I open a document in writer (by menu/open or recently used or new), it
opens a frame with full window size. bingo.
When I open the same document via a basic makro using
loadComponentfromUrl(sURL, "_blank", 0, args())
it opens in a frame maximised vertically but not horizontally.
All further open commands (menu/open AND basic) give the same reduced window
frame. I assume that somehow an internal variable has been changed by the
loadComponentfromUrl command.
of course I fiddled around with the parameters/args() of loadComponentfromURL
and the KDE windows configuration, does "_blank" start a new (wrong) parent
frame?, never Problem up to 3.4.
Any idea?
Walther
--
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+***@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
Ken Brucker
2012-10-04 16:04:36 UTC
Permalink
thanks to all for your answers and consideration

K
--
For unsubscribe instructions e-mail to: users+***@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
Mark Stanton
2012-10-04 10:29:35 UTC
Permalink
As well as existing guides by Andrew Pitonyak and others.

Mark
--
For unsubscribe instructions e-mail to: users+***@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
Dan Lewis
2012-10-04 13:55:16 UTC
Permalink
As well as existing guides by Andrew Pitonyak and others.
Mark
Could we have some links for the locations for these please. I
personally would like to have a list of these resources for personal
references. Perhaps others would also.

--Dan
--
For unsubscribe instructions e-mail to: users+***@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
webmaster-Kracked_P_P
2012-10-04 13:57:12 UTC
Permalink
I think one of the guys who is writing the Base documentation for
OpenOffice, and converting it to LO, is a very busy person and it is
taking him a lot of time to do the work for OpenOffice and does not have
as much time to convert each finished chapter to LO. It also takes
other people to look over the work and proofread and test out what is
stated. There seems not to be enough Base people who are able/willing
to help with this hard process.

It seems that Draw and Base are the two "more difficult" modules to
write guides for, with Base being the hardest.

Question: How many people do you know use Base, or have tried to use
Base? Then ask the same for Writer, Calc, Impress, Draw, and then
Math. I rarely use anything other than Writer or Calc, for LO's suite.
Hi :)
Thanks :) I just added it to the list in the Publications page
https://wiki.documentfoundation.org/Documentation/Publications#Base
Regards from
Tom :)
________________________________
Sent: Thursday, 4 October 2012, 13:09
Subject: [libreoffice-users] Re: documentation for LO base
http://www.scribd.com/doc/48635562/Base-Tutorial-OOo
--
View this message in context: http://nabble.documentfoundation.org/documentation-for-LO-base-tp4010907p4010986.html
Sent from the Users mailing list archive at Nabble.com.
--
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+***@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
Mark Stanton
2012-10-04 15:04:54 UTC
Permalink
Post by webmaster-Kracked_P_P
Question: How many people do you know use Base, or have tried to use
Base?
Whilst there is some quite valid criticism of Base, I don't think answering
this question says as much about Base as it does about the general usage
of databases. They are less familiar than word processors, spreadsheets or
drawing packages.

Mark
--
For unsubscribe instructions e-mail to: users+***@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
Joel Madero
2012-10-04 16:56:43 UTC
Permalink
I'm only catching bits and pieces of this conversation but if someone is
interested in doing documentation on base I'd recommend joining the
documentation mailing list. I'm sure they could use some help :)


Regards,
Joel
Post by Mark Stanton
Post by Mark Stanton
Post by webmaster-Kracked_P_P
Question: How many people do you know use Base, or have tried to use
Base?
Whilst there is some quite valid criticism of Base, I don't think
answering
Post by Mark Stanton
this question says as much about Base as it does about the general usage
of databases. They are less familiar than word processors, spreadsheets
or
Post by Mark Stanton
drawing packages.
Mark
I use databases at work, primarily MS SQL Server. My observation is to
be good at using databases (Base included) takes more time and effort up
front than most realize. Most people have a very rudimentary
understanding, if any, of databases. Often, they think of and use
spreadsheets as databases, which only works at a very rudimentary and
simple level (table of contact information for mailing list generation).
Any marginally more sophisticated use and spreadsheets fail as databases.
Database design is less obvious to most. I think most people do not
understand that databases are a type of model of the real world. The
accuracy of the model for the user's needs is what is important and this
not always easy to determine or model.
Beyond the conceptual problems with databases, they use a querying
language. Most (all?) relational databases like Base use a variant of
SQL. So to move beyond the wizards and have more control and
understanding one eventually needs to learn some SQL, another level
learning with more time and effort.
Word processors, spreadsheets, presentation packages, drawing packages,
etc. conceptually tend to follow how one would do the task manually.
Fundamentally, writing a document in Write at its most basic level is a
much nicer way of typing it than on typewriter. Because the program can
do more than just display the text, such spell check, auto format, auto
number lists, etc., the program adds considerable value beyond simply
typing. The early word processing programs had one feature that
typewriter could never do; save the document for later editing without
have to retype it in part or in entirety.
--
Jay Lozier
--
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
--
*Joel Madero*
LibO QA Volunteer
***@gmail.com
--
For unsubscribe instructions e-mail to: users+***@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
Jay Lozier
2012-10-04 16:49:24 UTC
Permalink
Post by Mark Stanton
Post by webmaster-Kracked_P_P
Question: How many people do you know use Base, or have tried to use
Base?
Whilst there is some quite valid criticism of Base, I don't think answering
this question says as much about Base as it does about the general usage
of databases. They are less familiar than word processors, spreadsheets or
drawing packages.
Mark
I use databases at work, primarily MS SQL Server. My observation is to
be good at using databases (Base included) takes more time and effort up
front than most realize. Most people have a very rudimentary
understanding, if any, of databases. Often, they think of and use
spreadsheets as databases, which only works at a very rudimentary and
simple level (table of contact information for mailing list generation).
Any marginally more sophisticated use and spreadsheets fail as databases.

Database design is less obvious to most. I think most people do not
understand that databases are a type of model of the real world. The
accuracy of the model for the user's needs is what is important and this
not always easy to determine or model.

Beyond the conceptual problems with databases, they use a querying
language. Most (all?) relational databases like Base use a variant of
SQL. So to move beyond the wizards and have more control and
understanding one eventually needs to learn some SQL, another level
learning with more time and effort.

Word processors, spreadsheets, presentation packages, drawing packages,
etc. conceptually tend to follow how one would do the task manually.
Fundamentally, writing a document in Write at its most basic level is a
much nicer way of typing it than on typewriter. Because the program can
do more than just display the text, such spell check, auto format, auto
number lists, etc., the program adds considerable value beyond simply
typing. The early word processing programs had one feature that
typewriter could never do; save the document for later editing without
have to retype it in part or in entirety.
--
Jay Lozier
***@gmail.com
--
For unsubscribe instructions e-mail to: users+***@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
Tom Davies
2012-10-04 16:57:29 UTC
Permalink
Hi :)
i think the point was that if more people use a thing then more people care about how well it works. 

If we start with the premise that only a fraction of people that use a thing are likely to be involved with fixing it (or even just reporting a problem) then it helps to have more people using it because that may lead to more people being involved in fixing it. 

Once you start adding in extra factors such as average skill level of the different users of the different apps then Base is still heavily out-gunned by Writer and Calc.  I kinda disagree about Draw tho.  I think Impress needs a lot more help than Draw.  Draw has some quite fancy features and i've been really happy using on the rare occasions i've needed something other than Gimp.  Impress is embarrasing.  Base is more important than either of those imo but gets a LOT less attention, except on this list 'recently'. 

Regards from
Tom :) 
________________________________
Sent: Thursday, 4 October 2012, 16:04
Subject: Re: [libreoffice-users] documentation for LO base
Question:  How many people do you know use Base, or have tried to use
Base?
Whilst there is some quite valid criticism of Base, I don't think answering
this question says as much about Base as it does about the general usage
of databases.  They are less familiar than word processors, spreadsheets or
drawing packages.
Mark
--
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+***@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
Pertti Rönnberg
2012-10-05 12:34:42 UTC
Permalink
Hi everybody,

I agree with Mark.

The question itself is interesting but an answer does not explain
anything relevant.

Let us turn the question around:how many people should use LO-Base if
there was a LibO-version available that is ready to use, reliable, and
free of problems (bugs).

If
Post by Mark Stanton
its installing instructions should be complete, consequent, and placed
in one easy to find place
Post by Mark Stanton
the program's every single detail should work -- functions, features,
processes at a level (e.g.) similar to MSAccess (2003) --the ability to
build decent reports included (and the embedded db-engine and its guides
up-dated and supported)
Post by Mark Stanton
the guiding documentation (& help) should be logic, understandable and
in every detail correlating with the program

With the exception of heavy industrial systems the need and
possibilities of up to medium complex databases in everyday life at home
are unlimited -- only limited by the decision to start creating.

There are really nothing difficult in creating such "home databases"--
no need to be an "Einstein", if only good guidings are available.
Creating database applications is also a very interesting form of brain
training -- and the feeling when succeeding is a "yippee". If you know
how to use Writer/Word and Calc/Excel (esp. as "databases") you are
almost half way. What you still has to do is to study and learn some few
basic theories about and how to create the tables and the
queries(experiment manually, not with wizards, if you want to learn and
understand);creating the forms and the reports is just a matter of
following instructions.

If you want LibO to be a popular competitor to MSO (& MSAccess), then
the rest is only a question of marketing.


As far as I have experienced LibO-Base (v. 3.4.5), there are only a few
details left to fixed before LibO should be almost perfect.

About contributing

A basic rule in quality systems (ISO9000) is that if you want
improvement you must first identify the problems (faults, weaknesses) --
and then follow up by a plan and an improving activity.

LibO might be a very fine and usable suit -- especially if also its Base
module (docs included) should work properly, at least as promised in
introductions.

Mr Dan Lewis is doing a good and valuable work when updating and
completing the Base's documentation and it is obvious that without any
help his project will take a long time.

Last winter I started to read and follow up experimenting Dan's docs
with the intension to send my comments as points of views. And hadquite
a lot already done.

At this list I several times also mentioned some quite basic
problems/faults both in Base's docs and especially in the modules's
features.

I never got any kind of response, I don' t know if my proposals were
noticed, nor do I know if the mentioned things have been fixed.

So I skipped working any further on experimenting LibO-Base and its
docs. (I am now back to OO and tries to learn MySQL)

You may take this as some sort of a contribution too.

Best regards

Pertti Rönnberg
Post by Mark Stanton
Question: How many people do you know use Base, or have tried to use
Base?
Whilst there is some quite valid criticism of Base, I don't think answering
this question says as much about Base as it does about the general usage
of databases. They are less familiar than word processors, spreadsheets or
drawing packages.
Mark
--
For unsubscribe instructions e-mail to: users+***@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
John Clegg
2012-10-05 13:31:32 UTC
Permalink
I am going to stick my head above the parapet and say it should have an
embedded database functionality that is secure and reliable. That is an
essential requirement for entry-level users that have only ever used Access.
Post by Pertti Rönnberg
Hi everybody,
I agree with Mark.
The question itself is interesting but an answer does not explain anything
relevant.
Let us turn the question around:how many people should use LO-Base if
there was a LibO-version available that is ready to use, reliable, and free
of problems (bugs).
If
its installing instructions should be complete, consequent, and placed
Post by Pertti Rönnberg
in one easy to find place
the program's every single detail should work -- functions, features,
Post by Pertti Rönnberg
processes at a level (e.g.) similar to MSAccess (2003) --the ability to
build decent reports included (and the embedded db-engine and its guides
up-dated and supported)
the guiding documentation (& help) should be logic, understandable and
Post by Pertti Rönnberg
in every detail correlating with the program
With the exception of heavy industrial systems the need and possibilities
of up to medium complex databases in everyday life at home are unlimited --
only limited by the decision to start creating.
There are really nothing difficult in creating such "home databases"-- no
need to be an "Einstein", if only good guidings are available. Creating
database applications is also a very interesting form of brain training --
and the feeling when succeeding is a "yippee". If you know how to use
Writer/Word and Calc/Excel (esp. as "databases") you are almost half way.
What you still has to do is to study and learn some few basic theories
about and how to create the tables and the queries(experiment manually, not
with wizards, if you want to learn and understand);creating the forms and
the reports is just a matter of following instructions.
If you want LibO to be a popular competitor to MSO (& MSAccess), then the
rest is only a question of marketing.
As far as I have experienced LibO-Base (v. 3.4.5), there are only a few
details left to fixed before LibO should be almost perfect.
About contributing
A basic rule in quality systems (ISO9000) is that if you want improvement
you must first identify the problems (faults, weaknesses) -- and then
follow up by a plan and an improving activity.
LibO might be a very fine and usable suit -- especially if also its Base
module (docs included) should work properly, at least as promised in
introductions.
Mr Dan Lewis is doing a good and valuable work when updating and
completing the Base's documentation and it is obvious that without any help
his project will take a long time.
Last winter I started to read and follow up experimenting Dan's docs with
the intension to send my comments as points of views. And hadquite a lot
already done.
At this list I several times also mentioned some quite basic
problems/faults both in Base's docs and especially in the modules's
features.
I never got any kind of response, I don' t know if my proposals were
noticed, nor do I know if the mentioned things have been fixed.
So I skipped working any further on experimenting LibO-Base and its docs.
(I am now back to OO and tries to learn MySQL)
You may take this as some sort of a contribution too.
Best regards
Pertti Rönnberg
Post by Pertti Rönnberg
Question: How many people do you know use Base, or have tried to use
Base?
Whilst there is some quite valid criticism of Base, I don't think answering
this question says as much about Base as it does about the general usage
of databases. They are less familiar than word processors, spreadsheets or
drawing packages.
Mark
--
Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
Posting guidelines + more: http://wiki.**documentfoundation.org/**
Netiquette <http://wiki.documentfoundation.org/Netiquette>
List archive: http://listarchives.**libreoffice.org/global/users/<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+***@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
Wolfgang Keller
2012-10-06 19:34:03 UTC
Permalink
Post by John Clegg
I am going to stick my head above the parapet and say it should have
an embedded database functionality that is secure and reliable.
Since recently, LO comes with a native driver for PostgreSQL. That's
probably the best thing that the LO developers have done for quite
some time. Since it makes LO Base actually useable *and a lot better*
than Access (which is unusable with PostgreSQL).
Post by John Clegg
That is an essential requirement for entry-level users that have only
ever used Access.
Reliability? As an essential requirement for Access users?

Huh?

Access is a pathological data shredder.

Sincerely,

Wolfgang
Andreas Säger
2012-10-06 19:54:16 UTC
Permalink
Post by Wolfgang Keller
Huh?
Access is a pathological data shredder.
Not as bad as Base's default type of database. This part of Base is not
even a valid proof-of-concept. The whole concept is dysfunctional by
design and nobody dares to stop this madness.
Just like MSAccess, Base is extremely useful as a frontend for database
engines. You must not use the built-in JET engine with Access. HSQL is
an excellent platform independent database engine but you must not embed
HSQL in extensions which are installed and repackaged every time you
"open" or "close" the so called "database document".
--
For unsubscribe instructions e-mail to: users+***@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
Wolfgang Keller
2012-10-07 18:45:45 UTC
Permalink
Post by Andreas Säger
Just like MSAccess, Base is extremely useful as a frontend for
database engines.
The last time I tried to run a non-trivial query (involving a join) from
Access against PostgreSQL, the result was a never-ending cursor
animation. It seems that Access fetches *all* records from the database
and runs the query locally.
Post by Andreas Säger
You must not use the built-in JET engine with Access. HSQL is an
excellent platform independent database engine but you must not embed
HSQL in extensions which are installed and repackaged every time you
"open" or "close" the so called "database document".
"Embedding" databases anywhere is imho nonsense. Database *content* can
imho be passed around between users in a pretty fool-proof way as a
zipped SQL dump, if required.

Sincerely,

Wolfgang
Ferry Toth
2012-10-09 21:01:29 UTC
Permalink
I agree.

I use it at the office for time registration and invoicing. At home for
the Taekwon-do club membership.

It's actually marvelous in combination with postgresql SDBC driver. And
actually useful as it is so easy to get your data to Calc, more useful
then I remember Access.

It always hurts a bit when people who don't use databases say that Base
is not good, databases are not useful etc.

I know a lot of people that never use a spreadsheet either. But I think
LO wouldn't be complete with Calc or Base.

My experience: de builtin hsql backend was very slow last time I tried,
sqlite unusefull, mysql OK but I couldn't find anything like PG Admin to
administer it.

So, if you have the choice, go for postgresql.

Ferry
Post by Wolfgang Keller
Post by John Clegg
I am going to stick my head above the parapet and say it should have
an embedded database functionality that is secure and reliable.
Since recently, LO comes with a native driver for PostgreSQL. That's
probably the best thing that the LO developers have done for quite
some time. Since it makes LO Base actually useable *and a lot better*
than Access (which is unusable with PostgreSQL).
Post by John Clegg
That is an essential requirement for entry-level users that have only
ever used Access.
Reliability? As an essential requirement for Access users?
Huh?
Access is a pathological data shredder.
Sincerely,
Wolfgang
--
For unsubscribe instructions e-mail to: users+***@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
Jay Lozier
2012-10-09 21:19:24 UTC
Permalink
Post by Ferry Toth
I agree.
I use it at the office for time registration and invoicing. At home for
the Taekwon-do club membership.
It's actually marvelous in combination with postgresql SDBC driver. And
actually useful as it is so easy to get your data to Calc, more useful
then I remember Access.
It always hurts a bit when people who don't use databases say that Base
is not good, databases are not useful etc.
I know a lot of people that never use a spreadsheet either. But I think
LO wouldn't be complete with Calc or Base.
My experience: de builtin hsql backend was very slow last time I tried,
sqlite unusefull, mysql OK but I couldn't find anything like PG Admin to
administer it.
mysql workbench (available from Oracle) works well with MySQL/MariaDB
Post by Ferry Toth
So, if you have the choice, go for postgresql.
Ferry
Post by Wolfgang Keller
Post by John Clegg
I am going to stick my head above the parapet and say it should have
an embedded database functionality that is secure and reliable.
Since recently, LO comes with a native driver for PostgreSQL. That's
probably the best thing that the LO developers have done for quite
some time. Since it makes LO Base actually useable *and a lot better*
than Access (which is unusable with PostgreSQL).
Post by John Clegg
That is an essential requirement for entry-level users that have only
ever used Access.
Reliability? As an essential requirement for Access users?
Huh?
Access is a pathological data shredder.
Sincerely,
Wolfgang
--
Jay Lozier
***@gmail.com
--
For unsubscribe instructions e-mail to: users+***@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
webmaster-Kracked_P_P
2012-10-09 23:02:41 UTC
Permalink
Back in my Mainframe days, I had to write a General Ledger Accounting
system in COBOL [not my choice] with a "master" database file[s] used
for more than just accounting. If anyone wants to choose to say
packages like Base is not good or some other negative term, ask them to
try and write the database package from scratch with programming
languages that are not designed to be a "flexible" as the modern
object-oriented languages.

I have not used Access since 2000 or 2003, so I have not used Base,
except to try it once and awhile.

To be honest, one reason why we do not have much Base documentation is
the simple fact that there are not as many people out there that know
Base well enough and can write documentation. It is much easier to find
Writer and Calc documentation, since more people use it and understand
it better than Base. That does not mean that Base is not a good
package, just one that it not used as in-dept by as many people as the
other parts of LO.
Post by Ferry Toth
I agree.
I use it at the office for time registration and invoicing. At home for
the Taekwon-do club membership.
It's actually marvelous in combination with postgresql SDBC driver. And
actually useful as it is so easy to get your data to Calc, more useful
then I remember Access.
It always hurts a bit when people who don't use databases say that Base
is not good, databases are not useful etc.
I know a lot of people that never use a spreadsheet either. But I think
LO wouldn't be complete with Calc or Base.
My experience: de builtin hsql backend was very slow last time I tried,
sqlite unusefull, mysql OK but I couldn't find anything like PG Admin to
administer it.
So, if you have the choice, go for postgresql.
Ferry
Post by Wolfgang Keller
Post by John Clegg
I am going to stick my head above the parapet and say it should have
an embedded database functionality that is secure and reliable.
Since recently, LO comes with a native driver for PostgreSQL. That's
probably the best thing that the LO developers have done for quite
some time. Since it makes LO Base actually useable *and a lot better*
than Access (which is unusable with PostgreSQL).
Post by John Clegg
That is an essential requirement for entry-level users that have only
ever used Access.
Reliability? As an essential requirement for Access users?
Huh?
Access is a pathological data shredder.
Sincerely,
Wolfgang
--
For unsubscribe instructions e-mail to: users+***@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 thi
Wolfgang Keller
2012-10-04 17:35:06 UTC
Permalink
Is there any documentation for LibreOffice Base?
In german language, yes.

http://wiki.documentfoundation.org/images/d/d4/06_BH_Gesamtband_V35_einseitig.pdf

It's probably in the process of being translated.

Sincerely,

Wolfgang
Tom Davies
2012-10-04 13:01:21 UTC
Permalink
Hi :)
Thanks :)  I just added it to the list in the Publications page
https://wiki.documentfoundation.org/Documentation/Publications#Base
Regards from
Tom :) 
________________________________
Sent: Thursday, 4 October 2012, 13:09
Subject: [libreoffice-users] Re: documentation for LO base
http://www.scribd.com/doc/48635562/Base-Tutorial-OOo
--
View this message in context: http://nabble.documentfoundation.org/documentation-for-LO-base-tp4010907p4010986.html
Sent from the Users mailing list archive at Nabble.com.
--
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+***@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
Andreas Säger
2012-10-04 12:09:42 UTC
Permalink
The ultimate guide by Mariano Casanova:
http://www.scribd.com/doc/48635562/Base-Tutorial-OOo



--
View this message in context: http://nabble.documentfoundation.org/documentation-for-LO-base-tp4010907p4010986.html
Sent from the Users mailing list archive at Nabble.com.
Viral Orpe
2012-10-05 05:05:18 UTC
Permalink
Hi,

I am new to Open source *.* (OS, environment, office, Banshee, wvdial, the works....)

I recently moved my excel spread-sheets to calc.
I am still going through files/features-check post the translation.
Most of the data, formula, and formatting are okay, fonts are better.

In the charts I observed:
1. The full worksheet as chart in excel are converted to embedded charts in those sheets (no full charts).
2. Legends are peculiar. They are named as "column?" and not any text string that I would like to give.

Is this the way Libre Calc is implemented or I can get back to chart as worksheet in itself and legends of my
liking without being restricted to the first column/ first row?


Also, is the system info below sufficient for posting here or anything more is advised?


Any pointers would be great help.

Thanks,
Viral Orpe
----------------------------------------------------------
Processor             : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz
Memory                : 4GB, DDR3
Operating System    : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686)

LibreOffice Version    : LibreOffice 3.4.3  OOO340m1 (Build:302)
--
For unsubscribe instructions e-mail to: users+***@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
Viral Orpe
2012-10-07 05:54:08 UTC
Permalink
The following mail was sent about 10-days ago.
I picked the address from the e-mails I receive from other list-members.

Even I did not get it back through the list nor was it bounced from somewhere
hence sending again.

This is the last time.
Sorry for the trouble.

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


Hi,

I am new to Open source *.* (OS, environment, office, Banshee, wvdial, the works....)

I recently moved my excel spread-sheets to calc.
I am still going through files/features-check post the translation.
Most of the data, formula, and formatting are okay, fonts are better.

In the charts I observed:
1. The full worksheet as chart in excel are converted to embedded charts in those sheets (no full charts).
2. Legends are peculiar. They are named as "column?" and not any text string that I would like to give.

Is this the way Libre Calc is implemented or I can get back to chart as worksheet in itself and legends of my
liking without being restricted to the first column/ first row?


Also, is the system info below sufficient for posting here or anything more is advised?


Any pointers would be great help.

Thanks,
Viral Orpe
----------------------------------------------------------
Processor             : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz
Memory                : 4GB, DDR3
Operating System    : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686)

LibreOffice Version    : LibreOffice 3.4.3  OOO340m1 (Build:302)
--
For unsubscribe instructions e-mail to: users+***@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
Rolf Lochbühler
2012-10-07 10:22:33 UTC
Permalink
Post by Viral Orpe
1. The full worksheet as chart in excel are converted to embedded charts in those sheets (no full charts).
I don't think that feature is available in Calc.

However, you may move your chart (by cut and paste) onto a separate sheet, of course.
Post by Viral Orpe
2. Legends are peculiar. They are named as "column?" and not any text string that I would like to give.
That “Column ...” is shown only when you deselect “First row as label” but don't specify any other text as legend label.

To change the legend text in your chart, go to the “Data Series” dialog.

If not done already, switch chart into edit mode:
double click on chart

Then:
“Format” menu
→ “Data Ranges...”
→ “Data Series”

There you can for each data series select “Name” and then enter into the “Range for Name” field either
- a string in double quotes "like this" or
- a reference to a cell that has the text you want



-rl
--
For unsubscribe instructions e-mail to: users+***@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
rost52
2012-10-08 02:08:00 UTC
Permalink
In general I am of the impression that Calc and Excel have some limitations when converting from one
into the other. I recently also observered some problems with charts but had no time to write them
down, thus I don't remember details sufficiently to list them here. Just don't be surprised about
loss of functionality etc. I used LO 3.5.6.2 or the 3.4.5 release at that time on XP SP3.

A chart as one sheet is, like Rolf mentioned, not a feature of Calc - that is a pitty.

ROSt
Post by Viral Orpe
The following mail was sent about 10-days ago.
I picked the address from the e-mails I receive from other list-members.
Even I did not get it back through the list nor was it bounced from somewhere
hence sending again.
This is the last time.
Sorry for the trouble.
/* *************************************** */
Hi,
I am new to Open source *.* (OS, environment, office, Banshee, wvdial, the works....)
I recently moved my excel spread-sheets to calc.
I am still going through files/features-check post the translation.
Most of the data, formula, and formatting are okay, fonts are better.
1. The full worksheet as chart in excel are converted to embedded charts in those sheets (no full charts).
2. Legends are peculiar. They are named as "column?" and not any text string that I would like to give.
Is this the way Libre Calc is implemented or I can get back to chart as worksheet in itself and legends of my
liking without being restricted to the first column/ first row?
Also, is the system info below sufficient for posting here or anything more is advised?
Any pointers would be great help.
Thanks,
Viral Orpe
----------------------------------------------------------
Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz
Memory : 4GB, DDR3
Operating System : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686)
LibreOffice Version : LibreOffice 3.4.3 OOO340m1 (Build:302)
--
For unsubscribe instructions e-mail to: users+***@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
Steve Edmonds
2012-10-08 02:43:57 UTC
Permalink
Hi.
Post by rost52
In general I am of the impression that Calc and Excel have some
limitations when converting from one into the other. I recently also
observered some problems with charts but had no time to write them
down, thus I don't remember details sufficiently to list them here.
Just don't be surprised about loss of functionality etc. I used LO
3.5.6.2 or the 3.4.5 release at that time on XP SP3.
A chart as one sheet is, like Rolf mentioned, not a feature of Calc - that is a pitty.
ROSt
Post by Viral Orpe
The following mail was sent about 10-days ago.
I picked the address from the e-mails I receive from other list-members.
Even I did not get it back through the list nor was it bounced from somewhere
hence sending again.
This is the last time.
Sorry for the trouble.
/* *************************************** */
My mail is hosted by google, for some reason my posts to the list do not
show to me. Possibly something to do with the way google labels mail
(some logic like it's in my sent box so why put it in my inbox also when
the list sends it back). I just have to assume if mail to the list is
not rejected it must have got there.
Steve
Post by rost52
Post by Viral Orpe
Hi,
I am new to Open source *.* (OS, environment, office, Banshee, wvdial, the works....)
I recently moved my excel spread-sheets to calc.
I am still going through files/features-check post the translation.
Most of the data, formula, and formatting are okay, fonts are better.
1. The full worksheet as chart in excel are converted to embedded
charts in those sheets (no full charts).
2. Legends are peculiar. They are named as "column?" and not any text
string that I would like to give.
Is this the way Libre Calc is implemented or I can get back to chart
as worksheet in itself and legends of my
liking without being restricted to the first column/ first row?
Also, is the system info below sufficient for posting here or
anything more is advised?
Any pointers would be great help.
Thanks,
Viral Orpe
----------------------------------------------------------
Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz
Memory : 4GB, DDR3
Operating System : Linux Mint 12 Lisa - Kernel Linux
3.0.0-13-generic (i686)
LibreOffice Version : LibreOffice 3.4.3 OOO340m1 (Build:302)
--
For unsubscribe instructions e-mail to: users+***@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
Tom Davies
2012-10-08 10:20:13 UTC
Permalink
Hi :)
Perhaps Viral Orpe is not properly subscribed to the list?  Perhaps he/she used a different email account that is supposed to filter mails through to the main one he/she uses? 

When you subscribe to these lists there are a few options you can choose.  One is for the list to cleverly NOT to send you emails that you sent from your own address.  you already know what is in the email and it's in your out-box so why would you want a duplicate copy?  That is the thinking anyway.  You can change that setting but i'm not completely sure where the instructions are.  Happy hunting! 
Apols and regards from
Tom :) 


--- On Mon, 8/10/12, Steve Edmonds <***@ptglobal.com> wrote:

From: Steve Edmonds <***@ptglobal.com>
Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features
To: "rost52" <***@online.de>
Cc: ***@global.libreoffice.org
Date: Monday, 8 October, 2012, 3:43

Hi.
In general I am of the impression that Calc and Excel have some limitations when converting from one into the other. I recently also observed some problems with charts but had no time to write them down, thus I don't remember details sufficiently to list them here. Just don't be surprised about loss of functionality etc.  I used LO 3.5.6.2 or the 3.4.5 release at that time on XP SP3.
A chart as one sheet is, like Rolf mentioned, not a feature of Calc - that is a pitty.
ROSt
Post by Viral Orpe
The following mail was sent about 10-days ago.
I picked the address from the e-mails I receive from other list-members.
Even I did not get it back through the list nor was it bounced from somewhere
hence sending again.
This is the last time.
Sorry for the trouble.
/* *************************************** */
My mail is hosted by google, for some reason my posts to the list do not show to me. Possibly something to do with the way google labels mail (some logic like it's in my sent box so why put it in my inbox also when the list sends it back). I just have to assume if mail to the list is not rejected it must have got there.
Steve
Post by Viral Orpe
Hi,
I am new to Open source *.* (OS, environment, office, Banshee, wvdial, the works....)
I recently moved my excel spread-sheets to calc.
I am still going through files/features-check post the translation.
Most of the data, formula, and formatting are okay, fonts are better.
1. The full worksheet as chart in excel are converted to embedded charts in those sheets (no full charts).
2. Legends are peculiar. They are named as "column?" and not any text string that I would like to give.
Is this the way Libre Calc is implemented or I can get back to chart as worksheet in itself and legends of my
liking without being restricted to the first column/ first row?
Also, is the system info below sufficient for posting here or anything more is advised?
Any pointers would be great help.
Thanks,
Viral Orpe
----------------------------------------------------------
Processor             : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz
Memory                : 4GB, DDR3
Operating System    : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686)
LibreOffice Version    : LibreOffice 3.4.3  OOO340m1 (Build:302)
-- For unsubscribe instructions e-mail to: users+***@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+***@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
Viral Orpe
2012-10-09 17:52:42 UTC
Permalink
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+***@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
MiguelAngel
2012-10-09 18:47:04 UTC
Permalink
Post by Viral Orpe
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 <<<<<<<<<<<<<<
Have you tried to overlap several charts with different types?. I think
this is possible if you set for each, the background of the the graphics
area, as 100% transparent. Even more, you can use the result of the
cells below the chart as part of it.
Miguel Ángel.
--
For unsubscribe instructions e-mail to: users+***@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
Dan Lewis
2012-10-09 20:01:18 UTC
Permalink
Post by MiguelAngel
Post by Viral Orpe
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 <<<<<<<<<<<<<<
Have you tried to overlap several charts with different types?. I
think this is possible if you set for each, the background of the the
graphics area, as 100% transparent. Even more, you can use the result
of the cells below the chart as part of it.
Miguel Ángel.
I am not acquainted with a candlestick chart. Is it perhaps a bar
graph?
I am also wondering why a database is not used for this? Queries
can be created to manipulate the data which can then be linked to a Calc
spreadsheet. Then the charts can be created for this. This is likely to
take some detailed planning, but it might be worth it.

--Dan
--
For unsubscribe instructions e-mail to: users+***@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
Steve Edmonds
2012-10-09 20:10:23 UTC
Permalink
Post by Viral Orpe
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)
_____________________
I once used a charting program (chartmaster) that allowed adding of
series once the chart was first defined. Each time you added a series
you could define the presentation (line, bar, x-y, scatter).
This way a chart could be made up of as many types as desired. If you
wanted a straight line across your chart you just defined a 2 point xy
series as line type.
You could add series from different columns and different files. This
was a proper charting program and not a graphical representation of some
selected spreadsheet data.
Steve
--
For unsubscribe instructions e-mail to: users+***@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
rost52
2012-10-10 01:32:56 UTC
Permalink
Could you possibly post somewhere an example of a candle stick chart?
Post by Viral Orpe
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+***@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
Tom Davies
2012-10-10 08:16:13 UTC
Permalink
Hi :)
I assumed he meant a bar-graph but made it sound more interesting.
Regards from
Tom :) 


--- On Wed, 10/10/12, rost52 <***@online.de> wrote:

From: rost52 <***@online.de>
Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features
To: ***@global.libreoffice.org
Date: Wednesday, 10 October, 2012, 2:32

Could you possibly post somewhere an example of a candle stick chart?
Post by Viral Orpe
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+***@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+***@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
Viral Orpe
2012-10-10 12:10:53 UTC
Permalink
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 <***@yahoo.co.uk>
To: ***@global.libreoffice.org; rost52 <***@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 <***@online.de> wrote:

From: rost52 <***@online.de>
Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features
To: ***@global.libreoffice.org
Date: Wednesday, 10 October, 2012, 2:32

Could you possibly post somewhere an example of a candle stick chart?
Post by Viral Orpe
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+***@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+***@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+***@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
rost52
2012-10-10 12:31:05 UTC
Permalink
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.
Post by Viral Orpe
Hi :)
Thanks for all the responses....
I have tried to respond collectively here.
/* ******************** */
============
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.
===
-----------------------------
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.
=============
--------------------------------
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.
====
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)
---------------------------------------------------------------------------------------------------
________________________________
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 :)
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?
Post by Viral Orpe
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+***@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
Viral Orpe
2012-10-10 12:59:42 UTC
Permalink
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 <***@online.de>
To: ***@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.
Post by Viral Orpe
Hi :)
Thanks for all the responses....
I have tried to respond collectively here.
/* ******************** */
============
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.
===
-----------------------------
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.
=============
--------------------------------
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.
====
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)
---------------------------------------------------------------------------------------------------
________________________________
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 :)
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?
Post by Viral Orpe
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+***@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+***@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
Viral Orpe
2012-10-10 15:48:56 UTC
Permalink
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 <***@yahoo.com>
To: "***@global.libreoffice.org" <***@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 <***@online.de>
To: ***@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.
Post by Viral Orpe
Hi :)
Thanks for all the responses....
I have tried to respond collectively here.
/* ******************** */
============
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.
===
-----------------------------
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.
=============
--------------------------------
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.
====
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)
---------------------------------------------------------------------------------------------------
________________________________
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 :)
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?
Post by Viral Orpe
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+***@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+***@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+***@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
Viral Orpe
2012-10-10 16:58:04 UTC
Permalink
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 <***@yahoo.com>
To: "***@global.libreoffice.org" <***@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 <***@yahoo.com>
To: "***@global.libreoffice.org" <***@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 <***@online.de>
To: ***@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.
Post by Viral Orpe
Hi :)
Thanks for all the responses....
I have tried to respond collectively here.
/* ******************** */
============
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.
===
-----------------------------
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.
=============
--------------------------------
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.
====
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)
---------------------------------------------------------------------------------------------------
________________________________
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 :)
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?
Post by Viral Orpe
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+***@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+***@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+***@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+***@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
Tom Davies
2012-10-11 05:26:32 UTC
Permalink
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 <***@yahoo.com> wrote:

From: Viral Orpe <***@yahoo.com>
Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features
To: "***@global.libreoffice.org" <***@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 <***@yahoo.com>
To: "***@global.libreoffice.org" <***@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 <***@yahoo.com>
To: "***@global.libreoffice.org" <***@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 <***@online.de>
To: ***@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.
Post by Viral Orpe
Hi :)
Thanks for all the responses....
I have tried to respond collectively here.
/* ******************** */
============
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.
===
-----------------------------
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.
=============
--------------------------------
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.
====
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)
---------------------------------------------------------------------------------------------------
________________________________
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 :)
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?
Post by Viral Orpe
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+***@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+***@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+***@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+***@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+***@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
Viral Orpe
2012-10-11 10:33:55 UTC
Permalink
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 <***@yahoo.co.uk>
To: "***@global.libreoffice.org" <***@global.libreoffice.org>; 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 :) 
Post by Tom Davies
Subject: Re: [libreoffice-users] Fw: Help request
on CALC charts' features
Post by Tom Davies
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.
Post by Tom Davies
 
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)
---------------------------------------------------------------------------------------------------
________________________________
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)
Post by Tom Davies
---------------------------------------------------------------------------------------------------
________________________________
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.
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.
Post by Tom Davies
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)
Post by Tom Davies
---------------------------------------------------------------------------------------------------
________________________________
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.
Post by Viral Orpe
Hi :)
Thanks for all the responses....
I have tried
to respond collectively here.
Post by Tom Davies
Post by Viral Orpe
/* ******************** */
============
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.
===
-----------------------------
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)
Post by Tom Davies
Post by Viral Orpe
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.
=============
--------------------------------
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.
Post by Tom Davies
Post by Viral Orpe
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.
====
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)
---------------------------------------------------------------------------------------------------
Post by Tom Davies
Post by Viral Orpe
________________________________
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 :)
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?
Post by Viral Orpe
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.
Post by Tom Davies
Post by Viral Orpe
Post by Viral Orpe
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 <<<<<<<<<<<<<<
--
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
--
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
--
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
--
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+***@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
Tom Davies
2012-10-11 12:28:06 UTC
Permalink
Hi :)
The LSE had the 'bright idea' of switching from their rock-solid highly-scalable unix-based Linux servers to MS servers.  After years of planning and heavy investment they flicked the switch to change everything over to Windows and all the machines in the building just died.  It took a whole day for the to fix it and get back to Linux.  The credit crunch happened soon after.  Oddly it didn't reach the mainstream news much. 

Apparently around 60-80% of stock exchanges run on Linux, around 20% on Bsd (not mac) and most of the remaining are also unix-based with less than 1% on Windows.  It's just not stable enough.  It's ok to have a few viruses and inconvenient updates and a forced reboot on desktops so that is where Windows really scores. 
Regards from
Tom :) 
________________________________
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)
---------------------------------------------------------------------------------------------------
________________________________
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 :) 
Post by Tom Davies
Subject: Re: [libreoffice-users] Fw: Help request
on CALC charts' features
Post by Tom Davies
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.
Post by Tom Davies
 
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)
---------------------------------------------------------------------------------------------------
________________________________
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)
Post by Tom Davies
---------------------------------------------------------------------------------------------------
________________________________
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.
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.
Post by Tom Davies
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)
Post by Tom Davies
---------------------------------------------------------------------------------------------------
________________________________
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.
Post by Viral Orpe
Hi :)
Thanks for all the responses....
I have tried
to respond collectively here.
Post by Tom Davies
Post by Viral Orpe
/* ******************** */
============
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.
===
-----------------------------
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)
Post by Tom Davies
Post by Viral Orpe
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.
=============
--------------------------------
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.
Post by Tom Davies
Post by Viral Orpe
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.
====
The chartmaster software - was it open-source?
May be I should search for similar charting software in open source
domain.
Post by Tom Davies
Post by Viral Orpe
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)
---------------------------------------------------------------------------------------------------
Post by Tom Davies
Post by Viral Orpe
________________________________
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 :)
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?
Post by Viral Orpe
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.
Post by Tom Davies
Post by Viral Orpe
Post by Viral Orpe
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 <<<<<<<<<<<<<<
--
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
--
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
--
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
--
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
--
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+***@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
rost52
2012-10-11 12:39:50 UTC
Permalink
Tom, interesting information about the usage of MS at stock-exchange operations

Viral, I don't recall if it was mentioned or not but did you ever consider to use base to collect
the data, run queries and do calculations and get all displayed in report based charts.
Hi :)
The LSE had the 'bright idea' of switching from their rock-solid highly-scalable unix-based Linux servers to MS servers. After years of planning and heavy investment they flicked the switch to change everything over to Windows and all the machines in the building just died. It took a whole day for the to fix it and get back to Linux. The credit crunch happened soon after. Oddly it didn't reach the mainstream news much.
Apparently around 60-80% of stock exchanges run on Linux, around 20% on Bsd (not mac) and most of the remaining are also unix-based with less than 1% on Windows. It's just not stable enough. It's ok to have a few viruses and inconvenient updates and a forced reboot on desktops so that is where Windows really scores.
Regards from
Tom :)
________________________________
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)
---------------------------------------------------------------------------------------------------
________________________________
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 :)
Post by Tom Davies
Subject: Re: [libreoffice-users] Fw: Help request
on CALC charts' features
Post by Tom Davies
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.
Post by Tom Davies
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)
---------------------------------------------------------------------------------------------------
________________________________
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)
Post by Tom Davies
---------------------------------------------------------------------------------------------------
________________________________
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.
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.
Post by Tom Davies
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)
Post by Tom Davies
---------------------------------------------------------------------------------------------------
________________________________
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.
Post by Viral Orpe
Hi :)
Thanks for all the responses....
I have tried
to respond collectively here.
Post by Tom Davies
Post by Viral Orpe
/* ******************** */
============
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.
===
-----------------------------
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)
Post by Tom Davies
Post by Viral Orpe
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.
=============
--------------------------------
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.
Post by Tom Davies
Post by Viral Orpe
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.
====
The chartmaster software - was it open-source?
May be I should search for similar charting software in open source
domain.
Post by Tom Davies
Post by Viral Orpe
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)
---------------------------------------------------------------------------------------------------
Post by Tom Davies
Post by Viral Orpe
________________________________
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 :)
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?
Post by Viral Orpe
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.
Post by Tom Davies
Post by Viral Orpe
Post by Viral Orpe
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 <<<<<<<<<<<<<<
--
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
--
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
--
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
--
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
--
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+***@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
Tom Davies
2012-10-11 14:31:25 UTC
Permalink
Hi :)
That was rumour&gossip about the LSE, not information as such and i can't verify it right now.  I should make some effort to look it up rather than claim it as fact which it clearly isn't.  Usually i put disclaimers in every unverifiable statement, such as "allegedly" or "apparently" or some-such. 

I had mentioned about using Base as a front-end directly reading the data from the Indian Exchange's site and also suggested looking into using a MySql / MariaDb as an intermediary to pull in the data to somewhere local.  I have no idea how to do either of those things!!  Viral Orpe seems to take such vague hints and makes something useful so i was wondering whether he would get back to us about how he did it before Alex, Jay or Andreas managed to give him some better ideas or detail. 
Regards from
Tom :) 
________________________________
Sent: Thursday, 11 October 2012, 13:39
Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features
Tom, interesting information about the usage of MS at stock-exchange operations
Viral, I don't recall if it was mentioned or not but did you ever consider to use base to collect
the data, run queries and do calculations and get all displayed in report based charts.
Post by Tom Davies
Hi :)
The LSE had the 'bright idea' of switching from their rock-solid highly-scalable unix-based Linux servers to MS servers.  After years of planning and heavy investment they flicked the switch to change everything over to Windows and all the machines in the building just died.  It took a whole day for the to fix it and get back to Linux.  The credit crunch happened soon after.  Oddly it didn't reach the mainstream news much.
Apparently around 60-80% of stock exchanges run on Linux, around 20% on Bsd (not mac) and most of the remaining are also unix-based with less than 1% on Windows.  It's just not stable enough.  It's ok to have a few viruses and inconvenient updates and a forced reboot on desktops so that is where Windows really scores.
Regards from
Tom :)
________________________________
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)
---------------------------------------------------------------------------------------------------
________________________________
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 :)
Post by Tom Davies
Subject: Re: [libreoffice-users] Fw: Help request
on CALC charts' features
Post by Tom Davies
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.
Post by Tom Davies
 
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)
---------------------------------------------------------------------------------------------------
________________________________
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)
Post by Tom Davies
---------------------------------------------------------------------------------------------------
________________________________
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.
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.
Post by Tom Davies
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)
Post by Tom Davies
---------------------------------------------------------------------------------------------------
________________________________
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.
Post by Viral Orpe
Hi :)
Thanks for all the responses....
I have tried
to respond collectively here.
Post by Tom Davies
Post by Viral Orpe
/* ******************** */
============
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.
===
-----------------------------
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)
Post by Tom Davies
Post by Viral Orpe
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.
=============
--------------------------------
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.
Post by Tom Davies
Post by Viral Orpe
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.
====
The chartmaster software - was it open-source?
May be I should search for similar charting software in open source
domain.
Post by Tom Davies
Post by Viral Orpe
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)
---------------------------------------------------------------------------------------------------
Post by Tom Davies
Post by Viral Orpe
________________________________
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 :)
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?
Post by Viral Orpe
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.
Post by Tom Davies
Post by Viral Orpe
Post by Viral Orpe
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 <<<<<<<<<<<<<<
--
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
--
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
--
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
--
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
--
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
--
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+***@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
Felmon Davis
2012-10-11 20:19:07 UTC
Permalink
Post by Tom Davies
Hi :)
That was rumour&gossip about the LSE, not information as such and i
can't verify it right now.  I should make some effort to look it up
rather than claim it as fact which it clearly isn't.  Usually i put
disclaimers in every unverifiable statement, such as "allegedly" or
"apparently" or some-such. 
wow, grasshopper, your google-fu these days is weak!

for instance:
<http://www.zdnet.com/blog/open-source/the-london-stock-exchange-moves-to-novell-linux/8285>

fair use quote:
----------
September 8th 2008 was one of the worst days ever for the London Stock
Exchange (LSE), and high-end Windows server-based applications. That
was the day that the LSE came to a crashing stop. What happened? While
the LSE has never come clean on the whole story, my sources told me
that the LSE's Windows-based .NET TradElec stock exchange had crashed.
What we do know is that the CEO who had brought Windows and TradElec
in was fired, TradElec was dumped, and a Novell SUSE Linux-based
platform was brought in to replace it.

Today, February 14th, the LSE's Linux-based Millennium Exchange took
over and everything just worked. It did take longer to switch to Linux
than expected, because of what the LSW first called "sabotage" but
later put down to "human error" in late 2010. On its first day, out
LSE ran like a charm.
---------
Post by Tom Davies
________________________________
Sent: Thursday, 11 October 2012, 13:39
Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features
Tom, interesting information about the usage of MS at stock-exchange operations
[...]
--
Felmon Davis

Every silver lining has a cloud around it.
--
For unsubscribe instructions e-mail to: users+***@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
Tom Davies
2012-10-11 20:42:28 UTC
Permalink
Hi :)
Superb!!  Thanks Felmon :)  again :)

SUSE are a supporter of LO right?  They even supply paid dev time to the project and chosen at least one superb person that has put far more in than he gets paid for. 

I guess next test is finding the reliable graphs of various stats  about the worlds top 500 super-computers = such as which OSes they run. 

Regards from
Tom :) 


--- On Thu, 11/10/12, Felmon Davis <***@union.edu> wrote:

From: Felmon Davis <***@union.edu>
Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features
To: ***@global.libreoffice.org
Date: Thursday, 11 October, 2012, 21:19
Post by Tom Davies
Hi :)
That was rumour&gossip about the LSE, not information as such and i can't verify it right now.  I should make some effort to look it up rather than claim it as fact which it clearly isn't.  Usually i put disclaimers in every unverifiable statement, such as "allegedly" or "apparently" or some-such. 
wow, grasshopper, your google-fu these days is weak!

for instance:
<http://www.zdnet.com/blog/open-source/the-london-stock-exchange-moves-to-novell-linux/8285>

fair use quote:
----------
September 8th 2008 was one of the worst days ever for the London Stock Exchange (LSE), and high-end Windows server-based applications. That was the day that the LSE came to a crashing stop. What happened? While the LSE has never come clean on the whole story, my sources told me that the LSE's Windows-based .NET TradElec stock exchange had crashed. What we do know is that the CEO who had brought Windows and TradElec in was fired, TradElec was dumped, and a Novell SUSE Linux-based platform was brought in to replace it.

Today, February 14th, the LSE's Linux-based Millennium Exchange took over and everything just worked. It did take longer to switch to Linux than expected, because of what the LSW first called "sabotage" but later put down to "human error" in late 2010. On its first day, out LSE ran like a charm. ---------
Post by Tom Davies
________________________________
Sent: Thursday, 11 October 2012, 13:39
Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features
Tom, interesting information about the usage of MS at stock-exchange operations
[...]
-- Felmon Davis

Every silver lining has a cloud around it.
-- For unsubscribe instructions e-mail to: users+***@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+***@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
Viral Orpe
2012-10-11 15:36:20 UTC
Permalink
Hi :)

Actually I do not have that much acquaintance with LO.

I moved from MS to G&L last week and had to immediately work on

spreadsheets - my bread and butter! Thanks to various inputs here,

I was able to get done something I just wished for soooooo looong.

I guess by base you mean the database that comes with LO.


Although I know nothing about databases what you are suggesting

is a complete solution to "what I do" right here within the LO suite!


*IF* I can link/"pipe" the various components of the suite, and get

most of the work done automatically with gr8 info-oozing charts :) that

will free me to explore other aspects of G&L - maintenance without

fear to begin with!


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

Tom, interesting information about the usage of MS at stock-exchange operations

Viral, I don't recall if it was mentioned or not but did you ever consider to use base to collect
the data, run queries and do calculations and get all displayed in report based charts.
Post by Tom Davies
Hi :)
The LSE had the 'bright idea' of switching from their rock-solid highly-scalable unix-based Linux servers to MS servers.  After years of planning and heavy investment they flicked the switch to change everything over to Windows and all the machines in the building just died.  It took a whole day for the to fix it and get back to Linux.  The credit crunch happened soon after.  Oddly it didn't reach the mainstream news much.
Apparently around 60-80% of stock exchanges run on Linux, around 20% on Bsd (not mac) and most of the remaining are also unix-based with less than 1% on Windows.  It's just not stable enough.  It's ok to have a few viruses and inconvenient updates and a forced reboot on desktops so that is where Windows really scores.
Regards from
Tom :)
________________________________
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)
---------------------------------------------------------------------------------------------------
________________________________
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 :)
Post by Tom Davies
Subject: Re: [libreoffice-users] Fw: Help request
on CALC charts' features
Post by Tom Davies
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.
Post by Tom Davies
 
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)
---------------------------------------------------------------------------------------------------
________________________________
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)
Post by Tom Davies
---------------------------------------------------------------------------------------------------
________________________________
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.
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.
Post by Tom Davies
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)
Post by Tom Davies
---------------------------------------------------------------------------------------------------
________________________________
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.
Post by Viral Orpe
Hi :)
Thanks for all the responses....
I have tried
to respond collectively here.
Post by Tom Davies
Post by Viral Orpe
/* ******************** */
============
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.
===
-----------------------------
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)
Post by Tom Davies
Post by Viral Orpe
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.
=============
--------------------------------
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.
Post by Tom Davies
Post by Viral Orpe
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.
====
The chartmaster software - was it open-source?
May be I should search for similar charting software in open source
domain.
Post by Tom Davies
Post by Viral Orpe
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)
---------------------------------------------------------------------------------------------------
Post by Tom Davies
Post by Viral Orpe
________________________________
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 :)
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?
Post by Viral Orpe
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.
Post by Tom Davies
Post by Viral Orpe
Post by Viral Orpe
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 <<<<<<<<<<<<<<
--
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
--
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
--
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
--
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
--
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+***@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+***@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
Tom Davies
2012-10-11 12:36:06 UTC
Permalink
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 :) 
________________________________
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)
---------------------------------------------------------------------------------------------------
________________________________
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 :) 
Post by Tom Davies
Subject: Re: [libreoffice-users] Fw: Help request
on CALC charts' features
Post by Tom Davies
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.
Post by Tom Davies
 
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)
---------------------------------------------------------------------------------------------------
________________________________
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)
Post by Tom Davies
---------------------------------------------------------------------------------------------------
________________________________
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.
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.
Post by Tom Davies
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)
Post by Tom Davies
---------------------------------------------------------------------------------------------------
________________________________
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.
Post by Viral Orpe
Hi :)
Thanks for all the responses....
I have tried
to respond collectively here.
Post by Tom Davies
Post by Viral Orpe
/* ******************** */
============
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.
===
-----------------------------
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)
Post by Tom Davies
Post by Viral Orpe
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.
=============
--------------------------------
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.
Post by Tom Davies
Post by Viral Orpe
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.
====
The chartmaster software - was it open-source?
May be I should search for similar charting software in open source
domain.
Post by Tom Davies
Post by Viral Orpe
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)
---------------------------------------------------------------------------------------------------
Post by Tom Davies
Post by Viral Orpe
________________________________
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 :)
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?
Post by Viral Orpe
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.
Post by Tom Davies
Post by Viral Orpe
Post by Viral Orpe
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 <<<<<<<<<<<<<<
--
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
--
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
--
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
--
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
--
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+***@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
Viral Orpe
2012-10-11 16:05:15 UTC
Permalink
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 <***@yahoo.co.uk>
To: Viral Orpe <***@yahoo.com>; "***@global.libreoffice.org" <***@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 :) 
________________________________
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)
---------------------------------------------------------------------------------------------------
________________________________
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
Post by Tom Davies
Subject: Re: [libreoffice-users] Fw: Help request
on CALC charts' features
Post by Tom Davies
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.
Post by Tom Davies
* 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.
Post by Tom Davies
 
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)
---------------------------------------------------------------------------------------------------
________________________________
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
Post by Tom Davies
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)
Post by Tom Davies
---------------------------------------------------------------------------------------------------
________________________________
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.
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.
Post by Tom Davies
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
Post by Tom Davies
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)
Post by Tom Davies
---------------------------------------------------------------------------------------------------
________________________________
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.
Post by Viral Orpe
Hi
:)
Post by Tom Davies
Post by Viral Orpe
Thanks for all the responses....
I have tried
to respond collectively here.
Post by Tom Davies
Post by Viral Orpe
/* ******************** */
============
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 -
Post by Tom Davies
Post by Viral Orpe
first in gimp and then in calc.
Thanks a lot for your inputs.
===
-----------------------------
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)
Post by Tom Davies
Post by Viral Orpe
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.
=============
--------------------------------
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.
Post by Tom Davies
Post by Viral Orpe
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
Post by Tom Davies
Post by Viral Orpe
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.
Post by Tom Davies
Post by Viral Orpe
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 :)
---------------------------------------------------------------------------------------------------
Post by Tom Davies
Post by 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)
---------------------------------------------------------------------------------------------------
Post by Tom Davies
Post by Viral Orpe
________________________________
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 :)
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?
Post by Viral Orpe
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.
Post by Tom Davies
Post by Viral Orpe
Post by Viral Orpe
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 :)
Post by Tom Davies
Post by Viral Orpe
Post by Viral Orpe
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
Post by Tom Davies
Post by Viral Orpe
Post by Viral Orpe
professional team)
________________________________
snip <<<<<<<<<<<<<<
--
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
--
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
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
--
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
--
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+***@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 ar
Tom Davies
2012-10-11 16:24:24 UTC
Permalink
Hi :)

They might not be looking for it because they don't realise it's possible.  Once you have done it, if you do, then people might suddenly wonder why it's not already up there.  So copyright it if you can.  Creative Commons have some good licenses that might be appropriate.
http://creativecommons.org/
Regards from
Tom :) 
________________________________
Sent: Thursday, 11 October 2012, 17:05
Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features
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)
---------------------------------------------------------------------------------------------------
________________________________
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 :) 
________________________________
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)
---------------------------------------------------------------------------------------------------
________________________________
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
Post by Tom Davies
Subject: Re: [libreoffice-users] Fw: Help request
on CALC charts' features
Post by Tom Davies
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.
Post by Tom Davies
* 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.
Post by Tom Davies
 
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)
---------------------------------------------------------------------------------------------------
________________________________
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
Post by Tom Davies
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)
Post by Tom Davies
---------------------------------------------------------------------------------------------------
________________________________
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.
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.
Post by Tom Davies
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
Post by Tom Davies
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)
Post by Tom Davies
---------------------------------------------------------------------------------------------------
________________________________
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.
Post by Viral Orpe
Hi
:)
Post by Tom Davies
Post by Viral Orpe
Thanks for all the responses....
I have tried
to respond collectively here.
Post by Tom Davies
Post by Viral Orpe
/* ******************** */
============
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 -
Post by Tom Davies
Post by Viral Orpe
first in gimp and then in calc.
Thanks a lot for your inputs.
===
-----------------------------
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
Post by Tom Davies
Post by Viral Orpe
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)
Post by Tom Davies
Post by Viral Orpe
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.
=============
--------------------------------
Candlestick charting is a Japanese charting technique for stocks,
commodities,
Post by Tom Davies
Post by Viral Orpe
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.
Post by Tom Davies
Post by Viral Orpe
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
Post by Tom Davies
Post by Viral Orpe
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.
Post by Tom Davies
Post by Viral Orpe
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 :)
---------------------------------------------------------------------------------------------------
Post by Tom Davies
Post by 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)
---------------------------------------------------------------------------------------------------
Post by Tom Davies
Post by Viral Orpe
________________________________
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 :)
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?
Post by Viral Orpe
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.
Post by Tom Davies
Post by Viral Orpe
Post by Viral Orpe
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 :)
Post by Tom Davies
Post by Viral Orpe
Post by Viral Orpe
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
Post by Tom Davies
Post by Viral Orpe
Post by Viral Orpe
professional team)
________________________________
snip <<<<<<<<<<<<<<
--
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
--
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
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
--
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
--
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
 
--
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+***@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 publ
Tom Davies
2012-10-10 21:39:25 UTC
Permalink
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 <***@yahoo.com> wrote:

From: Viral Orpe <***@yahoo.com>
Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features
To: "***@global.libreoffice.org" <***@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 <***@yahoo.co.uk>
To: ***@global.libreoffice.org; rost52 <***@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 <***@online.de> wrote:

From: rost52 <***@online.de>
Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features
To: ***@global.libreoffice.org
Date: Wednesday, 10 October, 2012, 2:32

Could you possibly post somewhere an example of a candle stick chart?
Post by Viral Orpe
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+***@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+***@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+***@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+***@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
Tom Davies
2012-10-08 21:06:57 UTC
Permalink
Hi :)
I keep forgetting about this one even though i have added it to the Publications page
https://wiki.documentfoundation.org/Documentation/Publications
Regards from
Tom :)
________________________________
Sent: Thursday, 4 October 2012, 13:09
Subject: [libreoffice-users] Re: documentation for LO base
http://www.scribd.com/doc/48635562/Base-Tutorial-OOo
--
View this message in context: http://nabble.documentfoundation.org/documentation-for-LO-base-tp4010907p4010986.html
Sent from the Users mailing list archive at Nabble.com.
--
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+***@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
Dan Lewis
2012-10-04 03:06:04 UTC
Permalink
Is there any documentation for LibreOffice Base?
There is the beginning of the Base Guide available at
http://wiki.documentfoundation.org/Documentation/Publications.
Three chapters are presently available: Chapter 8 of the Getting Started
Guide as well as chapters 1 and 2 of the Base Guide. The last of these
is still in draft form. There is the LibreOffice FAQ which are at
http://wiki.documentfoundation.org/Faq.

--Dan
--
For unsubscribe instructions e-mail to: users+***@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
Ken Brucker
2012-10-04 00:41:14 UTC
Permalink
Is there any documentation for LibreOffice Base?
--
For unsubscribe instructions e-mail to: users+***@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
Hank Alper
2012-10-09 05:20:02 UTC
Permalink
Hi
I have found that a good source of documentation for LO base is found in
some of the
documentation written for OO Base. I've been using Marano Casanova's
excellent work
available at Base_tutorial.pdf (application/pdf
Object)<https://wiki.documentfoundation.org/images/0/02/Base_tutorial.pdf>.
Is there any documentation for LibreOffice Base?
--
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+***@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
Continue reading on narkive:
Loading...