You don't need a very big one. With a big stall the fluid heats up a lot, so choose accordingly. And make sure you mount it in a location with lots of air flow.
Two styles of cooler.
1) Stacked Plate (more efficient, more expensive).
2) Tube and fin. (not as efficient, but OK for street Duty. WAAAAAAAAAAAY cheaper).
I ran a Tube and Fin on a street car with 1800 stall rated torque converter (about 15x6), and it did fine. On my other car, im using a stacked plate (about 12x12), but the trans did get hot a few times with the 3500 stall rated converter. Im going to add an air damn to cure the problem, or failing that a fan on the trans cooler.
The downside to running a trans cooler in the rad is that the trans will never be cooler than your engine. Your engine gets pretty hot sometimes.