Is Bitcoin private?

Why is privacy controversial in financial systems?

What happens if all transactions become transparent?