Gamestudio Links
Zorro Links
Newest Posts
Free Live Data for Zorro with Paper Trading?
by dr_panther. 05/18/24 11:01
Change chart colours
by 7th_zorro. 05/11/24 09:25
Data from CSV not parsed correctly
by dr_panther. 05/06/24 18:50
AUM Magazine
Latest Screens
The Bible Game
A psychological thriller game
SHADOW (2014)
DEAD TASTE
Who's Online Now
2 registered members (7th_zorro, dr_panther), 724 guests, and 3 spiders.
Key: Admin, Global Mod, Mod
Newest Members
Hanky27, firatv, wandaluciaia, Mega_Rod, EternallyCurious
19051 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,729
Chicago
AndrewAMD Offline
Serious User
AndrewAMD  Offline
Serious User

Joined: Feb 2017
Posts: 1,729
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,729
Chicago
AndrewAMD Offline
Serious User
AndrewAMD  Offline
Serious User

Joined: Feb 2017
Posts: 1,729
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,729
Chicago
AndrewAMD Offline
Serious User
AndrewAMD  Offline
Serious User

Joined: Feb 2017
Posts: 1,729
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,729
Chicago
AndrewAMD Offline
Serious User
AndrewAMD  Offline
Serious User

Joined: Feb 2017
Posts: 1,729
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