Tomasz: Thanks, that's great
news.
Hopefully Gary will help at QP since he's
seen the message traffic about
this want list.
Best regards
JOE
----- Original Message -----
Sent: Friday, July 22, 2005 12:37
PM
Subject: Re: [amibroker] Re: Historical
QP_QtrRev & QP_QtrEPS are kept in QuotesPlus!
Hello,
I am sorry for not responding
earlier. First of all it is important to understand that AmiBroker's QP2
plugin does not use "Excel" functions (like QP_QtrRev, and
alike).
It uses low-level QP2DLL.DLL library shipped with QP2 API which
is faster than COM/ActiveX based methods.
So I have re-checked the
QP2 API looking for somethign like QP_QtrRev (QP2 API has no special docs
only header files and one sample) and I have found a function with the
following prototype:
int __stdcall R2_QP_ReadZacksEPS( const
char* cpSymbol/*Ticker Symbol*/, QP_ZACKS_EPS zacks_EPS[20]/*Zack
Eps record array*/ );
and QP_ZACKS_EPS is defined
as: typedef struct { long FiscQuart; //Date of the Fiscal
Quarter
float Sales; //Sales of the Quarter float
EPS; //EPS of the Quarter
} *LPQP_ZACKS_EPS,
QP_ZACKS_EPS;
so it looks like counterpart of these QP_QtrRev,
QP_QtrEPS Excel functions.
From the declaration it seems that it
returns Sales and EPS for last 20 quarters (5 years max).
I will need
to verify my findings with Gary and if they are correct I will add this to
next version of QP2.
Best regards, Tomasz
Janeczko amibroker.com
----- Original Message ----- From:
"sgfuchs" <sgfuchs@xxxxxxxxxxxxx> To:
<amibroker@xxxxxxxxxxxxxxx> Sent: Thursday, July 21, 2005 9:06
AM Subject: [amibroker] Re: Historical QP_QtrRev & QP_QtrEPS are kept
in QuotesPlus!
Hi RJS,
thanks for this update. I was aware
of the excel functions of QP und use them in some spreadsheets. More than
the parameters you mentioned, you can also obtain changes in earnings
estimates over last xx periods (à la "Zacks" ) either through excel or
through QP's advanced scans.
I noticed, in the files section of this
board, there's a little tool that helps to control Excel from AB and vice
versa. maybe this could be a workaround until this particular savvy
programmerr can be found who would be so kind to implement the necessary
extended getextradata functions in AB ;-))
Tomasz, seems more and
more people are interested to combine fundamental and technical screening
:-)
regards Stefan --- In amibroker@xxxxxxxxxxxxxxx,
"razorruss17" <rsebring@xxxx> wrote: > To Jason, Joe, Stefan,
and everyone else dying to get QP's QtrRev and > QtrEPS historical
data into Amibroker, > > Thank you Jason for sharing your
GetExtraData() function, and also the > Qtr EPS screen you perform in
SPP --> this is living proof that more > 'historical' QP data is
available which can be of use to us in AmiBroker. > > A trader
named Denis over on the QP discussion board was nice enough > to
share with me how via Excel Quotes-Plus users are able to pull >
Quarterly Revenue and EPS figures from Quotes-Plus. The
functions used > in Excel include... > >
QP_QtrRev > QP_QtrEPS > Quarter_Index ( 0 being current
quarter, all the way back to -11) > QP_QuarterDate (Retrieves the
quarter dates as MM/YY) > > > While technically these Qtrly
figures are not historical arrays, by > using the QP_QuarterDate
function, some savvy AmiBroker programmers > (cough Tomasz cough) could
find a way to get these fields into > AmiBroker where we could then use
some date/time and BarIndex > functions to make very good use of the Rev
and EPS fields. With bar > counter and date/time counter here and there,
what could stop us from > 'ghetto-rigging' the Qtrly fields into
historical arrays of sorts? My > programming knowledge is very
limited, but I imagine some of the more > experienced AmiBroker users
understand what I'm getting at. > > Tomasz we are begging you for
an answer on this one! What is your Verdict? > > >
-Russ > > > > --- In amibroker@xxxxxxxxxxxxxxx, Jason
Hart <jayhart_1972@xxxx> wrote: > > Yes, it's in the SPP
warehouse. You can export to excel depending > on which data
you want. For example, if I want historical EPS data, > under
view in SPP I'll select "Fund Earnings --> Qtrly EPS"
then save > the list as. I believe there are other ways to do
this too, as was > posted by others, but I haven't experimented with it
in a while. For > my purposes this is easiest. > > >
> You might find this indicator I built useful too. It has all
of the > basic info for stocks, i.e. short interest, div yield,
market cap, PE, > etc. I have different colors pop up depending
on different levels of > short interest. Short interest under
10% will be yellow, 10-20% will > be blue, and short interest over
20% will be red. check it out > > > > > > x=
GetExtraData("SharesShort"); > > > > y =
GetExtraData("SharesFloat")*1000000; > > > > z=
(x/y)*100; > > > > d=GetExtraData("Shares"); >
> > > x1 = GetExtraData("InstHolds"); /*gives Quotes Plus
relative > strength (ARRAY) */ > > > > x11 =
GetExtraData("bookvaluepershare"); > > > > x12 =
C/x11; > > > > x13 = GetExtraData("QRS"); >
> > > x14 = GetExtraData("beta"); > > > > x15 =
GetExtraData("TTMeps"); > > > > x16 =
GetExtraData("epsrank"); > > > > a =
GetExtraData("AnnDividend"); /*gives Quotes Plus relative > strength
(ARRAY) */ > > > > aaa = GetExtraData("qRS"); >
> > > x2= (a/C)*100; > > > > a1 =
(d*C)/1000; > > > > eps1 = GetExtraData("PEG"); >
> > > eps2 = GetExtraData("LTDebtToEq"); > > > >
eps2a = Ref(eps2,-180); > > > >
barcolor=IIf(z>20,colorRed,IIf(z>10 AND >
z<=19.99,colorBlue,colorYellow)); > > > >
Color=LastValue(barcolor); > > > >
Title=EncodeColor(color)+"Close today"; > > > > pp =
MA(V,50); > > > > > > > > pe =
GetExtraData("ttmeps"); > > > > pe1 = C/pe; >
> > > > > > > Title = FullName() + " - " +
EncodeColor(colorGreen)+ " Industry: " > + EncodeColor( colorWhite)
+IndustryID(1) + > > > > EncodeColor(colorGreen) + " Group:
"+ > EncodeColor(colorWhite)+SectorID(1)+ EncodeColor(color)+
"\n\nShort > Interest: " + > > > > NumToStr(z,1.2) +
"%" + " Institutional Ownership: " + > > > >
NumToStr(x1,1.2) + "%" + " Dividend Yield: " + NumToStr(x2,1.2) + > "%"+
" Market Cap: " + NumToStr(a1,1.) + > > > > " million"+
"\nAvg Vol 25: " + NumToStr(pp,1.) + " PEG: "+ eps1 + " > LTDebtToEq
"+ eps2a > > > > + " RS Rank: " + aaa + " Price/Book: "
+ > > > > NumToStr(x12,1.2) + > > > >
"\nTrailing PE: " + NumToStr(pe1,1.2) + " Beta: " + NumToStr(x14 > ,1.2)
+ " RS: " + x13 > > > > + " TTM-EPS: " + x15 + " EPS Rank: "
+ x16; > > > > > > > > > >
razorruss17 <rsebring@xxxx> wrote: > > Jason, >
> > > Many thanks for your reply... > > > > Do
you perform the steps you mentioned the Stock Picker Pro > >
application? I didn't see the ' File --> save list as ' option in
QP, > > but it is in SPP. Whereever your pulling this data from, is
it giving > > you historical data as well? > > >
> RJS (Russ) > > > > > > > > >
> > > > > > > --- In amibroker@xxxxxxxxxxxxxxx,
Jason Hart <jayhart_1972@xxxx> wrote: > > > RJS, >
> > > > > In QP, go to File --> save list as , then save
the file. After you > > saved the text file open it up in excel
and the securities and data > > from the list will be
there. > > > > > > Jason > > > >
> > razorruss17 <rsebring@xxxx> wrote: > > > For those
of you familiar with Quotes-Plus.... I need your help! > >
> > > > Do any of you know how to extract (to Excel or
Amibroker) historical > > > fundamental data fields going back
as far as the Quotes Plus Database > > > holds?? We can do this
easily for the "QRS" and "EPSRANK" fields, but > > > how the
heck can export the many other useful fundamental fields? > > >
Someone please help!! > > > > > > > > >
-RJS > > > > > > > > > > >
> > > > > > > > > > > >
> > > > 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 >
> > > > > > > > > > > > >
> > > > SPONSORED LINKS > > > Investment management
software Investment property software > > Investment software
Investment tracking software Return on investment > > software
Stock investment software > > > > > >
--------------------------------- > > > YAHOO! GROUPS
LINKS > > > > > > > >
> Visit your group "amibroker" on the web. >
> > > > > To unsubscribe from this
group, send an email to: > > >
amibroker-unsubscribe@xxxxxxxxxxxxxxx > > > > >
> Your use of Yahoo! Groups is subject to the
Yahoo! Terms of > > Service. > > > > >
> > > > --------------------------------- > >
> > > > > > > > > >
__________________________________________________ > > > Do You
Yahoo!? > > > Tired of spam? Yahoo! Mail has the best spam
protection around > > > http://mail.yahoo.com > > >
> > > > > > > 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 >
> > > > > Visit your group
"amibroker" on the web. > > > > To
unsubscribe from this group, send an email to: > >
amibroker-unsubscribe@xxxxxxxxxxxxxxx > > >
> Your use of Yahoo! Groups is subject to the
Yahoo! Terms of > Service. > > > > > >
--------------------------------- > > > > >
> > > > > --------------------------------- >
> Start your day with Yahoo! - make it your home
page
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
SPONSORED LINKS
YAHOO! GROUPS LINKS
|