Stack Overflow
Stack Overflow

Questions tagged [quandl]

Quandl.com is a website gathering, formatting and offering finance and economic data.

Quandl.com is a website gathering, formatting and offering finance and economic data. Data can be downloaded (there is a free daily allowance), requested through an API or through an official Python client.

325 questions
2
votes
2 answers

R quandl : couldn't connect to host

I am begining to use Quandl facilities to import datasets to R with Quandl R API. It appears to be the easiest thing. However I have a problem. The below pasted snipet of code does not work (for me). It returns an error. …
Miha Trošt
  • 2,002
  • 22
  • 25
2
votes
5 answers

Python Quandl in Spyder

Spyder is working wonderfully with numpy and pandas, but with Quandl I get the following error (in spyder): >>> import Quandl Traceback (most recent call last): File "", line 1, in ImportError: No module named Quandl Yet from the…
jason m
  • 6,519
  • 20
  • 69
  • 122
1
vote
0 answers

limited date for QUANDL API Requests

I'm working on a personnal PHP app, trying to fetch stock market prices for Euronext shares with quandl api using an HTTP request But the request returns only data until 2021-06-01. PHP…
foxbille
  • 11
  • 2
1
vote
0 answers

AttributeError: 'Series' object has no attribute 'rolling', pandas

This is the code: %matplotlib inline from pylab import mpl,plt import quandl as q plt.style.use('ggplot') mpl.rcParams['font.family']='serif' q.ApiConfig.api_key='7QRLThQTiHp5Xp-tFlk' d=q.get('BCHAIN/MKPRU')…
ethan davitt
  • 19
  • 2
1
vote
1 answer

Can't truncate pandas dataframe from quandl

All my data is being pulled from quandl into pandas dataframes. For whatever reason when I call the dataframe function truncate, it seems to have no effect. oil = pd.DataFrame(qd.get('OPEC/ORB')) plat= pd.DataFrame(qd.get('LPPM/PLAT',…
user15730430
  • 13
  • 2
1
vote
1 answer

Having trouble setting API key for zipline ingestion

I ran the following commands in terminal on a mac running catalina. As far as I can tell my path is correct (I launched cmd from my conda environment) set QUANDL_API_KEY=mykey zipline ingest -b quandl I get the following error: ValueError: Please…
Alex
  • 11
  • 3
1
vote
1 answer

Unable to automatically infer frequency of Quandl Time Series Dataframe

I've downloaded a Quandl dataset. I'm unable to infer or find the frequency of the data using infer_freq or freq. These two methods don't return anything. I don't understand what the problem is. I'd like to see/print the frequency of the data,…
a_jelly_fish
  • 478
  • 6
  • 21
1
vote
1 answer

Correlation of Quandl Time Series with Pandas

I want to import two time series from Quandl and want to find the correlation between them. I found out about the pandas and tried with the corr function, however I always get the error ValueError: The truth value of a DataFrame is ambiguous. Use…
bruketa22
  • 11
  • 1
1
vote
1 answer

Quandl ingestion with zipline lacks data

I have recently installed Zipline and ingested Quandl data. However, it seems that Quandl hasn't ingested data of the years 2018,2019 and 2020. Just by plotting a stock price you can see this. AAPL stock 2016-2020: Why would this happen? Quandl…
ferran raiva
  • 11
  • 1
1
vote
2 answers

How to calculate the yearly cumulative percent change

So I have been studying the SP500 yearly returns with information downloaded from my quandl subscription. I have used resample() and pct_change() to study the data but my results are not coming as to what is expected for some reason. sp500_df =…
Ultima
  • 23
  • 1
  • 6
1
vote
1 answer

add Sparkline by xlsxwriter without writing data in spreadsheet

now I have some data sets in pandas Series form. I want to create an Excel spreadsheet dashboard by using xlsxwriter. the first column is the name and the second column is Sparklines. I see in xlsxwriter documentations if I want to add sparklines in…
Austin Jin
  • 141
  • 3
  • 11
1
vote
3 answers

ModuleNotFoundError: No module named 'Quandl'

Whenever I try to import quandl import quandl this error appears ModuleNotFoundError: No module named 'quandl' although I checked it was installed using pip list and Quandl 3.5.2 was installed
Aasmaa
  • 33
  • 4
1
vote
1 answer

Python use implicit argument on new class without pre constructing Object from class that inherits: pandas, Quandl, matplotlib, NumPy

I'm new to python as to artificial intelligence. I'm using matplotlib to plot the curve of data in a pandas dataframe that I get with Quandl. In examples, I'm seeing stuff like this: import pandas as pd import Quandl import matplotlib.pyplot as…
Jhon
  • 135
  • 8
1
vote
1 answer

curl_easy_perform() failed: SSL peer certificate or SSH remote key was not OK

Running this code i get an error "curl_easy_perform() failed: SSL peer certificate or SSH remote key was not OK" #include #include int main(void) { CURL* curl; CURLcode res; curl = curl_easy_init(); if…
ariia
  • 63
  • 1
  • 7
1
vote
1 answer

Can a csv file be used to download multiple zip-files in url?

I have a csv file with multiple dates, eg. Example of dates I want to download multiple zip files for each date in the csv file. In the specific example below the date is given as 20151117. Is there a way to download for each date in the csv…
Anders
  • 73
  • 7
1 2 3
…
21 22