ASCII Import couldn't update Dividends & Splits

Hi All,

I am having problem importing Dividends & Splits portion.
This is my .format file.
$FORMAT Ticker,DIVIDEND,DIV_PAY_DATE,EX_DIV_DATE,FORWARD_DIV ,LAST_SPLIT_DATE,LAST_SPLIT_RATIO
$SEPARATOR ,
$SKIPLINES 1
#$CONT 1
#$AUTOADD 1
#$DEBUG 1
$NOQUOTES 1

Sample of my import in CSV.
AAPL,2.82,2/14/2019,2/8/2019,2.92,6/9/2014,1:07

I am using version 6.20.1.
I couldn't get the CSV file to update in Amibroker.
Any help is much appreciated.

Those fields (values) are scalar so is the last one reflecting in "Symbol Information" atleast ?

I tried this format too. But it didn't work.
AAPL,2.82,02-14-2019,02-08-2019,2.92,06-09-2014,7:1

You really need to read the documentation http://www.amibroker.com/guide/d_ascii.html

To overwrite non-quotation data for existing symbols you need

$OVERWRITE 1

Open up aqfn.format file in Formats folder and you will see proper format. It looks like this:

$NOQUOTES 1
$AUTOADD 1
$OVERWRITE 1
$SEPARATOR ,

$FORMAT TICKER,FULLNAME,CLOSE, EPS, EPS_EST_CUR_YEAR, EPS_EST_NEXT_YEAR, EPS_EST_NEXT_QTR, PEG_RATIO, BOOK_VALUE_PER_SHARE, EBITDA, SKIP, REVENUE, SKIP, DIV_PAY_DATE, EX_DIV_DATE, DIVIDEND, ONE_YEAR_TARGET, SKIP, SHARES_FLOAT, SHARES_OUT

I did look at the page.
Change the .format to this.
$NOQUOTES 1
$AUTOADD 1
$OVERWRITE 1
$SEPARATOR ,
$SKIPLINES 1
$FORMAT TICKER,DIVIDEND,DIV_PAY_DATE,EX_DIV_DATE,FORWARD_DIV ,LAST_SPLIT_DATE,LAST_SPLIT_RATIO

My CSV input file.
TICKER,DIVIDEND,DIV_PAY_DATE,EX_DIV_DATE,FORWARD_DIV ,LAST_SPLIT_DATE,LAST_SPLIT_RATIO
AAPL,2.82,2/14/2019,2/8/2019,2.90,6/9/2014,7:1

I have no problem with Statistics and Financials parts.
Is it a proper way to import the LAST_SPLIT_RATIO ? 7:1
Still couldn't update.

Some how after many tries, it only accept DD/MM/YYYY format for input dates. If other than this date format, it will not update. As for split ratio format of 7:1 is OK but ratio like 1398:1000 for Agilent will not work. For the Agilent case, the imported ratio is 118:-24. The ratio figure has to be less than or equal to 100.
For AAPL, this works fine.
AAPL,2.80,14/2/2019,8/2/2019,2.92,9/6/2014,7:1
This is what I have found on my system and I cannot say other users will experience this problem.

Just curious, what is your system date format?

ASCII importer accepts not only DD-MM-YYYY but also ISO standard date format (YYYY-MM-DD) and various other formats including those with names for months (instead of numbers).

As for split ratio imported by ASCII importer it must be X:Y where X and Y are 1...127.

Users guide:
http://www.amibroker.com/guide/h_fundamental.html
and
http://www.amibroker.com/guide/d_ascii.html

Region%20and%20Language

As I wrote there is International Standard for date formatting, ISO, and it is: YYYY-MM-DD . https://en.wikipedia.org/wiki/ISO_8601

All other formats are non-standard. Fundamental data can use either ISO format (YYYY-MM-DD) or CDN format DD/MM/YYYY (DD-MM-YYYY, or whatever other separator) plus a plethora of other date formats that use names for months.

I am just reporting what I am seeing in my system. It could be my system related issue.
By the way, I plug in ratio numbers, the max it can go 127:127. If I plug 128, it will import -128.

Here is the screen shot of the Information window. It showing DDMMYYYY format. Possible to change it ? The -128:-128 is from import 128:128.
Amibroker_screen_shot

Yes indeed it 127 max, since this is signed char. But 6.31 will accept 1..32767

Many thanks.
The wonderful thing about Amibroker is that it has many routes to fixing problems.
OLE Automation has LastSplitFactor that will take ratio in string.