choco
October 13, 2021, 5:15pm
1
Hi @Tomasz ,
I would like to know more about the StockInfo
that I found in ADK
How is the mapping between symbol and their stockInfo? is it a 1-to-1 relation? or can a symbol has more than one StockInfo?
Are there any possibility to store historical Fundamental data in Amibroker Local Database?
I tried to search both information, coudnt find it
Thank you
Tomasz
October 13, 2021, 5:20pm
2
It is 1-to-1 relationship and fundamental data are stored in AmiBroker database already (but only current values). Historical fundamental data can be stored, if needed, in artificial symbols in regular OHLCV, Aux1/Aux fields.
choco
October 13, 2021, 5:21pm
3
Well, just found related information from this link
Alias as any other field should be used ONLY for its intended purpose (in this case the ALIAS) not for storing anything else. For storing “complex data” you have FILES
http://www.amibroker.com/f?fopen
Abusing any field for storing something else than designed may and will lead to unpredictable results including crashes all kind of troubles.
You just don’t do that as you don’t fill your bath tube with sulphuric acid.
may be this is an options
choco
October 13, 2021, 5:24pm
4
Which one do you think a better solution, using artificial symbols, or external file?
for artificial symbols, can you describe more about this idea?
assuming 1 symbol has 5 years of fundamental data (yearly)
Thank you
Tomasz
October 13, 2021, 9:58pm
5
Native database is faster than anything else.
Everything is in the Knowledge Base:
AmiBroker database structure offers the following fields: Open, High, Low, Close, Volume, OpenInt, Aux1, Aux2. The last two fields, i.e. Aux1 and Aux2 are meant for storing any custom historical data-arrays we may need.Pretty often, we already have...