documentation for LO base

users
#41

Hi rost52 :slight_smile:

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!!!:slight_smile:

Thanks,
Regards,
Viral Orpe :slight_smile:

#42

Hi :slight_smile:

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 :slight_smile:

#43

Hi :slight_smile:

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

* 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 :slight_smile:

#44

Hi :slight_smile:
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 :slight_smile:

#45

Hi :slight_smile:
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 :slight_smile:

#46

Hi Tom :slight_smile:

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 :slight_smile:

#47

Hi :slight_smile:
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 :slight_smile:

#48

Hi :slight_smile:
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 :slight_smile:

#49

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.

#50

Hi :slight_smile:
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 :slight_smile:

#51

Hi :slight_smile:

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 :slight_smile: that

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

fear to begin with!

Thanks,
Regards,
Viral Orpe :slight_smile:

#52

Hi Tom :slight_smile:

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 :slight_smile:
Thanks for the encouragement though.

And interesting read on the LSE!

Thanks,
Regards,
Viral Orpe :slight_smile:

#53

Hi :slight_smile:

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 :slight_smile:

#54

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:

#55

Hi :slight_smile:
Superb!!  Thanks Felmon :)  again :slight_smile:

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 :slight_smile:

#56

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

Should I perceive that as a threat? >;->

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.

In fact that's also the only application case that I would consider
using Calc and Writer for in their current state - for graphing and
printing database data.

Imho the most logical and least error-prone way to use Calc is to do
all your calculations in PostgreSQL and only display and graph the
results in Calc. *Never* do complex calculations in Calc.

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

Because they don't have a use for it (pure letter-writers for home-use)
or because they don't have a clue (most office users).

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

You mean withOUT, I presume?

Sincerely,

Wolfgang