|
PureBytes Links
Trading Reference Links
|
The code to hook up to the Access database is below. Before you can
use it there are two things you need to do.
1. You need to have an access database with the data you want in it
(obviously). In this case I have a database called "earnings" with
a table called "Selected" in it that has 1 record per symbol
containing fields with company name, ticker, float, earnings for each
of the last 8 quarters, sales for each of the last 8 quarters.
There are a ton of posts in the last 30 days about where to get this
info, I use the AAII data from the software I pay $200 / yr for.
2. You need to set up an ODBC connection to that database. On a 32
bit version of windows you can do it under "Administrative Tools"
under "Control Panel". In this case you'd set a connection with a
name of "earningsdb" (what I used below) to the physical database
called "earnings" (what I used). In my case I'm running xp64 which
created a complication into it but I found ways around it and managed
to set the connection up by finding the 32 bit odbc executable.
3. Once that is done, here is the code. I added some comments here.
//establishes the connection to the odbc source. you need to have
//first set up this through control panel
odbcOpenDatabase("DSN=earningsdb");
// tells amibroker what field to look for the ticker in (first field)
//and the date, which in this case was not relevant
odbcSetFieldNames("ticker", "datenum" );
// sets individual fields. First value is the table, 2nd value
// is the ticker. Since I want it to use the ticker that AmiBroker is
// on, I leave this blank. 3rd value is the field I am calling
coname = odbcGetValue( "selected", "", "company" );
indus = odbcGetValue("selected","","industry");
q1e = odbcGetValue("selected","", "q1e");
q2e = odbcGetValue("selected","","q2e");
q3e = odbcGetValue("selected","","q3e");
q4e = odbcGetValue("selected","","q4e");
q5e = odbcGetValue("selected","","q5e");
q6e = odbcGetValue("selected","","q6e");
q7e = odbcGetValue("selected","","q7e");
q8e = odbcGetValue("selected","","q8e");
s1 = odbcGetValue("selected","","q1s");
s2 = odbcGetValue("selected","","q2s");
s3 = odbcGetValue("selected","","q3s");
s4 = odbcGetValue("selected","","q4s");
s5 = odbcGetValue("selected","","q5s");
s6 = odbcGetValue("selected","","q6s");
s7 = odbcGetValue("selected","","q7s");
s8 = odbcGetValue("selected","","q8s");
float = odbcGetValue("selected","","float");
Coname = odbcGetValue("selected","","company");
/// from here you can set your own code.
// for instance to do a canslim type screen that looks for 100%
// earnings growth quarter over quarter, plus revenue growth
// plus an increase in volume, plus an increase in price
// this works very well.
--- In amibroker@xxxxxxxxxxxxxxx, "dingo" <dingo@xxx> wrote:
>
> How about showing the code you use to "hook up" to the Access DB?
>
> d
>
> > -----Original Message-----
> > From: amibroker@xxxxxxxxxxxxxxx
> > [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of mikelaurataylor
> > Sent: Sunday, August 06, 2006 10:45 AM
> > To: amibroker@xxxxxxxxxxxxxxx
> > Subject: [amibroker] Re: AmiBroker 4.84.0 BETA released
> >
> > THanks for the continual flow of new versions!
> >
> > For what it's worth I have managed to do 2 things with recent
> > versions. First, with the realtime tabbed pain I managed to work
> > most of last week without loading Tradestation, which I'm trying to
> > get away from. The multiple tabs plus an AA Explore I wrote that I
> > run now and then to identify key changes, allows me to get away from
> > the Tradestation radarscreen. This is a big help.
> >
> > Also, yesterday I managed to create a first (rough) version
> > of a graph I can display on the screen that shows the 8
> > quarterly earnings and 8 quarterly revenue trends alongside a
> > price graph. I was able to use the new SQL plugin and
> > downloaded data into an Access database that I
> > access through the plugin. It's still rough but ultimately I think
> > will be a big help.
> >
> > THanks!
> >
> > --- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko"
> > <groups@> wrote:
> > >
> > > Hello,
> > >
> > > AmiBroker 4.84.0 BETA is released now.
> > >
> > >
> > http://www.amibroker.com/devlog/2006/08/06/amibroker-4840-beta-relased
> > > /
> > >
> > >
> > > Best regards,
> > > Tomasz Janeczko
> > > amibroker.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
> >
> >
> >
> >
> >
> >
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Free Edition.
> > Version: 7.1.394 / Virus Database: 268.10.7/410 - Release
> > Date: 8/5/2006
> >
> >
>
|