PANDAS, STOCKS, how do you get a stock price, per cell in a csv file?

I have a CSV file of a numbers sheet of stocks ive found,
one "catch" is that I have a "-" or "+" in the cell to show why I wrote it down,

how do you loop/cycle through to get a stock price for each?
BUT, I do have duplicated stocks, its 50 rows of stocks that could have 10-20 per day.