I did the same calculation for my home a while back. Came to a similar result: about 0.5M EUR battery would be needed. Also self discharge is a big problem. Probably redox-flow battery would be best for this use case.