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 <[email protected]> >To: [email protected] >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 <[email protected]> >>> To: "[email protected]" <[email protected]> >>> 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 <[email protected]> >>> To: "[email protected]" <[email protected]>; Viral >>> Orpe <[email protected]> >>> 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 <[email protected]> wrote: >>> >>> >>>> From: Viral Orpe <[email protected]> >>>> Subject: Re: [libreoffice-users] Fw: Help request >>> on CALC charts' features >>>> To: "[email protected]" <[email protected]> >>>> Date: Wednesday, 10 October, 2012, 17:58 >>>> >>>> >>>> Hi :) >>>> >>>> I was able to overlap two charts in gimp as well as calc. Hurrraahhhh :) >>>> >>>> * Adjusted axis on both charts - major, minor ticks to match each other. >>>> >>>> * Scales (rather everything) "Automatic" is unmarked - in case we need to >>>> scale data ranges later. >>>> >>>> * Made the top one completely transparent before moving on top of first. >>>> >>>> >>>> In gimp one can be sure that they don't "slide" - ever. >>>> >>>> Not sure if there is a facility for that in calc - don't really expect. >>>> >>>> Just pinging in case anyone has any ideas. >>>> >>>> Objects once placed may move - e.g. one justified left other to center >>>> etc. - on their own >>>> with some remote change elsewhere in the sheet. >>>> >>>> >>>> The charts are now 100 times more helpful. No kidding! >>>> >>>> Thanks a lot >>> to everybody who chipped in with their suggestions. >>>> >>>> Regards, >>>> Viral Orpe :) >>>> --------------------------------------------------------------------------------------------------- >>>> Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz >>>> Memory : 4GB, DDR3 >>>> OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) >>>> LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) >>>> >>>> --------------------------------------------------------------------------------------------------- >>>> >>>> >>>> >>>> ________________________________ >>>> From: Viral Orpe <[email protected]> >>>> To: "[email protected]" <[email protected]> >>>> 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 <[email protected]> >>>> To: "[email protected]" <[email protected]> >>>> 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 <[email protected]> >>>> To: [email protected] >>>> Sent: Wednesday, October 10, 2012 6:01 PM >>>> Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features >>>> >>>> Candlestick charts >>>> >>>> The wikipedia link was helpful. >>>> I think that what you want to use is called in Calc chart type "stock". >>>> There are 4 different sub >>>> type shown. The second from left looks very much like the chart in the >>>> wiki link. >>>> >>>> >>>> On 10.10.2012 21:10, Viral Orpe wrote: >>>>> Hi :) >>>>> >>>>> Thanks for all the responses.... >>>>> >>>>> I have tried >>> to respond collectively here. >>>>> >>>>> /* ******************** */ >>>>> >>>>> Miguel Ángel: >>>>> ============ >>>>> About overlapping several charts >>>>> ------------------------------------------- >>>>> I got similar idea but not overlapping in calc itself but using gimp. >>>>> I came across gimp some time last week and it had some concept like >>>>> layers. >>>>> I have added a transparent layer and copied two charts - with same axis >>>>> scales, >>>>> ranges - on each layer. >>>>> >>>>> I am not very conversant with gimp though so right now I can only jump >>>>> from >>>>> one layer to another and see two charts one-by-one. My charts themselves >>>>> have opaque background so transparency of layers is not helping. Still a >>>>> work in progress, I must say. Will keep you posted once I get what I need >>>>> - >>>>> first in gimp and then in calc. >>>>> >>>>> Thanks a lot for your inputs. >>>>> >>>>> >>> Dan: >>>>> === >>>>> About using Databases: >>>>> ----------------------------- >>>>> Thanks Dan, you are absolutely right about wondering why not databases?! >>>>> I was thinking the best way to do what I do is using LAMP - particularly >>>>> since >>>>> I have to ultimately work on data that is 245 days/year, 12 years till >>>>> now, 1000+ >>>>> entries everyday, each entry has say 8-10 sub-entries and at least two >>>>> such sets >>>>> of data! (Equity, derivatives, & Commodity) >>>>> (365 - 52x2weekends - 16 holidays = 245 days/year!) >>>>> >>>>> But this is my first week with Linux! I can't possibly get into MySQL and >>>>> hope to >>>>> get it rightly done without crashing my system a thousand times. Right >>>>> now, I have this >>>>> one machine working. I hope to resurrect an old system and do all the >>>>> LAMP/ sys-admin >>>>> type of work (tweaking!) on it before moving the whole thing to a >>>>> powerful machine. >>>>> >>>>> The calc charting is a >>> short term solution before I get (and I hope I get it ultimately) >>>>> the whole LAMP thing going. (I had been using MS XP and Excel for couple >>>>> of years for >>>>> this purpose, I can't believe my own madness/inertia/procrastination!) >>>>> In fact I have noted your suggestion of linking the database files to >>>>> calc and then making >>>>> charts from it. That way I can use a database even before I get in to the >>>>> A & P of LAMP. >>>>> >>>>> Dan, rost52, Tom: >>>>> ============= >>>>> About Candlestick charts: >>>>> -------------------------------- >>>>> Candlestick charting is a Japanese charting technique for stocks, >>>>> commodities, >>>>> currencies. One candlestick represents the Open-High-Low-Close values for >>>>> a >>>>> given interval. The interval can be anything from minutes to years but is >>>>> constant >>>>> for a chart. It is an excellent visual representation that is extremely >>>>> quick to grasp. >>>>> Inferences are made based on a >>> single candle or multiple candles seen together. >>>>> Further info: https://en.wikipedia.org/wiki/Candlestick_chart >>>>> >>>>> Check the various candlestick patterns and their interpretations. >>>>> *** The Japanese have shown great imagination in naming the patterns! >>>>> >>>>> Just to check how a candle stick chart looks, please go to yahoo finance >>>>> and look for >>>>> a technical analysis/ charting link (mostly you can just click any chart >>>>> you see: NASDAQ/ >>>>> DAX etc). Choose "Basic Tech Analysis" under charts. Set the range to 6 >>>>> months and select >>>>> type as "candle". >>>>> >>>>> I will try to find a way to get a real life example .ods or screen-shots >>>>> on the net somewhere. >>>>> >>>>> Steve: >>>>> ==== >>>>> The chartmaster software - was it open-source? >>>>> May be I should search for similar charting software in open source >>> domain. >>>>> Unfortunately till now I have found myself to be "we didn't start the >>>>> fire" types :P >>>>> Someone, somewhere has always gone way ahead before me! >>>>> In any case, if I find something open-source I can be sure of tweaking it >>>>> (on my >>>>> own machine) to my desire/ caliber/ patience! May be add a little but not >>>>> reinvent! >>>>> >>>>> >>>>> Thanks, >>>>> Regards, >>>>> Viral Orpe :) >>>>> --------------------------------------------------------------------------------------------------- >>>>> Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz >>>>> Memory : 4GB, DDR3 >>>>> OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) >>>>> LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) >>>>> >>>>> >>> --------------------------------------------------------------------------------------------------- >>>>> >>>>> >>>>> ________________________________ >>>>> From: Tom Davies <[email protected]> >>>>> To: [email protected]; rost52 <[email protected]> >>>>> 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 <[email protected]> wrote: >>>>> >>>>> From: rost52 <[email protected]> >>>>> Subject: Re: [libreoffice-users] Fw: Help request on CALC charts' features >>>>> To: [email protected] >>>>> 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: [email protected] >>>> 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: [email protected] >>>> 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: [email protected] >>>> 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: [email protected] >>>> 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: [email protected] >>> 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: [email protected] >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: [email protected] 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
