Connections and performances of Green’s function methods for charged and neutral excitations | Synapse