I'm an Aquarius/Pisces cusper, and I acknowledge that it's generally pretty silly, can't be backed up with anything resembling facts, etc. ... but as far as anecdotal evidence goes, I think their traits fit me pretty well. Borrowing the write ups from
here and a few other places, some things that ring especially true for me:
Aquarius
Positive traits include brilliance, innovation, individuality, openness, social consciousness, inventiveness, practical skill, and self assertion; negative traits are eccentricity, lack of attachment to people and the "real world," over-intellectualizing of the emotions, a crotchety temper, rigidity, intellectual arrogance, and stubbornness.
The stereotypical geeks of the magical world, Ravenclaw Aquarians are noted mostly for their genius. They are gifted theorists and inventors, and highly talented students. Most wind up doing pure research after graduating from Hogwarts. Their noses are always in books of esoteric lore. Some people may laugh at them, either for their unconventional lifestyles or (more commonly) because they are obvious nerds, but they don't care. While they can have sharp tempers, especially when they encounter ignorance or stupidity, these wizards generally mean well, and have a "live and let live" philosophy.
Problem: Being left all alone while others enjoy the companionship you long for.
Solution: You should practice expressing your humanity by accepting people the way they are and not find too much fault in them.
Problem: You always seem to miss the boat when it comes to love.
Solution: Try letting down the mental guard that you keep on your emotions that stops you from being the self you long to be.
Problem: You seem to become physically ill more than you should.
Solution: By repressing your emotions you drive the unrest deep inside where it can cost you in terms of health. Express your feelings but do it with tact.
Pisces
Positive traits include idealism, wisdom, intuition, empathy, imagination, creativity, adaptability, compassion, and an uncanny connection to all that is spiritual and otherworldly (which makes for talent in magic); negative traits include being easily influenced by other people, gullibility, a lack of backbone, escapism, addictive personality, impracticality, emotional game-playing, delusion, and a total inability to say "no."
Ravenclaw Pisceans spend so much time dreaming or reading books of legends that it's a wonder they ever come down to earth. Care must be taken that they do not neglect their material needs, including those that involve sleep, food, and drink. These wizards are natural seers, and often specialize in things like horary astrology, cartomancy, dream interpretation, oracles, and the summoning of visions.
Problem: A strong sense of despair not shared by family and friends, thus leaving you with that all alone feeling.
Solution: You must come out of yourself and open up to those around you, you have the power to inspire others making you an important part of the human race; take your rightful place.
Problem: Causing others to be quarrelsome or to walk out on you all together.
Solution: The upstream fish may be pushing too hard for someone to meet your ideals and could wind up pushing people right out of your life. Try lightening up.
Fun fact: I share my birthday with Yoko Ono, John Hughes, Helen Gurley Brown, Molly Ringwald, and John Travolta. And apparently Ramakrishna, but I didn't know that until today.
Unrelated to this entry: ... Wikipedia leads me to conclude that there's doubt about the fact that Julianne Moore's character in I'm Not There (Alice Fabian) is supposed to be Joan Baez. ... Really?
Also, Darren Aronofsky is a life-ruiner. In the category of "things I found on tumblr": that phrase being used to describe very attractive men. Most often Darren Criss. ... I'm using it here because sdfkhggkeysmashes. No one, and I mean no one, is as capable of utilizing the film medium to emotionally wreck me like Darren Aronofsky. Trying to explain the ending of Black Swan to my dad is pretty much pointless, because he's insisting that he needs closure, resolution, "happy ending and all that shit" and refuses to accept, "the resolution is that she was perfect."
... He doesn't get along with ambiguous endings. He liked Eternal Sunshine Of The Spotless Mind (as much as he likes any movie that plays with nonlinear narrative) ... until the ending was ambiguous and didn't give him resolution. He didn't like Adaptation at all, and he just scratched his head at Being John Malkovich. Which, while we're on the subject of Charlie Kaufman, makes me want to sit Dad down with Synechdoche, NY and watch his brain shatter.