Regarding this discussion, is it possible to load a different value into one of the fundamental fields to be used in a scan. For example, if I have a field associated with a fund called "%Load" and want to scan for all funds with %Load < some value, can I load the percent Load into the "ROE" field for example and scan on ROE but really be looking at %Load??
Anyone know if this can be done? If the answer is yes, another question later on will be how do I get the specific data I want into the proper field in the AB database. Right now my source is an Excel spreadsheet but that in turn downloaded data from the Morningstar database (somehow). I am trying to answer a question for someone who has been Excel based and wants to try and become AB based. Any suggestions? Thanks, Ken --- In [email protected], "Joe Landry" <[EMAIL PROTECTED]> wrote: > > Correct, it's stored in the AB database. Note you can view these fields by > selecting View/Symbol Information and you'll get a pane with these fundamental values. > <snip> > Joe L. > > ----- Original Message ----- > From: ftstrades > To: [email protected] > Sent: Tuesday, February 20, 2007 6:35 PM > Subject: [amibroker] Re: Exploring fundamental data in AB 4.90 > > > Thanks Joe, that works very nicely. Now I guess this is reading from > Yahoo Finance database I downloaded using Amiquote, How often does > one have to update Yahoo finance data via Amiquote though? > Thanks > > --- In [email protected], "Joe Landry" <jelandry@> wrote: <snip> > > a.. "ReturnOnEquity" > > a.. "QtrlyRevenueGrowth" > > a.. "GrossProfitPerShare" > > a.. "SalesPerShare" > > a.. "EBITDAPerShare" > > a.. "QtrlyEarningsGrowth" > > a.. "InsiderHoldPercent" > > a.. "InstitutionHoldPercent" > > a.. "SharesShort" > > > > Run this clip in the Automatic Analyzer choosing the watchlist or > filter. > > // Start of Explore Example > > ROE = GetFnData("ReturnOnEquity"); > > filter = ROE > 15; > > addcolumn(ROE,"Return on Equity"); > > > > HTH > > Joe > >
