| StockFetcher Forums · General Discussion · ETF Ladder Results so far | << >>Post Follow-up |
| JoeyVinyl 125 posts msg #152574 - Ignore JoeyVinyl |
6/8/2020 11:45:46 PM Back on 4/3/2020 I made a post about making an ETF Ladder, similar to a CD Ladder. If you don't know what that is go read this post (https://stockfetcher.com/forums/Filter-Exchange/Making-an-ETF-ladder/151684) because I've already explained it there. This post is about how it's worked out so far. I have to admit that I didn't follow my own rules much of the time regarding how long I was going to hold them for. Looking back on those trades I can't remember why I sold them when I did. I think sometimes it was just because it had gone up and I wanted to take some profit when I could. Anyway, here they are in alphabetical order. Entry and exit prices are per share. Entry and exit trades were entered before market open, usually the day before if it was a Sunday or the night before on weekdays. These were market orders to be executed ASAP after the market opened. EDIT: I tried spacing this out but it isn't showing up that way in the preview. I apologize for not knowing how to make it more readable. Symbol Days Held Entry Exit P/L$ P/L% EPI 7 19.12 19.78 0.66 3.45 FCG 5 6.35 6.42 0.08 1.18 GLDM 6 17.38 16.89 -0.49 -2.82 GWX 25 24.61 25.90 1.29 5.24 NANR 28 28.94 31.08 2.14 7.39 SLVP 7 12.92 12.21 -0.72 -5.55 XLRE 28 32.52 35.04 2.52 7.75 XOP 2 42.01 44.01 2.00 4.76 XOP 17 52.10 68.02 15.92 30.56 XRT 21 38.49 45.05 6.56 17.04 As you can see there were two losses out of 10 trades, giving me an 80% win rate. I'll take it. If you had bought just one share each (and yes, I did buy more than just one share each) you'd have risked a total of 274.44 for a return of 304.40, a gain of $29.96 or 10.92%. It's not an earth shattering return, but it's not bad. I think the key factor here is how long I hold each one. The best results came from just less than a three week hold but I know I can't ignore other factors like overall market direction along with others I can't think of at the moment. Here's the code again. The Sharpe Ratio came from Kevin_in_GA, as well as the Relative Strength code (though I changed that to average four indexes). The top results are usually leveraged ETFs. I can't always tell by the title so I use Yahoo Finance to look up the symbol. I stay away from leveraged ETFs but if you like them then go for it. The NVI and PVI indicators in this filter are just for information. I'm not using them to help pick ETFs. I just like to see where the interest (and money) is. As always, if you want to use this filter feel free to make any changes to it that you want to make it work for you. |
| Village Elder 231 posts msg #152579 - Ignore Village Elder modified |
6/9/2020 10:55:34 AM Based on his urging, SF added a Sharpe ratio function: Add column Sharpe ratio(28) Should give you what you want ... Also, the higher the ratio the LOWER the risk for the same level of return, not HIGHER. |
| Cheese 1,374 posts msg #152580 - Ignore Cheese |
6/9/2020 11:59:04 AM @JoeyVinyl Thank you very much for both this thread and the original thread and thank you for your excellent fusion of risk-return, laddering and scoring. |
| Cheese 1,374 posts msg #152581 - Ignore Cheese |
6/9/2020 1:10:41 PM @JoeyVinyl I don't have any proof so I'm just thinking out loud here The numeric values of ror and change are larger than rs and sharpe so I'm wondering if score may be unduly influenced by ror and change. Also,in other forums, some traders caution that rs may be difficult to interpret when the market indices are falling. I'm flagging those points just in case you and nibor100 want to take a closer look. (Sometimes, nibor100 test some hypotheses.) Other than that, your filter is very useful to me. THANKS AGAIN. |
| JoeyVinyl 125 posts msg #152585 - Ignore JoeyVinyl |
6/9/2020 4:31:51 PM Village Elder, that's good to know. I was going off what Kevin said in this post: https://stockfetcher.com/forums/Filter-Exchange/PORTFOLIO-SELECTION-AND-MANAGEMENT-USING-RISK-REWARD-RATIOS/91296 "the higher the Sharpe ratio, the better the performance and the greater the profits for taking on additional risk." I understood that to mean the higher the ratio the riskier the investment. I'll have to do some research on that. I also found the post where SF added the Sharpe Ratio function. As I'm sure you know they keep adding things but not updating the manual. Makes it frustrating. |
| JoeyVinyl 125 posts msg #152586 - Ignore JoeyVinyl |
6/9/2020 4:44:08 PM Cheese, I always appreciate your feedback. I don't use the Change number in scoring since it's part of the ROR. It's the first part of the ROR calculation; how much has the current price gone up or down compared to 28 days ago. I should have fixed the filter I posted. It's the original but I took the ROR out of the scoring, going only with the Relative Strength and the Sharpe. There are definitely limitations to using the Relative Strength, especially in a bear market. I know a higher number doesn't mean the stock or ETF is going up if the indexes are falling. The stock might be falling too, just slower than the indexes. That's part of why I'm using four indexes for the RS number. I think averaging it out helps a bit but I don't know for sure. Still, this filter has helped me make a few bucks so I'm happy with it. |
| Cheese 1,374 posts msg #153101 - Ignore Cheese |
7/14/2020 3:16:58 PM JoeyVinyl Your ETF Ladder is truly excellent. I just want to thank you again. |
| Cheese 1,374 posts msg #153185 - Ignore Cheese |
7/17/2020 3:02:16 PM @graftonian @JoeyVinyl JoeyVinyl's ETF Ladder is an excellent tool, easy to customize, and gives a comprehensive assessment of risk and return In the code belpw. I've changed the symlist of JpeyVinyl's ETF Ladeer to reflect WIZ porfolio as of July 16, 2020 |
| StockFetcher Forums · General Discussion · ETF Ladder Results so far | << >>Post Follow-up |
Copyright 2022 - Vestyl Software L.L.C.•Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data
Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus