bestpika

Checking Exchange Rate using GOOGLEFINANCE with Google Apps Script

This is a sample script for checking the exchange rate using GOOGLEFINANCE with Google Apps Script.

Recently, I have published a report of "Report: Obtaining Values from GOOGLEFINANCE using Google Apps Script". Ref In this post, I would like to introduce a sample script for checking the exchange rate using Google Apps Script.

Sample script

bestpika

排序記錄

• 翻譯
• 總結（文本）
• 整理成表格
• 生成圖像
• 回電郵
• 回覆消息
• 解釋代碼
• 改寫

bestpika

const pastValue = pastValues[-1].primaryValue
const diff = primaryValue - pastValue
notificationText = diff !== 0 ? `... ${primaryValue} (${diff})` : null

bestpika

Twitter公式クライアントのコンシューマキー

Twitter for iPhone

Consumer key: IQKbtAYlXLripLGPWd0HUA
Consumer secret: GgDYlkSvaPxGxC4X8liwpUoqKwwr3lCADbz8A7ADU

Twitter for Android

Consumer key: 3nVuSoBZnx6U4vzUxf5w
Consumer secret: Bcs59EFbbsdF6Sl9Ng71smgStWEGwXXKSjYvPVt7qys

Twitter for iPad

Consumer key: CjulERsDeqhhjSme66ECg

bestpika

using Microsoft.Extensions.Configuration;

public class AppSettings
{
    static private readonly IConfiguration _config = new ConfigurationBuilder()
        .SetBasePath(Directory.GetCurrentDirectory())
        .AddJsonFile("appsettings.json", optional: true, reloadOnChange: true)
        .AddYamlFile("appsettings.yaml", optional: false, reloadOnChange: true)
        .Build();

bestpika

• https://github.com/Blinue/Magpie 提高視窗化遊戲的解析度，並全螢幕顯示

bestpika

version: '2'

services:
  db:
    image: postgres:alpine
    restart: always
    volumes:
     - ./postgres:/var/lib/postgresql/data
    ports:
     - 5432:5432

bestpika

IIS

• 解鎖設定

%windir%\system32\inetsrv\appcmd unlock config -section:system.webServer/serverRuntime

bestpika

// 文字轉換
unsigned char hs2i(char c)
{
  if ('0' <= c && c <= '9') {
    return ((unsigned char)c - '0');
  } else if ('a' <= c && c <= 'f') {
    return ((unsigned char)c - 'a' + 10);
  } else if ('A' <= c && c <= 'F') {
    return ((unsigned char)c - 'A' + 10);
  } else {

bestpika

<configuration>
  <system.webServer>
    <modules>
      <remove name="FormsAuthentication" />
      <remove name="RoleManager" />
      <remove name="UrlAuthorization" />
      <remove name="DefaultAuthentication" />
      <add name="FormsAuthentication" type="System.Web.Security.FormsAuthenticationModule" />
      <add name="RoleManager" type="System.Web.Security.RoleManagerModule" />
      <add name="UrlAuthorization" type="System.Web.Security.UrlAuthorizationModule" />