Importing NOQUOTES data via OLE

[amitabhanandy]

Hi,

I am trying to import stocks NOQUOTES type data via OLE. However, I am not getting the desired output. Request you to please assist on what am I missing.

Content of Format file used is as below:

Format definition file generated automatically

by AmiBroker's ASCII Import Wizard

$FORMAT Ticker,WATCHLIST,ROUNDLOTSIZE,TICKSIZE,MARGIN,SECTORNAME
$OVERWRITE 1
$CLEANSECTORS 1
$SORTSECTORS 1
$SEPARATOR ,
$AUTOADD 1
$CONT 1
$NOQUOTES 1

Sample Data trying to Import is as below:

IDXNNIFTYMIDCP,FNO,50,10,0,UNK
AARTIIND_20240725_640_CE,Ex_2024_07_25_STK,1000,0,0,UNK

As you can see, I am trying to assign Ticker IDXNNIFTYMIDCP to watchlist FNO and assigning ROUNDLOTSIZE to 50, TICKSIZE to 10, Margin 0, and Sector UNK

Similarly I am trying to assign Ticker AARTIIND_20240725_640_CE to watchlist Ex_2024_07_25_STK and assigning ROUNDLOTSIZE to 1000, TICKSIZE to 0, Margin 0, and Sector UNK

When I am running the import via OLE the ImportResponse is 0 which means the import was successfull. However I am not seeing the new watchlists under the Watch Lists tree . Please suggest what am I doing wrong.

Please note that the number of watchlists for the entire set of data is expected to be 100+ . But as far as I know there is no limit on number of watchlists in Amibroker.

Thanks,
Nandy

[mradtke]

From the documentation, it appears the watchlist should be identified by a number, not a name:

WATCHLIST specify a field that contains watch list number (0-31) (affects $AUTOADD and $OVERWRITE modes only)

[amitabhanandy]

Dear mradtke,

Thank you for pointing that. I tried using watch list number and it works perfectly. But I really wanted to control the Name of the new WatchList from my OLE program (which becomes much readable as simply by the watchlist name I know what type of symbols are present there) Using a number as watchlist and later renaming those is a bit cumbersome since I am trying to load Option symbols into the watchlist based on ExpiryDate and these kind of symbols will continue to come with new expiry dates. Do you have any solution/idea to address this ?

Thanks,
Nandy