G. Onida, L. Reining, and A. Rubio, Electronic excitations: density-functional versus many-body Green?s-function approaches, Reviews of Modern Physics, vol.74, issue.2, pp.601-659, 2002.

S. A. Huotari-;-m, N. T. Marques, F. M. Maitra, E. Nogueira, A. Gross et al., Tagebuch, Spectroscopy in the Frequency Domain, pp.15-28, 1925.

D. Pines, Elementary Excitations In Solids, 1963.

P. Anderson, Concepts in Solids, 1963.

R. M. Martin, L. Reining, and D. M. Ceperley, Interacting Electrons, Interacting Electrons, 2016.

A. Damascelli, Z. Hussain, and Z. Shen, Angle-resolved photoemission studies of the cuprate superconductors, Reviews of Modern Physics, vol.75, issue.2, pp.473-541, 2003.

R. S. Knox, Wannier Excitons in Simple van der Waals Crystals, Radiation Research, vol.20, issue.1, p.77, 1963.

F. Bassani, G. P. Parravicini, R. A. Ballinger, and J. L. Birman, Electronic States and Optical Transitions in Solids, Physics Today, vol.29, issue.3, pp.58-59, 1976.

P. Elliott, S. Goldson, C. Canahui, and N. T. Maitra, Perspectives on double-excitations in TDDFT, Chemical Physics, vol.391, issue.1, pp.110-119, 2011.

K. Sturm and A. Gusarov, Dynamical correlations in the electron gas, Physical Review B, vol.62, issue.24, pp.16474-16491, 2000.

C. Sternemann, S. Huotari, G. Vankó, M. Volmer, G. Monaco et al., Correlation-Induced Double-Plasmon Excitation in Simple Metals Studied by Inelastic X-Ray Scattering, Physical Review Letters, vol.95, issue.15, p.157401, 2005.

W. Kohn, Nobel Lecture: Electronic structure of matter?wave functions and density functionals, Reviews of Modern Physics, vol.71, issue.5, pp.1253-1266, 1999.

W. Kohn and L. J. Sham, Self-Consistent Equations Including Exchange and Correlation Effects, Physical Review, vol.140, issue.4A, pp.A1133-A1138, 1965.

P. Hohenberg and W. Kohn, Inhomogeneous Electron Gas, Physical Review, vol.136, issue.3B, pp.B864-B871, 1964.

E. Runge and E. K. Gross, Density-Functional Theory for Time-Dependent Systems, Physical Review Letters, vol.52, issue.12, pp.997-1000, 1984.

M. Levy, J. P. Perdew, and V. Sahni, Exact differential equation for the density and ionization energy of a many-particle system, Physical Review A, vol.30, issue.5, pp.2745-2748, 1984.

F. Malet and P. Gori-giorgi, Strong Correlation in Kohn-Sham Density Functional Theory, Physical Review Letters, vol.109, issue.24, p.246402, 2012.

A. L. Fetter and J. D. Walecka, Quantum theory of manyparticle systems, 1971.

M. Gatti, V. Olevano, L. Reining, and I. V. Tokatly, Transforming Nonlocality into a Frequency Dependence: A Shortcut to Spectroscopy, Physical Review Letters, vol.99, issue.5, p.57401, 2007.
URL : https://hal.archives-ouvertes.fr/hal-00148137

A. Ferretti, I. Dabo, M. Cococcioni, and N. Marzari, Bridging density-functional and many-body perturbation theory: Orbital-density dependence in electronic-structure functionals, Physical Review B, vol.89, issue.19, p.89, 2014.

M. Vanzini, L. Reining, and M. Gatti, Spectroscopy of the Hubbard dimer: the spectral potential, The European Physical Journal B, vol.91, issue.8, 2018.
URL : https://hal.archives-ouvertes.fr/hal-02347102

M. Vanzini, F. Sottile, I. Reshetnyak, S. Ciuchi, L. Reining et al., Design of auxiliary systems for spectroscopy, Faraday Discussions, 2020.
URL : https://hal.archives-ouvertes.fr/hal-02996427

P. Martin, Measurements and Correlation Functions, Gordon and Breach, 1968.

