I have recently done something similar. I use a database from Quandl.com where I can get a batch download of fundamental data that I can manipulate with excel and access. With Excel VBA I pull in recent stock data from Yahoo's API (I select 40 stocks based off of 3-year price to earnings ratio AND momentum factors and invest with FOLIO where transactions are free). This is a little more complex, but it allows for better control than using Google Sheets.
I have pasted below a section where I pull in the past price information. If you don't have any idea how to code, then you will likely want to ignore this. I'm just posting it in case anyone finds it interesting.
j is the rows that have ticker symbols in them
MinCap is the Minimum Market Cap that I allow
Note that I am operating with Excel 2013 and I believe the Split function needs to be adjusted for prior versions
Note that I am pasting in the momentum (running it last day of the month): Price 2 month ago/ Price 12 months ago - 1. We ignore price fluctuations from the last month. There is significant research that shows that momentum strategies work best by ignoring the price fluctuations over the prior 2 months.
For j = 2 To Last + 1
If W.Cells(j, 10).value >= MinCap Then
On Error Resume Next
strTicker = W.Cells(j, 1)
strURL = "
http://ichart.finance.yahoo.com/table.csv?s=" & strTicker & _
"&a=" & Month(dtPrevDate) - 1 & _
"&b=" & Day(dtPrevDate) & _
"&c=" & Year(dtPrevDate) & _
"&d=" & Month(dtDate) - 1 & _
"&e=" & Day(dtDate) & _
"&f=" & Year(dtDate) & _
"&g=m&ignore=.csv"
Http.Open "GET", strURL, False
Http.Send
strCSV = Http.ResponseText
strRows() = Split(strCSV, Chr(10))
strColumns = Split(strRows(2), ",")
dbEnd = strColumns(4)
strColumns = Split(strRows(12), ",")
dbStart = strColumns(4)
If Err.Number <> 0 Then
dbEnd = 0
dbStart = 1
End If
W.Cells(j, 12).value = (dbEnd / dbStart) - 1
Set Http = Nothing
Else
W.Cells(j, 12).value = ""
End If
Counter = Counter + 1
MainBar.NextAction "Downloading Data " & Counter, True
Next j
Consider this for informational purposes only. Always do your own research. Momentum strategies usually need to be reset either monthly for quarterly to be effective.