Is there a way to create a script to exclude the stocks that have been acquired recently?

Optuma Scripting
1

Hi. As mentioned in the title, I need some help in creating a script to exclude all the stocks that have been acquired recently.
Also, is there a way to scan for stocks that have an average daily trading value exceeding 10 million dollar?
One more question, how to create a script that gives a relative strength of a stock against, say, nasdaq index or spx?
Thanks in advance

2

There’s no way of knowing if a stock has been acquired - you would need to get that data from elsewhere and import it as an External Data Field to exclude them in a scan. For more on EDFs see here.

For a 10 day average of trading value over $10m use the Turnover function TO():

V1=TO();
MA(V1, BARS=10)>10000000

For relative strength use the RIC() function to set the benchmark and lookback period. For stocks outperforming the SPX over the last month:

V1=RIC(INDEX=SPX:WI, DATESEL=Last Month, ZEROBASED=True);
V1>0
1 Like
4

Thank you very much Darren! You are the best!

1 Like