My left column is stock ticker symbols (using the new data field "Stocks")….my top row is just dates in history

What I'm trying to do is create a spreadsheet that has about 50 different stocks and I want the 1st of the month from 2010 moving forward on all their stock prices.

Any idea if there is a formula that will automatically fill these in?

Thanks in advance....