- Add your coinMarketCap private key
YOUR_PRIVATE_KEY
- Use
=$COUNT_CELL*coingecko($SYMBOL_CELL)
in your sheet
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"Version": "2012-10-17", | |
"Id": "S3PolicyId1", | |
"Statement": [ | |
{ | |
"Sid": "IPAllow", | |
"Effect": "Allow", | |
"Principal": "*", | |
"Action": "s3:GetObject", | |
"Resource": "arn:aws:s3:::example.bucket/*", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
if (PHP_SAPI != 'cli') { | |
header('Status: 403 Forbidden'); | |
header('HTTP/1.1 403 Forbidden', true, 403); | |
exit(); | |
} | |
$_SERVER['REMOTE_ADDR'] = '127.0.0.1'; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
git reset $(git merge-base main $(git branch --show-current)) | |
git push --force |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function fish_prompt --description 'Informative prompt' | |
#Save the return status of the previous command | |
set -l last_pipestatus $pipestatus | |
set -lx __fish_last_status $status # Export for __fish_print_pipestatus. | |
if functions -q fish_is_root_user; and fish_is_root_user | |
printf '%s@%s %s%s%s# ' $USER (prompt_hostname) (set -q fish_color_cwd_root | |
and set_color $fish_color_cwd_root | |
or set_color $fish_color_cwd) \ | |
(prompt_pwd) (set_color normal) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
sudo certbot -d "*.example.com" --manual --preferred-challenges dns certonly |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env bash | |
function retry { | |
local retries=$1 | |
shift | |
local count=0 | |
until "$@"; do | |
exit=$? | |
wait=$((2 ** $count)) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
package main | |
import ( | |
"bufio" | |
"fmt" | |
"log" | |
"net" | |
) | |
func handleConnection(conn net.Conn) { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
* use =coinMarketCap('ETH') in your sheet | |
*/ | |
function coinMarketCap(symbol) { | |
const url = `https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=${symbol}&convert=EUR` | |
const headers = { | |
"X-CMC_PRO_API_KEY": 'API_KEY from https://pro.coinmarketcap.com/account' | |
}; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env python3 | |
""" | |
Warm the caches of your website by crawling each page or sitemap index defined in sitemap.xml. | |
To use, download this file and make it executable. Then run: | |
./cache-warmer.py --threads 4 --interval 10 --file https://example.com/sitemap.xml -v | |
./cache-warmer.py --threads 4 --interval 10 --file /data/web/public/sitemap.xml -v | |
""" | |
import argparse | |
from multiprocessing.pool import ThreadPool | |
import os.path |
NewerOlder