A. Georges, G. Kotliar, W. Krauth, and M. J. Rozenberg, Dynamical mean-field theory of strongly correlated fermion systems and the limit of infinite dimensions, Reviews of Modern Physics, vol.68, issue.1, pp.13-125, 1996.

L. Hedin, New Method for Calculating the One-Particle Green's Function with Application to the Electron-Gas Problem, Physical Review, vol.139, issue.3A, pp.A796-A823, 1965.

J. P. Perdew, Density-functional approximation for the correlation energy of the inhomogeneous electron gas, Physical Review B, vol.33, issue.12, pp.8822-8824, 1986.

J. P. Perdew, K. Burke, and M. Ernzerhof, Generalized Gradient Approximation Made Simple, Physical Review Letters, vol.77, issue.18, pp.3865-3868, 1996.

J. Tao, J. P. Perdew, V. N. Staroverov, and G. E. Scuseria, Climbing the Density Functional Ladder: Nonempirical Meta?Generalized Gradient Approximation Designed for Molecules and Solids, Physical Review Letters, vol.91, issue.14, p.146401, 2003.

J. Sun, A. Ruzsinszky, and J. P. Perdew, Strongly Constrained and Appropriately Normed Semilocal Density Functional, Physical Review Letters, vol.115, issue.3, p.36402, 2015.

C. Lee, W. Yang, and R. G. Parr, Development of the Colle-Salvetti correlation-energy formula into a functional of the electron density, Physical Review B, vol.37, issue.2, pp.785-789, 1988.

A. D. Becke, Density-functional exchange-energy approximation with correct asymptotic behavior, Physical Review A, vol.38, issue.6, pp.3098-3100, 1988.

A. D. Becke, Density?functional thermochemistry. III. The role of exact exchange, The Journal of Chemical Physics, vol.98, issue.7, pp.5648-5652, 1993.

A. D. Becke, Density?functional thermochemistry. IV. A new dynamical correlation functional and implications for exact?exchange mixing, The Journal of Chemical Physics, vol.104, issue.3, pp.1040-1046, 1996.

T. W. Keal and D. J. Tozer, A semiempirical generalized gradient approximation exchange-correlation functional, The Journal of Chemical Physics, vol.121, issue.12, pp.5654-5660, 2004.

Y. Zhao and D. G. Truhlar, A new local density functional for main-group thermochemistry, transition metal bonding, thermochemical kinetics, and noncovalent interactions, The Journal of Chemical Physics, vol.125, issue.19, p.194101, 2006.

D. M. Ceperley and B. J. Alder, Ground State of the Electron Gas by a Stochastic Method, Physical Review Letters, vol.45, issue.7, pp.566-569, 1980.

M. Vanzini, F. Sottile, I. Reshetnyak, S. Ciuchi, L. Reining et al., Design of auxiliary systems for spectroscopy, Faraday Discussions, 2020.
URL : https://hal.archives-ouvertes.fr/hal-02996427

L. J. Sham and M. Schlüter, Density-Functional Theory of the Energy Gap, Physical Review Letters, vol.51, issue.20, pp.1888-1891, 1983.

L. J. Sham, Exchange and correlation in density-functional theory, Physical Review B, vol.32, issue.6, pp.3876-3882, 1985.

R. T. Sharp and G. K. Horton, A Variational Approach to the Unipotential Many-Electron Problem, Physical Review, vol.90, issue.2, pp.317-317, 1953.

L. Reining, V. Olevano, A. Rubio, and G. Onida, Excitonic Effects in Solids Described by Time-Dependent Density-Functional Theory, Physical Review Letters, vol.88, issue.6, p.66404, 2002.
URL : https://hal.archives-ouvertes.fr/hal-00122419

F. Sottile, V. Olevano, and L. Reining, Parameter-Free Calculation of Response Functions in Time-Dependent Density-Functional Theory, Physical Review Letters, vol.91, issue.5, p.56402, 2003.

G. Adragna, R. Del-sole, and A. Marini, Ab initiocalculation of the exchange-correlation kernel in extended systems, Physical Review B, vol.68, issue.16, p.165108, 2003.

A. Marini, R. Del-sole, and A. Rubio, Bound Excitons in Time-Dependent Density-Functional Theory: Optical and Energy-Loss Spectra, Physical Review Letters, vol.91, issue.25, p.256402, 2003.

