Last active
May 9, 2018 01:57
-
-
Save technodivergent/860f6f67be5f4f4f93d79a63e1a9458a to your computer and use it in GitHub Desktop.
Compare SPX members to list of stocks (Google Apps Script)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Author: George Hall | |
| // Date: 5/8/2018 | |
| // Written in Google Apps Script | |
| // Compares a list of stocks being monitored against the list of SPX members | |
| // If the monitored stocks are SPX members, denote that in the boolean cell | |
| // Spreadsheet reference | |
| // Column A: List of symbols being monitored | |
| // Column B: Boolean cells for dollar strikes | |
| // Column C: Boolean cells for $INDU | |
| // Column D: Boolean cells for $COMPQ | |
| // Column E: Boolean cells for $SPX | |
| // Column I: List of SPX symbols | |
| function compareToSymbol() { | |
| var sheet = SpreadsheetApp.getActiveSheet(); | |
| var data = sheet.getDataRange().getValues(); | |
| var symbols = new Array(); | |
| var spx_members = new Array(); | |
| // get symbols and spx members | |
| for (var i = 1; i < data.length; i++) { | |
| symbols[i] = data[i][0]; | |
| spx_members[i] = data[i][8]; | |
| } | |
| // compare our symbols with spx members | |
| // if symbol is in spx, mark cell with a "Y" | |
| for (var j = 1; j < spx_members.length; j++) { | |
| for(var k = 1; k < symbols.length; k++) { | |
| if(symbols[k] == spx_members[j]) { | |
| Logger.log('Symbol ' + symbols[k] + ' is in SPX members at row ' + (k+1)); | |
| sheet.getRange(k+1,5).setValue("Y"); | |
| } | |
| } | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment