Devon,
the gethttp addon works for me - it uses curl:

load 'web/gethttp'

2 {. (<;._2) ,&LF gethttp '
https://query1.finance.yahoo.com/v7/finance/download/TSLA?period1=1277769600&period2=1609718400&interval=1d&events=history&includeAdjustedClose=true
'

┌─────────────────────────────────────────┬────────────────────────────────────────────────────────────────┐

│Date,Open,High,Low,Close,Adj
Close,Volume│2010-06-29,3.800000,5.000000,3.508000,4.778000,4.778000,93831500│

└─────────────────────────────────────────┴────────────────────────────────────────────────────────────────┘


Ciao. Stefan.

On Tue, Jan 5, 2021 at 2:26 PM 'Mike Day' via Programming <
programm...@jsoftware.com> wrote:

> I thought Yahoo had stopped supporting stock exchange queries a year or so
> ago;
> at least,  my old gethtml (?) calls from J stopped working for me.
>
> Tom McGuire and Gilles Kirouac commented helpfully at the time,  Nov 26,
> 2019.
>
> I eventually resorted to “Google sheets” and clunky copy n paste, as J
> sessions tended to crash with my attempted get-arounds.
>
> Cheers,
>
> Mike
>
> Sent from my iPad
>
> > On 5 Jan 2021, at 05:37, Devon McCormick <devon...@gmail.com> wrote:
> >
> > This is not really a J question, but has anyone successfully figured out
> > how to download something using https protocol?  It's actually more
> > complicated than this.  If I want to get, say, the price and volume
> history
> > for Tesla from Yahoo Finance, the "Download" command there generates a
> > string like this:
> >
> https://query1.finance.yahoo.com/v7/finance/download/TSLA?period1=1277769600&period2=1609718400&interval=1d&events=history&includeAdjustedClose=true
> >
> > I used to be able to take this string and substitute into it to download
> > not only prices for TSLA but any other stock on Yahoo Finance for which I
> > knew the ticker.  Now this sort of thing fails when I use my former
> method
> > which was just invoking "wget" via the "shell" command in J.  Instead I
> get
> > an 800+ byte html file with error messages.  I think the switch to https
> > from http is to blame but having a query string instead of a filename may
> > also be an issue.
> >
> > The "wget" method still works for http files like this (to get the famous
> > iris data): shell 'wget -O iris.data
> > http://archive.ics.uci.edu/ml/machine-learning-databases/iris/iris.data
> '.
> > So, I suspect it's probably https that is to blame but I do not have a
> > working example of submitting a query string using http so I cannot be
> > completely sure other than I think this used to work.
> >
> > Any suggestions for an automatable way to do this would be welcome.
> >
> > Thanks,
> >
> > Devon
> > --
> >
> > Devon McCormick, CFA
> >
> > Quantitative Consultant
> > ----------------------------------------------------------------------
> > For information about J forums see http://www.jsoftware.com/forums.htm
> ----------------------------------------------------------------------
> For information about J forums see http://www.jsoftware.com/forums.htm
>
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm

Reply via email to