By Popular Demand: Spreadsheet Tutorial for Creating Your Own FREE Relative Strength Histogram (Both Stock and ETF), that Updates Daily After Close. As requested by many of you, I will do my best to break down the steps and details so you can build your own RS tracking list of stocks, along with sector and industry group ETFs. For reference to my ETF listings (my preference is Equal Weight listings, which take precedence over cap-weighted ETFs, eg. XSD over. SMH), please refer to the post below. x.com/jfsrevg/status…

keyboard_arrow_left Previous keyboard_arrow_right Next

1. List down the tickers. I highly recommend you structured them in a efficient way to access them (eg. Main Component Index -> Sector -> Industry Groups -> Stocks). Put 'SPY' as the first, it will be the main reference point. 2. Convert them to 'Stock' data 3. The converted result as displayed in screenshot

keyboard_arrow_left Previous keyboard_arrow_right Next

@Clement_Ang17

@jfsrevg Super awesome, I will implement it in my trading journal. Thank you! 🔥

@jfsrevg This is great. Thank you for sharing, Jeff! I added a column (RS_STS) indicating where today's relative strength stands in the current month for the particular ETF/stock, and find it is helpful for quickly identifying those with the strongest relative strength currently -

@jfsrevg If I start trading all over again, I’d make sure I read through all your posts!

@jfsrevg @jfsrevg How do you calculate relative strength? Are you aware of the considerations for including ATR in the calculation? reddit.com/r/RealDayTradi…

@jfsrevg Wow Jeff, thanks! Have been envious of your sexy sheets for quite some time. Not much of a coder, so this should really help. Thanks for the new weekend project.

@jfsrevg Are these commands work in Google sheets? Do you have alternative in Google sheets?

@jfsrevg And just like that! Really appreciate this @jfsrevg !

@jfsrevg Going to begin to put this together this weekend, kinda hope it rains so I don’t feel bad not going outside lol

@jfsrevg Give this to my son as an assignment and he’s so quite since then 😂

@jfsrevg Thank thank thank you Sir

@jfsrevg Homework!

@jfsrevg Thank you

@jfsrevg WOW! Thank you very much.

@jfsrevg i took the time to do this this morning, and i don't know why i didn't far sooner, thank you so much sir!

@jfsrevg wow thank you!

@jfsrevg You’re awesome man!

@jfsrevg Hi Jeff, that's great thanks! Are you entering the values ​​for $MMTW and NH/NL manually?

@jfsrevg Thank you for sharing