|
PureBytes Links
Trading Reference Links
|
> Hi Dimitris,
>
> Here is the screenshot (actually a Word file containing an updated version
> with months showing). It shows a spike on 08/29/03 which is attributable,
> per Purify, to a missing quote (CHRW) and an unadjusted EBAY split.
>
> I am now analyzing all my data with Purify and it looks terrible. For
> example, when I copied the results for just the last 1000 quotes, I got
> 45,000 rows in Excel!! And my database contains only the 1000 or so
> optionable US stocks. Here is an example for just one symbol:
>
> AMCC
> 11/1/1999
> Extra quote
>
>
> AMCC
> 12/15/1999
> Missing quote
>
>
> AMCC
> 2/15/2000
> Missing quote
>
>
> AMCC
> 3/24/2000
> Possible unadjusted split 2 : 1
>
> AMCC
> 4/3/2000
> Low is higher than Close
>
> AMCC
> 4/3/2000
> Possible unadjusted split 1 : 221
>
> AMCC
> 6/7/2000
> Possible unadjusted split 1 : 2
>
> AMCC
> 6/8/2000
> Possible unadjusted split 2 : 1
>
> AMCC
> 7/6/2000
> Possible unadjusted split 1 : 2
>
> AMCC
> 7/7/2000
> Possible unadjusted split 2 : 1
>
> AMCC
> 7/20/2000
> Missing quote
>
>
> AMCC
> 10/31/2000
> Possible unadjusted split 2 : 1
>
> AMCC
> 4/11/2001
> Possible unadjusted split 1 : 2
>
>
> I know it is free, but doesn't the labor involved to fix all this
invalidate
> Yahoo as an useful EOD data source.
>
> Also I notice that Purify includes symbols like ~~~EQUITY when specify
'All
> Symbols.' Does this mean I should never use Automatic Analysis with 'All
> Symbols', unless I first remove all my Composites?
>
> Thanks for your help--even though I know you were the one originally
seeking
> it
>
> -john
>
> ----- Original Message -----
> From: john gibb
> To: amibroker@xxxxxxxxxxxxxxx
> Sent: Tuesday, October 07, 2003 4:02 PM
> Subject: Re: [amibroker] Re: A question
>
>
> Dimitris,
>
> I don't think it is aligned; see attached screenshot. If not, how do i
fix
> it?
>
> After running a Scan on my Group 254 with:
>
> AddToComposite(1,"~count","v");Buy=0;
>
> and then plotting this indicator:
>
> Plot(Foreign("~count","v"),"",1,1);
> I do get a '101' but with a downward spike (see bottom of attached).
> thanks
> -john
> PS: I did step thru all of the charts in Group 254; each had 10/06/03
> showing at the top of the Main price chart--indicating to me, at least,
that
> each has data for that date.
> ----- Original Message -----
> From: DIMITRIS TSOKAKIS
> To: amibroker@xxxxxxxxxxxxxxx
> Sent: Monday, October 06, 2003 11:02 PM
> Subject: [amibroker] Re: A question
>
>
> John,
> check if your database is aligned.
> The lastvalue(cum(1)) should be the same for all stocks.
> The
> AddToComposite(1,"~count","v");buy=0;
> should give a flat horizontal
> Plot(Foreign("~count","v"),"",1,1);
> at 101 [without spikes.
> If this requirement is OK, then all the indicators work.
> The method plots a bargraph of the last indicator values, assigned to
> the last 101 elements of the artificial array H0.
> I still do not see the Equity() problem...
> Dimitris Tsokakis
> --- In amibroker@xxxxxxxxxxxxxxx, "john gibb" <jgibb1@xxxx> wrote:
> > Hi Dimitris,
> >
> > With AB 4.43.2, Yahoo EOD data, and the Nasdaq 100 stocks plus ^NDX
> in my Group 254, I also get my initial equity returned for the Equity
> version of your 'Select() indicator.
> >
> > However, I do NOT get a bar graph for either the MACD or the Equity
> version with ^NDX as my selected symbol. (I do get 5.21987 on the Y-
> axis for the MACD version with ^NDX as the selected symbol)
> >
> > And, when I select any other symbol in that group, I get:
> >
> > <clip>
> > Line 17, Column 14:
> > return Rank ;
> >
> > }
> >
> > No=254;
> >
> > H0=Select(No);
> > -------------^
> >
> > Error 7.
> > Subscript out of range
> > <clip>
> >
> > -john
> >
> > ----- Original Message -----
> > From: DIMITRIS TSOKAKIS
> > To: amibroker@xxxxxxxxxxxxxxx
> > Sent: Monday, October 06, 2003 1:58 PM
> > Subject: [amibroker] A question
> >
> >
> > Using
> >
> > //Select the last MACD()
> > function select( listnum )
> > {
> > list = GetCategorySymbols( categoryGroup, listnum );
> > Rank = 0;
> > for( i = 0; ( sym = StrExtract( list, i ) ) != ""; i++ )
> > {
> > SetForeign(SYM);
> > E1=LastValue(MACD());
> > Rank[BarCount-1-i] = E1;
> > }
> > return Rank ;
> > }
> > No=254;
> > H0=Select(No);
> > Plot(H0,"",2,2);
> >
> > I have a bar graph of the last MACD() values.
> > I did not understand why the
> >
> > //Select the last equity()
> > function select( listnum )
> > {
> > list = GetCategorySymbols( categoryGroup, listnum );
> > Rank = 0;
> > for( i = 0; ( sym = StrExtract( list, i ) ) != ""; i++ )
> > {
> > SetForeign(SYM);SetTradeDelays(1,1,1,1);
> > BuyPrice=Open;SellPrice=Open;
> > Buy=Cross(StochD(),30);Sell=Cross(70,StochD());
> > E1=LastValue(Equity(1,0));
> > Rank[BarCount-1-i] = E1;
> > }
> > return Rank ;
> > }
> > No=254;
> > H0=Select(No);
> > Plot(H0,"",2,2);
> >
> > did not gave me the last equity() values. The output was 10,000
> for
> > all stocks [my initial equity in settings].
> > Any help appreciated.
> > [my database is placed in group254]
> > Dimitris Tsokakis
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> >
> >
> >
> > Send BUG REPORTS to bugs@xxxx
> > Send SUGGESTIONS to suggest@xxxx
> > -----------------------------------------
> > Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
> > (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> > --------------------------------------------
> > Check group FAQ at:
> http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
>
> Send BUG REPORTS to bugs@xxxxxxxxxxxxx
> Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
> -----------------------------------------
> Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
> (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> --------------------------------------------
> Check group FAQ at:
> http://groups.yahoo.com/group/amibroker/files/groupfaq.html
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> Send BUG REPORTS to bugs@xxxxxxxxxxxxx
> Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
> -----------------------------------------
> Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
> (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> --------------------------------------------
> Check group FAQ at:
> http://groups.yahoo.com/group/amibroker/files/groupfaq.html
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/GHeqlB/TM
---------------------------------------------------------------------~->
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Attachment:
dbAlign_N100.doc
Attachment:
Description: "Description: MS-Word document"
|