Re: [amibroker] Re: In the Ongoing Discussion of Historical Fundamental Data

Sun, 23 Jul 2006 20:13:22 -0700

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 <[EMAIL PROTECTED]> 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
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 -----
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
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-------
 
Date: 07/21/06 16:08:47
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" <[EMAIL PROTECTED]> 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
>
 
 
 
 
 
 
------------------------ Yahoo! Groups Sponsor --------------------~-->
Great things are happening at Yahoo! Groups.  See the new email design.
--------------------------------------------------------------------~->
 
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:
 
 
Yahoo! Groups Links
 
<*> To visit your group on the web, go to:
 
<*> To unsubscribe from this group, send an email to:
 
<*> Your use of Yahoo! Groups is subject to:
 
 
 




__._,_.___

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




SPONSORED LINKS
Investment management software Real estate investment software Investment property software
Software support Real estate investment analysis software Investment software

YAHOO! GROUPS LINKS



__,_._,___

Reply via email to