|
PureBytes Links
Trading Reference Links
|
Well, I asked him to post that - aren't you gonna thank ME? 8-)
d
> -----Original Message-----
> From: amibroker@xxxxxxxxxxxxxxx
> [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of Joe Landry
> Sent: Sunday, August 06, 2006 10:40 PM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: Re: [amibroker] Re: AmiBroker 4.84.0 BETA released
>
> Thanks Mike. But then it could have been Laura who was
> writing. (g)
>
> This was definitely the kick start I needed and I got a
> small demo going.
> Didn't read your note carefully enough and had a miscue with
> the connection name, but once I got past that it works fine.
>
> Best regards
> Joe
>
>
>
>
> ----- Original Message -----
> From: "mikelaurataylor" <mikelaurataylor@xxxxxxxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Sunday, August 06, 2006 8:38 PM
> Subject: [amibroker] Re: AmiBroker 4.84.0 BETA released
>
>
> > Yes, its Mike writing. If Taylor (3 yrs old) was writing then I'd
> > really be impressed.
> >
> > Mike
> > --- In amibroker@xxxxxxxxxxxxxxx, "Joe Landry" <jelandry@xxx> wrote:
> >>
> >> Bless you mikelaurataylor, for sharing this.
> >> I'm gong to use an Access table to track holdings with columns
> >> holding ticker, no of shares, divd, date split (wow it gets
> > complicated)
> >> in order to generate a weighted equity curve.
> >>
> >> Best regards
> >> JOE
> >> P/S. Is it Mike who's writing?
> >>
> >> ----- Original Message -----
> >> From: "mikelaurataylor" <mikelaurataylor@xxx>
> >> To: <amibroker@xxxxxxxxxxxxxxx>
> >> Sent: Sunday, August 06, 2006 2:46 PM
> >> 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@> 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
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >>
> >
> >
> >
> >
> >
> >
> > 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
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
> 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
>
>
|