Thanks! d
> -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of mikelaurataylor > Sent: Sunday, August 06, 2006 3:47 PM > To: [email protected] > 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" <[EMAIL PROTECTED]> 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 > > > > > > > > -- > 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/
