|
PureBytes Links
Trading Reference Links
|
Hello Graham,
Is that a cryptic message or are you just sick of acronyms?
BrianB2
--- In amibroker@xxxxxxxxxxxxxxx, Graham <kavemanperth@xxx> 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@xxx> 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@xxx>
> > *To:* amibroker@xxxxxxxxxxxxxxx
> > *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@xxx>
> > *To:* amibroker@xxxxxxxxxxxxxxx
> > *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@xxx>
> > *To:* amibroker@xxxxxxxxxxxxxxx
> > *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@xxx>
> > *Date:* 07/21/06 16:08:47
> > *To:* amibroker@xxxxxxxxxxxxxxx
> > *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 amibroker@xxxxxxxxxxxxxxx, "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
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
|