I have created a Nordic watchlist and imported the symbols into Amibroker. Since the tickers are Swedish, Danish, Norwegian or Finish, the symbol's currency will differ.
I do not want to go through each symbol and assign the currency in the Symbol Information window. So how do I go about importing the currency type when importing via an ASCII file? Perhaps there is another more suitable method.
I am using Amibroker version 6.30.5
I have done a search on the forum but can't find a suitable post.
there is no specific forum post on currency, but there is symbol information in which you can choose property
AmiBroker Knowledge Base » How to change property for multiple symbols at once.
so in your case you can modify the stock.Currency property
@wmorton, I will do via the Import Wizard using the ASCII specs.
In AB, create an exploration with all the Tickers (and Fullname if you have already filled them). Export the results to a .csv file.
Import in Excel.
Add a Currency column as needed (optionally add other columns like Country, ISIN - that for example you can store in the Alias field - FullName if not already present, etc.)
(You can also populate additionals column to also assign the symbols to specific watchlists and/or markets).
Save the Excel as .csv file and use the ASCII specs to update your database.
Before doing it, I suggest to backup your database (make a copy of the entire database folder), so you can experiment and in case something does not work as expected you can restore it (this also applies in case you opt for the OLE procedure described in the links provided in the @nsm51 post).