Hello Prashanth, Thanks for the zoo link. I didn't kow about that site before so that is a good find for me.
BrianB. --- In [email protected], "Prashanth" <[EMAIL PROTECTED]> wrote: > > Is this a Joke :) ? > > http://www.webopedia.com/TERM/O/ODBC.html > > http://en.wikipedia.org/wiki/ODBC > > http://sqlzoo.net/ > > http://en.wikipedia.org/wiki/SQL > > Cheers > > Prashanth > > ----- Original Message ----- > From: Graham > To: [email protected] > Sent: Monday, July 24, 2006 4:13 PM > Subject: Re: [amibroker] Re: In the Ongoing Discussion of Historical Fundamental Data > > > I honestly have no idea what the heck they mean or what they are for > > -- > Cheers > Graham > AB-Write >< Professional AFL Writing Service > Yes, I write AFL code to your requirements > http://e-wire.net.au/~eb_kavan/ab_write.htm > > On 24/07/06, brian.z123 <[EMAIL PROTECTED]> wrote: > > Hello Graham, > > > > Is that a cryptic message or are you just sick of acronyms? > > > > BrianB2 > > > > --- In [email protected], Graham <kavemanperth@> wrote: > > > > > > Now all I have to do is work what the heck all these acronyms like > > ODBC and > > > SQL mean > > > > > > > > > -- > > > Cheers > > > Graham > > > AB-Write >< Professional AFL Writing Service > > > Yes, I write AFL code to your requirements > > > http://e-wire.net.au/~eb_kavan/ab_write.htm > > > > > > On 22/07/06, Tomasz Janeczko <groups@> wrote: > > > > > > > > Hello, > > > > > > > > ODBC plugin is database-independent, so you can hook up to > > Access as well. > > > > Just create database in Access, then create ODBC data source > > name linking > > > > to Access database, > > > > using Windows Control Panel / Admin ODBC data sources and then > > you can > > > > use the plugin. > > > > > > > > Any subsequent examples will work on all/any database engine. > > > > > > > > Best regards, > > > > Tomasz Janeczko > > > > amibroker.com > > > > > > > > ----- Original Message ----- > > > > *From:* Joe Landry <jelandry@> > > > > *To:* [email protected] > > > > *Sent:* Saturday, July 22, 2006 4:15 PM > > > > *Subject:* Re: [amibroker] Re: In the Ongoing Discussion of > > Historical > > > > Fundamental Data > > > > > > > > Tomasz - Thanks for adding the ODBC plug-in. I think it will > > benefit me > > > > but the mySQL learning curve looks like > > > > it is pretty steep for me. I'm wondering if in your "details > > will follow > > > > later" if you could include an example of > > > > hooking up to Access tables? A starter say. > > > > > > > > Best regards > > > > JOE > > > > > > > > > > > > ----- Original Message ----- > > > > *From:* Tomasz Janeczko <groups@> > > > > *To:* [email protected] > > > > *Sent:* Saturday, July 22, 2006 3:34 AM > > > > *Subject:* Re: [amibroker] Re: In the Ongoing Discussion of > > Historical > > > > Fundamental Data > > > > > > > > Don, > > > > > > > > Current version of the SQL plugin is read-only, but future > > release will > > > > allow writing from AFL level, > > > > this connected with GetFnData would give possibility to actually > > create > > > > historical fundamental database from one simple > > > > AFL formula. Details will follow later. > > > > > > > > Best regards, > > > > Tomasz Janeczko > > > > amibroker.com > > > > > > > > ----- Original Message ----- > > > > *From:* Don Lindberg <dlindber@> > > > > *To:* [email protected] > > > > *Sent:* Saturday, July 22, 2006 8:05 AM > > > > *Subject:* Re: [amibroker] Re: In the Ongoing Discussion of > > Historical > > > > Fundamental Data > > > > > > > > Brian, > > > > > > > > Thanks for the reply. I now have a much clearer picture of how > > the data is > > > > kept in AB. Now I have to figure out how to create a SQL > > database with the > > > > "extra" data I want to build history on |;>). > > > > > > > > Thanks Again, > > > > > > > > Don > > > > > > > > *-------Original Message-------* > > > > > > > > *From:* brian.z123 <brian.z123@> > > > > *Date:* 07/21/06 16:08:47 > > > > *To:* [email protected] > > > > *Subject:* [amibroker] Re: In the Ongoing Discussion of > > Historical > > > > Fundamental Data > > > > > > > > Hello Don, > > > > > > > > I still have a lot to learn about AB, so, with some > > qualification the > > > > answer is no. > > > > > > > > Ami does not work like that. > > > > It can only keep six fields or columns of data (OHLCVOI), if we > > > > compare it a spreadsheet or a database table for learning > > purposes. > > > > The other information like the company name, category and the new > > > > fundamental data etc is only stored once. > > > > If you are used to spreadsheets just consider that the Yahoo > > data is > > > > stored in columns with only one row, while the OHLCVOI data can > > be > > > > stored in an unlimited number of rows (technically speaking this > > in > > > > not correct as Ami uses arrays not 'columns' but that is how I > > think > > > > about it for ease of learning). > > > > When you update your fdata with a new download from Yahoo the old > > > > numbers will be replaced (overwritten) by the new numbers so > > there is > > > > No way to refer back to previous, say EPS. > > > > > > > > There was a way around this by importing with the ASCII wizard > > and > > > > using an artificial ticker to store the historical data, but > > that is a > > > > little more difficult to do. > > > > To manage that with the new Yahoo fdata you would first need to > > export > > > > the data from AB on a regular basis and save each line of export > > by > > > > appending it to the previous line(s)in a separate file outside > > of AB > > > > e.g. a .CSV file. > > > > From there you can import it back into AB as an artificial > > ticker. > > > > That is a separate subject if you want to go into it. > > > > > > > > That is not so relevant as of today as Tomasz just posted a > > notice to > > > > say that the new 'database' plug in has been released. > > > > It is designed to allow users to read databases containing data > > that > > > > is extra to the OHLCVOI fields that comprise the normal AB > > databases. > > > > I haven't downloaded and read the instructions as yet but I > > expect it > > > > to be easy to use. > > > > > > > > In the long run, that would be the recommended way to go for > > > > fundamentalists. > > > > It will definitely be much easier to use historical fundamental > > data. > > > > That leaves us with the problem now of finding some databases to > > > > practise on. > > > > For actual trading use databases that have been kept for us by > > others > > > > are the best bet but some users will export from AB/Yhaoo data > > and > > > > compile historcal records for themselves. > > > > > > > > For commercial sources refer to mmy previous historical > > fundamental > > > > data provider lists. > > > > > > > > One of the sources in that list is reported to have free data > > (HOOVER) > > > > which would be good for training use or people who prefer that. > > > > I will look more closely at the prospects on the list later. > > > > I am not optimistic about the chance of finding free histo fdata > > (the > > > > cost of compiling and maintaining such databases is too high for > > > > owners to give a lot of it away). > > > > > > > > Some Amifriends might have histo database files they will share > > for > > > > training use. > > > > > > > > I am sure there will be more forum help forthcoming on the new > > plugin > > > > and how to acquire and use histo fundamental databases. > > > > > > > > BrianB. > > > > > > > > --- In [email protected], "Don Lindberg" <dlindber@> > > wrote: > > > > > > > > > > I have a question about setup of AmiBroker regarding the > > Fundamental > > > > > Data we can now dowload from Yahoo. While I realize that > > Yahoo does > > > > > not keep this info in a Historical database, does AmiBroker? > > What I > > > > > mean is this. If I download the fundamental data, say once a > > week, > > > > am > > > > > I overtime building a history of this data? And if I am, how > > do I > > > > > compare today with last week? > > > > > > > > > > Don Lindberg > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 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 > > > > > > > > > > > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> GFT Forex Trading Accounts As low as $250 with up to 400:1 Leverage. Free Demo. http://us.click.yahoo.com/lpv1TA/jlQNAA/U1CZAA/GHeqlB/TM --------------------------------------------------------------------~-> 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/
