Menu
▾
▴
geniustrader-system-traders — exchange your geniustrader usage methodology, trading systems, signals, etc
You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(11) |
Feb
|
Mar
(12) |
Apr
|
May
(36) |
Jun
(14) |
Jul
|
Aug
(8) |
Sep
|
Oct
(11) |
Nov
(11) |
Dec
|
| 2004 |
Jan
(2) |
Feb
(5) |
Mar
|
Apr
(3) |
May
(11) |
Jun
|
Jul
(13) |
Aug
(7) |
Sep
(1) |
Oct
(4) |
Nov
|
Dec
(4) |
| 2005 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(6) |
Jul
(25) |
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
| 2006 |
Jan
(1) |
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
(4) |
Oct
(3) |
Nov
(1) |
Dec
|
| 2007 |
Jan
|
Feb
|
Mar
(1) |
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2008 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(3) |
Oct
|
Nov
|
Dec
|
| 2009 |
Jan
|
Feb
(1) |
Mar
(1) |
Apr
(4) |
May
(1) |
Jun
(8) |
Jul
(4) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2010 |
Jan
(2) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(2) |
Oct
|
Nov
|
Dec
(27) |
| 2011 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(6) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2012 |
Jan
|
Feb
|
Mar
|
Apr
(10) |
May
(4) |
Jun
|
Jul
(3) |
Aug
|
Sep
|
Oct
|
Nov
(28) |
Dec
(4) |
| 2013 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2018 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Robert A. S. <uw...@fl...> - 2018-01-31 23:06:18
|
gt'ers somehow the recent changes to sourceforge have broken access to the geniustrader source code repository. until i can resolve that problem feel free to contact me, ras directly at acm dot org and i will email you a gz, bz2 or xz tarball of the code (please indicate preference). the size will be on the order of 2.5 Mbytes. sorry for the inconvenience, aloha ras |
|
From: Robert A. S. <ra...@ac...> - 2013-04-16 17:37:23
|
gt'ers url refs: gt website: http://geniustrader.org sourceforge gt webpage: http://sourceforge.net/projects/geniustrader sourceforge has changed the forge part of the hosting site to a new process and that has, unfortunately, impacted some of the urls used in the gt website, especially those urls that refer to the svn gt code base, but possibly others too. i am aware of the problem with the gt svn code base links and will be working on correcting them, but in the meantime you can always use the direct links on the sourceforge site pages to get direct access to the gt svn code base. if you run in to other failing links please bring them to my attention, either by direct email or either of these gt mail lists. thanks ras |
|
From: Robert A. S. <ra...@ac...> - 2012-12-02 04:12:28
|
Thomas Graham wrote: > Robert, > > Which generic indicator could deal with percentage calculation? well, none directly, but you understand the arithmetic involved, so you can use I:G:Eval and compute a data-series object which can be used in yet another indicator. a search (browse) of the -devel archive might yield some ideas to build upon. if you haven't already discovered it, most modules have pod -- read it using your favorite pod viewer. for example "perldoc -t ../GT/Indicators/Generic/Eval.pm" and feel encouraged to offer up improvements in the pod when it fails to be useful, seems complete or is missing entirely. simply post suggestions to this or the -devel list. ras > > Thomas Lau > whatsapp/Tel: +852 9323 9670 > On 2 Dec 2012 01:54, "Robert A. Schmied" <ra...@ac...> wrote: > > >>Thomas Graham wrote: >> >> >>>Hi all, >>> >>>does anyone know how could I define the price compare between SMA 10 as >>>example which is less than 5% diff? >>> >>>I want to check where the stocks current price is touching or very close >>>to >>>SMA 10. >>>Thanks. >>> >>> >>> >> >>you want to define a signal, that signal description will need indicator(s) >>that evaluate the desired data-series values over time -- look at the >>generic >>indicators (GT/Indicators/Generic) -- see if one of them might do what you >>need. >> >>testing (e.g. proofing) your ultimate sys-sig-indic desc can be done using >>the util apps display_indicator.pl and finally with display_signal.pl. >> >>ras >> >> >> >>>------------------------------**------------------------------** >>>------------ >>> >>>------------------------------**------------------------------** >>>------------------ >>>Keep yourself connected to Go Parallel: INSIGHTS What's next for parallel >>>hardware, programming and related areas? >>>Interviews and blogs by thought leaders keep you ahead of the curve. >>>http://goparallel.sourceforge.**net <http://goparallel.sourceforge.net> >>> >>> >>>------------------------------**------------------------------** >>>------------ >>> >>>______________________________**_________________ >>>Geniustrader-system-traders mailing list >>> >> >> > |
|
From: Thomas G. <lkt...@gm...> - 2012-12-02 01:57:20
|
Robert, Which generic indicator could deal with percentage calculation? Thomas Lau whatsapp/Tel: +852 9323 9670 On 2 Dec 2012 01:54, "Robert A. Schmied" <ra...@ac...> wrote: > Thomas Graham wrote: > >> Hi all, >> >> does anyone know how could I define the price compare between SMA 10 as >> example which is less than 5% diff? >> >> I want to check where the stocks current price is touching or very close >> to >> SMA 10. >> Thanks. >> >> >> > you want to define a signal, that signal description will need indicator(s) > that evaluate the desired data-series values over time -- look at the > generic > indicators (GT/Indicators/Generic) -- see if one of them might do what you > need. > > testing (e.g. proofing) your ultimate sys-sig-indic desc can be done using > the util apps display_indicator.pl and finally with display_signal.pl. > > ras > > >> ------------------------------**------------------------------** >> ------------ >> >> ------------------------------**------------------------------** >> ------------------ >> Keep yourself connected to Go Parallel: INSIGHTS What's next for parallel >> hardware, programming and related areas? >> Interviews and blogs by thought leaders keep you ahead of the curve. >> http://goparallel.sourceforge.**net <http://goparallel.sourceforge.net> >> >> >> ------------------------------**------------------------------** >> ------------ >> >> ______________________________**_________________ >> Geniustrader-system-traders mailing list >> > > |
|
From: Robert A. S. <ra...@ac...> - 2012-12-01 17:54:14
|
Thomas Graham wrote: > Hi all, > > does anyone know how could I define the price compare between SMA 10 as > example which is less than 5% diff? > > I want to check where the stocks current price is touching or very close to > SMA 10. > Thanks. > > you want to define a signal, that signal description will need indicator(s) that evaluate the desired data-series values over time -- look at the generic indicators (GT/Indicators/Generic) -- see if one of them might do what you need. testing (e.g. proofing) your ultimate sys-sig-indic desc can be done using the util apps display_indicator.pl and finally with display_signal.pl. ras > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------------ > Keep yourself connected to Go Parallel: > INSIGHTS What's next for parallel hardware, programming and related areas? > Interviews and blogs by thought leaders keep you ahead of the curve. > http://goparallel.sourceforge.net > > > ------------------------------------------------------------------------ > > _______________________________________________ > Geniustrader-system-traders mailing list |
|
From: Thomas G. <lkt...@gm...> - 2012-12-01 03:43:02
|
Hi all, does anyone know how could I define the price compare between SMA 10 as example which is less than 5% diff? I want to check where the stocks current price is touching or very close to SMA 10. Thanks. -- Thomas G Lau Tel: 93239670 |
|
From: Robert A. S. <ra...@ac...> - 2012-11-30 17:31:30
|
Thomas Graham wrote: > Robert, thanks. I will write a script to fit my local data feed instead. it might be a bigger job than it seems at first glance. take a hard look at the myriad variants on cpan ... and you might want to start a discussion with dirk (beancounter) eddelbuettel on general interest of alternate data source ... and by the way he has put beancounter on google.code. ras > > > On Sat, Dec 1, 2012 at 1:00 AM, Robert A. Schmied <ra...@ac...> wrote: > > >>Thomas Graham wrote: >> >> >>>By the way, does the most important one is stockprices table data for GT >>>usage?! seems all other things is not important for charts and signals >>>generating. >>> >> >>gt only uses beancounter table stockprices if i remember correctly -- you >>can see this yourself by looking at the code for GT::DB:bean and GT::Prices >> >> >> >> >>>On Fri, Nov 30, 2012 at 11:04 PM, Thomas Graham <lkt...@gm...> >>>wrote: >>> >>> >>> What do you think if I write another script to insert daily data from a >>> >>>>more reliable source into sqlite instead of rely on yahoo?! to be honest >>>>Yahoo is a poor data source all the time. >>>> >>>> >>>> >> >>you can use any data source (or sources) at your disposal to feed data into >>the beancounter (or any other) database. when performing the sql insert >>(or update)just make sure that the data is appropriately formatted >>(posgresql does not want any commas in numbers and dates, symbols, >>and company names, etc need to be a quoted string; you are on your own >>with sqlite3). >> >>you might try to leverage the bulk of beancounter and just provide an >>alternative to yahooquote ... >> >>gt also provides prices sourcing using file based data, but it has some >>limits including no support for limiting the data fetch (entire file >>is read), one file per symbol per time-frame. see GT::DB::Text for details. >> >> >><< big snip >> >> > > > |
|
From: Thomas G. <lkt...@gm...> - 2012-11-30 17:10:52
|
Robert, thanks. I will write a script to fit my local data feed instead. On Sat, Dec 1, 2012 at 1:00 AM, Robert A. Schmied <ra...@ac...> wrote: > Thomas Graham wrote: > >> By the way, does the most important one is stockprices table data for GT >> usage?! seems all other things is not important for charts and signals >> generating. >> > > gt only uses beancounter table stockprices if i remember correctly -- you > can see this yourself by looking at the code for GT::DB:bean and GT::Prices > > > >> >> On Fri, Nov 30, 2012 at 11:04 PM, Thomas Graham <lkt...@gm...> >> wrote: >> >> >> What do you think if I write another script to insert daily data from a >>> more reliable source into sqlite instead of rely on yahoo?! to be honest >>> Yahoo is a poor data source all the time. >>> >>> >>> > you can use any data source (or sources) at your disposal to feed data into > the beancounter (or any other) database. when performing the sql insert > (or update)just make sure that the data is appropriately formatted > (posgresql does not want any commas in numbers and dates, symbols, > and company names, etc need to be a quoted string; you are on your own > with sqlite3). > > you might try to leverage the bulk of beancounter and just provide an > alternative to yahooquote ... > > gt also provides prices sourcing using file based data, but it has some > limits including no support for limiting the data fetch (entire file > is read), one file per symbol per time-frame. see GT::DB::Text for details. > > > << big snip >> > -- Thomas G Lau Tel: 93239670 |
|
From: Robert A. S. <ra...@ac...> - 2012-11-30 17:01:13
|
Thomas Graham wrote: > By the way, does the most important one is stockprices table data for GT > usage?! seems all other things is not important for charts and signals > generating. gt only uses beancounter table stockprices if i remember correctly -- you can see this yourself by looking at the code for GT::DB:bean and GT::Prices > > > On Fri, Nov 30, 2012 at 11:04 PM, Thomas Graham <lkt...@gm...> wrote: > > >>What do you think if I write another script to insert daily data from a >>more reliable source into sqlite instead of rely on yahoo?! to be honest >>Yahoo is a poor data source all the time. >> >> you can use any data source (or sources) at your disposal to feed data into the beancounter (or any other) database. when performing the sql insert (or update)just make sure that the data is appropriately formatted (posgresql does not want any commas in numbers and dates, symbols, and company names, etc need to be a quoted string; you are on your own with sqlite3). you might try to leverage the bulk of beancounter and just provide an alternative to yahooquote ... gt also provides prices sourcing using file based data, but it has some limits including no support for limiting the data fetch (entire file is read), one file per symbol per time-frame. see GT::DB::Text for details. << big snip >> |
|
From: Thomas G. <lkt...@gm...> - 2012-11-30 15:54:45
|
By the way, does the most important one is stockprices table data for GT usage?! seems all other things is not important for charts and signals generating. On Fri, Nov 30, 2012 at 11:04 PM, Thomas Graham <lkt...@gm...> wrote: > What do you think if I write another script to insert daily data from a > more reliable source into sqlite instead of rely on yahoo?! to be honest > Yahoo is a poor data source all the time. > > > On Fri, Nov 30, 2012 at 10:59 PM, Robert A. Schmied <ra...@ac...> wrote: > >> Thomas Graham wrote: >> >>> Robert, I found out this is a bug. >>> >>> Try this step to reproduce it: >>> 1. beancounter backpopulate T --prevdate (Any date) --date 'today' >>> 2. run scan.pl. works fine >>> 3. beancounter update --forceupdate today >>> >> >> oh yea! i avoid some beancounter commands completely, as it can, >> will and does destroy ones database without any by-your-leave. >> >> the --forceupdate is especially dangerous as i recall. >> >> ok -- so things (gt) work if you have a valid database, correct? >> >> assuming that's a yes -- here's how i approach the stock prices issue: >> here in states yahoo eod is usually complete by about 40 minutes after >> nyse closing (4pm et) so i run 'beancounter update' from a crontab >> entry at that time every market day -- determining market day is >> another task in and of itself. >> >> then i have a number of gt crontab entries scheduled after the beancounter >> eod update is complete. >> >> i've also hacked up a few beancounter database checkers that look >> to see if data from yesterday is good and valid, if not i do yesterday >> only backpop for that symbol. i also think i've got a terribly hacked >> version of GT::DB::bean with logic that ensures the prices data is >> 'reasonable' within the context expected in gt (high is highest, low >> is lowest, etc). >> >> this latter feature can be implemented much more simply using the gt >> GT::DB::genericdbi module and providing the appropriate sql query in >> $HOME/.gt/options >> >> >> >>> >>> tons of error: >>> Use of uninitialized value $age in numeric gt (>) at >>> /usr/share/perl5/Finance/**BeanCounter.pm line 1743. >>> Overriding date for 0175.HK (GEELY AUTO) to 20121130 >>> >>> >>> 4. ./scan.pl --timeframe=day --start=2012-07-26 --end=2012-11-26 >>> /mnt/stocks/newstockscode.txt 2012-11-26 /mnt/trading/system.gt >>> Use of uninitialized value $d in pattern match (m//) at ../GT/DateTime.pm >>> line 284, <> line 4. >>> Use of uninitialized value $m in subtraction (-) at ../GT/DateTime.pm >>> line >>> 285, <> line 4. >>> >>> >>> >> < big snip > >> > > > > -- > Thomas G Lau > Tel: 93239670 > -- Thomas G Lau Tel: 93239670 |
|
From: Thomas G. <lkt...@gm...> - 2012-11-30 15:11:00
|
Thanks Robert, by the way after I use /1 /2 on MACD then remove switch-zone, graph seems work fine; but I discover RSI graph is inaccurate. Let me post another mail out. On Fri, Nov 30, 2012 at 11:03 PM, Robert A. Schmied <ra...@ac...> wrote: > Thomas Graham wrote: > >> Hi Robert, how come it is not showing /1 result only ? >> >> ./display_indicator.pl --timeframe=day I:MACD/1 0001.HK >> Calculating indicator MACD[12, 26, {I:Prices CLOSE}] ... >> MACD[12, 26, {I:Prices CLOSE}][2012-09-10] = 0.6142 >> MACDSignal[9, {I:Prices CLOSE}][2012-09-10] = 0.7731 >> MACDDifference[12, 26, 9, {I:Prices CLOSE}][2012-09-10] = >> -0.158871278469423 >> > > good question! it may be broke. i'll look at it and get back to ya! > > ras > > > >> >> >> On Fri, Nov 30, 2012 at 10:34 PM, Robert A. Schmied <ra...@ac...> wrote: >> >> >> Thomas Graham wrote: >>> >>> Hi, >>>> >>>> I am testing Indicators::MACD, but no graph being generate at all. >>>> >>>> at the same time, I experiment other indicator which works pretty well. >>>> >>>> What went wrong here? >>>> >>>> scripts for ADX: >>>> --title=Stock of %c >>>> --add=Switch-Zone(0) >>>> --add=Curve(Indicators::SMA 10, [255,0,0]) >>>> --add=Curve(Indicators::SMA 20, [255,240,0]) >>>> --add=Curve(Indicators::SMA 50, [194,198,236]) >>>> --add=Curve(Indicators::SMA 100, [255,200,0]) >>>> --add=Curve(Indicators::SMA 150, [255,175,175]) >>>> --add=New-Zone(100) >>>> --add=Switch-Zone(2) >>>> --add=Text("RSI (14)", 0, 100) >>>> --add=Curve(Indicators::RSI 14, [255,0,0]) >>>> --add=New-Zone(100) >>>> --add=Switch-Zone(3) >>>> --add=Text("ADX", 0, 100) >>>> --add=Curve(Indicators::ADX, [255,0,0]) >>>> >>>> >>>> Scripts for MACD: >>>> --title=Stock of %c >>>> --add=Switch-Zone(0) >>>> --add=Curve(Indicators::SMA 10, [255,0,0]) >>>> --add=Curve(Indicators::SMA 20, [255,240,0]) >>>> --add=Curve(Indicators::SMA 50, [194,198,236]) >>>> --add=Curve(Indicators::SMA 100, [255,200,0]) >>>> --add=Curve(Indicators::SMA 150, [255,175,175]) >>>> --add=New-Zone(100) >>>> --add=Switch-Zone(2) >>>> --add=Text("RSI (14)", 0, 100) >>>> --add=Curve(Indicators::RSI 14, [255,0,0]) >>>> --add=New-Zone(100) >>>> --add=Switch-Zone(3) >>>> --add=Text("MACD", 0, 100) >>>> --add=Curve(Indicators::MACD, [255,0,0]) >>>> >>>> >>>> >>>> >>>> ------------------------------**------------------------------** >>>> ------------ >>>> >>>> >>>> ------------------------------**------------------------------** >>>> ------------ >>>> >>>> >>>> ------------------------------**------------------------------** >>>> ------------ >>>> >>>> >>>> >>> ------------------------------**------------------------------** >>> ------------------ >>> >>> Keep yourself connected to Go Parallel: >>>> TUNE You got it built. Now make it sing. Tune shows you how. >>>> http://goparallel.sourceforge.**net <http://goparallel.sourceforge.net> >>>> >>>> >>>> ------------------------------**------------------------------** >>>> ------------ >>>> >>>> ______________________________**_________________ >>>> Geniustrader-system-traders mailing list >>>> >>> >>> well, what makes you think there is no MACD output -- looks to me like >>> the >>> plot worked fine -- but the values are very close to zero. >>> >>> what happens if you do something like >>> % display_indicator.pl --timeframe=day <<date range>> I:MACD 0773.HK >>> >>> note MACD has at 3 output values, you are plotting the default (e.g. >>> I:MACD/1) >>> (see various 'how to' on website, gt pod, etc on how to select one of >>> multiple indicator/signal values.) >>> >>> don't think you need to Switch-Zone unless you want to reselect it, >>> the New-Zone directive both creates and switches to it and according >>> my tests just now having this directive (Switch-Zone) does cause an >>> issue the zone scale settings. i suggest you remove all Switch-Zone >>> directives in the above simple gconf lists and *only* use it if you >>> want to go back to an already created and drawn on new zone. >>> >>> you might want to explicitly set the zone scale for each zone consistent >>> with the data being displayed in it. >>> >>> >>> ras >>> >>> >>> ------------------------------**------------------------------** >>> ------------------ >>> Keep yourself connected to Go Parallel: >>> TUNE You got it built. Now make it sing. Tune shows you how. >>> http://goparallel.sourceforge.**net <http://goparallel.sourceforge.net> >>> ______________________________**_________________ >>> Geniustrader-system-traders mailing list >>> >>> >> >> >> >> > -- Thomas G Lau Tel: 93239670 |
|
From: Thomas G. <lkt...@gm...> - 2012-11-30 15:05:39
|
What do you think if I write another script to insert daily data from a more reliable source into sqlite instead of rely on yahoo?! to be honest Yahoo is a poor data source all the time. On Fri, Nov 30, 2012 at 10:59 PM, Robert A. Schmied <ra...@ac...> wrote: > Thomas Graham wrote: > >> Robert, I found out this is a bug. >> >> Try this step to reproduce it: >> 1. beancounter backpopulate T --prevdate (Any date) --date 'today' >> 2. run scan.pl. works fine >> 3. beancounter update --forceupdate today >> > > oh yea! i avoid some beancounter commands completely, as it can, > will and does destroy ones database without any by-your-leave. > > the --forceupdate is especially dangerous as i recall. > > ok -- so things (gt) work if you have a valid database, correct? > > assuming that's a yes -- here's how i approach the stock prices issue: > here in states yahoo eod is usually complete by about 40 minutes after > nyse closing (4pm et) so i run 'beancounter update' from a crontab > entry at that time every market day -- determining market day is > another task in and of itself. > > then i have a number of gt crontab entries scheduled after the beancounter > eod update is complete. > > i've also hacked up a few beancounter database checkers that look > to see if data from yesterday is good and valid, if not i do yesterday > only backpop for that symbol. i also think i've got a terribly hacked > version of GT::DB::bean with logic that ensures the prices data is > 'reasonable' within the context expected in gt (high is highest, low > is lowest, etc). > > this latter feature can be implemented much more simply using the gt > GT::DB::genericdbi module and providing the appropriate sql query in > $HOME/.gt/options > > > >> >> tons of error: >> Use of uninitialized value $age in numeric gt (>) at >> /usr/share/perl5/Finance/**BeanCounter.pm line 1743. >> Overriding date for 0175.HK (GEELY AUTO) to 20121130 >> >> >> 4. ./scan.pl --timeframe=day --start=2012-07-26 --end=2012-11-26 >> /mnt/stocks/newstockscode.txt 2012-11-26 /mnt/trading/system.gt >> Use of uninitialized value $d in pattern match (m//) at ../GT/DateTime.pm >> line 284, <> line 4. >> Use of uninitialized value $m in subtraction (-) at ../GT/DateTime.pm line >> 285, <> line 4. >> >> >> > < big snip > > -- Thomas G Lau Tel: 93239670 |
|
From: Robert A. S. <ra...@ac...> - 2012-11-30 15:03:32
|
Thomas Graham wrote: > Hi Robert, how come it is not showing /1 result only ? > > ./display_indicator.pl --timeframe=day I:MACD/1 0001.HK > Calculating indicator MACD[12, 26, {I:Prices CLOSE}] ... > MACD[12, 26, {I:Prices CLOSE}][2012-09-10] = 0.6142 > MACDSignal[9, {I:Prices CLOSE}][2012-09-10] = 0.7731 > MACDDifference[12, 26, 9, {I:Prices CLOSE}][2012-09-10] = -0.158871278469423 good question! it may be broke. i'll look at it and get back to ya! ras > > > > On Fri, Nov 30, 2012 at 10:34 PM, Robert A. Schmied <ra...@ac...> wrote: > > >>Thomas Graham wrote: >> >>>Hi, >>> >>>I am testing Indicators::MACD, but no graph being generate at all. >>> >>>at the same time, I experiment other indicator which works pretty well. >>> >>>What went wrong here? >>> >>>scripts for ADX: >>>--title=Stock of %c >>>--add=Switch-Zone(0) >>>--add=Curve(Indicators::SMA 10, [255,0,0]) >>>--add=Curve(Indicators::SMA 20, [255,240,0]) >>>--add=Curve(Indicators::SMA 50, [194,198,236]) >>>--add=Curve(Indicators::SMA 100, [255,200,0]) >>>--add=Curve(Indicators::SMA 150, [255,175,175]) >>>--add=New-Zone(100) >>>--add=Switch-Zone(2) >>>--add=Text("RSI (14)", 0, 100) >>>--add=Curve(Indicators::RSI 14, [255,0,0]) >>>--add=New-Zone(100) >>>--add=Switch-Zone(3) >>>--add=Text("ADX", 0, 100) >>>--add=Curve(Indicators::ADX, [255,0,0]) >>> >>> >>>Scripts for MACD: >>>--title=Stock of %c >>>--add=Switch-Zone(0) >>>--add=Curve(Indicators::SMA 10, [255,0,0]) >>>--add=Curve(Indicators::SMA 20, [255,240,0]) >>>--add=Curve(Indicators::SMA 50, [194,198,236]) >>>--add=Curve(Indicators::SMA 100, [255,200,0]) >>>--add=Curve(Indicators::SMA 150, [255,175,175]) >>>--add=New-Zone(100) >>>--add=Switch-Zone(2) >>>--add=Text("RSI (14)", 0, 100) >>>--add=Curve(Indicators::RSI 14, [255,0,0]) >>>--add=New-Zone(100) >>>--add=Switch-Zone(3) >>>--add=Text("MACD", 0, 100) >>>--add=Curve(Indicators::MACD, [255,0,0]) >>> >>> >>> >>> >>>------------------------------------------------------------------------ >>> >>> >>>------------------------------------------------------------------------ >>> >>> >>>------------------------------------------------------------------------ >>> >>> >> >>------------------------------------------------------------------------------ >> >>>Keep yourself connected to Go Parallel: >>>TUNE You got it built. Now make it sing. Tune shows you how. >>>http://goparallel.sourceforge.net >>> >>> >>>------------------------------------------------------------------------ >>> >>>_______________________________________________ >>>Geniustrader-system-traders mailing list >> >>well, what makes you think there is no MACD output -- looks to me like the >>plot worked fine -- but the values are very close to zero. >> >>what happens if you do something like >> % display_indicator.pl --timeframe=day <<date range>> I:MACD 0773.HK >> >>note MACD has at 3 output values, you are plotting the default (e.g. >>I:MACD/1) >>(see various 'how to' on website, gt pod, etc on how to select one of >>multiple indicator/signal values.) >> >>don't think you need to Switch-Zone unless you want to reselect it, >>the New-Zone directive both creates and switches to it and according >>my tests just now having this directive (Switch-Zone) does cause an >>issue the zone scale settings. i suggest you remove all Switch-Zone >>directives in the above simple gconf lists and *only* use it if you >>want to go back to an already created and drawn on new zone. >> >>you might want to explicitly set the zone scale for each zone consistent >>with the data being displayed in it. >> >> >>ras >> >> >>------------------------------------------------------------------------------ >>Keep yourself connected to Go Parallel: >>TUNE You got it built. Now make it sing. Tune shows you how. >>http://goparallel.sourceforge.net >>_______________________________________________ >>Geniustrader-system-traders mailing list >> > > > > |
|
From: Robert A. S. <ra...@ac...> - 2012-11-30 14:59:55
|
Thomas Graham wrote: > Robert, I found out this is a bug. > > Try this step to reproduce it: > 1. beancounter backpopulate T --prevdate (Any date) --date 'today' > 2. run scan.pl. works fine > 3. beancounter update --forceupdate today oh yea! i avoid some beancounter commands completely, as it can, will and does destroy ones database without any by-your-leave. the --forceupdate is especially dangerous as i recall. ok -- so things (gt) work if you have a valid database, correct? assuming that's a yes -- here's how i approach the stock prices issue: here in states yahoo eod is usually complete by about 40 minutes after nyse closing (4pm et) so i run 'beancounter update' from a crontab entry at that time every market day -- determining market day is another task in and of itself. then i have a number of gt crontab entries scheduled after the beancounter eod update is complete. i've also hacked up a few beancounter database checkers that look to see if data from yesterday is good and valid, if not i do yesterday only backpop for that symbol. i also think i've got a terribly hacked version of GT::DB::bean with logic that ensures the prices data is 'reasonable' within the context expected in gt (high is highest, low is lowest, etc). this latter feature can be implemented much more simply using the gt GT::DB::genericdbi module and providing the appropriate sql query in $HOME/.gt/options > > > tons of error: > Use of uninitialized value $age in numeric gt (>) at > /usr/share/perl5/Finance/BeanCounter.pm line 1743. > Overriding date for 0175.HK (GEELY AUTO) to 20121130 > > > 4. ./scan.pl --timeframe=day --start=2012-07-26 --end=2012-11-26 > /mnt/stocks/newstockscode.txt 2012-11-26 /mnt/trading/system.gt > Use of uninitialized value $d in pattern match (m//) at ../GT/DateTime.pm > line 284, <> line 4. > Use of uninitialized value $m in subtraction (-) at ../GT/DateTime.pm line > 285, <> line 4. > > < big snip > |
|
From: Thomas G. <lkt...@gm...> - 2012-11-30 14:40:49
|
Hi Robert, how come it is not showing /1 result only ? ./display_indicator.pl --timeframe=day I:MACD/1 0001.HK Calculating indicator MACD[12, 26, {I:Prices CLOSE}] ... MACD[12, 26, {I:Prices CLOSE}][2012-09-10] = 0.6142 MACDSignal[9, {I:Prices CLOSE}][2012-09-10] = 0.7731 MACDDifference[12, 26, 9, {I:Prices CLOSE}][2012-09-10] = -0.158871278469423 On Fri, Nov 30, 2012 at 10:34 PM, Robert A. Schmied <ra...@ac...> wrote: > Thomas Graham wrote: > > Hi, > > > > I am testing Indicators::MACD, but no graph being generate at all. > > > > at the same time, I experiment other indicator which works pretty well. > > > > What went wrong here? > > > > scripts for ADX: > > --title=Stock of %c > > --add=Switch-Zone(0) > > --add=Curve(Indicators::SMA 10, [255,0,0]) > > --add=Curve(Indicators::SMA 20, [255,240,0]) > > --add=Curve(Indicators::SMA 50, [194,198,236]) > > --add=Curve(Indicators::SMA 100, [255,200,0]) > > --add=Curve(Indicators::SMA 150, [255,175,175]) > > --add=New-Zone(100) > > --add=Switch-Zone(2) > > --add=Text("RSI (14)", 0, 100) > > --add=Curve(Indicators::RSI 14, [255,0,0]) > > --add=New-Zone(100) > > --add=Switch-Zone(3) > > --add=Text("ADX", 0, 100) > > --add=Curve(Indicators::ADX, [255,0,0]) > > > > > > Scripts for MACD: > > --title=Stock of %c > > --add=Switch-Zone(0) > > --add=Curve(Indicators::SMA 10, [255,0,0]) > > --add=Curve(Indicators::SMA 20, [255,240,0]) > > --add=Curve(Indicators::SMA 50, [194,198,236]) > > --add=Curve(Indicators::SMA 100, [255,200,0]) > > --add=Curve(Indicators::SMA 150, [255,175,175]) > > --add=New-Zone(100) > > --add=Switch-Zone(2) > > --add=Text("RSI (14)", 0, 100) > > --add=Curve(Indicators::RSI 14, [255,0,0]) > > --add=New-Zone(100) > > --add=Switch-Zone(3) > > --add=Text("MACD", 0, 100) > > --add=Curve(Indicators::MACD, [255,0,0]) > > > > > > > > > > ------------------------------------------------------------------------ > > > > > > ------------------------------------------------------------------------ > > > > > > ------------------------------------------------------------------------ > > > > > ------------------------------------------------------------------------------ > > Keep yourself connected to Go Parallel: > > TUNE You got it built. Now make it sing. Tune shows you how. > > http://goparallel.sourceforge.net > > > > > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > Geniustrader-system-traders mailing list > > well, what makes you think there is no MACD output -- looks to me like the > plot worked fine -- but the values are very close to zero. > > what happens if you do something like > % display_indicator.pl --timeframe=day <<date range>> I:MACD 0773.HK > > note MACD has at 3 output values, you are plotting the default (e.g. > I:MACD/1) > (see various 'how to' on website, gt pod, etc on how to select one of > multiple indicator/signal values.) > > don't think you need to Switch-Zone unless you want to reselect it, > the New-Zone directive both creates and switches to it and according > my tests just now having this directive (Switch-Zone) does cause an > issue the zone scale settings. i suggest you remove all Switch-Zone > directives in the above simple gconf lists and *only* use it if you > want to go back to an already created and drawn on new zone. > > you might want to explicitly set the zone scale for each zone consistent > with the data being displayed in it. > > > ras > > > ------------------------------------------------------------------------------ > Keep yourself connected to Go Parallel: > TUNE You got it built. Now make it sing. Tune shows you how. > http://goparallel.sourceforge.net > _______________________________________________ > Geniustrader-system-traders mailing list > -- Thomas G Lau Tel: 93239670 |
|
From: Robert A. S. <ra...@ac...> - 2012-11-30 14:34:42
|
Thomas Graham wrote:
> Hi,
>
> I am testing Indicators::MACD, but no graph being generate at all.
>
> at the same time, I experiment other indicator which works pretty well.
>
> What went wrong here?
>
> scripts for ADX:
> --title=Stock of %c
> --add=Switch-Zone(0)
> --add=Curve(Indicators::SMA 10, [255,0,0])
> --add=Curve(Indicators::SMA 20, [255,240,0])
> --add=Curve(Indicators::SMA 50, [194,198,236])
> --add=Curve(Indicators::SMA 100, [255,200,0])
> --add=Curve(Indicators::SMA 150, [255,175,175])
> --add=New-Zone(100)
> --add=Switch-Zone(2)
> --add=Text("RSI (14)", 0, 100)
> --add=Curve(Indicators::RSI 14, [255,0,0])
> --add=New-Zone(100)
> --add=Switch-Zone(3)
> --add=Text("ADX", 0, 100)
> --add=Curve(Indicators::ADX, [255,0,0])
>
>
> Scripts for MACD:
> --title=Stock of %c
> --add=Switch-Zone(0)
> --add=Curve(Indicators::SMA 10, [255,0,0])
> --add=Curve(Indicators::SMA 20, [255,240,0])
> --add=Curve(Indicators::SMA 50, [194,198,236])
> --add=Curve(Indicators::SMA 100, [255,200,0])
> --add=Curve(Indicators::SMA 150, [255,175,175])
> --add=New-Zone(100)
> --add=Switch-Zone(2)
> --add=Text("RSI (14)", 0, 100)
> --add=Curve(Indicators::RSI 14, [255,0,0])
> --add=New-Zone(100)
> --add=Switch-Zone(3)
> --add=Text("MACD", 0, 100)
> --add=Curve(Indicators::MACD, [255,0,0])
>
>
>
>
> ------------------------------------------------------------------------
>
>
> ------------------------------------------------------------------------
>
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> Keep yourself connected to Go Parallel:
> TUNE You got it built. Now make it sing. Tune shows you how.
> http://goparallel.sourceforge.net
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Geniustrader-system-traders mailing list
well, what makes you think there is no MACD output -- looks to me like the
plot worked fine -- but the values are very close to zero.
what happens if you do something like
% display_indicator.pl --timeframe=day <<date range>> I:MACD 0773.HK
note MACD has at 3 output values, you are plotting the default (e.g. I:MACD/1)
(see various 'how to' on website, gt pod, etc on how to select one of
multiple indicator/signal values.)
don't think you need to Switch-Zone unless you want to reselect it,
the New-Zone directive both creates and switches to it and according
my tests just now having this directive (Switch-Zone) does cause an
issue the zone scale settings. i suggest you remove all Switch-Zone
directives in the above simple gconf lists and *only* use it if you
want to go back to an already created and drawn on new zone.
you might want to explicitly set the zone scale for each zone consistent
with the data being displayed in it.
ras
|
|
From: Thomas G. <lkt...@gm...> - 2012-11-30 13:55:46
|
one step forward, I found data in DB is the cause of problem, check the compare between yesterday and today data in the current DB: sqlite> select * from stockprices where symbol = '0590.HK' AND date = '2012-11-30'; 0590.HK|2012-11-30|23.15|23.0|22.2|23.45|23.25|0.1|23.2|23.25|5979040 sqlite> select * from stockprices where symbol = '0590.HK' AND date = '2012-11-29'; 0590.HK|2012-11-29||21.5|21.4|23.45|23.15||||18117100 On Fri, Nov 30, 2012 at 9:47 PM, Thomas Graham <lkt...@gm...> wrote: > Robert, I found out this is a bug. > > Try this step to reproduce it: > 1. beancounter backpopulate T --prevdate (Any date) --date 'today' > 2. run scan.pl. works fine > 3. beancounter update --forceupdate today > > > tons of error: > Use of uninitialized value $age in numeric gt (>) at > /usr/share/perl5/Finance/BeanCounter.pm line 1743. > Overriding date for 0175.HK (GEELY AUTO) to 20121130 > > > 4. ./scan.pl --timeframe=day --start=2012-07-26 --end=2012-11-26 > /mnt/stocks/newstockscode.txt 2012-11-26 /mnt/trading/system.gt > Use of uninitialized value $d in pattern match (m//) at > ../GT/DateTime.pm line 284, <> line 4. > Use of uninitialized value $m in subtraction (-) at ../GT/DateTime.pm line > 285, <> line 4. > > > > On Fri, Nov 30, 2012 at 9:24 PM, Robert A. Schmied <ra...@ac...> wrote: > >> aloha thomas >> >> thanks for the cc -- the list is not forwarding things correctly >> >> >> Thomas Graham wrote: >> >>> Another problem after this: >>> $ ./scan.pl --timeframe=day --start=2012-01-26 --end=2012-11-26 >>> /mnt/stocks/newstockscode.txt 2012-11-26 /mnt/trading/system.gt >>> Use of uninitialized value $d in pattern match (m//) at ../GT/DateTime.pm >>> line 284, <> line 5. >>> Use of uninitialized value $m in subtraction (-) at ../GT/DateTime.pm >>> line >>> 285, <> line 5. >>> Month '-1' out of range 0..11 at ../GT/DateTime.pm line 285 >>> Use of uninitialized value $d in pattern match (m//) at ../GT/DateTime.pm >>> line 284, <> line 5. >>> Use of uninitialized value $m in subtraction (-) at ../GT/DateTime.pm >>> line >>> 285, <> line 5. >>> >>> >>> >> this sort of warnings indicate a problem with the values being supplied >> from >> the prices database source. >> >> <snip> >> >> >>>> Thomas Graham wrote: >>>>> >>>>> >>>>> sqlite> .tables >>>>>> beancounter fxprices portfolio stockprices >>>>>> cash indices stockinfo >>>>>> >>>>>> >>>>>> sqlite> select * from stockprices where symbol='0001.HK'; >>>>>> 0001.HK >>>>>> |2012-08-08||109.168546617916|****106.979204753199|109.** >>>>>> 268062157221|108.87||||4971300 >>>>>> 0001.HK >>>>>> |2012-08-09||109.266318631863|****108.967776777678|110.** >>>>>> 858541854185|110.56||||7319600 >>>>>> 0001.HK >>>>>> |2012-08-10||109.763678899083|****107.474862385321|110.** >>>>>> 36076146789|108.47||||5611200 >>>>>> 0001.HK >>>>>> |2012-08-13||109.967106460419|****109.071446769791|111.** >>>>>> 161319381256|109.37||||6163000 >>>>>> >>>>>> >> humm -- the fields with the asterisks look strange or are the asterisk >> pairs >> some sort of email/gmail escaping -- i see them in the font paths below >> too >> >> my postgresql beancounter tuple fields are: >> >> symbol | date | previous_close | day_open | day_low | day_high | >> day_close | day_change | bid | ask | volume >> gt only uses 'symbol | date | day_open | day_low | day_high | day_close | >> volume' >> if i remember correctly. >> if the asterisks are really entered in the db it looks like your prices >> source for 0001.HK is feeding things beancounter and/or yahooquote cannot >> correctly parse and archive. >> >> interesting. 0001.HK here in states returns what looks to be reasonable >> data >> >> >> does your prices database include data for all dates in your date range? >> --start=2012-01-26 --end=2012-11-26 >> many times missing price data can manifest itself in very strange behavior >> and or messages. >> >> what happens if you try a very simple graphic.pl chart for 0001.HK with >> this same date range? >> % graphic.pl --start=2012-01-26 --end=2012-11-26 0001.HK>/tmp/tg_0001.hk.png >> >> ras >> >> >>>>>> ~/.gt/options >>>>>> DB::module bean >>>>>> DB::bean::dbname /mnt/trading/stocks.db >>>>>> DB::bean::db SQLite >>>>>> Path::Font::Arial /usr/share/fonts/truetype/**** >>>>>> msttcorefonts/arial.ttf >>>>>> Path::Font::Courier /usr/share/fonts/truetype/**** >>>>>> msttcorefonts/couri.ttf >>>>>> Path::Font::Times /usr/share/fonts/truetype/**** >>>>>> msttcorefonts/times.ttf >>>>>> >>>>>> >>>>>> >>>>> >> << big snip >> >> >> >> > > > -- > Thomas G Lau > Tel: 93239670 > -- Thomas G Lau Tel: 93239670 |
|
From: Thomas G. <lkt...@gm...> - 2012-11-30 13:48:37
|
Robert, I found out this is a bug. Try this step to reproduce it: 1. beancounter backpopulate T --prevdate (Any date) --date 'today' 2. run scan.pl. works fine 3. beancounter update --forceupdate today tons of error: Use of uninitialized value $age in numeric gt (>) at /usr/share/perl5/Finance/BeanCounter.pm line 1743. Overriding date for 0175.HK (GEELY AUTO) to 20121130 4. ./scan.pl --timeframe=day --start=2012-07-26 --end=2012-11-26 /mnt/stocks/newstockscode.txt 2012-11-26 /mnt/trading/system.gt Use of uninitialized value $d in pattern match (m//) at ../GT/DateTime.pm line 284, <> line 4. Use of uninitialized value $m in subtraction (-) at ../GT/DateTime.pm line 285, <> line 4. On Fri, Nov 30, 2012 at 9:24 PM, Robert A. Schmied <ra...@ac...> wrote: > aloha thomas > > thanks for the cc -- the list is not forwarding things correctly > > > Thomas Graham wrote: > >> Another problem after this: >> $ ./scan.pl --timeframe=day --start=2012-01-26 --end=2012-11-26 >> /mnt/stocks/newstockscode.txt 2012-11-26 /mnt/trading/system.gt >> Use of uninitialized value $d in pattern match (m//) at ../GT/DateTime.pm >> line 284, <> line 5. >> Use of uninitialized value $m in subtraction (-) at ../GT/DateTime.pm line >> 285, <> line 5. >> Month '-1' out of range 0..11 at ../GT/DateTime.pm line 285 >> Use of uninitialized value $d in pattern match (m//) at ../GT/DateTime.pm >> line 284, <> line 5. >> Use of uninitialized value $m in subtraction (-) at ../GT/DateTime.pm line >> 285, <> line 5. >> >> >> > this sort of warnings indicate a problem with the values being supplied > from > the prices database source. > > <snip> > > >>> Thomas Graham wrote: >>>> >>>> >>>> sqlite> .tables >>>>> beancounter fxprices portfolio stockprices >>>>> cash indices stockinfo >>>>> >>>>> >>>>> sqlite> select * from stockprices where symbol='0001.HK'; >>>>> 0001.HK >>>>> |2012-08-08||109.168546617916|****106.979204753199|109.** >>>>> 268062157221|108.87||||4971300 >>>>> 0001.HK >>>>> |2012-08-09||109.266318631863|****108.967776777678|110.** >>>>> 858541854185|110.56||||7319600 >>>>> 0001.HK >>>>> |2012-08-10||109.763678899083|****107.474862385321|110.** >>>>> 36076146789|108.47||||5611200 >>>>> 0001.HK >>>>> |2012-08-13||109.967106460419|****109.071446769791|111.** >>>>> 161319381256|109.37||||6163000 >>>>> >>>>> > humm -- the fields with the asterisks look strange or are the asterisk > pairs > some sort of email/gmail escaping -- i see them in the font paths below too > > my postgresql beancounter tuple fields are: > > symbol | date | previous_close | day_open | day_low | day_high | > day_close | day_change | bid | ask | volume > gt only uses 'symbol | date | day_open | day_low | day_high | day_close | > volume' > if i remember correctly. > if the asterisks are really entered in the db it looks like your prices > source for 0001.HK is feeding things beancounter and/or yahooquote cannot > correctly parse and archive. > > interesting. 0001.HK here in states returns what looks to be reasonable > data > > > does your prices database include data for all dates in your date range? > --start=2012-01-26 --end=2012-11-26 > many times missing price data can manifest itself in very strange behavior > and or messages. > > what happens if you try a very simple graphic.pl chart for 0001.HK with > this same date range? > % graphic.pl --start=2012-01-26 --end=2012-11-26 0001.HK>/tmp/tg_0001.hk.png > > ras > > >>>>> ~/.gt/options >>>>> DB::module bean >>>>> DB::bean::dbname /mnt/trading/stocks.db >>>>> DB::bean::db SQLite >>>>> Path::Font::Arial /usr/share/fonts/truetype/**** >>>>> msttcorefonts/arial.ttf >>>>> Path::Font::Courier /usr/share/fonts/truetype/**** >>>>> msttcorefonts/couri.ttf >>>>> Path::Font::Times /usr/share/fonts/truetype/**** >>>>> msttcorefonts/times.ttf >>>>> >>>>> >>>>> >>>> > << big snip >> > > > -- Thomas G Lau Tel: 93239670 |
|
From: Robert A. S. <ra...@ac...> - 2012-11-30 13:27:36
|
Thomas Graham wrote: > Hi all, > > I realize that Yahoo EOD data does not shows using Yahoo API until next > morning. > > and I have a way to find out each stocks today EOD data. How could I insert > them into beancounter database ? or should I write a beancounter plugin ?! thomas -- this topic is one for the geniustrader-devel message list. if you search that list i suspect you will find some hints as to how to proceed. ras > > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------------ > Keep yourself connected to Go Parallel: > TUNE You got it built. Now make it sing. Tune shows you how. > http://goparallel.sourceforge.net > > > ------------------------------------------------------------------------ > > _______________________________________________ > Geniustrader-system-traders mailing list |
|
From: Robert A. S. <ra...@ac...> - 2012-11-30 13:24:35
|
aloha thomas thanks for the cc -- the list is not forwarding things correctly Thomas Graham wrote: > Another problem after this: > $ ./scan.pl --timeframe=day --start=2012-01-26 --end=2012-11-26 > /mnt/stocks/newstockscode.txt 2012-11-26 /mnt/trading/system.gt > Use of uninitialized value $d in pattern match (m//) at ../GT/DateTime.pm > line 284, <> line 5. > Use of uninitialized value $m in subtraction (-) at ../GT/DateTime.pm line > 285, <> line 5. > Month '-1' out of range 0..11 at ../GT/DateTime.pm line 285 > Use of uninitialized value $d in pattern match (m//) at ../GT/DateTime.pm > line 284, <> line 5. > Use of uninitialized value $m in subtraction (-) at ../GT/DateTime.pm line > 285, <> line 5. > > this sort of warnings indicate a problem with the values being supplied from the prices database source. <snip> >> >>>Thomas Graham wrote: >>> >>> >>>>sqlite> .tables >>>>beancounter fxprices portfolio stockprices >>>>cash indices stockinfo >>>> >>>> >>>>sqlite> select * from stockprices where symbol='0001.HK'; >>>>0001.HK >>>>|2012-08-08||109.168546617916|**106.979204753199|109.** >>>>268062157221|108.87||||4971300 >>>>0001.HK >>>>|2012-08-09||109.266318631863|**108.967776777678|110.** >>>>858541854185|110.56||||7319600 >>>>0001.HK >>>>|2012-08-10||109.763678899083|**107.474862385321|110.** >>>>36076146789|108.47||||5611200 >>>>0001.HK >>>>|2012-08-13||109.967106460419|**109.071446769791|111.** >>>>161319381256|109.37||||6163000 >>>> humm -- the fields with the asterisks look strange or are the asterisk pairs some sort of email/gmail escaping -- i see them in the font paths below too my postgresql beancounter tuple fields are: symbol | date | previous_close | day_open | day_low | day_high | day_close | day_change | bid | ask | volume gt only uses 'symbol | date | day_open | day_low | day_high | day_close | volume' if i remember correctly. if the asterisks are really entered in the db it looks like your prices source for 0001.HK is feeding things beancounter and/or yahooquote cannot correctly parse and archive. interesting. 0001.HK here in states returns what looks to be reasonable data does your prices database include data for all dates in your date range? --start=2012-01-26 --end=2012-11-26 many times missing price data can manifest itself in very strange behavior and or messages. what happens if you try a very simple graphic.pl chart for 0001.HK with this same date range? % graphic.pl --start=2012-01-26 --end=2012-11-26 0001.HK >/tmp/tg_0001.hk.png ras >>>> >>>>~/.gt/options >>>>DB::module bean >>>>DB::bean::dbname /mnt/trading/stocks.db >>>>DB::bean::db SQLite >>>>Path::Font::Arial /usr/share/fonts/truetype/**msttcorefonts/arial.ttf >>>>Path::Font::Courier /usr/share/fonts/truetype/**msttcorefonts/couri.ttf >>>>Path::Font::Times /usr/share/fonts/truetype/**msttcorefonts/times.ttf >>>> >>>> >>> << big snip >> |
|
From: Thomas G. <lkt...@gm...> - 2012-11-30 11:07:31
|
Another problem after this: $ ./scan.pl --timeframe=day --start=2012-01-26 --end=2012-11-26 /mnt/stocks/newstockscode.txt 2012-11-26 /mnt/trading/system.gt Use of uninitialized value $d in pattern match (m//) at ../GT/DateTime.pm line 284, <> line 5. Use of uninitialized value $m in subtraction (-) at ../GT/DateTime.pm line 285, <> line 5. Month '-1' out of range 0..11 at ../GT/DateTime.pm line 285 Use of uninitialized value $d in pattern match (m//) at ../GT/DateTime.pm line 284, <> line 5. Use of uninitialized value $m in subtraction (-) at ../GT/DateTime.pm line 285, <> line 5. On Fri, Nov 30, 2012 at 9:21 AM, Thomas Graham <lkt...@gm...> wrote: > Robert, thanks for helping. > > Here is sqlite: > SQLite version 3.7.13 2012-06-11 02:05:22 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> .help > .backup ?DB? FILE Backup DB (default "main") to FILE > .bail ON|OFF Stop after hitting an error. Default OFF > .databases List names and files of attached databases > .dump ?TABLE? ... Dump the database in an SQL text format > If TABLE specified, only dump tables matching > LIKE pattern TABLE. > .echo ON|OFF Turn command echo on or off > .exit Exit this program > .explain ?ON|OFF? Turn output mode suitable for EXPLAIN on or off. > With no args, it turns EXPLAIN on. > .header(s) ON|OFF Turn display of headers on or off > .help Show this message > .import FILE TABLE Import data from FILE into TABLE > .indices ?TABLE? Show names of all indices > If TABLE specified, only show indices for tables > matching LIKE pattern TABLE. > .load FILE ?ENTRY? Load an extension library > .log FILE|off Turn logging on or off. FILE can be stderr/stdout > .mode MODE ?TABLE? Set output mode where MODE is one of: > csv Comma-separated values > column Left-aligned columns. (See .width) > html HTML <table> code > insert SQL insert statements for TABLE > line One value per line > list Values delimited by .separator string > tabs Tab-separated values > tcl TCL list elements > .nullvalue STRING Print STRING in place of NULL values > .output FILENAME Send output to FILENAME > .output stdout Send output to the screen > .prompt MAIN CONTINUE Replace the standard prompts > .quit Exit this program > .read FILENAME Execute SQL in FILENAME > .restore ?DB? FILE Restore content of DB (default "main") from FILE > .schema ?TABLE? Show the CREATE statements > If TABLE specified, only show tables matching > LIKE pattern TABLE. > .separator STRING Change separator used by output mode and .import > .show Show the current values for various settings > .stats ON|OFF Turn stats on or off > .tables ?TABLE? List names of tables > If TABLE specified, only list tables matching > LIKE pattern TABLE. > .timeout MS Try opening locked tables for MS milliseconds > .trace FILE|off Output each SQL statement as it is run > .vfsname ?AUX? Print the name of the VFS stack > .width NUM1 NUM2 ... Set column widths for "column" mode > .timer ON|OFF Turn the CPU timer measurement on or off > > > I am posting another question. Stay tune :) > > > On Thu, Nov 29, 2012 at 9:20 PM, Robert A. Schmied <ra...@ac...> wrote: > >> Thomas Graham wrote: >> >>> sqlite> .tables >>> beancounter fxprices portfolio stockprices >>> cash indices stockinfo >>> >>> >>> sqlite> select * from stockprices where symbol='0001.HK'; >>> 0001.HK >>> |2012-08-08||109.168546617916|**106.979204753199|109.** >>> 268062157221|108.87||||4971300 >>> 0001.HK >>> |2012-08-09||109.266318631863|**108.967776777678|110.** >>> 858541854185|110.56||||7319600 >>> 0001.HK >>> |2012-08-10||109.763678899083|**107.474862385321|110.** >>> 36076146789|108.47||||5611200 >>> 0001.HK >>> |2012-08-13||109.967106460419|**109.071446769791|111.** >>> 161319381256|109.37||||6163000 >>> >>> >>> ~/.gt/options >>> DB::module bean >>> DB::bean::dbname /mnt/trading/stocks.db >>> DB::bean::db SQLite >>> Path::Font::Arial /usr/share/fonts/truetype/**msttcorefonts/arial.ttf >>> Path::Font::Courier /usr/share/fonts/truetype/**msttcorefonts/couri.ttf >>> Path::Font::Times /usr/share/fonts/truetype/**msttcorefonts/times.ttf >>> >>> >> options looks fine. and so does your bc db. >> >> >> the upper case requirement is actually a database imposed requirement, >> that's the way (upcased) symbols are being added to the database. >> >> in many of my hacks to gt script apps i tend to >> upcase codes because i'm a poor and lazy typist >> ... but maybe not in any of the versions on the >> trunk-head. seems not everyone is as poor and as lazy >> as i am when typing. >> >> ok. so now we (you) have a known working beancounter database as >> demonstrated >> above. just so i'm on the same configuration can you send me the output >> from: >> % sqlite >> sqlite> .help >> >> that will print the sqlite version. >> >> in a later message Thomas Graham will write: >> >>> perl display_indicator.pl --verbose --timeframe=day --start=2012-10-29 >>> >>> --end=2012-11-26 I:Prices 0001.HK CLOSE >>> Unknown option: verbose >>> Calculating indicator Prices[CLOSE] ... >>> Prices[CLOSE] [2012-10-29] = 112.3000 >>> Prices[CLOSE] [2012-10-30] = 112.2000 >>> Prices[CLOSE] [2012-10-31] = 114.5000 >>> Prices[CLOSE] [2012-11-01] = 115.0000 >>> Prices[CLOSE] [2012-11-02] = 115.8000 >>> Prices[CLOSE] [2012-11-05] = 115.6000 >>> Prices[CLOSE] [2012-11-06] = 115.5000 >>> Prices[CLOSE] [2012-11-07] = 116.1000 >>> Prices[CLOSE] [2012-11-08] = 113.5000 >>> Prices[CLOSE] [2012-11-09] = 112.9000 >>> Prices[CLOSE] [2012-11-12] = 114.4000 >>> Prices[CLOSE] [2012-11-13] = 112.5000 >>> Prices[CLOSE] [2012-11-14] = 113.7000 >>> Prices[CLOSE] [2012-11-15] = 112.6000 >>> Prices[CLOSE] [2012-11-16] = 112.4000 >>> Prices[CLOSE] [2012-11-19] = 113.7000 >>> Prices[CLOSE] [2012-11-20] = 113.2000 >>> Prices[CLOSE] [2012-11-21] = 113.7000 >>> Prices[CLOSE] [2012-11-22] = 116.2000 >>> Prices[CLOSE] [2012-11-23] = 117.3000 >>> Prices[CLOSE] [2012-11-26] = 117.2000 >>> >>> >>> >>> >> and the above gt script app demonstrating the gt-bc interface >> is also working. >> >> so back to the issue at hand: with a very simple market file consisting >> of one line containing one code: >> 0001.HK >> >> does scan.pl work? >> ./scan.pl --timeframe=year --start=2012-08-26 --end=2012-11-26 >> /mnt/stocks/hk001stockscode.**mkt 2012-11-25 /mnt/trading/system.gt >> >> >> i'll assume we are getting very close and will take the time to make a >> couple of pointed comments about the date ranges on the command app and >> the issue with them with respect to the sys-sig-indic description: >> >> S:Generic:And \ >> {S:Generic:Above {I:Prices} {I:SMA 20}} {S:Generic:Above {I:Prices} >> {I:SMA 50}} \ >> {S:Generic:Above {I:Prices} {I:SMA 100}} {S:Generic:Above {I:Prices} >> {I:SMA 150}} >> >> >> note your date range is about 3 months or about 66 trading days, but >> your sys-sig-indic desc is trying to run I:SMA with time-periods including >> 100 and 150. you will probably find differing signal results if you run >> with a larger input data range. it might not be enough to make a >> difference >> but something to take note of. >> >> this sort of issue can be explored using the three 3 display_\*.pl script >> apps. the downside is you will have to craft individual sys-sig-indic desc >> specifically for each of the three scripts, display_indicator.pl will >> only >> deal with indicators, display_signal.pl only signals and >> display_system.pl >> may not work well enough to be of much help in this particular case, but >> is there for exploration and study. >> >> hopefully you are well on you way to start exploring gt. >> >> aloha >> >> ras >> > > > > -- > Thomas G Lau > Tel: 93239670 > -- Thomas G Lau Tel: 93239670 |
|
From: Thomas G. <lkt...@gm...> - 2012-11-30 01:29:54
|
Hi all, I realize that Yahoo EOD data does not shows using Yahoo API until next morning. and I have a way to find out each stocks today EOD data. How could I insert them into beancounter database ? or should I write a beancounter plugin ?! -- Thomas G Lau Tel: 93239670 |
|
From: Thomas G. <lkt...@gm...> - 2012-11-30 01:22:10
|
Robert, thanks for helping.
Here is sqlite:
SQLite version 3.7.13 2012-06-11 02:05:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .help
.backup ?DB? FILE Backup DB (default "main") to FILE
.bail ON|OFF Stop after hitting an error. Default OFF
.databases List names and files of attached databases
.dump ?TABLE? ... Dump the database in an SQL text format
If TABLE specified, only dump tables matching
LIKE pattern TABLE.
.echo ON|OFF Turn command echo on or off
.exit Exit this program
.explain ?ON|OFF? Turn output mode suitable for EXPLAIN on or off.
With no args, it turns EXPLAIN on.
.header(s) ON|OFF Turn display of headers on or off
.help Show this message
.import FILE TABLE Import data from FILE into TABLE
.indices ?TABLE? Show names of all indices
If TABLE specified, only show indices for tables
matching LIKE pattern TABLE.
.load FILE ?ENTRY? Load an extension library
.log FILE|off Turn logging on or off. FILE can be stderr/stdout
.mode MODE ?TABLE? Set output mode where MODE is one of:
csv Comma-separated values
column Left-aligned columns. (See .width)
html HTML <table> code
insert SQL insert statements for TABLE
line One value per line
list Values delimited by .separator string
tabs Tab-separated values
tcl TCL list elements
.nullvalue STRING Print STRING in place of NULL values
.output FILENAME Send output to FILENAME
.output stdout Send output to the screen
.prompt MAIN CONTINUE Replace the standard prompts
.quit Exit this program
.read FILENAME Execute SQL in FILENAME
.restore ?DB? FILE Restore content of DB (default "main") from FILE
.schema ?TABLE? Show the CREATE statements
If TABLE specified, only show tables matching
LIKE pattern TABLE.
.separator STRING Change separator used by output mode and .import
.show Show the current values for various settings
.stats ON|OFF Turn stats on or off
.tables ?TABLE? List names of tables
If TABLE specified, only list tables matching
LIKE pattern TABLE.
.timeout MS Try opening locked tables for MS milliseconds
.trace FILE|off Output each SQL statement as it is run
.vfsname ?AUX? Print the name of the VFS stack
.width NUM1 NUM2 ... Set column widths for "column" mode
.timer ON|OFF Turn the CPU timer measurement on or off
I am posting another question. Stay tune :)
On Thu, Nov 29, 2012 at 9:20 PM, Robert A. Schmied <ra...@ac...> wrote:
> Thomas Graham wrote:
>
>> sqlite> .tables
>> beancounter fxprices portfolio stockprices
>> cash indices stockinfo
>>
>>
>> sqlite> select * from stockprices where symbol='0001.HK';
>> 0001.HK
>> |2012-08-08||109.168546617916|**106.979204753199|109.**
>> 268062157221|108.87||||4971300
>> 0001.HK
>> |2012-08-09||109.266318631863|**108.967776777678|110.**
>> 858541854185|110.56||||7319600
>> 0001.HK
>> |2012-08-10||109.763678899083|**107.474862385321|110.**
>> 36076146789|108.47||||5611200
>> 0001.HK
>> |2012-08-13||109.967106460419|**109.071446769791|111.**
>> 161319381256|109.37||||6163000
>>
>>
>> ~/.gt/options
>> DB::module bean
>> DB::bean::dbname /mnt/trading/stocks.db
>> DB::bean::db SQLite
>> Path::Font::Arial /usr/share/fonts/truetype/**msttcorefonts/arial.ttf
>> Path::Font::Courier /usr/share/fonts/truetype/**msttcorefonts/couri.ttf
>> Path::Font::Times /usr/share/fonts/truetype/**msttcorefonts/times.ttf
>>
>>
> options looks fine. and so does your bc db.
>
>
> the upper case requirement is actually a database imposed requirement,
> that's the way (upcased) symbols are being added to the database.
>
> in many of my hacks to gt script apps i tend to
> upcase codes because i'm a poor and lazy typist
> ... but maybe not in any of the versions on the
> trunk-head. seems not everyone is as poor and as lazy
> as i am when typing.
>
> ok. so now we (you) have a known working beancounter database as
> demonstrated
> above. just so i'm on the same configuration can you send me the output
> from:
> % sqlite
> sqlite> .help
>
> that will print the sqlite version.
>
> in a later message Thomas Graham will write:
>
>> perl display_indicator.pl --verbose --timeframe=day --start=2012-10-29
>>
>> --end=2012-11-26 I:Prices 0001.HK CLOSE
>> Unknown option: verbose
>> Calculating indicator Prices[CLOSE] ...
>> Prices[CLOSE] [2012-10-29] = 112.3000
>> Prices[CLOSE] [2012-10-30] = 112.2000
>> Prices[CLOSE] [2012-10-31] = 114.5000
>> Prices[CLOSE] [2012-11-01] = 115.0000
>> Prices[CLOSE] [2012-11-02] = 115.8000
>> Prices[CLOSE] [2012-11-05] = 115.6000
>> Prices[CLOSE] [2012-11-06] = 115.5000
>> Prices[CLOSE] [2012-11-07] = 116.1000
>> Prices[CLOSE] [2012-11-08] = 113.5000
>> Prices[CLOSE] [2012-11-09] = 112.9000
>> Prices[CLOSE] [2012-11-12] = 114.4000
>> Prices[CLOSE] [2012-11-13] = 112.5000
>> Prices[CLOSE] [2012-11-14] = 113.7000
>> Prices[CLOSE] [2012-11-15] = 112.6000
>> Prices[CLOSE] [2012-11-16] = 112.4000
>> Prices[CLOSE] [2012-11-19] = 113.7000
>> Prices[CLOSE] [2012-11-20] = 113.2000
>> Prices[CLOSE] [2012-11-21] = 113.7000
>> Prices[CLOSE] [2012-11-22] = 116.2000
>> Prices[CLOSE] [2012-11-23] = 117.3000
>> Prices[CLOSE] [2012-11-26] = 117.2000
>>
>>
>>
>>
> and the above gt script app demonstrating the gt-bc interface
> is also working.
>
> so back to the issue at hand: with a very simple market file consisting
> of one line containing one code:
> 0001.HK
>
> does scan.pl work?
> ./scan.pl --timeframe=year --start=2012-08-26 --end=2012-11-26
> /mnt/stocks/hk001stockscode.**mkt 2012-11-25 /mnt/trading/system.gt
>
>
> i'll assume we are getting very close and will take the time to make a
> couple of pointed comments about the date ranges on the command app and
> the issue with them with respect to the sys-sig-indic description:
>
> S:Generic:And \
> {S:Generic:Above {I:Prices} {I:SMA 20}} {S:Generic:Above {I:Prices}
> {I:SMA 50}} \
> {S:Generic:Above {I:Prices} {I:SMA 100}} {S:Generic:Above {I:Prices}
> {I:SMA 150}}
>
>
> note your date range is about 3 months or about 66 trading days, but
> your sys-sig-indic desc is trying to run I:SMA with time-periods including
> 100 and 150. you will probably find differing signal results if you run
> with a larger input data range. it might not be enough to make a difference
> but something to take note of.
>
> this sort of issue can be explored using the three 3 display_\*.pl script
> apps. the downside is you will have to craft individual sys-sig-indic desc
> specifically for each of the three scripts, display_indicator.pl will only
> deal with indicators, display_signal.pl only signals and display_system.pl
> may not work well enough to be of much help in this particular case, but
> is there for exploration and study.
>
> hopefully you are well on you way to start exploring gt.
>
> aloha
>
> ras
>
--
Thomas G Lau
Tel: 93239670
|
|
From: Robert A. S. <ra...@ac...> - 2012-11-29 13:20:48
|
Thomas Graham wrote: > sqlite> .tables > beancounter fxprices portfolio stockprices > cash indices stockinfo > > > sqlite> select * from stockprices where symbol='0001.HK'; > 0001.HK > |2012-08-08||109.168546617916|106.979204753199|109.268062157221|108.87||||4971300 > 0001.HK > |2012-08-09||109.266318631863|108.967776777678|110.858541854185|110.56||||7319600 > 0001.HK > |2012-08-10||109.763678899083|107.474862385321|110.36076146789|108.47||||5611200 > 0001.HK > |2012-08-13||109.967106460419|109.071446769791|111.161319381256|109.37||||6163000 > > > ~/.gt/options > DB::module bean > DB::bean::dbname /mnt/trading/stocks.db > DB::bean::db SQLite > Path::Font::Arial /usr/share/fonts/truetype/msttcorefonts/arial.ttf > Path::Font::Courier /usr/share/fonts/truetype/msttcorefonts/couri.ttf > Path::Font::Times /usr/share/fonts/truetype/msttcorefonts/times.ttf > options looks fine. and so does your bc db. the upper case requirement is actually a database imposed requirement, that's the way (upcased) symbols are being added to the database. in many of my hacks to gt script apps i tend to upcase codes because i'm a poor and lazy typist ... but maybe not in any of the versions on the trunk-head. seems not everyone is as poor and as lazy as i am when typing. ok. so now we (you) have a known working beancounter database as demonstrated above. just so i'm on the same configuration can you send me the output from: % sqlite sqlite> .help that will print the sqlite version. in a later message Thomas Graham will write: > perl display_indicator.pl --verbose --timeframe=day --start=2012-10-29 > --end=2012-11-26 I:Prices 0001.HK CLOSE > Unknown option: verbose > Calculating indicator Prices[CLOSE] ... > Prices[CLOSE] [2012-10-29] = 112.3000 > Prices[CLOSE] [2012-10-30] = 112.2000 > Prices[CLOSE] [2012-10-31] = 114.5000 > Prices[CLOSE] [2012-11-01] = 115.0000 > Prices[CLOSE] [2012-11-02] = 115.8000 > Prices[CLOSE] [2012-11-05] = 115.6000 > Prices[CLOSE] [2012-11-06] = 115.5000 > Prices[CLOSE] [2012-11-07] = 116.1000 > Prices[CLOSE] [2012-11-08] = 113.5000 > Prices[CLOSE] [2012-11-09] = 112.9000 > Prices[CLOSE] [2012-11-12] = 114.4000 > Prices[CLOSE] [2012-11-13] = 112.5000 > Prices[CLOSE] [2012-11-14] = 113.7000 > Prices[CLOSE] [2012-11-15] = 112.6000 > Prices[CLOSE] [2012-11-16] = 112.4000 > Prices[CLOSE] [2012-11-19] = 113.7000 > Prices[CLOSE] [2012-11-20] = 113.2000 > Prices[CLOSE] [2012-11-21] = 113.7000 > Prices[CLOSE] [2012-11-22] = 116.2000 > Prices[CLOSE] [2012-11-23] = 117.3000 > Prices[CLOSE] [2012-11-26] = 117.2000 > > > and the above gt script app demonstrating the gt-bc interface is also working. so back to the issue at hand: with a very simple market file consisting of one line containing one code: 0001.HK does scan.pl work? ./scan.pl --timeframe=year --start=2012-08-26 --end=2012-11-26 /mnt/stocks/hk001stockscode.mkt 2012-11-25 /mnt/trading/system.gt i'll assume we are getting very close and will take the time to make a couple of pointed comments about the date ranges on the command app and the issue with them with respect to the sys-sig-indic description: S:Generic:And \ {S:Generic:Above {I:Prices} {I:SMA 20}} {S:Generic:Above {I:Prices} {I:SMA 50}} \ {S:Generic:Above {I:Prices} {I:SMA 100}} {S:Generic:Above {I:Prices} {I:SMA 150}} note your date range is about 3 months or about 66 trading days, but your sys-sig-indic desc is trying to run I:SMA with time-periods including 100 and 150. you will probably find differing signal results if you run with a larger input data range. it might not be enough to make a difference but something to take note of. this sort of issue can be explored using the three 3 display_\*.pl script apps. the downside is you will have to craft individual sys-sig-indic desc specifically for each of the three scripts, display_indicator.pl will only deal with indicators, display_signal.pl only signals and display_system.pl may not work well enough to be of much help in this particular case, but is there for exploration and study. hopefully you are well on you way to start exploring gt. aloha ras |
|
From: Thomas G. <lkt...@gm...> - 2012-11-29 11:46:51
|
Robert, I found the problem. market file is using 0001.hk, while in DB, the symbol 0001.HK seems the perl program have a very tight requirement on letter precision. On Thu, Nov 29, 2012 at 9:28 AM, Thomas Graham <lkt...@gm...> wrote: > perl display_indicator.pl --verbose --timeframe=day --start=2012-10-29 > --end=2012-11-26 I:Prices 0001.HK CLOSE > Unknown option: verbose > Calculating indicator Prices[CLOSE] ... > Prices[CLOSE] [2012-10-29] = 112.3000 > Prices[CLOSE] [2012-10-30] = 112.2000 > Prices[CLOSE] [2012-10-31] = 114.5000 > Prices[CLOSE] [2012-11-01] = 115.0000 > Prices[CLOSE] [2012-11-02] = 115.8000 > Prices[CLOSE] [2012-11-05] = 115.6000 > Prices[CLOSE] [2012-11-06] = 115.5000 > Prices[CLOSE] [2012-11-07] = 116.1000 > Prices[CLOSE] [2012-11-08] = 113.5000 > Prices[CLOSE] [2012-11-09] = 112.9000 > Prices[CLOSE] [2012-11-12] = 114.4000 > Prices[CLOSE] [2012-11-13] = 112.5000 > Prices[CLOSE] [2012-11-14] = 113.7000 > Prices[CLOSE] [2012-11-15] = 112.6000 > Prices[CLOSE] [2012-11-16] = 112.4000 > Prices[CLOSE] [2012-11-19] = 113.7000 > Prices[CLOSE] [2012-11-20] = 113.2000 > Prices[CLOSE] [2012-11-21] = 113.7000 > Prices[CLOSE] [2012-11-22] = 116.2000 > Prices[CLOSE] [2012-11-23] = 117.3000 > Prices[CLOSE] [2012-11-26] = 117.2000 > > > > On Thu, Nov 29, 2012 at 9:22 AM, Thomas Graham <lkt...@gm...> wrote: > >> sqlite> .tables >> beancounter fxprices portfolio stockprices >> cash indices stockinfo >> >> >> sqlite> select * from stockprices where symbol='0001.HK'; >> 0001.HK >> |2012-08-08||109.168546617916|106.979204753199|109.268062157221|108.87||||4971300 >> 0001.HK >> |2012-08-09||109.266318631863|108.967776777678|110.858541854185|110.56||||7319600 >> 0001.HK >> |2012-08-10||109.763678899083|107.474862385321|110.36076146789|108.47||||5611200 >> 0001.HK >> |2012-08-13||109.967106460419|109.071446769791|111.161319381256|109.37||||6163000 >> >> >> ~/.gt/options >> DB::module bean >> DB::bean::dbname /mnt/trading/stocks.db >> DB::bean::db SQLite >> Path::Font::Arial /usr/share/fonts/truetype/msttcorefonts/arial.ttf >> Path::Font::Courier /usr/share/fonts/truetype/msttcorefonts/couri.ttf >> Path::Font::Times /usr/share/fonts/truetype/msttcorefonts/times.ttf >> >> >> On Thu, Nov 29, 2012 at 2:42 AM, Robert A. Schmied <ra...@ac...> wrote: >> >>> Thomas Graham wrote: >>> >>>> Hi Robert. >>>> >>>> 1. for the market file, I changed to a one per line file like this: >>>> 0001.hk >>>> 0002.hk >>>> 0003.hk >>>> 0004.hk >>>> 0005.hk >>>> 0006.hk >>>> 0007.hk >>>> 0008.hk >>>> 0009.hk >>>> 0010.hk >>>> 0011.hk >>>> >>>> 2. system file contain one line: >>>> S:Generic:And {S:Generic:Above {I:Prices} {I:SMA 20}} {S:Generic:Above >>>> {I:Prices} {I:SMA 50}} {S:Generic:Above {I:Prices} {I:SMA 100}} >>>> {S:Generic:Above {I:Prices} {I:SMA 150}} >>>> >>>> 3. result: >>>> perl display_indicator.pl --timeframe=day --start=2012-10-29 >>>> --end=2012-11-26 I:Prices T CLOSE >>>> The beancounter DB module does not support intraday data. >>>> >>> >>> thomas >>> >>> looking at ../GT/DB/bean.pm it requires specific config data in >>> $HOME/.gt/options >>> (and it may not actually be compatible with sqlite ... but that remains >>> to be proven) >>> >>> please provide your $HOME/.gt/options file >>> >>> thanks >>> >>> ras >>> >>> ps -- maybe a better solution will be to use ../GT/DB/genericdbi.pm and >>> encode the necessary sql query statement(s) in $HOME/.gt/options -- ras >>> >>> >>> >>>> >>>> >>>> it is still not working after replace the mistaken market file into one >>>> per >>>> line stock code file on (1.): >>>> >>>> ./scan.pl --timeframe=year --start=2012-08-26 --end=2012-11-26 >>>> /mnt/stocks/newstockscode.txt 2012-11-25 /mnt/trading/system.gt >>>> The beancounter DB module does not support intraday data. >>>> The beancounter DB module does not support intraday data. >>>> The beancounter DB module does not support intraday data. >>>> The beancounter DB module does not support intraday data. >>>> The beancounter DB module does not support intraday data. >>>> The beancounter DB module does not support intraday data. >>>> The beancounter DB module does not support intraday data. >>>> The beancounter DB module does not support intraday data. >>>> The beancounter DB module does not support intraday data. >>>> >>>> >>>> >>> >>> < big snip > >>> >>> >> >> >> -- >> Thomas G Lau >> Tel: 93239670 >> > > > > -- > Thomas G Lau > Tel: 93239670 > -- Thomas G Lau Tel: 93239670 |
1 message has been excluded from this view by a project administrator.
