Importing historical fundamental data

[kaizen]

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.

[Tomasz]

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

[kaizen]

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

[Tomasz]

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).

[beppe]

@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.

[Milosz]

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

Arrays of strings

Amibroker DB is designed for only Numeric Array. Because all functions will process only float/ date values. Being able to use String array opens a huge world of opportunities to bring in qualitative data points like custom notes, News, social media sentiments, News Full text Search and lot more. But @Tomasz what stops from introducing String Array? If at all a user uses string array with a function that expects a numeric array then just show a error “Format Mismatch” or something. varset/ v…

Duplicating Symbols in amibroker

Hi, Is there a way how I can duplicate an existing symbol and store the duplicated symbol under a different name in the same database ? For Eg. I want to duplicate “NIFTY” and store it as “NIFTYONE” so that every time " NIFTY " gets updated in real time , "NIFTYONE " also gets updated. Regards

Plot Earnings Dates

Hey @tomasz, that’s great. So I know since the data can be stored per bar in the database…that we can plot it. So, I guess the questions are: Anyone know of any good databases that would provide this data by ticker by date Wondering what the best way to import this data is if we get it Thanks!

Aligning a custom array's index to symbol's index

Just wondering is there any function or code available that aligns an array (created from external Text file content) to the symbol’s index? Note: this array can be a subset or superset in terms of date of the Symbol’s date. So I want to align the custom array’s index to that of Symbol’s Index.

Which field to store String Type Ticker Level Data?

Hi, I want to store string type - Ticker level data like : status - Active, suspended, inactive State of Operation subsidiary names And couple of more such fields. All are String. I am already strong Sector and Industry in their respective fields. I know I can convert String to Numeric ( Codify) but, I want to know are there any placeholder fields which can hold strings? The fundamental data fields https://www.amibroker.com/guide/h_fundamental.html can only hold Numerics. Any guidance on …

Aligning a custom array's index to symbol's index

Just wondering is there any function or code available that aligns an array (created from external Text file content) to the symbol’s index? Note: this array can be a subset or superset in terms of date of the Symbol’s date. So I want to align the custom array’s index to that of Symbol’s Index.

[beppe]

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!

[kaizen]

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