Re: [libreoffice-users] Fw: Help request on CALC charts' features
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 wrote: From: Felmon Davis Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features To: users@global.libreoffice.org Date: Thursday, 11 October, 2012, 21:19 On Thu, 11 Oct 2012, Tom Davies wrote: > 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. - >> >> From: rost52 >> To: users@global.libreoffice.org >> 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+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Fw: Help request on CALC charts' features
On Thu, 11 Oct 2012, Tom Davies wrote: 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. - From: rost52 To: users@global.libreoffice.org 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+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Fw: Help request on CALC charts' features
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 :) > > From: Viral Orpe >To: "users@global.libreoffice.org" >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) >------- > > > >____________ >From: Tom Davies >To: Viral Orpe ; "users@global.libreoffice.org" > >Sent: Thursday, October 11, 2012 6:06 PM >Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features > > >Hi :) >The copyright notice is on >http://www.nseindia.com/copyright.htm >and says >"Copyright >Except as specifically permitted herein the Exchange is the >owner of copyright in all information featured on this website and no >portion of the information on this website may be reproduced on or >transmitted to or stored in any other website or in other form of >electronic retrieval system or by in any other form or by in any other >means. > >Visitors or users may view, print >copies in hard copy and download the information for personal, >non-commercial or educational purpose without in any way amending, >altering, deleting or modifying any part of the information and provided full >acknowledgement that the information originated from NSE's website is given in >the copy of the material. Contents may be displayed >provided successful linking to, redirection to NSE's website is >acknowledged. Information may be used for commercial purpose after >obtaining prior permission of the Exchange. Visitors or users must >inform third party that material may not be copied or reproduced in any >way. " > >So i think it's probably fine for you to use but just let people who access >the charts know where the data is from. If you are going to use the the >charts commercially then probably best to just let them know and ask >permission. Who knows, they might want you to put your charts on their >website! Not sure if they would pay you for it but if they do want your >charts then definitely ask for a decent salary! If they want to do it >themselves then perhaps neogtiate some sort of royalties. > >Goodl luck and regards from >Tom :) > > > > > > >> >> From: Viral Orpe >>To: "users@global.libreoffice.org" >>Sent: Thursday, 11 October 2012, 11:33 >>Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features >> >>Hi Tom :) >> >>Yahoo screen-shot was used as an example since Yahoo is omnipresent. >> >> >>You are most probably right about the yahoo data but I don't think they give >>out any data >> >>- just charts with the limited options that are on offer - chart type , data >>range, and a bouquet >> >>of indicators. >> >> >>I take my data from the Exchange itself - The National St
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) --- From: Tom Davies To: Viral Orpe ; "users@global.libreoffice.org" Sent: Thursday, October 11, 2012 6:06 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi :) The copyright notice is on http://www.nseindia.com/copyright.htm and says "Copyright Except as specifically permitted herein the Exchange is the owner of copyright in all information featured on this website and no portion of the information on this website may be reproduced on or transmitted to or stored in any other website or in other form of electronic retrieval system or by in any other form or by in any other means. Visitors or users may view, print copies in hard copy and download the information for personal, non-commercial or educational purpose without in any way amending, altering, deleting or modifying any part of the information and provided full acknowledgement that the information originated from NSE's website is given in the copy of the material. Contents may be displayed provided successful linking to, redirection to NSE's website is acknowledged. Information may be used for commercial purpose after obtaining prior permission of the Exchange. Visitors or users must inform third party that material may not be copied or reproduced in any way. " So i think it's probably fine for you to use but just let people who access the charts know where the data is from. If you are going to use the the charts commercially then probably best to just let them know and ask permission. Who knows, they might want you to put your charts on their website! Not sure if they would pay you for it but if they do want your charts then definitely ask for a decent salary! If they want to do it themselves then perhaps neogtiate some sort of royalties. Goodl luck and regards from Tom :) > > From: Viral Orpe >To: "users@global.libreoffice.org" >Sent: Thursday, 11 October 2012, 11:33 >Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features > >Hi Tom :) > >Yahoo screen-shot was used as an example since Yahoo is omnipresent. > > >You are most probably right about the yahoo data but I don't think they give >out any data > >- just charts with the limited options that are on offer - chart type , data >range, and a bouquet > >of indicators. > > >I take my data from the Exchange itself - The National Stock Exchange (NSE), >India. >And do my own calculations - in CALC - to extract some meaning out of it. > > >http://www.nseindia.com/index_nse.htm > > >Under the products tab one gets daily data called "Bhav-copy" (translates to >"Rate Sheet") > >Around 7 p.m. every evening they diligently load the day's activities in .csv >(which I use) > >and .dbf (? database) format which I just download in case one day I use a DB. >Some data is available only for the day and not for past days, that has to be >collected and stored >away before it gets overwritten the next day! > >I am worried that one day these exchanges will start asking for money for this >or older data. > >For example, a few years ago I think I could not get the London Metal >Exchange' historical >data for Copper, and Gold prices - to get a glimpse of what happened when in >the past. >I am collecting my stock exchanges daily data ever since!! > &
Re: [libreoffice-users] Fw: Help request on CALC charts' features
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 soo 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 To: users@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. On 11.10.2012 21:28, Tom Davies wrote: > 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 :) > > > > > > >> ____ >> From: Viral Orpe >> To: "users@global.libreoffice.org" >> Sent: Thursday, 11 October 2012, 11:33 >> Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features >> >> Hi Tom :) >> >> Yahoo screen-shot was used as an example since Yahoo is omnipresent. >> >> >> You are most probably right about the yahoo data but I don't think they give >> out any data >> >> - just charts with the limited options that are on offer - chart type , data >> range, and a bouquet >> >> of indicators. >> >> >> I take my data from the Exchange itself - The National Stock Exchange (NSE), >> India. >> And do my own calculations - in CALC - to extract some meaning out of it. >> >> >> http://www.nseindia.com/index_nse.htm >> >> >> Under the products tab one gets daily data called "Bhav-copy" (translates to >> "Rate Sheet") >> >> Around 7 p.m. every evening they diligently load the day's activities in >> .csv (which I use) >> >> and .dbf (? database) format which I just download in case one day I use a >> DB. >> Some data is available only for the day and not for past days, that has to >> be collected and stored >> away before it gets overwritten the next day! >> >> I am worried that one day these exchanges will start asking for money for >> this or older data. >> >> For example, a few years ago I think I could not get the London Metal >> Exchange' historical >> data for Copper, and Gold prices - to get a glimpse of what happened when in >> the past. >> I am collecting my stock exchanges daily data ever since!! >> >> >> Thanks for the concern though, >> Much appreciated, >> >> Regards, >> Viral Orpe :) >> --- >> Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz >> Memory : 4GB, DDR3 >> OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) >> >> >> LibreOffice :
Re: [libreoffice-users] Fw: Help request on CALC charts' features
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 :) > > From: rost52 >To: users@global.libreoffice.org >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. > > >On 11.10.2012 21:28, Tom Davies wrote: >> 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 :) >> >> >> >> >> >> >>> >>> From: Viral Orpe >>> To: "users@global.libreoffice.org" >>> Sent: Thursday, 11 October 2012, 11:33 >>> Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features >>> >>> Hi Tom :) >>> >>> Yahoo screen-shot was used as an example since Yahoo is omnipresent. >>> >>> >>> You are most probably right about the yahoo data but I don't think they >>> give out any data >>> >>> - just charts with the limited options that are on offer - chart type , >>> data range, and a bouquet >>> >>> of indicators. >>> >>> >>> I take my data from the Exchange itself - The National Stock Exchange >>> (NSE), India. >>> And do my own calculations - in CALC - to extract some meaning out of it. >>> >>> >>> http://www.nseindia.com/index_nse.htm >>> >>> >>> Under the products tab one gets daily data called "Bhav-copy" (translates >>> to "Rate Sheet") >>> >>> Around 7 p.m. every evening they diligently load the day's activities in >>> .csv (which I use) >>> >>> and .dbf (? database) format which I just download in case one day I use a >>> DB. >>> Some data is available only for the day and not for past days, that has to >>> be collected and stored >>> away before it gets overwritten the next day! >>> >>> I am worried that one day these exchanges will start asking for money for >>> this or older data. >>> >>> For example, a few years ago I think I could not get the London Metal >>> Exchange' historical >>> data for Copper, and Gold prices - to get a glimpse of what happened when >>> in the past. >>> I am collecting my stock exchanges daily data ever since!! >>> >>> >>> Thanks for the concern though, >>> Much appreciated, >>> >>> Regards, >>> Viral Orpe :) >>> --- >>> Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz >>> Memory : 4GB, DDR3 >>> OS : Linux Mint 12 Lisa - Kernel L
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. On 11.10.2012 21:28, Tom Davies wrote: 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 :) From: Viral Orpe To: "users@global.libreoffice.org" Sent: Thursday, 11 October 2012, 11:33 Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi Tom :) Yahoo screen-shot was used as an example since Yahoo is omnipresent. You are most probably right about the yahoo data but I don't think they give out any data - just charts with the limited options that are on offer - chart type , data range, and a bouquet of indicators. I take my data from the Exchange itself - The National Stock Exchange (NSE), India. And do my own calculations - in CALC - to extract some meaning out of it. http://www.nseindia.com/index_nse.htm Under the products tab one gets daily data called "Bhav-copy" (translates to "Rate Sheet") Around 7 p.m. every evening they diligently load the day's activities in .csv (which I use) and .dbf (? database) format which I just download in case one day I use a DB. Some data is available only for the day and not for past days, that has to be collected and stored away before it gets overwritten the next day! I am worried that one day these exchanges will start asking for money for this or older data. For example, a few years ago I think I could not get the London Metal Exchange' historical data for Copper, and Gold prices - to get a glimpse of what happened when in the past. I am collecting my stock exchanges daily data ever since!! Thanks for the concern though, Much appreciated, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS: Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: Tom Davies To: "users@global.libreoffice.org" ; Viral Orpe Sent: Thursday, October 11, 2012 10:56 AM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi :) Draw also has some sort of layers function but i'm not sure they are as easy to use as Gimp. Gimp is excellent but keeping the chart in LibreOffice increases the chance of keeping the information dynamic rather than as a series of static files. Lamp uses MySql (sadly i've not heard of anyone using the non-Oracle drop-in replacement called MariaDb) which is a database back-end. Could that pull in the data you use but do it automatically and dynamically rather than as snapshots? Base can supposedly read and present the data stored in MySql/MariaDb databases. Other modules, such as Writer, can use various "data sources", i think the F4 key. Can Draw? Can Base use the original data rather than trying to pull the data into a MySql databse? All that sounds like a complete nightmare to organise but i've already been very impressed with how fast you've managed to pick up new tools and get them doing something intriguingly unusual. Getting good-enough results fast is great. There might be a copyright issue with using Yahoo's data but presumably they get it their original data from a public source and then maybe do a few actions to the data to present it differently? Can you get to the original source and do your own set of calculations or do you have permission to use Yahoo;s info or is that not a concern at the moment? (prolly best NOT to answer those. It's just something to consider) Regards from Tom :) --- On Wed, 10/10/12, Viral Orpe wrote: From: Viral Orpe Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features To
Re: [libreoffice-users] Fw: Help request on CALC charts' features
Hi :) The copyright notice is on http://www.nseindia.com/copyright.htm and says "Copyright Except as specifically permitted herein the Exchange is the owner of copyright in all information featured on this website and no portion of the information on this website may be reproduced on or transmitted to or stored in any other website or in other form of electronic retrieval system or by in any other form or by in any other means. Visitors or users may view, print copies in hard copy and download the information for personal, non-commercial or educational purpose without in any way amending, altering, deleting or modifying any part of the information and provided full acknowledgement that the information originated from NSE's website is given in the copy of the material. Contents may be displayed provided successful linking to, redirection to NSE's website is acknowledged. Information may be used for commercial purpose after obtaining prior permission of the Exchange. Visitors or users must inform third party that material may not be copied or reproduced in any way. " So i think it's probably fine for you to use but just let people who access the charts know where the data is from. If you are going to use the the charts commercially then probably best to just let them know and ask permission. Who knows, they might want you to put your charts on their website! Not sure if they would pay you for it but if they do want your charts then definitely ask for a decent salary! If they want to do it themselves then perhaps neogtiate some sort of royalties. Goodl luck and regards from Tom :) > > From: Viral Orpe >To: "users@global.libreoffice.org" >Sent: Thursday, 11 October 2012, 11:33 >Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features > >Hi Tom :) > >Yahoo screen-shot was used as an example since Yahoo is omnipresent. > > >You are most probably right about the yahoo data but I don't think they give >out any data > >- just charts with the limited options that are on offer - chart type , data >range, and a bouquet > >of indicators. > > >I take my data from the Exchange itself - The National Stock Exchange (NSE), >India. >And do my own calculations - in CALC - to extract some meaning out of it. > > >http://www.nseindia.com/index_nse.htm > > >Under the products tab one gets daily data called "Bhav-copy" (translates to >"Rate Sheet") > >Around 7 p.m. every evening they diligently load the day's activities in .csv >(which I use) > >and .dbf (? database) format which I just download in case one day I use a DB. >Some data is available only for the day and not for past days, that has to be >collected and stored >away before it gets overwritten the next day! > >I am worried that one day these exchanges will start asking for money for this >or older data. > >For example, a few years ago I think I could not get the London Metal >Exchange' historical >data for Copper, and Gold prices - to get a glimpse of what happened when in >the past. >I am collecting my stock exchanges daily data ever since!! > > >Thanks for the concern though, >Much appreciated, > >Regards, >Viral Orpe :) >--- > >Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz >Memory : 4GB, DDR3 >OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) > > >LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) >--------------------------- > > > > >From: Tom Davies >To: "users@global.libreoffice.org" ; Viral Orpe > >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
Re: [libreoffice-users] Fw: Help request on CALC charts' features
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 :) > > From: Viral Orpe >To: "users@global.libreoffice.org" >Sent: Thursday, 11 October 2012, 11:33 >Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features > >Hi Tom :) > >Yahoo screen-shot was used as an example since Yahoo is omnipresent. > > >You are most probably right about the yahoo data but I don't think they give >out any data > >- just charts with the limited options that are on offer - chart type , data >range, and a bouquet > >of indicators. > > >I take my data from the Exchange itself - The National Stock Exchange (NSE), >India. >And do my own calculations - in CALC - to extract some meaning out of it. > > >http://www.nseindia.com/index_nse.htm > > >Under the products tab one gets daily data called "Bhav-copy" (translates to >"Rate Sheet") > >Around 7 p.m. every evening they diligently load the day's activities in .csv >(which I use) > >and .dbf (? database) format which I just download in case one day I use a DB. >Some data is available only for the day and not for past days, that has to be >collected and stored >away before it gets overwritten the next day! > >I am worried that one day these exchanges will start asking for money for this >or older data. > >For example, a few years ago I think I could not get the London Metal >Exchange' historical >data for Copper, and Gold prices - to get a glimpse of what happened when in >the past. >I am collecting my stock exchanges daily data ever since!! > > >Thanks for the concern though, >Much appreciated, > >Regards, >Viral Orpe :) >--- > >Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz >Memory : 4GB, DDR3 >OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) > > >LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) >--------------------------- > > > > >From: Tom Davies >To: "users@global.libreoffice.org" ; Viral Orpe > >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/1
Re: [libreoffice-users] Fw: Help request on CALC charts' features
Hi Tom :) Yahoo screen-shot was used as an example since Yahoo is omnipresent. You are most probably right about the yahoo data but I don't think they give out any data - just charts with the limited options that are on offer - chart type , data range, and a bouquet of indicators. I take my data from the Exchange itself - The National Stock Exchange (NSE), India. And do my own calculations - in CALC - to extract some meaning out of it. http://www.nseindia.com/index_nse.htm Under the products tab one gets daily data called "Bhav-copy" (translates to "Rate Sheet") Around 7 p.m. every evening they diligently load the day's activities in .csv (which I use) and .dbf (? database) format which I just download in case one day I use a DB. Some data is available only for the day and not for past days, that has to be collected and stored away before it gets overwritten the next day! I am worried that one day these exchanges will start asking for money for this or older data. For example, a few years ago I think I could not get the London Metal Exchange' historical data for Copper, and Gold prices - to get a glimpse of what happened when in the past. I am collecting my stock exchanges daily data ever since!! Thanks for the concern though, Much appreciated, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: Tom Davies To: "users@global.libreoffice.org" ; Viral Orpe Sent: Thursday, October 11, 2012 10:56 AM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi :) Draw also has some sort of layers function but i'm not sure they are as easy to use as Gimp. Gimp is excellent but keeping the chart in LibreOffice increases the chance of keeping the information dynamic rather than as a series of static files. Lamp uses MySql (sadly i've not heard of anyone using the non-Oracle drop-in replacement called MariaDb) which is a database back-end. Could that pull in the data you use but do it automatically and dynamically rather than as snapshots? Base can supposedly read and present the data stored in MySql/MariaDb databases. Other modules, such as Writer, can use various "data sources", i think the F4 key. Can Draw? Can Base use the original data rather than trying to pull the data into a MySql databse? All that sounds like a complete nightmare to organise but i've already been very impressed with how fast you've managed to pick up new tools and get them doing something intriguingly unusual. Getting good-enough results fast is great. There might be a copyright issue with using Yahoo's data but presumably they get it their original data from a public source and then maybe do a few actions to the data to present it differently? Can you get to the original source and do your own set of calculations or do you have permission to use Yahoo;s info or is that not a concern at the moment? (prolly best NOT to answer those. It's just something to consider) Regards from Tom :) --- On Wed, 10/10/12, Viral Orpe wrote: >From: Viral Orpe >Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features >To: "users@global.libreoffice.org" >Date: Wednesday, 10 October, 2012, 17:58 > > >Hi :) > >I was able to overlap two charts in gimp as well as calc. Hurrraa :) > >* 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
Re: [libreoffice-users] Fw: Help request on CALC charts' features
Hi :) Draw also has some sort of layers function but i'm not sure they are as easy to use as Gimp. Gimp is excellent but keeping the chart in LibreOffice increases the chance of keeping the information dynamic rather than as a series of static files. Lamp uses MySql (sadly i've not heard of anyone using the non-Oracle drop-in replacement called MariaDb) which is a database back-end. Could that pull in the data you use but do it automatically and dynamically rather than as snapshots? Base can supposedly read and present the data stored in MySql/MariaDb databases. Other modules, such as Writer, can use various "data sources", i think the F4 key. Can Draw? Can Base use the original data rather than trying to pull the data into a MySql databse? All that sounds like a complete nightmare to organise but i've already been very impressed with how fast you've managed to pick up new tools and get them doing something intriguingly unusual. Getting good-enough results fast is great. There might be a copyright issue with using Yahoo's data but presumably they get it their original data from a public source and then maybe do a few actions to the data to present it differently? Can you get to the original source and do your own set of calculations or do you have permission to use Yahoo;s info or is that not a concern at the moment? (prolly best NOT to answer those. It's just something to consider) Regards from Tom :) --- On Wed, 10/10/12, Viral Orpe wrote: From: Viral Orpe Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features To: "users@global.libreoffice.org" Date: Wednesday, 10 October, 2012, 17:58 Hi :) I was able to overlap two charts in gimp as well as calc. Hurrraa :) * 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 To: "users@global.libreoffice.org" Sent: Wednesday, October 10, 2012 9:18 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi :) I have added the Yahoo finance image illustrating the overlap of the basic candlestick chart and line chart and bar chart to my facebook page. Album: LibreCALC_Query File: z.png Hope that clarifies. Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: Viral Orpe To: "users@global.libreoffice.org" Sent: Wednesday, October 10, 2012 6:29 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi rost52 :) Yes, That's right. That is the one I am using. Problem is: I want to add some indicators on it too. Like say the average of the past 3 months - which will be a line chart. I have uploaded two screenshots (.png) of the file I am using on my facebook page. They are made "public" under the album "Libre_CALC_Query" I don't use fb often so if you find any trouble downloading them please do not fight with FB. Just let me know. In all probability it will be some mistake from my side. I might make it three screen-shots with one example from yahoo finance in a couple of hours. Got to move out of this chair now!!!:) Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory
Re: [libreoffice-users] Fw: Help request on CALC charts' features
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 wrote: From: Viral Orpe Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features To: "users@global.libreoffice.org" Date: Wednesday, 10 October, 2012, 13:10 Hi :) Thanks for all the responses I have tried to respond collectively here. /* */ Miguel Ángel: About overlapping several charts --- I got similar idea but not overlapping in calc itself but using gimp. I came across gimp some time last week and it had some concept like layers. I have added a transparent layer and copied two charts - with same axis scales, ranges - on each layer. I am not very conversant with gimp though so right now I can only jump from one layer to another and see two charts one-by-one. My charts themselves have opaque background so transparency of layers is not helping. Still a work in progress, I must say. Will keep you posted once I get what I need - first in gimp and then in calc. Thanks a lot for your inputs. Dan: === About using Databases: - Thanks Dan, you are absolutely right about wondering why not databases?! I was thinking the best way to do what I do is using LAMP - particularly since I have to ultimately work on data that is 245 days/year, 12 years till now, 1000+ entries everyday, each entry has say 8-10 sub-entries and at least two such sets of data! (Equity, derivatives, & Commodity) (365 - 52x2weekends - 16 holidays = 245 days/year!) But this is my first week with Linux! I can't possibly get into MySQL and hope to get it rightly done without crashing my system a thousand times. Right now, I have this one machine working. I hope to resurrect an old system and do all the LAMP/ sys-admin type of work (tweaking!) on it before moving the whole thing to a powerful machine. The calc charting is a short term solution before I get (and I hope I get it ultimately) the whole LAMP thing going. (I had been using MS XP and Excel for couple of years for this purpose, I can't believe my own madness/inertia/procrastination!) In fact I have noted your suggestion of linking the database files to calc and then making charts from it. That way I can use a database even before I get in to the A & P of LAMP. Dan, rost52, Tom: = About Candlestick charts: Candlestick charting is a Japanese charting technique for stocks, commodities, currencies. One candlestick represents the Open-High-Low-Close values for a given interval. The interval can be anything from minutes to years but is constant for a chart. It is an excellent visual representation that is extremely quick to grasp. Inferences are made based on a single candle or multiple candles seen together. Further info: https://en.wikipedia.org/wiki/Candlestick_chart Check the various candlestick patterns and their interpretations. *** The Japanese have shown great imagination in naming the patterns! Just to check how a candle stick chart looks, please go to yahoo finance and look for a technical analysis/ charting link (mostly you can just click any chart you see: NASDAQ/ DAX etc). Choose "Basic Tech Analysis" under charts. Set the range to 6 months and select type as "candle". I will try to find a way to get a real life example .ods or screen-shots on the net somewhere. Steve: The chartmaster software - was it open-source? May be I should search for similar charting software in open source domain. Unfortunately till now I have found myself to be "we didn't start the fire" types :P Someone, somewhere has always gone way ahead before me! In any case, if I find something open-source I can be sure of tweaking it (on my own machine) to my desire/ caliber/ patience! May be add a little but not reinvent! Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: Tom Davies To: users@global.libreoffice.org; rost52 Sent: Wednesday, October 10, 2012 1:46 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi :) I assumed he meant a bar-graph but made it sound more interesting. Regards from Tom :) --- On Wed, 10/10/12, rost52 wrote:
Re: [libreoffice-users] Fw: Help request on CALC charts' features
Hi :) I was able to overlap two charts in gimp as well as calc. Hurrraa :) * 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 To: "users@global.libreoffice.org" Sent: Wednesday, October 10, 2012 9:18 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi :) I have added the Yahoo finance image illustrating the overlap of the basic candlestick chart and line chart and bar chart to my facebook page. Album: LibreCALC_Query File: z.png Hope that clarifies. Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: Viral Orpe To: "users@global.libreoffice.org" Sent: Wednesday, October 10, 2012 6:29 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi rost52 :) Yes, That's right. That is the one I am using. Problem is: I want to add some indicators on it too. Like say the average of the past 3 months - which will be a line chart. I have uploaded two screenshots (.png) of the file I am using on my facebook page. They are made "public" under the album "Libre_CALC_Query" I don't use fb often so if you find any trouble downloading them please do not fight with FB. Just let me know. In all probability it will be some mistake from my side. I might make it three screen-shots with one example from yahoo finance in a couple of hours. Got to move out of this chair now!!!:) Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: rost52 To: users@global.libreoffice.org Sent: Wednesday, October 10, 2012 6:01 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Candlestick charts The wikipedia link was helpful. I think that what you want to use is called in Calc chart type "stock". There are 4 different sub type shown. The second from left looks very much like the chart in the wiki link. On 10.10.2012 21:10, Viral Orpe wrote: > Hi :) > > Thanks for all the responses > > I have tried to respond collectively here. > > > /* */ > > Miguel Ángel: > > About overlapping several charts > --- > I got similar idea but not overlapping in calc itself but using gimp. > I came across gimp some time last week and it had some concept like layers. > I have added a transparent layer and copied two charts - with same axis > scales, > ranges - on each layer. > > I am not very conversant with gimp though so right now I can only jump from > one layer to another and see two charts one-by-one. My charts themselves > have opaque background so transparency of layers is not helping. Still a > work in progress, I must say. Will keep you posted once I get what I need - > first in gimp and then in calc. > > Thanks a lot for your inputs. > > Dan: > === > About using Databases: > ---
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 To: "users@global.libreoffice.org" Sent: Wednesday, October 10, 2012 6:29 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi rost52 :) Yes, That's right. That is the one I am using. Problem is: I want to add some indicators on it too. Like say the average of the past 3 months - which will be a line chart. I have uploaded two screenshots (.png) of the file I am using on my facebook page. They are made "public" under the album "Libre_CALC_Query" I don't use fb often so if you find any trouble downloading them please do not fight with FB. Just let me know. In all probability it will be some mistake from my side. I might make it three screen-shots with one example from yahoo finance in a couple of hours. Got to move out of this chair now!!!:) Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: rost52 To: users@global.libreoffice.org Sent: Wednesday, October 10, 2012 6:01 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Candlestick charts The wikipedia link was helpful. I think that what you want to use is called in Calc chart type "stock". There are 4 different sub type shown. The second from left looks very much like the chart in the wiki link. On 10.10.2012 21:10, Viral Orpe wrote: > Hi :) > > Thanks for all the responses > > I have tried to respond collectively here. > > > /* */ > > Miguel Ángel: > > About overlapping several charts > --- > I got similar idea but not overlapping in calc itself but using gimp. > I came across gimp some time last week and it had some concept like layers. > I have added a transparent layer and copied two charts - with same axis > scales, > ranges - on each layer. > > I am not very conversant with gimp though so right now I can only jump from > one layer to another and see two charts one-by-one. My charts themselves > have opaque background so transparency of layers is not helping. Still a > work in progress, I must say. Will keep you posted once I get what I need - > first in gimp and then in calc. > > Thanks a lot for your inputs. > > Dan: > === > About using Databases: > - > Thanks Dan, you are absolutely right about wondering why not databases?! > I was thinking the best way to do what I do is using LAMP - particularly since > I have to ultimately work on data that is 245 days/year, 12 years till now, > 1000+ > entries everyday, each entry has say 8-10 sub-entries and at least two such > sets > of data! (Equity, derivatives, & Commodity) > (365 - 52x2weekends - 16 holidays = 245 days/year!) > > But this is my first week with Linux! I can't possibly get into MySQL and > hope to > get it rightly done without crashing my system a thousand times. Right now, I > have this > one machine working. I hope to resurrect an old system and do all the LAMP/ > sys-admin > type of work (tweaking!) on it before moving the whole thing to a powerful > machine. > > The calc charting is a short term solution before I get (and I hope I get it > ultimately) > the whole LAMP thing going. (I had been using MS XP and Excel for couple of > years for > this purpose, I can't believe my own madness/inertia/procrastination!) > In fact I have noted your suggestion of linking the database files to calc > and then making > charts from it. That way I can use a database even before I get in to the A & > P of LAMP. > > Dan, rost52, Tom: > = > About Candlestick charts: > --
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 To: users@global.libreoffice.org Sent: Wednesday, October 10, 2012 6:01 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Candlestick charts The wikipedia link was helpful. I think that what you want to use is called in Calc chart type "stock". There are 4 different sub type shown. The second from left looks very much like the chart in the wiki link. On 10.10.2012 21:10, Viral Orpe wrote: > Hi :) > > Thanks for all the responses > > I have tried to respond collectively here. > > > /* */ > > Miguel Ángel: > > About overlapping several charts > --- > I got similar idea but not overlapping in calc itself but using gimp. > I came across gimp some time last week and it had some concept like layers. > I have added a transparent layer and copied two charts - with same axis > scales, > ranges - on each layer. > > I am not very conversant with gimp though so right now I can only jump from > one layer to another and see two charts one-by-one. My charts themselves > have opaque background so transparency of layers is not helping. Still a > work in progress, I must say. Will keep you posted once I get what I need - > first in gimp and then in calc. > > Thanks a lot for your inputs. > > Dan: > === > About using Databases: > - > Thanks Dan, you are absolutely right about wondering why not databases?! > I was thinking the best way to do what I do is using LAMP - particularly since > I have to ultimately work on data that is 245 days/year, 12 years till now, > 1000+ > entries everyday, each entry has say 8-10 sub-entries and at least two such > sets > of data! (Equity, derivatives, & Commodity) > (365 - 52x2weekends - 16 holidays = 245 days/year!) > > But this is my first week with Linux! I can't possibly get into MySQL and > hope to > get it rightly done without crashing my system a thousand times. Right now, I > have this > one machine working. I hope to resurrect an old system and do all the LAMP/ > sys-admin > type of work (tweaking!) on it before moving the whole thing to a powerful > machine. > > The calc charting is a short term solution before I get (and I hope I get it > ultimately) > the whole LAMP thing going. (I had been using MS XP and Excel for couple of > years for > this purpose, I can't believe my own madness/inertia/procrastination!) > In fact I have noted your suggestion of linking the database files to calc > and then making > charts from it. That way I can use a database even before I get in to the A & > P of LAMP. > > Dan, rost52, Tom: > = > About Candlestick charts: > > Candlestick charting is a Japanese charting technique for stocks, commodities, > currencies. One candlestick represents the Open-High-Low-Close values for a > given interval. The interval can be anything from minutes to years but is > constant > for a chart. It is an excellent visual representation that is extremely quick > to grasp. > Inferences are made based on a single candle or multiple candles seen > together. > > Further info: https://en.wikipedia.org/wiki/Candlestick_chart > > Check the various candlestick patterns and their interpretations. > *** The Japanese have shown great imagination in naming the patterns! > > Just to check how a candle stick chart looks, please go to yahoo finance and > look for > a technical analysis/ charting link (mostly you can just click any chart you > see: NASDAQ/ > D
Re: [libreoffice-users] Fw: Help request on CALC charts' features
Candlestick charts The wikipedia link was helpful. I think that what you want to use is called in Calc chart type "stock". There are 4 different sub type shown. The second from left looks very much like the chart in the wiki link. On 10.10.2012 21:10, Viral Orpe wrote: Hi :) Thanks for all the responses I have tried to respond collectively here. /* */ Miguel Ángel: About overlapping several charts --- I got similar idea but not overlapping in calc itself but using gimp. I came across gimp some time last week and it had some concept like layers. I have added a transparent layer and copied two charts - with same axis scales, ranges - on each layer. I am not very conversant with gimp though so right now I can only jump from one layer to another and see two charts one-by-one. My charts themselves have opaque background so transparency of layers is not helping. Still a work in progress, I must say. Will keep you posted once I get what I need - first in gimp and then in calc. Thanks a lot for your inputs. Dan: === About using Databases: - Thanks Dan, you are absolutely right about wondering why not databases?! I was thinking the best way to do what I do is using LAMP - particularly since I have to ultimately work on data that is 245 days/year, 12 years till now, 1000+ entries everyday, each entry has say 8-10 sub-entries and at least two such sets of data! (Equity, derivatives, & Commodity) (365 - 52x2weekends - 16 holidays = 245 days/year!) But this is my first week with Linux! I can't possibly get into MySQL and hope to get it rightly done without crashing my system a thousand times. Right now, I have this one machine working. I hope to resurrect an old system and do all the LAMP/ sys-admin type of work (tweaking!) on it before moving the whole thing to a powerful machine. The calc charting is a short term solution before I get (and I hope I get it ultimately) the whole LAMP thing going. (I had been using MS XP and Excel for couple of years for this purpose, I can't believe my own madness/inertia/procrastination!) In fact I have noted your suggestion of linking the database files to calc and then making charts from it. That way I can use a database even before I get in to the A & P of LAMP. Dan, rost52, Tom: = About Candlestick charts: Candlestick charting is a Japanese charting technique for stocks, commodities, currencies. One candlestick represents the Open-High-Low-Close values for a given interval. The interval can be anything from minutes to years but is constant for a chart. It is an excellent visual representation that is extremely quick to grasp. Inferences are made based on a single candle or multiple candles seen together. Further info: https://en.wikipedia.org/wiki/Candlestick_chart Check the various candlestick patterns and their interpretations. *** The Japanese have shown great imagination in naming the patterns! Just to check how a candle stick chart looks, please go to yahoo finance and look for a technical analysis/ charting link (mostly you can just click any chart you see: NASDAQ/ DAX etc). Choose "Basic Tech Analysis" under charts. Set the range to 6 months and select type as "candle". I will try to find a way to get a real life example .ods or screen-shots on the net somewhere. Steve: The chartmaster software - was it open-source? May be I should search for similar charting software in open source domain. Unfortunately till now I have found myself to be "we didn't start the fire" types :P Someone, somewhere has always gone way ahead before me! In any case, if I find something open-source I can be sure of tweaking it (on my own machine) to my desire/ caliber/ patience! May be add a little but not reinvent! Thanks, Regards, Viral Orpe :) --- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory : 4GB, DDR3 OS: Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) --- From: Tom Davies To: users@global.libreoffice.org; rost52 Sent: Wednesday, October 10, 2012 1:46 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi :) I assumed he meant a bar-graph but made it sound more interesting. Regards from Tom :) --- On Wed, 10/10/12, rost52 wrote: From: rost52 Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features To: users@global.libreoffice.org Date: Wednesday, 10 October, 2012, 2:32 Could you possibly post somewhere an example of a candle stick chart?
Re: [libreoffice-users] Fw: Help request on CALC charts' features
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 To: users@global.libreoffice.org; rost52 Sent: Wednesday, October 10, 2012 1:46 PM Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features Hi :) I assumed he meant a bar-graph but made it sound more interesting. Regards from Tom :) --- On Wed, 10/10/12, rost52 wrote: From: rost52 Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features To: users@global.libreoffice.org Date: Wednesday, 10 October, 2012, 2:32 Could you possibly post somewhere an example of a candle stick chart? On 2012-10-10 02:52, Viral Orpe wrote: > Hi :) > > Thanks for your time and replies. > I could stop fighting calc to show me the chart as a single worksheet! > > I was charting the stock market data (available in daily doses to b
Re: [libreoffice-users] Fw: Help request on CALC charts' features
Hi :) I assumed he meant a bar-graph but made it sound more interesting. Regards from Tom :) --- On Wed, 10/10/12, rost52 wrote: From: rost52 Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features To: users@global.libreoffice.org Date: Wednesday, 10 October, 2012, 2:32 Could you possibly post somewhere an example of a candle stick chart? On 2012-10-10 02:52, Viral Orpe wrote: > Hi :) > > Thanks for your time and replies. > I could stop fighting calc to show me the chart as a single worksheet! > > I was charting the stock market data (available in daily doses to be bunched > neatly in weekly, monthly, quarterly, yearly batches) in candlestick form. > Both Excel and Calc do not allow any other lines on the candlestick charts > (moving averages, e.g.). > It robs the ease of analysis (and make me dependent on some websites that > offer it - currently for free :) but I never liked the dependence) > > I read somewhere* what Shakespeare wrote of vaulting ambition :) > Since, I have no spur to prick my intent, as of today I can't start vaulting > onto tweaking CALC source code to add a new chart type. > > But, it would be fun and a taste + test of the Linux promise of free(dom)! > Hope I reach the promised land one day. > > Any pointers are welcome. > > again, thanks for your time, > regards, > Viral Orpe > > p.s. > *Vaulting Ambition :) > http://www.shakespeare-online.com/plays/macbeth/soliloquies/blow.html > > (spur: I know just C, data structures, and presently am learning shell > scripting. > Nothing about Linux kernel/ internals and have never written software in a > professional team) > > > >>>>>>>>>>>>> snip <<<<<<<<<<<<<< -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Fw: Help request on CALC charts' features
Could you possibly post somewhere an example of a candle stick chart? On 2012-10-10 02:52, Viral Orpe wrote: Hi :) Thanks for your time and replies. I could stop fighting calc to show me the chart as a single worksheet! I was charting the stock market data (available in daily doses to be bunched neatly in weekly, monthly, quarterly, yearly batches) in candlestick form. Both Excel and Calc do not allow any other lines on the candlestick charts (moving averages, e.g.). It robs the ease of analysis (and make me dependent on some websites that offer it - currently for free :) but I never liked the dependence) I read somewhere* what Shakespeare wrote of vaulting ambition :) Since, I have no spur to prick my intent, as of today I can't start vaulting onto tweaking CALC source code to add a new chart type. But, it would be fun and a taste + test of the Linux promise of free(dom)! Hope I reach the promised land one day. Any pointers are welcome. again, thanks for your time, regards, Viral Orpe p.s. *Vaulting Ambition :) http://www.shakespeare-online.com/plays/macbeth/soliloquies/blow.html (spur: I know just C, data structures, and presently am learning shell scripting. Nothing about Linux kernel/ internals and have never written software in a professional team) snip << -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Fw: Help request on CALC charts' features
On 2012-10-10 06:52, Viral Orpe wrote: Hi :) Thanks for your time and replies. I could stop fighting calc to show me the chart as a single worksheet! I was charting the stock market data (available in daily doses to be bunched neatly in weekly, monthly, quarterly, yearly batches) in candlestick form. Both Excel and Calc do not allow any other lines on the candlestick charts (moving averages, e.g.). It robs the ease of analysis (and make me dependent on some websites that offer it - currently for free :) but I never liked the dependence) I read somewhere* what Shakespeare wrote of vaulting ambition :) Since, I have no spur to prick my intent, as of today I can't start vaulting onto tweaking CALC source code to add a new chart type. But, it would be fun and a taste + test of the Linux promise of free(dom)! Hope I reach the promised land one day. Any pointers are welcome. again, thanks for your time, regards, Viral Orpe p.s. *Vaulting Ambition :) http://www.shakespeare-online.com/plays/macbeth/soliloquies/blow.html (spur: I know just C, data structures, and presently am learning shell scripting. Nothing about Linux kernel/ internals and have never written software in a professional team) _ 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+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Fw: Help request on CALC charts' features
On 10/09/2012 02:47 PM, MiguelAngel wrote: El 09/10/12 19:52, Viral Orpe escribió: 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+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Fw: Help request on CALC charts' features
El 09/10/12 19:52, Viral Orpe escribió: 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+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Fw: Help request on CALC charts' features
Hi :) Thanks for your time and replies. I could stop fighting calc to show me the chart as a single worksheet! I was charting the stock market data (available in daily doses to be bunched neatly in weekly, monthly, quarterly, yearly batches) in candlestick form. Both Excel and Calc do not allow any other lines on the candlestick charts (moving averages, e.g.). It robs the ease of analysis (and make me dependent on some websites that offer it - currently for free :) but I never liked the dependence) I read somewhere* what Shakespeare wrote of vaulting ambition :) Since, I have no spur to prick my intent, as of today I can't start vaulting onto tweaking CALC source code to add a new chart type. But, it would be fun and a taste + test of the Linux promise of free(dom)! Hope I reach the promised land one day. Any pointers are welcome. again, thanks for your time, regards, Viral Orpe p.s. *Vaulting Ambition :) http://www.shakespeare-online.com/plays/macbeth/soliloquies/blow.html (spur: I know just C, data structures, and presently am learning shell scripting. Nothing about Linux kernel/ internals and have never written software in a professional team) snip << -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Fw: Help request on CALC charts' features
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 wrote: From: Steve Edmonds Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features To: "rost52" Cc: users@global.libreoffice.org Date: Monday, 8 October, 2012, 3:43 Hi. On 2012-10-08 15:08, rost52 wrote: > 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 > On 2012-10-07 14:54, Viral Orpe wrote: >> >> >> >> 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 >> >> 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+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Fw: Help request on CALC charts' features
Hi. On 2012-10-08 15:08, rost52 wrote: 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 On 2012-10-07 14:54, Viral Orpe wrote: 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 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+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Fw: Help request on CALC charts' features
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 On 2012-10-07 14:54, Viral Orpe wrote: 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+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Fw: Help request on CALC charts' features
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+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted