I helped a friend put some coax cables through a shingled roof a few years ago.
I think he used a pvc vent pipe and then put a "U" at the top with the above
mentioned drip loop in the cable. Worked great, still does. Poke around your
local "Mega Lo Mart".

jw
wb9uai
milwaukee