スプレッドシートを用意して
シートの名前を zaif
に設定
ZaifのAPIキーやシークレット、積立したい金額を入力
curl "https://www.google.co.jp/complete/search?hl=ja&output=toolbar&ie=utf-8&oe=utf-8&client=firefox&q=旦那" |
version: '2' | |
services: | |
db: | |
image: mysql:5.7 | |
restart: always | |
environment: | |
MYSQL_ROOT_PASSWORD: {root-pass} | |
MYSQL_DATABASE: {db-name} | |
MYSQL_USER: {user-name} | |
MYSQL_PASSWORD: {user-password} |
var BK = SpreadsheetApp.getActiveSpreadsheet(), | |
SHEET = BK.getSheetByName('portfolio'), | |
QUERY_STRING = Math.random(), | |
BTC_SYMBOL = 'BTC'; | |
function onOpen() { | |
function showMenu() { | |
var menu = [ | |
{name: "Get Crypto Currency Data", functionName: "setData"} | |
]; |
var BK = SpreadsheetApp.getActiveSpreadsheet(), | |
SHEET = BK.getSheetByName('portfolio'); | |
function onOpen() { | |
function showMenu() { | |
var menu = [ | |
{name: "Get Crypto Currency Data", functionName: "setData"} | |
]; | |
BK.addMenu("Custom Management", menu); | |
} |
var BK = SpreadsheetApp.getActiveSpreadsheet(), | |
SHEET = BK.getSheetByName('portfolio'), | |
BTC_SYMBOL = 'BTC'; | |
function onOpen() { | |
function showMenu() { | |
var menu = [ | |
{name: "Get Crypto Currency Data", functionName: "setData"} | |
]; | |
BK.addMenu("Custom Management", menu); |
var BK = SpreadsheetApp.getActiveSpreadsheet(), | |
SHEET = BK.getSheetByName('portfolio'); | |
function onOpen() { | |
function showMenu() { | |
var menu = [ | |
{name: "Get Crypto Currency Data", functionName: "setData"} | |
]; | |
BK.addMenu("Custom Management", menu); | |
} |
# 全投稿view数順 | |
SELECT | |
p.post_title, | |
pm.meta_value, | |
p.guid | |
FROM wp_posts p | |
INNER JOIN wp_postmeta pm | |
ON p.id = pm.post_id | |
AND pm.meta_key = "post_views_count" |