[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



PureBytes Links

Trading Reference Links

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
>