Sherlock Holmes didn’t go in for ghosts — but the fictional detective’s creator Arthur Conan Doyle had other ideas