Skip to content

Instantly share code, notes, and snippets.

View yukihirai0505's full-sized avatar
:octocat:
Wanna work abroad

Yuki Hirai yukihirai0505

:octocat:
Wanna work abroad
View GitHub Profile
@yukihirai0505
yukihirai0505 / 01_coin-regular-investment.md
Last active July 23, 2021 00:44
ZaifのAPIを使用してイーサリアム(ETH)とネム(XEM)を指値注文するためのGoogle Apps Script

Get Started

スプレッドシートを用意して シートの名前を zaif に設定

ZaifのAPIキーやシークレット、積立したい金額を入力

dglxcxuvaaeipji

@yukihirai0505
yukihirai0505 / 01_coin-regular-investment.md
Last active June 22, 2018 08:19
bitbankのAPIを使用してリップルとモナコイン を成行買いするためのGoogle Apps Script

Get Started

スプレッドシートを用意して シートの名前を bitbank に設定

bitbankのAPIキーやシークレット、積立したい金額を入力

dglxcxuvaaeipji

@yukihirai0505
yukihirai0505 / google_suggest.sh
Last active September 3, 2019 08:34
Google検索サジェスト
curl "https://www.google.co.jp/complete/search?hl=ja&output=toolbar&ie=utf-8&oe=utf-8&client=firefox&q=旦那"
@yukihirai0505
yukihirai0505 / docker-compose.yml
Created May 16, 2018 07:43
docker-compose.ymlでwordpressの環境構築
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}
@yukihirai0505
yukihirai0505 / v1_crypto_sheet.gs
Last active January 26, 2018 04:52
KuCoin,Cryptopia,Binance,CoinExchangeで購入してる仮想通貨の情報を取得するプログラム with Zaifビットコイン価格
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"}
];
@yukihirai0505
yukihirai0505 / OutputTwitterFollower.md
Created January 23, 2018 08:05
Twitterで特定のユーザーのフォロワー名を全部取得する
  1. フォロワーIDを取得する => 5,000*15で15分で75,000フォロワー取得可能
  2. IDからユーザーを検索 => 100*900で15分で90,000分のユーザー情報取得可能
@yukihirai0505
yukihirai0505 / getBinanceCryptoCurrencyData.gs
Last active January 12, 2018 11:04
Binance(バイナンス)の銘柄情報取得プログラム
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);
}
@yukihirai0505
yukihirai0505 / getZaifAndBinanceData.gs
Last active February 9, 2018 02:02
Get crypto currency data from zaif and binance
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);
@yukihirai0505
yukihirai0505 / getCryptoCurrencyData.gs
Last active January 10, 2018 01:33
Get cryptocurrency data
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);
}
@yukihirai0505
yukihirai0505 / popular_post_list.sql
Last active December 22, 2017 09:19
Wordpress popular post list
# 全投稿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"