if you have a meter just trace your way back . i started at the warning buzzer socket on the 31 pin.this is the blue wire i mentioned.
it actually goes all the way across the car under the carpets and terminates about 6" above the big connector blocks behind the passenger kick panel .it joins to several other blue wires.
i cut the joint and found just 1 low to earth wire. traced it back to the drivers door connector.ive left mine unconnected and its fine. that blue wire is now clear to earth but its still unconnected .
if you look in your door check its the blue wire issue first to save unnesessary work.im curious where it goes to ??
as for the missfire you should find something. damp or water in the plugwell(idealy) or maybee oil ( less ideal !) and possibly some cracking insulation on the coilpack. this can be cleaned up/ dried out and epoxy sealed if nesessary if its not too bad and worth trying first before a new one . water can be dried up,plug cleaned externally and either find the cause of scuttle leak or add an extra rubber mat between engine top and scuttle foam as well .