You need to provide conversion from the digital signals that the apple tv generates to analog signals that your rf modulator requires. A simple cable will not do that... you need a digital to analog convertor box.
jr
example on youtube:
https://m.youtube.com/watch?v=LFZiOd-bJJA
.