I am getting rid of satellite soon. I have an inexpensive amazon antenna that works with my tv. It only gets about half of the local channels that i should get in my area and it says some are not good reception. What antenna should i look at? Should I oput  one in the attic? Any way to use the coax that will come from the old satellite location and mount an antenna there. I do not want some giant tv antenna from my youth but I do want to get as many channels as I can.
Thanks

once you get rid of the dish, then the coax should work for an antenna

attic antennas can work, depends on roofing and other factors
outdoors is always best, and the higher the better, depending on terrain and distance to towers

try a site like tvfool

Those work best.

Start with antennaweb.org and give us a general idea of the direction and distance to the transmitters.  Also post the channels that you want to pick up.  Not the display channel but the broadcast channel.  For example, here channel 5 broadcasts on VHF channel 5.  But channel 3 broadcasts on UHF channel 24.

I have my cheapo Amazon antenna in the attic hanging from a rafter; from there it connects to the coax that run to my tv. Works really well for my area.

Before that in a previous area I used a larger modern antenna mounted outside where the previous homeowner had Dish set up.

That's handy.  I was wondering what stations I wasn't getting and they are ones I don't want as it is.