Importing historical fundamental data

Hi, i'm building a database with fundamental data from Esignal in Excel, so i can import it as csv to Amibroker. It is posible to have historical fundamental data in Amibroker, and not just the last value. I'm asking because i'm not able to get it to work. I've already made the custom import format, something like this:

$NOQUOTES 1
$SKIPLINES 0
$SEPARATOR ,
$DEBUG 1
$AUTOADD 0
$ALLOWNEG 1

$FORMAT DATE_DMY, Ticker, SHARES_SHORT,

And i want to now if it can be done, so i am not wasting my time. Thanks.

As written in manual: http://www.amibroker.com/guide/h_fundamental.html

number (scalar) representing current value of fundamental data item. There is no history of values

If you want historical fundamentals you need to store them externally in the database and access them via ODBC plugin http://www.amibroker.com/odbc.html

Ok, thanks. It seems that i still have a lot to learn about that. I didn't notice the "scalar" term. Thanks.

Scalar has multiple meanings but in computer science it is just variable that can hold one value at a time https://en.wikipedia.org/wiki/Scalar (contrasted with array that holds multiple values).

1 Like

@kaizen, about the use of the ODCB AFL plugin, as suggested by @Tomasz, see also this post, where I answered a similar question, and I elaborated a bit on this subject.

@kaizen Additionally you might also consider some alternative ways of storing and accessing such data, discussed in these threads:






1 Like

And if one wants something fancier there is the option to use OLE automation to access directly Excel files or to write a web server (that probably will use some sort of DB) and then use a Rest API to query it.

But probably the ODBC way is simpler and more reliable!

Ok, thank you all for the imput. I have a lot to learn.