I have created a local database and use a third party plugin for RT data feed. Limitation of plugin is of 200 tickers at a time, whereas the number of tickers I create in the database range between 500-600. These are weekly options. Database is for one month. So at a time only 1/4th of total symbols require RT feed. I import these tickers through the 'Import Ascii' option from a csv file.
I am trying to set the 'Use Only Local database' option for every symbol to 'Yes' while using 'Import ASCII', but failed. I tried creating a separate format file with $USEONLYLOCALDB 1. But even that doesn't work. Setting these manually for 400-500 tickers would be very tedious every month or every week. Is there a way to set this flag through AFL?
@snoopy.pa30, unfortunately there's no such filter. The RT plugin subscribes to all the tickers that are Explored/Back tested. The only way is to create a filtered watchlist for only those symbols that need RT feed. But this invalidates my purpose of including the old ones which provide historic data back testing in the same backtest. I could do this but this would result in a lot of extra collation of data from two separate backtest results into excel and then organizing them. I was wondering if there is a way of setting the 'use local database only' flag for required symbols through AFL. Thanks.
@Muli, thanks. But this is the manual way that I am aware of. Setting it this way would be too tedious for hundreds of symbols. And this procedure has to be repeated every week, because these tickers are weekly options. I am looking for an easier way, if any, through some keyword used in import ascii format file OR any command/procedure in AFL.