AmiQuote Quandl AMFI format file construction

I am giving up trying now. Please help with a little guidance. What's the correct format to import a csv file that looks like below? (This is from QuanDL)

$NAME AMFI/100034
Date,Net Asset Value,Repurchase Price,Sale Price
2019-04-30,93.0,,
2019-05-02,92.6,,
2019-05-03,92.69,,
2019-05-06,91.84,,
2019-05-07,91.04,,
2019-05-08,89.92,,
2019-05-09,89.58,,
2019-05-10,89.97,,

Import ASCII help page does not guide on such a format.

Is it correct to not include Ticker anywhere in format file as it is being supplied by CSV? In that case the below format file structure should be correct. Please guide.

# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard
$FORMAT Date_YMD, Close, Skip, Skip, Skip, Skip, Skip
$BREAKONERR 0
$SKIPLINES 0
$SEPARATOR ,
$CONT 1
$GROUP 255
$AUTOADD 1
$DEBUG 1

If your filename is same as ticker, then not necessary. Say, you have multiple files with each file_name same as ticker, then this code will work. Ami will take file_name as ticker.

Otherwise include ticker name in your import code.

Hope it helps

1 Like

AmiQuote does download and saves file with ticker as filename. So that solves the problem.