|
PureBytes Links
Trading Reference Links
|
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 amibroker@xxxxxxxxxxxxxxx, "Prashanth" <prash454@xxx> 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: amibroker@xxxxxxxxxxxxxxx
> 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 <brian.z123@xxx> wrote:
> > Hello Graham,
> >
> > Is that a cryptic message or are you just sick of acronyms?
> >
> > BrianB2
> >
> > --- In amibroker@xxxxxxxxxxxxxxx, 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:* 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@>
> > > > *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@>
> > > > *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@>
> > > > *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
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> >
> >
> >
> >
> >
> >
> >
> > 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
> >
> >
> >
> >
> >
> >
> >
> >
>
|