Gamestudio Links
Zorro Links
Newest Posts
Zorro FIX plugin - Experimental
by flink. 04/21/24 07:12
Data from CSV not parsed correctly
by EternallyCurious. 04/20/24 21:39
M1 Oversampling
by 11honza11. 04/20/24 20:57
Scripts not found
by juergen_wue. 04/20/24 18:51
zorro 64bit command line support
by 7th_zorro. 04/20/24 10:06
StartWeek not working as it should
by jcl. 04/20/24 08:38
folder management functions
by VoroneTZ. 04/17/24 06:52
AUM Magazine
Latest Screens
The Bible Game
A psychological thriller game
SHADOW (2014)
DEAD TASTE
Who's Online Now
1 registered members (rki), 405 guests, and 1 spider.
Key: Admin, Global Mod, Mod
Newest Members
EternallyCurious, howardR, 11honza11, ccorrea, sakolin
19047 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
Page 5 of 8 1 2 3 4 5 6 7 8
Re: Yahoo has changed their protocol [Re: konorti] #466302
06/07/17 06:08
06/07/17 06:08
Joined: Jan 2017
Posts: 64
J
Jeff1228 Offline
Junior Member
Jeff1228  Offline
Junior Member
J

Joined: Jan 2017
Posts: 64
Hi all,

Can I use the google script provided by jcl to download Canadian stocks history from Yahoo, I tried but got this

google compiling..............

Bad - can't parse Historyhistory.csv
Time 00:01:14

Last time I used an assetList with all US stocks, it worked.

I copied the link "https://www.google.com/finance/historical?q=AC.TO&startdate=01-Jan-2000" into the browser, actually it worked and I got the data up to date.

What's wrong here?

Thank you

Jeff

Last edited by Jeff1228; 06/07/17 11:10.
Re: Yahoo has changed their protocol [Re: konorti] #466305
06/07/17 08:37
06/07/17 08:37
Joined: Jan 2017
Posts: 64
J
Jeff1228 Offline
Junior Member
Jeff1228  Offline
Junior Member
J

Joined: Jan 2017
Posts: 64
Originally Posted By: konorti
Thanks! I also modified the "Download" strategy to use your exe.


Hi,

I am using MVO script and an assetlist with all Canadian stocks. I tried your method to download data from YAHOO. I put the .exe to the Zorro fold and your "var dataFromYahoo(string Code, int mode)" snippet as a function into the MVO script ahead of run function, changed orignal "assetHistory(Names[N],FROM_YAHOO);" to "dataFromYahoo(Names[N],FROM_YAHOO);". When I run it, for each of the assets, it seemed that a blank window pooped up waiting for some input, but I could not type in anything. When I crossed it out, Zorro seemed to download data. But at the end, the data is all old, not updated!

What's wrong with my script?

Thank you

Last edited by Jeff1228; 06/07/17 09:11.
Re: Yahoo has changed their protocol [Re: vinsom] #466319
06/08/17 08:41
06/08/17 08:41
Joined: Jan 2017
Posts: 64
J
Jeff1228 Offline
Junior Member
Jeff1228  Offline
Junior Member
J

Joined: Jan 2017
Posts: 64
Originally Posted By: vinsom
Here it is.
https://we.tl/Jfs1kuwNRJ

need the .Net framework to work.
Download it from microsoft.

Regards


Hi vinsom,

Are you Dennis Lee on Github? Is this .exe for Yahoo's cookie and token? I have tried but did not work out. I use win10 with .net built-in.

What went wrong?

Thanks

Re: Yahoo has changed their protocol [Re: Jeff1228] #466322
06/08/17 12:14
06/08/17 12:14
Joined: Jul 2016
Posts: 27
K
konorti Offline
Newbie
konorti  Offline
Newbie
K

Joined: Jul 2016
Posts: 27
I think pop-up empty window is fine. This works the same as original Download script that you have to write asset name and press "Load Yahoo Data" then. Try the the code snipet from Download_Y script as I modified a little. Naming of the CSV file didnt work for me in the original script, so I changed it.

Zorro should print something like this:

Download_Y compiling...........
FXCM.dll => FXCM plugin mounted
Login FXCM.. at UTC 06-08 12:10
Downloading TLT..
Parse Historyhistory.csv..
2017-06-07,125.239998,125.519997,124.790001,124.919998,124.919998,11951200
42893.00000000 125.2400 125.5200 124.7900 124.9200 11951200.0000 .
2017-06-06,125.690002,125.870003,125.400002,125.519997,125.519997,12841500
42892.00000000 125.6900 125.8700 125.4000 125.5200 12841500.0000 nTLT 3741 records read from YAHOO

