|
PureBytes Links
Trading Reference Links
|
Thanks!
d
> -----Original Message-----
> From: amibroker@xxxxxxxxxxxxxxx
> [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of mikelaurataylor
> Sent: Sunday, August 06, 2006 3:47 PM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: [amibroker] Re: AmiBroker 4.84.0 BETA released
>
> 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
> > >
> > >
> >
>
>
>
>
>
>
> 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
>
>
|