Google Scripts documentation for Historical Stock Info? <p>I'm working on a google spreadsheet right now. The goal is for it to automatically get a stock open, close and change for a date in the past. </p> <p>Unfortunately, I don't understand the documentation and it doesn't seem to be working out. <a href="https://developers.google.com/apps-script/reference/finance/historical-stock-info" rel="nofollow">Here</a> is the link to the class I have to use, but I don't know how to implement it.</p> <p>Here is the code I have now for current stock data, that works. I spent a long time with the documentation and piecing together bits of code that I found. </p> <pre><code>function stockRun() { var sheet = SpreadsheetApp.getActiveSheet(); var row = 2; while (true) { if (!sheet.getRange(row, 2).getValue()) { var ticker = sheet.getRange(row, 1).getValue(); if (!ticker) break; var stockInfo = FinanceApp.getStockInfo(ticker); sheet.getRange(row, 2).setValue(stockInfo.closeyest); sheet.getRange(row, 3).setValue(stockInfo.priceopen); sheet.getRange(row, 4).setValue(stockInfo.change); sheet.getRange(row, 5).setValue(stockInfo.changepct + "%"); } row++; } } </code></pre> <p>Now that I want historical data, I'm not really sure where to go. I don't understand how I can use the class <a href="https://developers.google.com/apps-script/reference/finance/stock-info-snapshot" rel="nofollow">StockInfoSnapshot[]</a> and use the properties of it.</p> <p>Thanks so much for all your help! I know this must seem so simple, but it's really confusing to me. Once I understand how to use the class I'll be able to work on it and expand my program from there. :)</p>