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

Dump quandl data to file

I'm using the Quandl Python module to get data. I'm fetching the data using: quandl.ApiConfig.api_key = '******************' df = quandl.get('WIKI/GOOGL') This seems to work fine. If I try to print the data (using print(df)) on screen it shows me…
ameyazing
  • 403
  • 12
  • 24
2
votes
0 answers

Download FX historical data (5 years) using R?

Is it possible to download hourly data from Quandl (or another provider) using something like: library(Quandl) Quandl('EUR/USD',type=hourly) ? and if so more than 3 or 5 years?
H701
  • 51
  • 3
2
votes
1 answer

How to join/merge two data frames from Quandl?

Specificly, I use Python2.7. I read and print the two data frames from Quandl: 'FMAC/HPI_AK' and 'FMAC/HPI_CA' individually with no problem. I used merged = pd.merge(df1, df2, on = 'Date', how = 'outer') to merge the two data frames. But when I…
Hanshenry90
  • 109
  • 1
  • 8
2
votes
3 answers

Web scraping of key stats in Yahoo! Finance with R

Is anyone experienced in scraping data from the Yahoo! Finance key statistics page with R? I am familiar scraping data directly from html using read_html, html_nodes(), and html_text() from rvest package. However, this web page MSFT key stats is a…
tonykuoyj
  • 81
  • 3
  • 10
2
votes
3 answers

Quandl response extremely slow on my home network as opposed to my mobile WIFI hotspot network

As stated in the question, something weird is happening. My quandl code: import quandl df = quandl.get('WIKI/GOOGL') print(df.head()) Responds after a few minutes on my home network, however if i connect my laptop to mobile WIFI hotspot, it…
KAKAK
  • 879
  • 7
  • 16
  • 32
2
votes
2 answers

Quandl download wiki EOD stock prices from python - how to?

Is there a way to do a partial download on Quandl for the Wiki EOD Stock Prices but for a given day in the past - not the most current date e.g. download for 2016-07-20? Entire database (too large):…
Goofball
  • 735
  • 2
  • 9
  • 27
2
votes
1 answer

Getting Unusual error with Pandas for a regression learning program in python

import pandas as pandas import Quandl as Quandl df = Quandl.get('WIKI/GOOGL') print (df.head) when i try to run this program it generates an unusual error Traceback (most recent call last): File…
Lucky Ansari
  • 51
  • 1
  • 1
  • 9
2
votes
0 answers

Python & Pandas Iteration Criteria

I am trying to get an iteration of every state from quandl, however unless I just have the query be print(X), it only returns one string for abbv instead of listing all 50 states and joining them together. Any reason for this? Thanks. for abbv in…
Tinkinc
  • 449
  • 2
  • 8
  • 21
2
votes
1 answer

dataset for 13F/13G SEC filing

I am looking for a database that contains the 13F/13G filings in Quandl but can't find any. Maybe I am not using the right keywords? Any suggestion where to find a curated dataset? I don't want to end up scraping EDGAR again. Cheers!
user2471214
  • 729
  • 9
  • 17
2
votes
1 answer

Log into Corporate Proxy Server with Python to Pull Data

I am trying to pull data from Quandl through Python. The problem I run into is that my Corporate's proxy blocks my ability to pull the data. Is there a way to log in to the proxy within the code itself by providing my username and password? I am…
lchkng922
  • 23
  • 5
2
votes
2 answers

Read Quandl API errors in Python

I am still relatively new to python, and I am trying to read/catch/handle errors when using the Quandl api. For example, if I type in a dataset that does not exist, I would like to "read" the error returned from the call, but as a newbie to python,…
Snoopy
  • 53
  • 2
  • 7
2
votes
3 answers

Python is returning an AttributeError while importing some modules all of sudden. How do I fix it?

My script was running well before. I had a series of crashes on some scripts where I had to fix some things. However, all of a sudden, I can't even run a script and my sublime text shell is displaying this error. I tried chasing down the files in my…
petermaxstack
  • 325
  • 1
  • 3
  • 10
2
votes
2 answers

urllib2.URLError when using Quandl for Python behind a proxy

I'm posting this because I tried searching for the answer myself and I was not able to find a solution. I was eventually able to figure out a way to get this to work & I hope this helps someone else in the future. Scenario: In Windows XP, I'm using…
user3150079
  • 459
  • 4
  • 6
2
votes
1 answer

Python Pandas 0.14.0. Error with timestamp format when using dataframe.to_sql

Code is pretty straight forward: import Quandl import sqlite3 myData = Quandl.get("DMDRN/AAPL_ALLFINANCIALRATIOS") cnx = sqlite3.connect("APPL.db") myData.to_sql('AAPL', cnx) I make a call to Quandl API. It gives me a pandas dataframe. When I…
abuteau
  • 6,963
  • 4
  • 16
  • 20
2
votes
2 answers

Quandl Julia error

I've been experimenting with Quandl in Julia and it works well on the mac, but, alas, Linux not so much. I'm doing really important work and I can't have any hiccups (ok ok I'm just downloading datasets and messing around). For some reason I get…
Chase CB
  • 1,561
  • 1
  • 13
  • 20
1 2 3
…
21 22