R. Stubner, I. V. Tokatly, and O. Pankratov, Excitonic effects in time-dependent density-functional theory: An analytically solvable model, Physical Review B, vol.70, issue.24, p.245119, 2004.

F. Bruneval, F. Sottile, V. Olevano, R. Del sole, and L. Reining, Many-Body Perturbation Theory Using the Density-Functional Concept: Beyond theGWApproximation, Physical Review Letters, vol.94, issue.18, p.186402, 2005.

S. Hüfner, Introduction and Basic Principles, Photoelectron Spectroscopy, pp.1-60, 2003.

L. Hedin, J. Michiels, and J. Inglesfield, Phys. Rev. B, vol.58, pp.15565-15582, 1998.

J. P. Perdew, R. G. Parr, M. Levy, and J. L. Balduz, Phys. Rev. Lett, vol.49, pp.1691-1694, 1982.

J. Heyd, G. E. Scuseria, and M. Ernzerhof, The Journal of Chemical Physics, vol.118, pp.8207-8215, 2003.

J. Heyd, G. E. Scuseria, and M. Ernzerhof, Erratum: ?Hybrid functionals based on a screened Coulomb potential? [J. Chem. Phys. 118, 8207 (2003)], The Journal of Chemical Physics, vol.124, issue.21, p.219906, 2006.

A. V. Krukau, O. A. Vydrov, A. F. Izmaylov, and G. E. Scuseria, The Journal of Chemical Physics, p.224106, 2006.

J. Paier, M. Marsman, K. Hummer, G. Kresse, I. C. Gerber et al., The Journal of Chemical Physics, vol.124, p.154709, 2006.

J. Paier, M. Marsman, K. Hummer, G. Kresse, I. C. Gerber et al., The Journal of Chemical Physics, p.249901, 2006.

J. Paier, M. Marsman, and G. Kresse, The Journal of Chemical Physics, p.24103, 2007.

G. D. Mahan, Many-particle physics, 1981.

M. Petersilka, U. J. Gossmann, and E. K. Gross, Phys. Rev. Lett, vol.76, pp.1212-1215, 1996.

D. Bohm and D. Pines, Phys. Rev, vol.92, pp.609-625, 1953.

S. Botti, A. Schindlmayr, R. D. Sole, and L. Reining, Time-dependent density-functional theory for extended systems, Reports on Progress in Physics, vol.70, issue.3, pp.357-407, 2007.
URL : https://hal.archives-ouvertes.fr/hal-00438360

E. E. Salpeter and H. A. Bethe, Phys. Rev, vol.84, pp.1232-1242, 1951.

G. Strinati, La Rivista del Nuovo Cimento, vol.11, pp.1-86, 1988.

G. Onida, L. Reining, R. W. Godby, R. Sole, and W. Andreoni, Phys. Rev. Lett, vol.75, pp.818-821, 1995.

S. Albrecht, L. Reining, R. Del-sole, and G. Onida, Ab InitioCalculation of Excitonic Effects in the Optical Spectra of Semiconductors, Physical Review Letters, vol.80, issue.20, pp.4510-4513, 1998.

L. X. Benedict, E. L. Shirley, and R. B. Bohn, Optical Absorption of Insulators and the Electron-Hole Interaction: AnAb InitioCalculation, Physical Review Letters, vol.80, issue.20, pp.4514-4517, 1998.

M. Rohlfing and S. G. Louie, Electron-Hole Excitations in Semiconductors and Insulators, Physical Review Letters, vol.81, issue.11, pp.2312-2315, 1998.

E. G. Van-loon, F. Krien, and A. A. Katanin, Bethe-Salpeter Equation at the Critical End Point of the Mott Transition, Physical Review Letters, vol.125, issue.13, 2020.

F. Krien, E. G. Van-loon, M. I. Katsnelson, A. I. Lichtenstein, and M. Capone, Two-particle Fermi liquid parameters at the Mott transition: Vertex divergences, Landau parameters, and incoherent response in dynamical mean-field theory, Physical Review B, vol.99, issue.24, p.245128, 2019.

