|
PureBytes Links
Trading Reference Links
|
Hello Mohan,
EPSRANK is a function of CompanyInfo ... try this:
ticker=Name();
EnableScript("jscript");
<%
CInfo = AFL.CreateStaticObject("QuotesPlus.CompanyInfo");
// NEW CreateStaticObject !
CInfo.Symbol = AFL("ticker");
// try-catch block handles the situation when
// QuotesPlus object returns strange values
try
{
EPS= Number( CInfo.epsrank() );
}
catch( e )
{
EPS = 0;
}
AFL.Var("EPS") = EPS;
%>
Filter = C>0;
NumColumns=2;
Column0=Close;
Column1=EPS;
PS I get this information from the COM add-in in Excel FWIW.
-----Original Message-----
From: Mohan Yellayi [mailto:myellayi@x...]
Sent: Thursday, November 15, 2001 10:04 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] Importing Quotes Plus Fundamental fields into
AMIBroker
Hi Peter,
Thank you very much for your help. It worked. I tried the same to get
EPSRANK too and it doesn't seem to work. Are all these defined somewhere -
what is associated with what.
Thanks for all your help.
regards
mohan
----- Original Message -----
From: Peter Gialames
To: amibroker@xxxxxxxxxxxxxxx
Sent: Thursday, November 15, 2001 10:54 AM
Subject: RE: [amibroker] Importing Quotes Plus Fundamental fields into
AMIBroker
Hello Mohan,
Try this (you need to initialize ticker in AFL):
ticker=Name();
EnableScript("jscript");
<%
CInfo = AFL.CreateStaticObject("QuotesPlus.Price");
// NEW CreateStaticObject !
CInfo.Symbol = AFL("ticker");
// try-catch block handles the situation when
// QuotesPlus object returns strange values
try
{
QRS= Number( CInfo.QRS(0) ); // Change 0 to -1,-2,etc.
}
catch( e )
{
QRS = 0;
}
AFL.Var("QRS") = QRS;
%>
Filter = C>0;
NumColumns=2;
Column0=Close;
Column1=QRS;
-----Original Message-----
From: Mohan Yellayi [mailto:myellayi@x...]
Sent: Thursday, November 15, 2001 8:51 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] Importing Quotes Plus Fundamental fields into
AMIBroker
Hi Peter,
Thanks for your email. I tried it and unfortunately, it still returns , a
zero for QRS value. I tried for AOL. Here is my code.
Thanks for any help.
regards
Mohan
EnableScript("jscript");
<%
CInfo = AFL.CreateStaticObject("QuotesPlus.Price");
// NEW CreateStaticObject !
CInfo.Symbol = AFL("ticker");
// try-catch block handles the situation when
// QuotesPlus object returns strange values
try
{
//AFL("Float") = Number( CInfo.Float() )*1000000;
QRS= Number( CInfo.QRS() ); // I tried QRS(0) and QRS(-1) too
}
catch( e )
{
QRS = 0;
}
AFL.Var("QRS") = QRS;
%>
Filter = C>0;
NumColumns=2;
Column0=Close;
Column1=QRS;
----- Original Message -----
From: Peter Gialames
To: amibroker@xxxxxxxxxxxxxxx
Sent: Wednesday, November 14, 2001 2:53 PM
Subject: RE: [amibroker] Importing Quotes Plus Fundamental fields into
AMIBroker
Hello Mohan,
QRS is a function of Price NOT CompanyInfo so you would have:
CInfo = AFL.CreateStaticObject("QuotesPlus.Price");
This should work ...
Peter Gialames
-----Original Message-----
From: Mohan Yellayi [mailto:myellayi@x...]
Sent: Wednesday, November 14, 2001 9:41 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: [amibroker] Importing Quotes Plus Fundamental fields into AMIBroker
Hi Peter,
In your float indicator code , you are importing Float value form Quotes
Plus database. Have you been able to get other data from quotes plus? I
tried to get QRS and EPS values with the following commands, but it doesn't
seem to work. I appreciate any help.
thanks
Mohan
try
{
//Float = Number( CInfo.Float() )*1000000;
QRS= Number( CInfo.QRS(0) ); //QRS= Number( CInfo.QRS ); - Neither seems to
work
//EPS= Number( CInfo.EPS );
}
catch( e )
{
//AFL("Float") = 0;
QRS = 0;
}
----- Original Message -----
From: Peter Gialames
To: amibroker@xxxxxxxxxxxxxxx
Sent: Wednesday, November 14, 2001 9:24 AM
Subject: [amibroker] Re: Point & Figure Charting
Since there have been some problems with Geocities and the download
of the Point & Figure application, Tomasz has been generous enough to
lend me some space. So if anyone has had any problems please
download the app here:
http://www.amibroker.net/~pgialames/
Peter Gialames
--- In amibroker@xxxx, "Peter Gialames" <investor@xxxx> wrote:
> For those of you who are interested in Point & Figure charting ...
I have
> created an application that will create charts in Excel 2000 (I am
not sure
> if it will work in other versions).
>
> You can get the download at www.xlpnf.com. I did not create a help
file
> because I was not sure if there would be enough interest. I
created the
> application for my own use and will be updating it frequently (I
hope).
> Although the spreadsheet and application DLL are only 200k, the
download is
> about 2.5 meg because of VB overhead.
>
> The install will create a new startup folder with xlpnf.xls
spreadsheet in
> it. This spreadsheet will call the DLL file to begin the program.
It
> should be pretty self explanatory but if there are any questions
please
> email me directly so not to congest this list (sorry for the cross
posting
> by the way).
>
> To draw trendlines on the chart, just right click to get a pop-up
menu. A
> couple of other shortcuts I should mention:
>
> CTRL-SHIFT-S will toggle the data sheets visible/hidden
> CTRL-SHIFT-T will toggle the minor grid line visible/hidden
> CTRL-SHIFT-C will toggle the comments visible/hidden
>
> You can get data using (currently) three data sources - Quotes Plus,
> AmiBroker and Yahoo. Quotes Plus is by far the fastest interface.
Yahoo is
> dependent on your internet connection. AmiBroker is kind of slow
(there has
> been mention of a better interface). But a faster call can be made
directly
> from AFL:
> //Create object from VB Project DLL
>
> xlpnf=CreateStaticObject("xlpnf.amibroker");
>
> q=xlpnf.ami2pnf(Name(),Day(),Month(),Year(),High,Low,Close,V,16);
>
> Everything up to Volume ('V') will remain the same. 16 is months
of data to
> load. There are two optional parameters after months of data -
Boxsize
> (default to traditional boxsize) and Reversal (default=3).
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
|