I figured out the answer to this recently, and I wanted to post it for others since the info seems to be incredibly hard to come by.
First, I have a 2008 MDX. I'm fairly sure this method will work on the 2007-2009 models. Most likely it will also work on the 2010-2013, since I think they have the same transmission. I have no idea if this will work on the 1st gen (2006 and prior) or the 3rd gen (2014-present), but if does please post a reply for everyone else.
Ok so what I did to make this work was to buy a $20 ELM327 OBD-II wifi dongle from Amazon and the $6 EngineLink app for iPhone. The Transmission Temperature is accessible with a custom PID, so I just had to create one with the following info:
Header: 18DA1DF1
Mode and PID: 222201
Name: A/T Temp
Minimum: -40
Maximum: 300
Unit type: F
Equation: AA*(9/5)-40
(Note: Scale Factor was not requested but if you use a different app that asks it just use x1).
This seems to work well. When completely cold (sitting overnight) my trans temp was pretty close to the ambient air temp. Driving it around town with the air temp close to 90 today it got up to about 152. I haven't tried towing yet but when I do that I'll update this post.
For those curious, I got the info above from one of the Honda Odyssey forums. The info on the Ridgeline owners forum is similar. I spent quite a bit of time researching this, reading up on the OBD2 protocol, etc so I'm pretty confident at this point that the numbers are reading pretty accurately.
BTW if you use Torque I found the following values, which should work for you as well:
ATF Temp
TXD:1DF1222201
RXF:032400000000
RXD:2808
MTH:00090005FFD8
NAM:ATF
Protocol: 29-bit CAN
Now that I have this working, I'm going to spend some time with my android tablet and TorqueScan to see if I can find some other hidden temperature PIDs that will allow me to read rear diff and VTM temperatures.