T. Schäfer, G. Rohringer, O. Gunnarsson, S. Ciuchi, G. Sangiovanni et al., Divergent Precursors of the Mott-Hubbard Transition at the Two-Particle Level, Physical Review Letters, vol.110, issue.24, p.246405, 2013.

T. Schäfer, S. Ciuchi, M. Wallerberger, P. Thunström, O. Gunnarsson et al., Nonperturbative landscape of the Mott-Hubbard transition: Multiple divergence lines around the critical endpoint, Physical Review B, vol.94, issue.23, p.235108, 2016.

I. Reshetnyak, M. Gatti, F. Sottile, and L. Reining, Excitons on a microscopic level: The mixed dynamic structure factor, Physical Review Research, vol.1, issue.3, 2019.
URL : https://hal.archives-ouvertes.fr/hal-02364225

R. Sole, G. Adragna, V. Olevano, and L. Reining, Phys. Rev. B, vol.67, p.45207, 2003.

S. Baroni and R. Resta, Ab initiocalculation of the macroscopic dielectric constant in silicon, Physical Review B, vol.33, issue.10, pp.7017-7021, 1986.

P. Ghosez, X. Gonze, and R. W. Godby, Phys. Rev. B, vol.56, pp.12811-12817, 1997.

S. Botti, A. Fourreau, F. Nguyen, Y. Renault, F. Sottile et al., Energy dependence of the exchange-correlation kernel of time-dependent density functional theory: A simple model for solids, Physical Review B, vol.72, issue.12, p.125203, 2005.
URL : https://hal.archives-ouvertes.fr/hal-00438365

S. Botti, F. Sottile, N. Vast, V. Olevano, L. Reining et al., Long-range contribution to the exchange-correlation kernel of time-dependent density functional theory, Physical Review B, vol.69, issue.15, p.155112, 2004.
URL : https://hal.archives-ouvertes.fr/hal-00438371

S. Sharma, J. K. Dewhurst, A. Sanna, and E. K. Gross, Bootstrap Approximation for the Exchange-Correlation Kernel of Time-Dependent Density-Functional Theory, Physical Review Letters, vol.107, issue.18, 2011.

S. Rigamonti, S. Botti, V. Veniard, C. Draxl, L. Reining et al., Rigamontiet al.Reply:, Physical Review Letters, vol.117, issue.15, p.146402, 2016.

Y. Byun and C. A. Ullrich, Assessment of long-range-corrected exchange-correlation kernels for solids: Accurate exciton binding energies via an empirically scaled bootstrap kernel, Physical Review B, vol.95, issue.20, 2017.

J. E. Rowe and D. E. Aspnes, Approximate Treatment of Exciton Effects in Electric Field Modulation Via the Slater-Koster Interaction, Physical Review Letters, vol.25, issue.3, pp.162-165, 1970.

R. M. Martin, J. A. Van-vechten, J. E. Rowe, and D. E. Aspnes, Local-Field Effects on Electroreflectance Line Shapes: the Contact Exciton, Physical Review B, vol.6, issue.6, pp.2500-2502, 1972.

F. Sottile, K. Karlsson, L. Reining, and F. Aryasetiawan, Macroscopic and microscopic components of exchange-correlation interactions, Physical Review B, vol.68, issue.20, p.205112, 2003.

G. Giuliani and G. Vignale, Quantum Theory of the Electron Liquid, Quantum theory of the electron liquid, 2005.

E. K. Gross and N. T. Maitra, Fundamentals of Time-Dependent Density Functional Theory, Introduction to TDDFT, p.53, 2012.

X. Gonze, J. Beuken, R. Caracas, F. Detraux, M. Fuchs et al., First-principles computation of material properties: the ABINIT software project, Computational Materials Science, vol.25, issue.3, pp.478-492, 2002.

J. P. Perdew and Y. Wang, Accurate and simple analytic representation of the electron-gas correlation energy, Physical Review B, vol.45, issue.23, pp.13244-13249, 1992.

N. Troullier and J. L. Martins, Phys. Rev. B, vol.43, 1991.

L. Reining, V. Olevano, S. Albrecht, G. Onida, and F. Sottile,

V. Olevano, L. Reining, and F. Sottile, The DP code, pp.unpub- lished