|
PureBytes Links
Trading Reference Links
|
Great Tomas,
another reason to renew my upgrade subscription for AB :-)) Still
using 4.69beta without problems.
You should think of having an automated reminder .... ;-)
regards and keep up the great work.
Stefan
--- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko" <amibroker@xxxx>
wrote:
> 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@xxxx>
> 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
------------------------ Yahoo! Groups Sponsor --------------------~-->
Try Online Currency Trading with GFT. Free 50K Demo. Trade
24 Hours. Commission-Free.
http://us.click.yahoo.com/DldnlA/9M2KAA/U1CZAA/GHeqlB/TM
--------------------------------------------------------------------~->
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:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|