Well, I asked him to post that - aren't you gonna thank ME? 8-) d
> -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of Joe Landry > Sent: Sunday, August 06, 2006 10:40 PM > To: [email protected] > 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" <[EMAIL PROTECTED]> > To: <[email protected]> > 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 [email protected], "Joe Landry" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > >> To: <[email protected]> > >> 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 [email protected], "dingo" <dingo@> wrote: > >> >> > >> >> How about showing the code you use to "hook up" to the > Access DB? > >> >> > >> >> d > >> >> > >> >> > -----Original Message----- > >> >> > From: [email protected] > >> >> > [mailto:[EMAIL PROTECTED] On Behalf Of > mikelaurataylor > >> >> > Sent: Sunday, August 06, 2006 10:45 AM > >> >> > To: [email protected] > >> >> > 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 [email protected], "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 > > 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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/amibroker/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
