Have you considered using a Google spreadsheet along with: GOOGLEFINANCE("NASDAQ:GOOG", "price", DATE(2014,1,1), DATE(2014,12,31), "DAILY") GOOGLEFINANCE("NASDAQ:GOOG","price",TODAY()-30,TODAY()) It lets you get the prices on a range of dates. > >