|
PureBytes Links
Trading Reference Links
|
Hi Peter,
It worked. Thank you very much for your help. You
have been very helpful with all my repeated questions.
regards
Mohan
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
Peter
Gialames
To: <A
href=""
title=amibroker@xxxxxxxxxxxxxxx>amibroker@xxxxxxxxxxxxxxx
Sent: Friday, November 16, 2001 11:14
AM
Subject: RE: [amibroker] ImportingQuotes
Plus Fundamental fields into AMIBroker
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 valuestry{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@xxxx]Sent:
Thursday, November 15, 2001 10:04 PMTo:
amibroker@xxxxxxxxxxxxxxxSubject: Re: [amibroker] Importing Quotes Plus
Fundamental fields intoAMIBrokerHi Peter,Thank you
very much for your help. It worked. I tried the same to getEPSRANK too and
it doesn't seem to work. Are all these defined somewhere -what is
associated with what.Thanks for all your
help.regardsmohan----- Original Message -----From:
Peter GialamesTo: amibroker@xxxxxxxxxxxxxxxSent: Thursday, November
15, 2001 10:54 AMSubject: RE: [amibroker] Importing Quotes Plus
Fundamental fields intoAMIBrokerHello 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 valuestry{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@xxxx]Sent:
Thursday, November 15, 2001 8:51 AMTo:
amibroker@xxxxxxxxxxxxxxxSubject: Re: [amibroker] Importing Quotes Plus
Fundamental fields intoAMIBrokerHi Peter,Thanks for
your email. I tried it and unfortunately, it still returns , azero for QRS
value. I tried for AOL. Here is my code.Thanks for any
help.regardsMohanEnableScript("jscript");<%CInfo
= AFL.CreateStaticObject("QuotesPlus.Price");// NEW CreateStaticObject
!CInfo.Symbol = AFL("ticker");// try-catch block handles the situation
when// QuotesPlus object returns strange
valuestry{//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 GialamesTo:
amibroker@xxxxxxxxxxxxxxxSent: Wednesday, November 14, 2001 2:53
PMSubject: RE: [amibroker] Importing Quotes Plus Fundamental fields
intoAMIBrokerHello 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@xxxx]Sent: Wednesday, November 14, 2001 9:41
AMTo: amibroker@xxxxxxxxxxxxxxxSubject: [amibroker] Importing Quotes
Plus Fundamental fields into AMIBrokerHi Peter,In your
float indicator code , you are importing Float value form QuotesPlus
database. Have you been able to get other data from quotes plus? Itried to
get QRS and EPS values with the following commands, but it doesn'tseem to
work. I appreciate any help.thanksMohantry{//Float
= Number( CInfo.Float() )*1000000;QRS= Number( CInfo.QRS(0) );
//QRS= Number( CInfo.QRS ); - Neither seems towork//EPS= Number(
CInfo.EPS );}catch( e ){//AFL("Float") = 0;QRS =
0;}----- Original Message -----From: Peter GialamesTo:
amibroker@xxxxxxxxxxxxxxxSent: Wednesday, November 14, 2001 9:24
AMSubject: [amibroker] Re: Point & Figure ChartingSince
there have been some problems with Geocities and the downloadof the Point
& Figure application, Tomasz has been generous enough tolend me some
space. So if anyone has had any problems pleasedownload the app
here:<A
href="">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 amnot sure> if it will work in other
versions).>> You can get the download at www.xlpnf.com. I
did not create a helpfile> because I was not sure if there would be
enough interest. Icreated the> application for my own use and
will be updating it frequently (Ihope).> Although the spreadsheet
and application DLL are only 200k, thedownload is> about 2.5 meg
because of VB overhead.>> The install will create a new startup
folder with xlpnf.xlsspreadsheet in> it. This spreadsheet
will call the DLL file to begin the program.It> should be pretty
self explanatory but if there are any questionsplease> email me
directly so not to congest this list (sorry for the crossposting>
by the way).>> To draw trendlines on the chart, just right click
to get a pop-upmenu. 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
madedirectly> 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 monthsof
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 theYahoo!
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.Your
use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
|