def quandl_data(symbol,
since=None,
until=None,
*,
collapse='daily',
api_key=''):
"""
Parameters
----------
symbol
since
until
collapse: none|daily|weekly|monthly|quarterly|annual
api_key
Returns
-------
"""
if since is None:
since = date(1900, 1, 1).isoformat()
if until is None:
until = date.today().isoformat()
QUANDL_URL = ('https://www.quandl.com/api/v3/datasets/WIKI/{SYMBOL}/data.csv?'
'start_date={START_DATE}&end_date={END_DATE}&order=asc&'
'collapse={COLLAPSE}&transform=rdiff&api_key={API_KEY}')
url = QUANDL_URL.format(SYMBOL=symbol,
START_DATE=since,
END_DATE=until,
COLLAPSE=collapse,
API_KEY=api_key)
ts = Timeseries.from_url(url)
return ts
def test_cb_axes(self):
""" Test that all possible axes work, including discrete variables. """
w = self.widget
data = Timeseries.from_url(
'http://datasets.orange.biolab.si/core/philadelphia-crime.csv.xz')
self.send_signal(w.Inputs.time_series, data)
# test all possibilities for Y axis
simulate.combobox_run_through_all(w.combo_ax2)
# test all possibilites for radial
simulate.combobox_run_through_all(w.combo_ax1)
def finance_data(symbol, since=None, until=None, granularity='d'):
"""Fetch Yahoo Finance data for stock or index `symbol` within the period
after `since` and before `until` (both inclusive).
Parameters
----------
symbol: str
A stock or index symbol, as supported by Yahoo Finance.
since: date
A start date (default: 1900-01-01).
until: date
An end date (default: today).
granularity: 'd' or 'w' or 'm' or 'v'
What data to get: daily, weekly, monthly, or dividends.
Returns
-------
data : Timeseries
"""
if since is None:
since = date(1900, 1, 1)
if until is None:
until = date.today()
YAHOO_URL = (
'http://chart.finance.yahoo.com/table.csv?'
's={SYMBOL}&d={TO_MONTH}&e={TO_DAY}&f={TO_YEAR}&'
'g={GRANULARITY}&a={FROM_MONTH}&b={FROM_DAY}&c={FROM_YEAR}&ignore=.csv'
)
url = YAHOO_URL.format(SYMBOL=symbol,
GRANULARITY=granularity,
TO_MONTH=until.month - 1,
TO_DAY=until.day,
TO_YEAR=until.year,
FROM_MONTH=since.month - 1,
FROM_DAY=since.day,
FROM_YEAR=since.year)
data = Timeseries.from_url(url)[::-1]
# Make Adjusted Close a class variable
attrs = [var.name for var in data.domain.attributes]
attrs.remove('Adj Close')
data = Timeseries(
Domain(attrs, [data.domain['Adj Close']], None, source=data.domain),
data)
data.name = symbol
data.time_variable = data.domain['Date']
return data
def finance_data(symbol,
since=None,
until=None,
granularity='d'):
"""Fetch Yahoo Finance data for stock or index `symbol` within the period
after `since` and before `until` (both inclusive).
Parameters
----------
symbol: str
A stock or index symbol, as supported by Yahoo Finance.
since: date
A start date (default: 1900-01-01).
until: date
An end date (default: today).
granularity: 'd' or 'w' or 'm' or 'v'
What data to get: daily, weekly, monthly, or dividends.
Returns
-------
data : Timeseries
"""
if since is None:
since = date(1900, 1, 1)
if until is None:
until = date.today()
YAHOO_URL = ('http://chart.finance.yahoo.com/table.csv?'
's={SYMBOL}&d={TO_MONTH}&e={TO_DAY}&f={TO_YEAR}&'
'g={GRANULARITY}&a={FROM_MONTH}&b={FROM_DAY}&c={FROM_YEAR}&ignore=.csv')
url = YAHOO_URL.format(SYMBOL=symbol,
GRANULARITY=granularity,
TO_MONTH=until.month - 1,
TO_DAY=until.day,
TO_YEAR=until.year,
FROM_MONTH=since.month - 1,
FROM_DAY=since.day,
FROM_YEAR=since.year)
data = Timeseries.from_url(url)[::-1]
# Make Adjusted Close a class variable
attrs = [var.name for var in data.domain.attributes]
attrs.remove('Adj Close')
data = Timeseries(Domain(attrs, [data.domain['Adj Close']], None, source=data.domain), data)
data.name = symbol
data.time_variable = data.domain['Date']
return data
def test_new_data(self):
"""
Widget crashes when it gets new data with different domain.
GH-50
"""
w = self.widget
url = "http://file.biolab.si/datasets/cyber-security-breaches.tab"
time_series2 = Timeseries.from_url(url)
self.send_signal(w.Inputs.time_series, self.passengers)
self.select_item(w, 0)
output1 = self.get_output(w.Outputs.time_series)
self.send_signal(w.Inputs.time_series, time_series2)
self.select_item(w, 0)
output2 = self.get_output(w.Outputs.time_series)
self.assertNotEqual(output1, output2)
def quandl_data(symbol,
since=None,
until=None,
*,
collapse='daily',
api_key=''):
"""
Parameters
----------
symbol
since
until
collapse: none|daily|weekly|monthly|quarterly|annual
api_key
Returns
-------
"""
if since is None:
since = date(1900, 1, 1).isoformat()
if until is None:
until = date.today().isoformat()
QUANDL_URL = (
'https://www.quandl.com/api/v3/datasets/WIKI/{SYMBOL}/data.csv?'
'start_date={START_DATE}&end_date={END_DATE}&order=asc&'
'collapse={COLLAPSE}&transform=rdiff&api_key={API_KEY}')
url = QUANDL_URL.format(SYMBOL=symbol,
START_DATE=since,
END_DATE=until,
COLLAPSE=collapse,
API_KEY=api_key)
ts = Timeseries.from_url(url)
return ts
def setUp(self):
self.widget = self.create_widget(OWSpiralogram) # type: OWSpiralogram
self.passengers = Timeseries.from_file("airpassengers")
self.philadelphia = Timeseries.from_url(
'http://datasets.orange.biolab.si/core/philadelphia-crime.csv.xz')
def setUp(self):
self.widget = self.create_widget(OWDifference) # type: OWDifference
url = "https://datasets.biolab.si/core/ewba-slovenia-illegal-dumpsites.tab"
self.data = Timeseries.from_url(url)
self.simple_data = Table('iris')
self.selected = [self.simple_data.domain.attributes[-1]]
