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
3
votes
1 answer

How do I get rid of the ellipsis in Pycharm console and display information instead using Quandl?

I am working with Quandl in Pycharm. I tried to get information from the web and display it on the console; however, when I try to print the data, it shows an ellipsis instead. This problem only happens when using Pycharm. In the Python console…
Andrew
  • 35
  • 5
3
votes
1 answer

How to view the whole table

I am trying to get a table(dataset) using quandl. The table has 5rows X 12Columns but it is only showing 4 columns in the output and rest columns are replaced by 3 dots. I wrote the following piece of code using Python: import quandl df =…
BLCKJCK
  • 71
  • 1
  • 1
  • 7
3
votes
1 answer

Python Quandl giving me error

So I have a bit of code in python which tries to get home prices from zillow. I am following the documentation exactly but I still get errors. The code: import quandl quandl.ApiConfig.api_key = "I have a key here in the code" data =…
GS483
  • 31
  • 4
3
votes
1 answer

How can I get list of all data set codes of Quandl API?

I want list of all dataset codes for each company,Ex. for Facebook dataset code is FB,for MICROSOFT it is MSFT.How can I get such list of all available codes for data sets ??
3
votes
8 answers

Cannot import quandl in Python 3

I have spyder (Python2.7) and spyder3 (Python3.5) installed on Ubuntu 16.04. I was able to import quandl in spyder (Python2.7) setup, but not in spyder3 (Python3.5). Do you have any suggestions? Below is the error returned in the terminal when…
anicehat
  • 45
  • 1
  • 1
  • 8
3
votes
2 answers

Quandl, Quantmod, or TrueFX hourly data

I have been trying to find some source code in R using either Quantmod, TrueFX or Quandl for downloading historical Hourly and H4 currency data. Unfortunately almost every provider only has daily data. TrueFX provides historical tick-data in CSV…
H701
  • 51
  • 3
3
votes
0 answers

Passing Quandl query to pandas dataframe

I'm using the Quandl database service API and its python support to download stock financial data. Right now, I'm using the free SFO database which downloads year operational financial data. For example, this query code passes the last 6-8 years…
leeprevost
  • 384
  • 1
  • 3
  • 15
3
votes
1 answer

Pandas - KeyError: columns not in index

import pandas as pd import quandl df=quandl.get('WIKI/GOOGL') #print(df.head()) df=df[['Adj.Open','Adj.High','Adj.Low','Adj.Close','Adj.Volume']] df['HL_PCT'] =(df['Adj.High']-df['Adj.Close'])/df['Adj.Close'] * 100 df['PCT_change']…
Suraj Kumar Singh
  • 140
  • 1
  • 1
  • 6
3
votes
1 answer

Cannot connect to Quandl via R

I am trying to pull down data from Quandl using R. When I try to pull a data series down, I get this message: Error in curl::curl_fetch_memory(url, handle = handle) : Couldn't connect to server I have reviewed similar posts and apparently…
Jack
  • 31
  • 1
3
votes
2 answers

Dowloading data from quandl.com and want to know how I include my API key with my request?

I am downloading data from quandl.com with python and I have reached my limit with 50 downloads for today. Users with an account can exceed this limit which I already have an account set up. The error message say I need to put my api key with the…
ZacAttack
  • 1,035
  • 2
  • 12
  • 29
3
votes
1 answer

Unable to install Quandl under R version 3.2?

I'm running R version 3.2 because it is a requirement for ggplots2. However it seems that I cannot install package "Quandl". I'm getting the following warnings: No package 'libcurl' found Using PKG_CFLAGS= Using…
Oliver
  • 31
  • 5
3
votes
2 answers

How to store and retrieve data in python

I have been looking for answers to my questions, but haven't found a definitive answer. I am new to python, mysql, and data science, so any advice is appreciated What I want to be able to do is: use python to pull daily close data from quandl for n…
John
3
votes
5 answers

How to install: Quandl on Anaconda (Python) 3.4 on OSX

I cant figure out for the life of me how in the world to install How to Quandl on Anaconda 3.4 on OSX. I have tried using: pip install quandl, I have tried moving files around and opening the setup.py file and I keep getting a syntax error. It is…
akaras222
  • 81
  • 1
  • 2
  • 10
3
votes
2 answers

R Quandl Library Behind Corporate Firewall/Proxy

I'm new to the Quandl package for R and am trying to use it at work. Unfortunately, I'm forced to work behind the corporate firewall and have to connect to the internet via a proxy. I've been able to get around this before while using R to scrape…
tblznbits
  • 6,602
  • 6
  • 36
  • 66
3
votes
1 answer

Grabbing data from entire index (e.g., DJIA) using pandas web.DataReader

I know how to get individual stocks. How might I get data for an entire index, like the DJI? https://www.google.com/finance?q=INDEXDJX%3A.DJI&ei=zsVZU4iADYKI6AGoXA I'd like to analyze the stock market as a whole from as far back as possible start,…
user3314418
  • 2,903
  • 9
  • 33
  • 55
1
2
3
21 22