Yellow missingno takes it's behavior from an unused chunk of data in SRAM bank 0 which can be quite random. thezzazzglitch made a video on stable yellow missingno using a method of arbitrary code execution https://youtube.com/watch?v=eLuUWUeUTg4