EViews.com

This thread is about the GetQuandl Add-in that provides an easy way to download Quandl data into EViews.

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!

Good call.

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

I don't understand what you're asking.

Sorry it is solved, thanks.

Dear Gareth, is there a way to update data that we already download from Quandl? Thanks

Only by redownloading it.

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

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.

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

EViews Gareth wrote: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.

The add-in is open source - you can look at the code and change it any way you want.

http://www.eviews.com/Addins/addins.shtml the addin of GetStocks's forum link to here, should go to viewtopic.php?f=23&t=2128

Thanks, fixed.

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