Hi Donna,
I've had hot foot and charlie horses for years. New shoes, new pedals, new shoe plate positions, etc... nothing worked. I've started taking Magnesium, and voila.... no more hot foot or cramps. Not sure if it's the same issue at all... but give it a try.
Cheers,
E