GetQuandl
Moderators: EViews Gareth, EViews Moderator, EViews Esther
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13399
- Joined: Tue Sep 16, 2008 5:38 pm
GetQuandl
This thread is about the GetQuandl Add-in that provides an easy way to download Quandl data into EViews.
Follow us on Twitter @IHSEViews
Re: GetQuandl
I believe there is a mistake in your code
instead of
it should be (changes are in bold)
'check that the user entered at least one stock symbol.
if @wcount(%vars)=0 then
@uiprompt("You must enter at least one Quandl code")
stop
endif
if @wcount(%vars)>1 then
@uiprompt("Due to Quandl API restrictions, only one code may be entered at a time")
stop
endif
fixing that worked for me
thnx for the add in
quandl is amazing!
instead of
Code: Select all
'check that the user entered at least one stock symbol.
if @length(%vars)=0 then
@uiprompt("You must enter at least one Quandl code")
stop
endif
if @length(%vars)>1 then
@uiprompt("Due to Quandl API restrictions, only one code may be entered at a time")
stop
endif
'check that the user entered at least one stock symbol.
if @wcount(%vars)=0 then
@uiprompt("You must enter at least one Quandl code")
stop
endif
if @wcount(%vars)>1 then
@uiprompt("Due to Quandl API restrictions, only one code may be entered at a time")
stop
endif
fixing that worked for me
thnx for the add in
quandl is amazing!
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13399
- Joined: Tue Sep 16, 2008 5:38 pm
Re: GetQuandl
Hi Gareth, I already added GetQuandl to my Eviews8 add-in, I tried to run this codes on Eviews programming windows but it doesnt work, for instance if my quandl code is FOO_3, then I have to write this command:
if @wcount(%vars)=0 then
@uiprompt("FOO_3")
stop
endif
if @wcount(%vars)>1 then
@uiprompt("FOO_3")
stop
endif
I appreciate if you help me.
thanks
if @wcount(%vars)=0 then
@uiprompt("FOO_3")
stop
endif
if @wcount(%vars)>1 then
@uiprompt("FOO_3")
stop
endif
I appreciate if you help me.
thanks
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13399
- Joined: Tue Sep 16, 2008 5:38 pm
Re: GetQuandl
Dear Gareth, is there a way to update data that we already download from Quandl? Thanks
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13399
- Joined: Tue Sep 16, 2008 5:38 pm
Re: GetQuandl
Thanks for your reply, I got another problem.
I downloaded plenty of data by getQuandl, then my daily restriction that is 500 API calls for registered API is finished, then I contacted Quandl and asked for more allowance and they gave me 10,000 API calls but still Eviews doesnt allow me to download data, and keep giving this messege:
Web server error: Forbidden in "WFOPEN(WF=QUANDL, PAGE="QUANDL", TYPE=TXT) HTTP://WWW.QUANDL.COM/API/V1/DATASETS/OFDP/FUTURE_HO ...
Do you have any idea that what can be the problem? I contacted again with Quandl and they told me that they are suspecting Eviews can not recognize my extended allowance API, do you have any suggestion?
Thanks
I downloaded plenty of data by getQuandl, then my daily restriction that is 500 API calls for registered API is finished, then I contacted Quandl and asked for more allowance and they gave me 10,000 API calls but still Eviews doesnt allow me to download data, and keep giving this messege:
Web server error: Forbidden in "WFOPEN(WF=QUANDL, PAGE="QUANDL", TYPE=TXT) HTTP://WWW.QUANDL.COM/API/V1/DATASETS/OFDP/FUTURE_HO ...
Do you have any idea that what can be the problem? I contacted again with Quandl and they told me that they are suspecting Eviews can not recognize my extended allowance API, do you have any suggestion?
Thanks
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13399
- Joined: Tue Sep 16, 2008 5:38 pm
Re: GetQuandl
They're probably right. If you're downloading that many, you're probably better off writing your own program to do it via the Quandl API rather than using the add-in.
Follow us on Twitter @IHSEViews
Re: GetQuandl
Dear Eviews Gareth, If I want to take the historical futures data from Quandl, it would be too many series, something like 400 series and getting them one bye one with Eviews Ttakes so much time (as I need them for different commodities it woulbe be more than 2000 downloads) I could manage to get them all together (historical futures for one commodity) in one code with Stata as below:
local fut "CL1 CLM1983 CLN1983 CLQ1983 CLU1983 CLV1983 CLX1983 CLZ1983 CLF1984 CLG1984 CLH1984 CLJ1984 CLK1984 CLM1984 CLN1984 CLQ1984 CLU1984 CLV1984 CLX1984 CLZ1984...."
local j 0
foreach x of local fut {
local nome = "OFDP/FUTURE_"+"`x'"
quandl, quandlcode(`nome') authtoken(C5iRsDGdor1T5hAGvnMV)
drop open high low volume openinterest
rename settle pc_`x'
* Uncomment to create continous vol, oi, etc.
*rename volume vol_`x'
*rename openinterest oi_`x'
*rename open po_`x'
*rename high ph_`x'
*reaname low pl_`x'
sort date
save dati_`j'.dta, replace
local ++j
clear
}
local j 0
foreach x of local fut {
if `j'==0 {
use "dati_`j'.dta", clear
}
else {
merge date using "dati_`j'.dta"
sort date
drop _merge
}
local ++j
}
/*
save prove.dta, replace
use prove.dta, clear
*/
but as my work is with Eviews I would like to know that is it possible to modify the codes for Eviews?
My API Quandl key can get 10000 download per day.
Thank you
local fut "CL1 CLM1983 CLN1983 CLQ1983 CLU1983 CLV1983 CLX1983 CLZ1983 CLF1984 CLG1984 CLH1984 CLJ1984 CLK1984 CLM1984 CLN1984 CLQ1984 CLU1984 CLV1984 CLX1984 CLZ1984...."
local j 0
foreach x of local fut {
local nome = "OFDP/FUTURE_"+"`x'"
quandl, quandlcode(`nome') authtoken(C5iRsDGdor1T5hAGvnMV)
drop open high low volume openinterest
rename settle pc_`x'
* Uncomment to create continous vol, oi, etc.
*rename volume vol_`x'
*rename openinterest oi_`x'
*rename open po_`x'
*rename high ph_`x'
*reaname low pl_`x'
sort date
save dati_`j'.dta, replace
local ++j
clear
}
local j 0
foreach x of local fut {
if `j'==0 {
use "dati_`j'.dta", clear
}
else {
merge date using "dati_`j'.dta"
sort date
drop _merge
}
local ++j
}
/*
save prove.dta, replace
use prove.dta, clear
*/
but as my work is with Eviews I would like to know that is it possible to modify the codes for Eviews?
My API Quandl key can get 10000 download per day.
Thank you
They're probably right. If you're downloading that many, you're probably better off writing your own program to do it via the Quandl API rather than using the add-in.
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13399
- Joined: Tue Sep 16, 2008 5:38 pm
Re: GetQuandl
The add-in is open source - you can look at the code and change it any way you want.
Follow us on Twitter @IHSEViews
Re: GetQuandl
http://www.eviews.com/Addins/addins.shtml the addin of GetStocks's forum link to here, should go to http://forums.eviews.com/viewtopic.php?f=23&t=2128
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13399
- Joined: Tue Sep 16, 2008 5:38 pm
Re: GetQuandl
Hi there,
I have failed to download at once 2 series from Quandl...Evidently I am doing I should be doing something wrong so I would appreciate a bit of guidance here :)
%list2= "CME/CLF2016 CME/CLG2016"
for %a {%list2}
statusline {%a} downloading
getquandl {%a}
rename settle %a
statusline {%a} done
next
In addition, I would like to download all the series to the same workfile without creating a new file all the time. In the documentation I only found that it is possible to set the start and end date.
Cheers,
Fede
I have failed to download at once 2 series from Quandl...Evidently I am doing I should be doing something wrong so I would appreciate a bit of guidance here :)
%list2= "CME/CLF2016 CME/CLG2016"
for %a {%list2}
statusline {%a} downloading
getquandl {%a}
rename settle %a
statusline {%a} done
next
In addition, I would like to download all the series to the same workfile without creating a new file all the time. In the documentation I only found that it is possible to set the start and end date.
Cheers,
Fede
Who is online
Users browsing this forum: No registered users and 2 guests