SHEET_NAME="Sheet1"
URL="https://data.sparkfun.com/output/VFEEYZENwLCNwE8LZjDA.csv"
function myFunction() {
ScriptApp.newTrigger("getData")
.timeBased()
.everyMinutes(1)
.create();
}
This file contains hidden or 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 | |
/** | |
* PHP implementation of Pyton's requests module | |
* Copyright 2017-2018 Ran Aroussi | |
* | |
* Licensed under the GNU Lesser General Public License, v3.0 (the "License"); | |
* you may not use this file except in compliance with the License. | |
* You may obtain a copy of the License at | |
* | |
* https://www.gnu.org/licenses/lgpl-3.0.en.html |
This file contains hidden or 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 python | |
# -*- coding: utf-8 -*- | |
import pandas as pd | |
from urllib.parse import urlencode | |
class AlphaVantage(object): | |
def __init__(self, api_key): |
I hereby claim:
- I am ranaroussi on github.
- I am ranaroussi (https://keybase.io/ranaroussi) on keybase.
- I have a public key ASA6RgWZK5het4zvK722ATQfHG0lqH6iUX2IQrwVtsuZ0Qo
To claim this, I am signing this object:
This file contains hidden or 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
{"lastUpload":"2022-03-29T10:27:38.273Z","extensionVersion":"v3.4.3"} |
This file contains hidden or 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 python | |
from dateutil.parser import parse as parse_date | |
import datetime | |
import requests | |
import pandas as pd | |
def get_contracts(url): | |
html = requests.get(url, timeout=5) |
This file contains hidden or 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 python | |
import subprocess | |
import time | |
import sys | |
import logging | |
class Job: | |
""" | |
monitors that a job is running and executing it when it's not |
This file contains hidden or 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
import pandas as pd | |
def resample(data, resolution="1T", tz=None, ffill=True, dropna=False): | |
""" | |
>>> resample(df, '500K') # resample 500 ticks (by counting trades) | |
>>> resample(df, '500V') # resample ~500 volume (by counting volume) | |
""" | |
def __finalize(data, tz=None): | |
# figure out timezone |
This file contains hidden or 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
import requests | |
def get_premarket(ticker): | |
""" | |
gets premarket prices from nasdaq | |
usage: | |
>> price, volume = get_premarket('spy') | |
""" |