|
PureBytes Links
Trading Reference Links
|
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
>
>
>
>
>
>
>
|