[B! Spreadsheets] palmyraã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

palmyra id:palmyra

Spreadsheetsã«é–¢ã™ã‚‹palmyraã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

5åˆ†ã§ç†è§£ã™ã‚‹ã€€Google Apps Script - Qiita
ã¯ã˜ã‚ã« Google Apps Scriptï¼ˆä»¥é™ã€GASï¼‰ã¯Googleã«ã‚ˆã£ã¦é–‹ç™ºã•ã‚ŒãŸã‚¹ã‚¯ãƒªãƒ—ãƒˆè¨€èªžã«ãªã‚Šã¾ã™ã€‚ æ¥å‹™ã§Googleã‚µãƒ¼ãƒ“ã‚¹ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹å ´åˆã€GASã‚’ç”¨ã„ã‚‹ã“ã¨ã§æ§˜ã€…ãªæ¥å‹™åŠ¹çŽ‡åŒ–ã‚’è¡Œã†ã“ã¨ãŒã§ãã¾ã™ã€‚ æœ¬è¨˜äº‹ã§ã¯GASã«ã¤ã„ã¦æœ€é€Ÿã§ç†è§£ã™ã‚‹ã“ã¨ã‚’ç›®çš„ã«ã€æœ€ä½Žé™å¿…è¦ãªçŸ¥è˜ã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ã„ã¾ã™ã€‚ GASæ¦‚è¦ GASã‚’å§‹ã‚ã‚‹ã®ã«å¿…è¦ãªã®ã¯Googleã‚¢ã‚«ã‚¦ãƒ³ãƒˆã®ã¿ã§ã™ã€‚ Googleã®ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ä¸Šã§å‹•ä½œã™ã‚‹ãŸã‚ã€å®Ÿè¡Œç’°å¢ƒã‚‚ä¸è¦ã§ã™ã€‚ JavaScriptã‚’åŸºã«ä½œã‚‰ã‚Œã¦ã„ã‚‹ãŸã‚ã€JavaScriptã‚’çŸ¥ã£ã¦ã„ã‚‹äººãªã‚‰ç°¡å˜ã«ä½¿ã„å§‹ã‚ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã¾ãŸã€å¦ç¿’ã‚³ã‚¹ãƒˆã‚‚ä½Žã„ã®ã§éžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ–¹ã§ã‚‚ç¿’å¾—ã—ã¦æ¥å‹™ã«æ´»ç”¨ã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ GASã®æ´»ç”¨ è¦ç´„ã™ã‚‹ã¨ä»¥ä¸‹ã®æ§˜ãªã“ã¨ãŒã§ãã¾ã™ã€‚ ä½œæˆã—ãŸã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ä½¿ç”¨ã—ãŸãƒžã‚¯ãƒã®å®Ÿè¡Œ ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‹ã‚‰ã®ãƒ¡ãƒ¼ãƒ«ä¸€æ‹¬é€ä¿¡ G
palmyra 2022/02/27
Spreadsheets
ãƒªãƒ³ã‚¯
GASã§ç°¡å˜WEBã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°ï¼HTMLã‚’ç°¡å˜ã«ãƒ‘ãƒ¼ã‚¹ã§ãã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªParserã‚’ä½¿ã£ã¦ã¿ãŸ - Binary Diary
ã©ã†ã‚‚ã“ãŸã«ã‚“ã§ã™ã€‚ æœ¬æ—¥ã¯å˜ç™ºæŠ€è¡“è¨˜äº‹ã§ã™ã€‚ WEBã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°ã—ãŸã„ã¨æ€ã£ãŸã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿ ã‚¦ã‚§ãƒ–ã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚° - Wikipedia ã¨ã„ã†ã“ã¨ã§ä»Šå›žã¯ã€Google Apps Script (GAS) ã§WEBã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°ã‚’ã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ ã¯ã„ã€ç›®æ¬¡ã©ã‚“ï¼ ä»Šå›žã‚„ã‚‹ã“ã¨ Parserãƒ©ã‚¤ãƒ–ãƒ©ãƒª .data(content) .from(pattern, [offset]) .to(pattern, [offset]) .offset(index) .setDirection(way) .setLog() .build() .iterate() GASä¸Šã«ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æ›¸ã ãƒˆãƒªã‚¬ãƒ¼ã‚’ä½œã‚‹ ã¾ã¨ã‚ ä»Šå›žã‚„ã‚‹ã“ã¨ GASã§WEBã‚µã‚¤ãƒˆã®HTMLã‚’ãƒ‘ãƒ¼ã‚¹ã—ã¦ä»»æ„ã®å€¤ã‚’å®šæœŸçš„ã«å–å¾—ã™ã‚‹ã€‚ Parserãƒ©ã‚¤ãƒ–ãƒ©ãƒª GASä¸Šã§ãƒ‘ãƒ¼ã‚¹ã—ã¦ãã‚Œã‚‹ã‚ˆã•ã’ãªãƒ©ã‚¤
palmyra 2022/02/27
Spreadsheets
ãƒªãƒ³ã‚¯
ã€Google Financeé–¢æ•°ã€‘Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã§æ ªä¾¡ã‚’å–å¾—ã™ã‚‹æ–¹æ³• â€“ ç±³å›½æ ªGAFAã®å ´åˆ | UX BEARã€ã‚†ãˆã£ãã¾ã€‘
Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã¨ã¯ï¼Ÿ Google ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã¨ã¯ã€ã‚¨ã‚¯ã‚»ãƒ«ã®ã‚ˆã†ã«ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®ä½œæˆã‚„ã€ä»–ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨åŒæ™‚ã«å…±åŒä½œæ¥ã§ãã‚‹ã€ç„¡æ–™ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚¢ãƒ—ãƒªã§ã™ã€‚ Google ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®ä½¿ã„æ–¹ PC(Webï¼‰ã€iOSã€Androidã‚¢ãƒ—ãƒªã‚’é¸ã‚“ã§ä½¿ã†ã“ã¨ãŒã§ãã¾ã™ã€‚ Google Financeé–¢æ•°ã‚’ä½¿ã† Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã§ã¯ã€=googlefinance()é–¢æ•°ã‚’ä½¿ã†ã“ã¨ãŒã§ãã¾ã™ã€‚ ã‚»ãƒ«ã«è¨˜è¿°ã™ã‚‹ã“ã¨ã§ã€æ ªä¾¡ã‚’è‡ªå‹•å–å¾—ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã‚µãƒ³ãƒ—ãƒ« ã‚»ãƒ«ã¸ã®æ›¸ãæ–¹ã¨ã—ã¦ã¯ã“ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ // GoogleéŠ˜æŸ„ã®æ ªä¾¡ã‚’"2020/01/01" ã‹ã‚‰ "2020/1/31" ã¾ã§ æ¯Žæ—¥å–å¾— GOOGLEFINANCE("NASDAQ:GOOG", "price", DATE(2020,1,1), DATE(2020,1,31),
palmyra 2022/02/27
Spreadsheets
ãƒªãƒ³ã‚¯
ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã§æ—¥æœ¬æ ªã®æ ªä¾¡ã‚„æŠ•è³‡ä¿¡è¨—ã®ä¾¡æ ¼ã®å–å¾—æ–¹æ³•(GASã‚ªãƒªã‚¸ãƒŠãƒ«é–¢æ•°) | AutoWorkerã€œGoogle Apps Script(GAS)ã¨Sikuliã§å§‹ã‚ã‚‹æ¥å‹™æ”¹å–„å…¥é–€
ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã«ç”¨æ„ã•ã‚Œã¦ã„ã‚‹é–¢æ•°ã§ã¯ã€ã‚¢ãƒ¡ãƒªã‚«ã®æ ªä¾¡ã‚’å–å¾—ã§ãã‚‹ã‚‚ã®ã®ã€æ—¥æœ¬ã®ä¸Šå ´ä¼æ¥ã®æ ªä¾¡ã‚„æŠ•è³‡ä¿¡è¨—ã®ä¾¡æ ¼ã‚’å–å¾—ã§ãã¾ã›ã‚“ã€‚ ãã“ã§ã€ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã§æ—¥æœ¬ã®æ ªå¼ä¼šç¤¾ã®æ ªä¾¡ã‚„æŠ•è³‡ä¿¡è¨—ä¾¡æ ¼ã‚’å–å¾—ã™ã‚‹æ–¹æ³•ã¨è¨å®šæ‰‹é †ã‚’è§£èª¬ã—ã¾ã™ã€‚ ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã§æ—¥æœ¬ä¼æ¥ã®æ ªä¾¡ãŒå–å¾—ã—ãŸã„è¡¨è¨ˆç®—ã®Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚’ä½¿ã„ã€æ—¥æœ¬ã®ä¸Šå ´ä¼æ¥ã®æ ªä¾¡ã‚’å–å¾—ã—ãŸã„ãƒ‹ãƒ¼ã‚ºãŒã‚ã‚Šã¾ã™ã€‚ ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã§æ—¥æœ¬ã®æ ªä¾¡æƒ…å ±ã‚’å–å¾—ã§ãã‚Œã°ã€è³‡ç”£ç®¡ç†ã‚„æŠ•è³‡åˆ†æžã«ã‚‚æ´»ç”¨ã§ãã¾ã™ã€‚ ãŸã ã€æ®‹å¿µãªãŒã‚‰ã€ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã«æ¨™æº–ã§å‚™ã‚ã£ã¦ã„ã‚‹é–¢æ•°ã§ã¯ã€æ—¥æœ¬ã®æ ªä¾¡ã‚’å–å¾—ãŒã§ãã¾ã›ã‚“ã€‚ GOOGLEFINANCEé–¢æ•°ã¯æ—¥æœ¬æ ªã«éžå¯¾å¿œã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã«ã¯GOOGLEFINANCEã¨ã„ã†é–¢æ•°ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã®GOOGLEFINANCEé–¢æ•°ã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã«ã¯ã€ã€ŒGoogle Financeã‹ã‚‰ç¾åœ¨ã‚„éŽåŽ»ã®è¨¼åˆ¸æƒ…å ±ã‚’å–å¾—ã—ã¾ã™ã€‚
palmyra 2022/02/27
æ‹¡å¼µæ©Ÿèƒ½â†’AppsScriptã€€ãƒ‡ãƒ—ãƒã‚¤ã¯ã—ãªãã¦ã‚‚ä¿å˜ã™ã‚ŒSpreadSheetä¸Šã§é–¢æ•°ãŒä½¿ãˆã‚‹ã‚ˆã†ã«ãªã‚‹

Spreadsheets
ãƒªãƒ³ã‚¯
1