|
PureBytes Links
Trading Reference Links
|
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
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
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
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
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
|