Last edited by konorti; 06/08/17 12:20.
Re: Yahoo has changed their protocol [Re: konorti] #466329
06/09/17 02:25
06/09/17 02:25
Joined: Jan 2017
Posts: 64
J
Jeff1228 Offline
Junior Member
Jeff1228  Offline
Junior Member
J

Joined: Jan 2017
Posts: 64
Originally Posted By: konorti
I think pop-up empty window is fine. This works the same as original Download script that you have to write asset name and press "Load Yahoo Data" then. Try the the code snipet from Download_Y script as I modified a little. Naming of the CSV file didnt work for me in the original script, so I changed it.

Zorro should print something like this:

Download_Y compiling...........
FXCM.dll => FXCM plugin mounted
Login FXCM.. at UTC 06-08 12:10
Downloading TLT..
Parse Historyhistory.csv..
2017-06-07,125.239998,125.519997,124.790001,124.919998,124.919998,11951200
42893.00000000 125.2400 125.5200 124.7900 124.9200 11951200.0000 .
2017-06-06,125.690002,125.870003,125.400002,125.519997,125.519997,12841500
42892.00000000 125.6900 125.8700 125.4000 125.5200 12841500.0000 nTLT 3741 records read from YAHOO



Thank you very much for your reply. I tried your method in my MVO script with a Canadian stocks, I got this,


MVO compiling...........
Parse Historyhistory.csv..
8-Jun-17,155.25,155.54,154.40,154.99,21250798
39447.00000000 155.2500 155.5400 154.4000 21250798.0000 .
7-Jun-17,155.02,155.98,154.48,155.37,21069647
39082.00000000 155.0200 155.9800 154.4800 21069647.0000
AC.TO 4001 records read from YAHOO
284 Bars 2016-03-28..2017-05-11 generated
Test: MVO AC.TO 2016..2017
Assets CATEST666.csv


In my script, I set the StartDate=20160601, no EndDate, but the bars generated here is from 20160328 to 20170511. Also, the price of AC.TO is bit above 17$ but here it's 155.

Any thoughts?

Best

Jeff


Last edited by Jeff1228; 06/09/17 03:17.
Re: Yahoo has changed their protocol [Re: Jeff1228] #466420
06/13/17 12:29
06/13/17 12:29
Joined: Jan 2017
Posts: 64
J
Jeff1228 Offline
Junior Member
Jeff1228  Offline
Junior Member
J

Joined: Jan 2017
Posts: 64
Finally a solution is working, thank you team Zorro

Re: Yahoo has changed their protocol [Re: Jeff1228] #466421
06/13/17 13:12
06/13/17 13:12
Joined: Dec 2016
Posts: 71
F
firecrest Offline
Junior Member
firecrest  Offline
Junior Member
F

Joined: Dec 2016
Posts: 71
Hi Jeff1228,

Would you be able to share the solution? I am trading Z8. Thanks.

Re: Yahoo has changed their protocol [Re: firecrest] #466433
06/14/17 02:28
06/14/17 02:28
Joined: Jan 2017
Posts: 64
J
Jeff1228 Offline
Junior Member
Jeff1228  Offline
Junior Member
J

Joined: Jan 2017
Posts: 64
Zorro releases a new version 1.59, then you use Alphavantage, then you go!

Re: Yahoo has changed their protocol [Re: Jeff1228] #466541
06/20/17 08:30
06/20/17 08:30
Joined: Jul 2016
Posts: 27
K
konorti Offline
Newbie
konorti  Offline
Newbie
K

Joined: Jul 2016
Posts: 27
I downloaded beta version 1.59.4 but I cant download history with it.
It freezes in the message:

Downloading AGG..

Re: Yahoo has changed their protocol [Re: konorti] #466545
06/20/17 12:35
06/20/17 12:35
Joined: Jun 2016
Posts: 30
france
S
stephane97490 Offline
Newbie
stephane97490  Offline
Newbie
S

Joined: Jun 2016
Posts: 30
france
Hi,
Can Zorro team improve a script for downloading data from https://stooq.com/
it canbe useful instead using Yahoo or else ?

Page 5 of 8 1 2 3 4 5 6 7 8

Moderated by  Petra 

Gamestudio download | chip programmers | Zorro platform | shop | Data Protection Policy

oP group Germany GmbH | Birkenstr. 25-27 | 63549 Ronneburg / Germany | info (at) opgroup.de

Powered by UBB.threads™ PHP Forum Software 7.7.1