HomeReady-2-GoPortfolioRankingScreenerStockETFToolsCommunityHelp
ForumsEmail UserPollsFeature RequestsGroups


  Index  | Recent Threads  | Who's Online  | User List  | Search
  Search  
Quick Go »
Thread Status: Normal
Total posts in this thread: 8
[Request a Feature] [Post new Thread]
[Add To My Favorites] [Watch this Thread]
Author
Previous Thread This topic has been viewed 857 times and has 7 replies Next Thread
bobhaskell1495
Advanced Member
Member's Avatar

UNITED STATES
Joined: Apr 20, 2006
Posts: 172
Status: Offline
Sim to stay in top-ranked stocks Reply to this Post
Reply with Quote

How would I construct a sim which would keep me in the top ranked stocks in a ranking system?

For example, suppose I want a sim which keeps me in the top five stocks in the GARP ranking system. It would have to buy the top five stocks at the start and then sell any that fell below the top five on each rebalance and buy the others that had moved into the top five. How would I write the buy rules and the sell rules?

-Bob
----------------------------------------
[Edit 1 times, last edit by bobhaskell1495 at Aug 18, 2006 1:03:57 PM]
[Aug 18, 2006 1:01:20 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
bl82
Advanced Member
Member's Avatar

UNITED STATES
Joined: Apr 18, 2004
Posts: 97
Status: Offline
Re: Sim to stay in top-ranked stocks Reply to this Post
Reply with Quote

One way would be by having some of the attached feature requests implemented: http://www.portfolio123.com/feature_request.jsp?poll=181
----------------------------------------
http://vixandmore.blogspot.com/
"Your one stop VIX-centric view of the universe..."
[Aug 18, 2006 1:14:58 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
jerrodmason
Advanced Member
Member's Avatar

UNITED STATES
Joined: Jan 14, 2005
Posts: 599
Status: Offline
Re: Sim to stay in top-ranked stocks Reply to this Post
Reply with Quote

Good news: It's easy to do this. Here's an example sim (Edited to correct bad link)

The key is to select the "YES" option button in the General Parameters section: Allow sold stocks to be rebought.

The buy/sell rules are really simple:
Buy:
Sell: Rank < 101
This sim sells everything each week, then buys the top five. Often this involves selling and buying the same stock, which should result in a wash (nosale), BUT P123 actually treats this as two transactions with DOUBLE commissions and slippage (instead of zero) and artificially inflating the turnover.

I'm reporting this as an error. I also note that the feature request mentioned by Bill (bl82) is a much more flexible implementation of the basic idea.

J
----------------------------------------
The smart money was on Goliath.
"He's not the Messiah. He's a very naughty boy."

----------------------------------------
[Edit 6 times, last edit by jerrodmason at Aug 18, 2006 5:37:46 PM]
[Aug 18, 2006 2:00:40 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
bobhaskell1495
Advanced Member
Member's Avatar

UNITED STATES
Joined: Apr 20, 2006
Posts: 172
Status: Offline
Re: Sim to stay in top-ranked stocks Reply to this Post
Reply with Quote

Thank you. However, I already voted.
-Bob
[Aug 19, 2006 7:22:41 AM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
bobhaskell1495
Advanced Member
Member's Avatar

UNITED STATES
Joined: Apr 20, 2006
Posts: 172
Status: Offline
Re: Sim to stay in top-ranked stocks Reply to this Post
Reply with Quote

Jerrod-
Thank you for your rules. I tried them and got "Required Dates are not Loaded" "Try Again". I thought that maybe today's date was not loaded, so I backed up a day from today and tried again with the same result. So I took a month off each end of the run and tried again and still got the same result. Do you know what the problem might be?
-Bob
[Aug 19, 2006 7:35:15 AM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
forte
Member


UNITED STATES
Joined: Aug 9, 2006
Posts: 9
Status: Offline

Re: Sim to stay in top-ranked stocks Reply to this Post
Reply with Quote

I'm having the same proble. Clearly the system is down. It would be nice to have the people in charge publish a notice to that effect so that everyone would kept up to date
[Aug 19, 2006 8:38:13 AM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
bobhaskell1495
Advanced Member
Member's Avatar

UNITED STATES
Joined: Apr 20, 2006
Posts: 172
Status: Offline
Re: Sim to stay in top-ranked stocks Reply to this Post
Reply with Quote

The problem seemed to be that I was running a sim on Saturday morning when Marco was doing the rebalancing.

I ran a sim using Jerrod's rules on Filip's Super Value, 10 stocks, weekly rebalance, all possible dates, commission of $1 per trade, and got the following result:

AR= 154
ATO= 5159
DD= 27
Sharpe=4.99
%win=57

I wouldn't want to use this with real money because the high turnover would hurt me with real commissions and slippage.

It would help if Bill's Feature Request would be acted on (Poll 181). Then we could cut down on the turnover for the same strategy because we would not have to sell all the stocks each rebalance.

-Bob
[Aug 19, 2006 9:13:55 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
jerrodmason
Advanced Member
Member's Avatar

UNITED STATES
Joined: Jan 14, 2005
Posts: 599
Status: Offline
Re: Sim to stay in top-ranked stocks Reply to this Post
Reply with Quote

Bob, I checked out your example to see about weekly turnover. At 43% (calculated average for 5 years of sim) it's high, but not as bad as it might seem. Here are the details on number of NoSales each week:
0 0%
1 0%
2 2%
3 8%
4 12%
5 21%
6 25%
7 22%
8 9%
9 2%
10 0%
I suspect that a 20 stock sim would have a lower turnover. Will check.
----------------------------------------
The smart money was on Goliath.
"He's not the Messiah. He's a very naughty boy."

----------------------------------------
[Edit 1 times, last edit by jerrodmason at Aug 20, 2006 6:28:48 PM]
[Aug 20, 2006 4:41:55 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
[Show Thread Printable Version] [Post new Thread]

Free Trial  /  Log In
Username or Email
Password
Stay logged in
Can't remember username or password?