The thread guide on top guides the thread smoothly from the top of the spool. Just then pull the thread across your machine and thread as you normally would if it were a small spool on the machine spindle. Some don't even use a thread stand--they just put the cone in a mug or jar and let it feed from the top.
Or am I not understanding your explanation? I shouldn't think you would need any tension on the thread holder.