I just created a spell and I was wondering how do I get that spell in game using the console?

Using the console: player.addspell #

where # is the spell ID.

I tried that, it's telling me that it cannot find the spell parameter.

Are you sure you are typing in the correct ID? Remember that the name of the spell is not its ID.

I am using the Form ID which is the Hex Number but it still cannot find it.

I haven't tried adding spells to the game using the CK yet so there isn't much I can do except point out the obvious, such as; have you activated your mod (the esp file) in the Data Files menu in the Skyrim launcher?

You can use this console command to find the ID for your spell:

"help 0"

Whereas you then use the addspell command:

"player.addspell "

Form IDs change according to your load order. Use the help command as hellbreaker suggests or find out the modindex with Wrye Bash and adjust the form ID accordingly.

http://cs.elderscrolls.com/index.php/FormID, it's still valid.