Gamestudio Links
Zorro Links
Newest Posts
optimize global parameters SOLVED
by dBc. 09/27/25 17:07
ZorroGPT
by TipmyPip. 09/27/25 10:05
Release 2.68 replacement of the .par format
by Martin_HH. 09/23/25 20:48
assetHistory one candle shift
by jcl. 09/21/25 11:36
Plugins update
by Grant. 09/17/25 16:28
AUM Magazine
Latest Screens
Rocker`s Revenge
Stug 3 Stormartillery
Iljuschin 2
Galactic Strike X
Who's Online Now
1 registered members (TipmyPip), 17,605 guests, and 5 spiders.
Key: Admin, Global Mod, Mod
Newest Members
krishna, DrissB, James168, Ed_Love, xtns
19168 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
Page 1 of 2 1 2
Trouble downloading from QUANDL #473276
06/25/18 14:39
06/25/18 14:39
Joined: Sep 2017
Posts: 235
H
Hredot Offline OP
Member
Hredot  Offline OP
Member
H

Joined: Sep 2017
Posts: 235
I put the quandl api key into the ini file. My assets file reads as follows:

Quote:
Name,Price,Spread,RollLong,RollShort,PIP,PIPCost,MarginCost,Leverage,LotAmount,Commission,Symbol
NVDA,50,0.1,0,0,0.01,0.01,0,2,1,0.02,QUANDL:NVDA


Now I try to use the following code to download data

Quote:
function run()
{
assetList("History\assets.csv"); // load asset list
while(loop(Assets))
assetHistory(Loop1,FROM_QUANDL);
quit();
}


However, Zorro complains:



And the "history.csv" file shows the following response from QUANDL

Quote:
code,message

QECx05,The url you requested is incorrect. Please use the following url instead: /api/v3/datasets/:database_code/:dataset_code.


What do I do wrong? How can I fix this?

Re: Trouble downloading from QUANDL [Re: Hredot] #473277
06/25/18 14:51
06/25/18 14:51
Joined: Sep 2017
Posts: 235
H
Hredot Offline OP
Member
Hredot  Offline OP
Member
H

Joined: Sep 2017
Posts: 235
Changing just the line

assetHistory(Loop1,FROM_QUANDL);

to

assetHistory(Loop1,FROM_AV);

downloads the data just fine (even though assets.csv still refers to QUANDL). So how to make it work with quandl?

Re: Trouble downloading from QUANDL [Re: Hredot] #473279
06/25/18 15:20
06/25/18 15:20
Joined: Feb 2017
Posts: 1,806
Chicago
AndrewAMD Offline
Serious User
AndrewAMD  Offline
Serious User

Joined: Feb 2017
Posts: 1,806
Chicago
Your symbol is QUANDL:NVDA... I thought this notation is for broker arb only, but I could be wrong.

Does it work if you change it to NVDA?

Re: Trouble downloading from QUANDL [Re: AndrewAMD] #473280
06/25/18 16:02
06/25/18 16:02
Joined: Sep 2017
Posts: 235
H
Hredot Offline OP
Member
Hredot  Offline OP
Member
H

Joined: Sep 2017
Posts: 235
@AndrewAMD

Thanks for the suggestion! Changed symbol to NVDA, but the problem still persists in exactly the same fashion.

Re: Trouble downloading from QUANDL [Re: Hredot] #473283
06/25/18 17:49
06/25/18 17:49
Joined: Feb 2017
Posts: 1,806
Chicago
AndrewAMD Offline
Serious User
AndrewAMD  Offline
Serious User

Joined: Feb 2017
Posts: 1,806
Chicago
From the manual:

http://zorro-trader.com/manual/en/loadhistory.htm
http://zorro-trader.com/manual/en/data.htm
Quote:
Quandl data from the WIKI (stocks), CHRIS/CME and CHRIS/ICE (futures), BITFINEX and GDAX (Bitcoin and other cryptocurrencies) EOD databases are supported. Other Quandl databases in different formats can be downloaded with the dataDownload function. Quandl data loads fast and is of good quality. The Quandl key must be present in Zorro.ini.
So which Quandl database are you downloading from, exactly?

Re: Trouble downloading from QUANDL [Re: AndrewAMD] #473284
06/25/18 18:00
06/25/18 18:00
Joined: Sep 2017
Posts: 235
H
Hredot Offline OP
Member
Hredot  Offline OP
Member
H

Joined: Sep 2017
Posts: 235
Thank you for pointing this out AndrewAMD!
I would also like to know which one I am trying to download. laugh Literally all the setup that I made is described above. I am not sure where to specify in Zorro which database should be used. Perhaps you know where to look for it?

Re: Trouble downloading from QUANDL [Re: Hredot] #473285
06/25/18 18:47
06/25/18 18:47
Joined: Feb 2017
Posts: 1,806
Chicago
AndrewAMD Offline
Serious User
AndrewAMD  Offline
Serious User

Joined: Feb 2017
Posts: 1,806
Chicago
I misspoke. Which database did you **intend** to download from?

I mean - browse Quandl and show us the ticker you want to use. Is the ticker premium or free? Are you paying for premium? Which Quandl database is it under? Will you need to use dataDownload as the manual suggests?

Re: Trouble downloading from QUANDL [Re: AndrewAMD] #473286
06/25/18 19:02
06/25/18 19:02
Joined: Sep 2017
Posts: 235
H
Hredot Offline OP
Member
Hredot  Offline OP
Member
H

Joined: Sep 2017
Posts: 235
Oh, I'm sorry for the confusion. I intend to download from the WIKI, which is freely accessible even without the api (but api key allows for more downloads per time frame).

Here the source I would like Zorro to access:
https://www.quandl.com/api/v3/datasets/WIKI/NVDA/data.csv

See this blog entry for some more details:
https://blog.quandl.com/getting-started-with-the-quandl-api

Re: Trouble downloading from QUANDL [Re: Hredot] #473293
06/25/18 21:25
06/25/18 21:25
Joined: Feb 2017
Posts: 1,806
Chicago
AndrewAMD Offline
Serious User
AndrewAMD  Offline
Serious User

Joined: Feb 2017
Posts: 1,806
Chicago
Hmm. Did Quandl change their WIKI dataset formats? (now v3)

You can always do the dataDownload method. Happy parsing! laugh

Re: Trouble downloading from QUANDL [Re: AndrewAMD] #473294
06/25/18 21:30
06/25/18 21:30
Joined: Sep 2017
Posts: 235
H
Hredot Offline OP
Member
Hredot  Offline OP
Member
H

Joined: Sep 2017
Posts: 235
Soo... basically, Zorro is not up to date with current data provider settings. frown

Page 1 of 2 1 2

Moderated by  Petra 

Powered by UBB.threads™ PHP Forum Software 7.7.1