|
PureBytes Links
Trading Reference Links
|
TJ,
this seems to work. But why does AB crash (returns
an error after having scanned 4-5% of the QP2 database) when running it on the
WHOLE database?
Does filter=getextradata ("issuetype")=="1"
retrieve ALL preferred stocks.
Thanks for
clarifying
Markus
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
Tomasz Janeczko
To: <A title=amibroker@xxxxxxxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Wednesday, May 21, 2003 2:01
AM
Subject: Re: [amibroker] String question
- STILL Problems
Markus,
Click on Filter button and set include filter to GROUP:
STOCKS.
Best regards,Tomasz Janeczkoamibroker.com
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
IVA GmbH
To: <A title=amibroker@xxxxxxxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Wednesday, May 21, 2003 1:19
AM
Subject: Re: [amibroker] String
question - STILL Problems
Bob,
when I run a code like the one provided below,
AB successfully scans about 4-5% of my entire QP2 database and then crashes
telling me that GetExtraData failed plus somewhere in my code were bad
arguments.
Please use the code provided below and tell me
if you encounter the same, if you don´t mind.
Thanks
Markus
Filter= <FONT
face="Courier New" color=#ff00ff>1<FONT face="Courier New"
color=#6600aa>;
AddColumn(<FONT
face="Courier New" color=#000000>Close<FONT face="Courier New"
color=#6600aa>, "last
close",<FONT
face="Courier New" color=#ff00ff>1.2<FONT face="Courier New"
color=#6600aa>);
AddTextColumn(<FONT
face="Courier New" color=#0000ff>GetExtraData<FONT face="Courier New"
color=#6600aa>(<FONT face="Courier New"
color=#ff00ff>"issuestatus"),
"Issuestatus"<FONT
face="Courier New" color=#6600aa>);<FONT face="Courier New"
color=#0000ff>
AddTextColumn(<FONT
face="Courier New" color=#0000ff>Name<FONT face="Courier New"
color=#6600aa>(), "Ticker
symbol"<FONT face="Courier New"
color=#6600aa>);
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
Bob Jagow
To: <A
title=amibroker@xxxxxxxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Tuesday, May 20, 2003 6:48
PM
Subject: RE: [amibroker] String
question
<SPAN
class=109391016-20052003>Bob,
<SPAN
class=109391016-20052003>
<SPAN
class=109391016-20052003>when I run a code with
GetMarkus,<SPAN
class=109391016-20052003><FONT color=#000000
size=2>
<SPAN
class=109391016-20052003>Filter =
GetExtraData<FONT color=#000000
size=2>("IssueType"<FONT
color=#000000 size=2>) == <FONT color=#ff00ff
size=2>"P"; "worked" but returned
nothing-- your " P" may have been the problem or <FONT color=#0000ff
size=2>GetExtraData may have tired of the game
:)
<SPAN
class=109391016-20052003><FONT color=#000000
size=2>
<SPAN
class=109391016-20052003>Tomasz said IssueType returns "1
character string [matching] the fields available in the QP2
MasterRec--whatever they are?<FONT face=Arial
color=#0000ff size=2><A
href="">http://groups.yahoo.com/group/amibroker/message/17355
<SPAN
class=109391016-20052003>
<FONT
color=#000000>
I meant
that you should use issuetype in a QP scan [see below]
In order
see what was happening, I scanned with IssueType Preferred; and imported
the list..
Voila, the
critters all returned "1".
Hence Filter =
GetExtraData<FONT
color=#000000>("IssueType"<FONT
color=#000000>) ==
"1";<SPAN
class=109391016-20052003> got them and != "1" should toss 'em out.
Note, however, that this way is much slower than doing it in QP and
importing the watcchlist.
<SPAN
class=109391016-20052003>Bob
<SPAN
class=109391016-20052003><FONT
face=Arial color=#0000ff size=2><SPAN
class=109391016-20052003>---<SPAN
class=109391016-20052003><FONT
face=Arial><SPAN
class=109391016-20052003>
<FONT
face=Arial>I
normally use IssueType Common; <SPAN
class=109391016-20052003>, but t<SPAN
class=371050819-19052003>his exclude<SPAN
class=109391016-20052003>s warrants<SPAN
class=109391016-20052003>, closed- end funds<SPAN
class=109391016-20052003>, and ETF<SPAN
class=109391016-20052003>. Add them if desired, e.g.,
<FONT face=Arial color=#0000ff
size=2>IssueType Common,ETF;
<SPAN
class=371050819-19052003>Had never tried
IssueType != Preferred;, but now see it's
unliked.
<FONT face=Tahoma
size=2>-----Original Message-----From: funnybiz@xxxxxx
[mailto:funnybiz@xxxxxx]Sent: Tuesday, May 20, 2003 7:51
AMTo: amibroker@xxxxxxxxxxxxxxxSubject: Re:
[amibroker] String question
Bob,
glad you stepped in here.
I used the
filter=getextradata("issuetype")=="p".
Weird enough, AB starts checking, then
returns error as below.
Would you mind checking if the code is
correct (i.e. finds ALL preferred) plus if you encounter the same error,
please????
Line 2, Column 40:Filter=
GetExtraData("issuetype")=="
p";---------------------------------------^
Error 18.GetExtraData
failed
Many thanks
Markus
<BLOCKQUOTE
>
<DIV
>From:
Bob
Jagow
To: <A
title=amibroker@xxxxxxxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Tuesday, May 20, 2003 4:36
PM
Subject: RE: [amibroker] String
question
<SPAN
class=499482914-20052003>Especially since there are lots of
preferred issues [such as CYA] that don't end in "
P*".
<SPAN
class=499482914-20052003>Would need to use issuetype to exclude
them.
<SPAN
class=499482914-20052003>
<SPAN
class=499482914-20052003>Bob <FONT face=Arial
color=#0000ff size=2><SPAN
class=499482914-20052003>
<FONT face=Tahoma
size=2>-----Original Message-----From: <A
href="">funnybiz@xxxxxx
[mailto:funnybiz@xxxxxx]Sent: Tuesday, May 20, 2003 1:54
AMTo: <A
href="">amibroker@xxxxxxxxxxxxxxxSubject:
Re: [amibroker] String question
Jayson,
this might be the most efficient way to
go.
Justwanted to play arount with the
string functions to understand them better.
Markus
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
<A title=jcasavant@xxxxxxxxxxxx
href="">Jayson
To: <A
title=amibroker@xxxxxxxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Monday, May 19, 2003
4:40 PM
Subject: RE: [amibroker]
String question
<SPAN
class=290302014-19052003>Markus,
<SPAN
class=290302014-19052003>Why not simply do this in QP2 then create
a watchlist of your exported qp2 list? The advantage is that AB
does not need to chug through your whole database checking all
your various criteria since every stock in your watchlist will
meet all your criteria.When doing scans and explores you simply
point to this "Universe" of stocks.
<FONT face=Arial color=#0000ff
size=2>Regards,
Jayson
<FONT
face=Tahoma size=2>-----Original Message-----From:
funnybiz@xxxxxx [mailto:funnybiz@xxxxxx]Sent: Monday,
May 19, 2003 5:32 AMTo: Amibroker
(Yahoo-Forum)Subject: [amibroker] String
question
Hello,
I want to exclude all preferred
stocks from my scan.
In their symbols they either end with
" p" (space p) or with " p.." (space p followed by any other
letter).
While the first may be excluded
by
(<FONT face="Courier New"
color=#0000ff>StrRight<FONT face="Courier New"
color=#6600aa>(<FONT face="Courier New"
color=#0000ff>Name<FONT face="Courier New"
color=#6600aa>(),<FONT face="Courier New"
color=#ff00ff>2) !=
" P"
how could exclude latter case since I don´t know which (if at
all) letter might follow??
Thank you for your help
Markus
(<FONT face="Courier New"
color=#0000ff>StrRight<FONT face="Courier New"
color=#6600aa>(<FONT face="Courier New"
color=#0000ff>Name<FONT face="Courier New"
color=#6600aa>(),<FONT face="Courier New"
color=#ff00ff>2) !=
" P"<FONT
face="Courier New"
color=#6600aa>);Send BUG REPORTS to
bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
(Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of
Service. Send BUG REPORTS to
bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
(Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of
Service. Send BUG REPORTS to
bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web
page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of
Service. Send BUG REPORTS to
bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web
page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of
Service. Send BUG REPORTS to
bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web
page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of
Service. Send BUG REPORTS to
bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page:
<A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
Send BUG REPORTS to bugs@xxxxxxxxxxxxxSend
SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page:
<A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
Send
BUG REPORTS to bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
Yahoo! Groups Sponsor
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.
|