Ken,
From the QP2 help file:
----------------------------------------------------
QRS()
Relative Strength( DayNum )
Returns the relative strength for the selected date. The Quotes Plus
Relative Strength is calculated by comparing the performance of each
issue for the past 4 quarters to the performance of every other issue in
the database over the same time. The most recent quarter is given twice
the weight of the previous 3 quarters.
-------------------------------------------------------
So, using RSI you could formulate something like this:
QRSI =RSI(90); //Quarterly RSI
Q1RSI = QRSI;
Q2RSI = Ref(QRSI,-1);
Q3RSI = Ref(QRSI,-2);
Q4RSI = Ref(QRSI,-3);
QRSx = (Q1RSI + Q2RSI + Q3RSI + 2*Q4RSI)/5;
AddColumn(QRSx,"QRSx",2.0);
QRS=GetExtraData("QRS");
AddColumn(QRS,"QRS",2.0);
Filter=1;
Regards,
Ed
Ken Close wrote:
> Thanks much for your help.
>
> I still want to poke at easy ways to develop ranking within AB. In using
> the data from QP (admittedly easy to do with the GetExtraData command, you
> are still left using the parameters set up by QP. If you have a super-duper
> indicator of your own and wanted to rank on it, you would have to do that
> internally....hence back to the issue of how to code a ranking system (not a
> trading system).
>
> Ken
>
> -----Original Message-----
> From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
> Of e
> Sent: Wednesday, August 30, 2006 2:02 PM
> To: [email protected]
> Subject: Re: [amibroker] Re: Quotes Plus Mutual Funds
>
> Ken,
> Here is some ranking code for stocks which utilizes QP2 data:
> QRS=GetExtraData("QRS");
> AddColumn(QRS,"QRS",2.0)
> EPS=GetExtraData("EPSRank");
> AddColumn(EPS,"EPS",2.0);
> MyRSI=RSI(5);
> AddColumn(MyRSI,"RSI",2.0);
> ERQ=(QRS+EPS+MyRSI)/3;
> AddColumn(ERQ,"ERQ",2.0);
>
> If you want an integer rank, just round the ERQ number.
> Regards,
> Ed
> p.s. QRS is the QP2 ranking which is available without SPP.
>
> Ken Close wrote:
>> Brian: thanks for the reminder on your xls; I will go look at it, but
>> I have plugged the trigger on the new subscription.
>>
>> Regarding your comment: " "My opinion was that the QP ranking systems
> were
>> fairly transparent and could be duplicated in AB with relative ease'",
>> I think this is an assertion that may prove harder to fulfill than you
>> realize. Unless you have already done this (and if you have, you
>> would be my new best friend because I would like to see it), I think
>> you will find that developing a ranking score (and I do not mean the
>> PositionScore variable within AB) that is integer based is extremely
>> difficult. I have tried numerous approaches, including using
>> PositionScore, and do not get anything meaningful. In fact, I believe
>> I am correct that the only way to create integer rankings of
>> calculated quantities within Ab is to use the so-called Osaka plugin,
>> something of complexity that I have so far been unwilling to tackle.
>> Drawing QP3 integer rankings out has been my only "easy" solution.
>>
>> If anyone wants to refute my claim, I would be more than welcome to
>> see an approach that is shareable, doesn't require C++ programming
>> skills, and satisfies the need to create integer ranking scores/numbers.
>>
>> Ken
>>
>> -----Original Message-----
>> From: [email protected] [mailto:[EMAIL PROTECTED] On
>> Behalf Of brian.z123
>> Sent: Wednesday, August 30, 2006 9:00 AM
>> To: [email protected]
>> Subject: [amibroker] Re: Quotes Plus Mutual Funds
>>
>> Ken,
>>
>> The answer to your question is no.
>> You would not have access to the ranking scores if you had not
>> purchased SPP.
>>
>> I have posted an updated QPAmiCompare.xls file.
>> I used the file in the first place to track the raw data that was used
>> in various places between QP and Ami.
>> The QP scan database, which is installed on your hard-drive, appears
>> to be the underlying database for SPP.
>> >From the SPP help/data fields section each of the fields in SPP states
>>> if it
>> is a computed or imported field so they can be cross referenced to
>> each other.
>> So with the exception of QRS and EPS rank all of the other ranks are
>> calculated in SPP and not part of the Ami package.
>>
>> To correct my previous statement on ethical grounds:
>>
>> "My opinion was that the QP ranking systems were fairly transparent
>> and could be duplicated in AB with relative ease'"
>>
>> I am biased towards creating my own rankings anyway.
>> I wasn't considering QP for the rankings.
>> Most if not all of the rankings used in QP are already part of the
>> public domain.
>>
>> BrianB2.
>>
>>
>> --- In [email protected], Ken Close <[EMAIL PROTECTED]> wrote:
>>> Thanks Steve, for your comments. I, too, am beginning to
>> concentrate on
>>> just ETFs and the "daily" funds from Profunds, Rydex, and
>> Potomac. Hence my
>>> desire to isolate just those. If I had spent more time with the
>> trial I
>>> might have tried to get by without the SPP. but all the pretty red
>> and green
>>> boxes got to me and I liked them. Can I assume that I still would
>> have had
>>> access to the ranking scores even if I had not purchased the SPP?
>>>
>>> Ken
>>>
>>> _____
>>>
>>> From: [email protected] [mailto:[EMAIL PROTECTED]
>> On Behalf
>>> Of Steve Dugas
>>> Sent: Tuesday, August 29, 2006 1:36 PM
>>> To: [email protected]
>>> Subject: Re: [amibroker] Quotes Plus Mutual Funds
>>>
>>>
>>> Hi Ken - I see that Joe has already come up with a solution for
>> you. When I
>>> went back to QP recently, I did not sign up for SPP since I am now
>>> concentrating only on 2x +/- funds. There are not that many of
>> them so I
>>> just created my watchlists by hand. I did want to get the funds
>> themselves
>>> into AB so I could access them there, but for testing, etc I
>> generally use
>>> the benchmark indices rather than the funds themselves. QP lacks
>> several of
>>> these benchmarks, especially for the foreign markets, so for these
>> I
>>> substitute the most popular ETF's instead.
>>>
>>> BTW, if you like the 2x funds, don't forget about DireXion. Their
>> American
>>> funds are 2.5-beta. Also, for anyone that might not be aware,
>> ProFunds
>>> introduced their 2x +/- ETF's last month. See www.proshares.com
>> for more
>>> info.
>>>
>>> Steve
>>>
>>> ----- Original Message -----
>>> From: Ken Close <mailto:[EMAIL PROTECTED]>
>>> To: [email protected]
>>> Sent: Tuesday, August 29, 2006 6:31 AM
>>> Subject: RE: [amibroker] Quotes Plus Mutual Funds
>>>
>>> Steve:
>>>
>>> Many thanks. Now that I am signed up, am discovering various
>> unfriendly
>>> aspects to the program(s) that I guess I did not discover or try
>> hard enough
>>> during the trial period. But I want the data (mainly the ranks
>> which can be
>>> imported into AB) so I will have to slog thru a learning curve,
>> just like
>>> with ..... well ...... AB. I dont want to do complex things, just
>> isolate
>>> ETFs and Rydex/Profunds Mutual Funds. Should be simple and almost
>>> intuitive. It is not.
>>>
>>> Thanks for the response.
>>>
>>> Ken
>>>
>>> PS: If you dont mind, is the easiest way to get a Watchlist of the
>>> Rydex/Profunds Mutual Funds to import via a lst or txt file of the
>> symbols??
>>> _____
>>>
>>> From: [email protected] [mailto:[EMAIL PROTECTED]
>> On Behalf
>>> Of Steve Dugas
>>> Sent: Monday, August 28, 2006 3:28 PM
>>> To: [email protected]
>>> Subject: Re: [amibroker] Quotes Plus Mutual Funds
>>>
>>>
>>> Ken - By Default, QP plugin does not retrieve MF's or futures. Go
>> to File >
>>> Database Settings > Configure, check the box for MF's and hit
>> Retrieve.
>>>
>>> Steve
>>>
>>> ----- Original Message -----
>>> From: Ken Close <mailto:[EMAIL PROTECTED]>
>>> To: [email protected]
>>> Sent: Monday, August 28, 2006 3:08 PM
>>> Subject: [amibroker] Quotes Plus Mutual Funds
>>>
>>> Maybe this is obvious, but how do I chart Quotes Plus 3 Mutual
>> Funds.
>>>
>>> I do not see any data plugin just for QP Mutual Funds.
>>>
>>> I am plotting stocks and ETFs find with the QP3 database. I have
>> mutual
>>> fund data on my drive (can plot with QP charting package), but I
>> do not see
>>> how to make AB do that.
>>>
>>> Thanks for your suggestions.
>>>
>>> Ken
>>>
>>
>>
>>
>>
>>
>> Please note that this group is for discussion between users only.
>>
>> To get support from AmiBroker please send an e-mail directly to
>> SUPPORT {at} amibroker.com
>>
>> For other support material please check also:
>> http://www.amibroker.com/support.html
>>
>>
>> Yahoo! Groups Links
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Please note that this group is for discussion between users only.
>>
>> To get support from AmiBroker please send an e-mail directly to
>> SUPPORT {at} amibroker.com
>>
>> For other support material please check also:
>> http://www.amibroker.com/support.html
>>
>>
>> Yahoo! Groups Links
>>
>>
>>
>>
>>
>>
>>
>
>
> Please note that this group is for discussion between users only.
>
> To get support from AmiBroker please send an e-mail directly to SUPPORT {at}
> amibroker.com
>
> For other support material please check also:
> http://www.amibroker.com/support.html
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
> Please note that this group is for discussion between users only.
>
> To get support from AmiBroker please send an e-mail directly to
> SUPPORT {at} amibroker.com
>
> For other support material please check also:
> http://www.amibroker.com/support.html
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
Please note that this group is for discussion between users only.
To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
For other support material please check also:
http://www.amibroker.com/support.html
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
