Search / Replace (MA, C, AR)

[kcaron]

I have to find a way to replace MA, C, and AR if a user enters these stock tickers in a program.

My program begins with a userform that asks the user to enter a list of tickers and then stores the tickers in a variable called %tickerlist. It then fetches a stock price series for each using a Bloomberg link.

It works well except where MA, C, or AR are entered because these are all restricted variables in EViews.

So... I think a workaround is to run a loop of some kind on the tickers stored in %tickerlist and, whenever a restricted ticker is found, replace it with the company's CUSIP or ISIN.

it would be great if there was a list of all reststricted variables in case there are other tickers that might cause issues... It may exist somewhere, but I can't seem to find it.

Many thanks in advance for any suggestions.

KC

[EViews Gareth]

You can use the @isvalidname function.