First, your idea sounds good, hope you make it. There are tons of websites like you describe but it's based on selling and trading, not to mention most of them aren't honest because they base their reputation on building successful websites that aren't successful, or having traffic that isn't real, not to mention the amount of forums only talking about supposed monthly income (again, not real). Tons of serious people who wanted to build websites have approached those "gurus" only to end up lied to and having unfinished projects (that's one way to confirm it's just smoke). And my favorite: so many successful projects and websites that won't make it after 1 year, they are that successful! so much for their portfolio even if those are personal projects.
And I have all the technical knowledge but I want a sponsor that can host my site and I don't know how to find one
You have to build it first, and then you can show people what you have and make offers (traffic, ads, brand name space, etc). Otherwise just as you explain how other forums work, it would be in that case another project selling it's own name that still doesn't exist.
Sponsorship or advertising work similar in many ways, in the sense that they want specific benefits, being traffic, exposure, personal data, tracking, X number of sales per month, etc.
So you have to kind of... think and ponder if you have what they want, if you can in some way provide it, otherwise it won't last, even while there are no guarantees on sponsorship or advertising, being sponsorship the best option IMHO because it's mostly based on someone having the same goals and philosophy you have towards a project or situation.
BTW, Welcome to the forum. If you take your time to read around, you will find many forum members started just like you did (me included) in the sense that many had an idea just like yours and made it a personal project in which they invested their own time and resources, sort of "
personally funded or sponsored". They/we believed that much in the project, and over time it got advertising or sponsors. This is an example of what happens when people believe in their own projects, and it's easier for others to also believe. Why? there is a quote on some old magazine: why others would invest if you don't invest yourself on your own projects?. I'm not saying you wouldn't, just consider the meaning of the sentence.
Good luck with your project.