|
PureBytes Links
Trading Reference Links
|
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@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxx>
> *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@xxxxxxxxxxxxx>
> *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@xxxxxxxxxxxxx>
> *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@xxxxxxxxxxxx>
> *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@xxx> 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
>
>
>
>
>
>
>
>
>
>
>
|