Yuki Hirai yukihirai0505

## Nampa.java
package com.example;

import java.util.Calendar;
import java.util.Date;
import java.util.GregorianCalendar;
import java.util.Random;

class NampaMan {

    private int nampaCount = 0;

## slack_attachements.go
package slack

import (
	"bytes"
	"encoding/json"
	"net/http"
	"net/url"
	"os"
)

## 01_coin-regular-investment.md

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

スプレッドシートを用意して
シートの名前を bitbank に設定
bitbankのAPIキーやシークレット、積立したい金額を入力


## docker-compose.yml
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}

## getZaifAndBinanceData.gs
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);

## v1_crypto_sheet.gs
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"}
    ];

## OutputTwitterFollower.md

      
              2 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                yukihirai0505
                / OutputTwitterFollower.md
            
            
              Created
              January 23, 2018 08:05
            
              
                Twitterで特定のユーザーのフォロワー名を全部取得する
              
          
フォロワーIDを取得する
=> 5,000*15で15分で75,000フォロワー取得可能
IDからユーザーを検索
=> 100*900で15分で90,000分のユーザー情報取得可能


## getBinanceCryptoCurrencyData.gs
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);
  }

## getCryptoCurrencyData.gs
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);
  }

## popular_post_list.sql
# 全投稿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"
	package com.example;

	import java.util.Calendar;
	import java.util.Date;
	import java.util.GregorianCalendar;
	import java.util.Random;

	class NampaMan {

	private int nampaCount = 0;
	package slack

	import (
	"bytes"
	"encoding/json"
	"net/http"
	"net/url"
	"os"
	)
	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'),
	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'),
	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);
	}
	# 全投稿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"