Help with strategy - Trading Software

Help with strategy

Will
2015-02-25 17:15:39

Can someone please suggest a way that I can rank a group of ETF's and only purchase the top 4 ranking etf's so long as they are ranked lower than
the ETF SHY.

so I have a group of ETF which I rank using 12 month performance.

Rank12 = comp(perf(close,252),"rank");

buy = rank12 <5

This will buy the top 4 ranking etf's but I need a rule that says only buy if the rank is lower the SHY, so if SHY happens to be ranked 3 the buy would
only purchase the top 2 ranking etf's.

Any ideas? I'm new to programming in Quantshare and still trying to learn how these codes and functions work.

Thanks

QuantShare
2015-02-27 03:00:14

The rank is lower than SHY means that the ETF perf must be higher than SHY perf.

For this you can use this formula:

p = perf(close,252);
Rank12 = comp(p,"rank");
shy = perf(getseries("shy", close), 252);
buy = rank12 <5 and p > shy;

Get more messages

No more messages

Back


Trading Items Long strategy created with the money management tool Adaptive BuyInd MR_Mom Strategy Sleep Well Bond Rotation Strategy V1.0 Intraday Trading System with Daily Ranking FRAMA Adaptive Strategy	How-to Lessons How to use QuantShare with Metastock data How to associate an index with a list of stocks How to screen for stocks having a high correlation with the Dow J... How to create a chart with a black background How to speed up watchlist and screener plug-ins when working with...
Related Forum Threads Help With Daily Data Import Script Problem with downloading a strategy Need help with a MM Script Help with Quantshare Language Help with Survivorship Bias Free DB	Blog Posts Money Management: Scale-in Trading Strategy How to Backtest a Strategy from a Chart How to Backtest an Intraday Stock Trading System with EOD Ranking Backtesting a Strategy Based on Bond and Stock Index ETFs Working with the formula editor