Sounds like you are definitely going to have to improve light quality if you are interested in an expanding palm collection. Having said that, MOST do very well with supplemental artificial light. Many of the northern palm growers on this forum move their collection OUTSIDE for the growing season to benefit from the sun, ventilation, rains, humidity, etc.. But you have to be very careful and knowledgeable about doing this because DIRECT SUN CAN EASILY BURN ANY PALM USED TO GROWING INSIDE. The two species that you mentioned are especially prone to burning if unacclimatized to direct sun outside (speaking from experience here). The Raphis actually
is better in a fairly shaded location. The Spindle can deal with it but only after acclimation. It's late in the season anyway, so I would leave them inside and work on their winter lighting situation. I have only used florescent lighting on palms (standard double 48" fluorescent tubes, cool white and warm white spectrum). They are great indoor palm species (fairly easy and robust) and the spindle always remains me of a coconut palm (which are NOT so easy inside).Good luck!

when i got the palm the guy at the store said to leave it in the pot it came in and i shouldnt have to transplant it because they like to be root bound. It is good draining but since its inside should i repot it with more of a sand and palm soil mix instead of whats in it?

There's nothing wrong transplanting in a slightly deeper container--Palm pots tend to be deeper than standard containers (or should be). Yes, it is true that they like be pot bound but they also need room for growing roots (it's a balancing act). Only go a bit bigger as you don't want too much wet soil laying around the roots taking forever to dry out. Palms prefer well-drained, rich soils (like to work extra sand and a bit more humus into the mix). Often, I find that the palms from the big chains are growing in soil that is soooo well draining that it doesn't hold any water! Of the two palms you mentioned, the Raphis needs a more consistent level of soil moisture. They can go into a sudden tailspin if you let them get too dry without too much prior warning.

It is kind of surprising that anyone would even mention planting either of those two in the ground in zone 5 or 6. That would really be a challenge!