topic Re: How to use jsl to download yahoo's U.S. stock quotes. in Discussions

How to use jsl to download yahoo's U.S. stock quotes.

lwx228 — Mon, 02 Mar 2020 08:14:37 GMT

A browser allows can to browse and download stock quotes from yahoo's websites, and directly download data files in CSV format.
But directly copy the link of this file, and then use JMP download software to download the prompt to log in.

How do I download these stock data files in bulk with JSL?

https://finance.yahoo.com/quote/GE/history?period1=-252374400&period2=1583107200&interval=1d&filter=history&frequency=1d

file

https://query1.finance.yahoo.com/v7/finance/download/GE?period1=-252374400&period2=1583107200&interval=1d&events=history&crumb=nAEMY74aBER

Error message for downloading with JSL

Thanks!

Re: How to use jsl to download yahoo's U.S. stock quotes.

txnelson — Mon, 02 Mar 2020 09:11:05 GMT

You can directly access Yahoo's website data by going to:

File=>Internet Open=>Web Page

The data table it downloads has a "Source" entry which provides one with the JSL that can be used to directly open the table from JSL

So here is the script that directly opens the Yahoo table

names default to here(1);
Open(
	"https://finance.yahoo.com/quote/GE/history?period1=-252374400&period2=1583107200&interval=1d&filter=history&frequency=1d",
	HTML Table( 1, Column Names( 1 ), Data Starts( 2 ) )
);

Re: How to use jsl to download yahoo's U.S. stock quotes.

lwx228 — Mon, 02 Mar 2020 09:25:25 GMT

Thank Jim!

But why only 100 rows of data can be downloaded with jim's JSL?I can get all the dates by downloading the file.
The range of dates compared to the link is the same.

Re: How to use jsl to download yahoo's U.S. stock quotes.

lwx228 — Mon, 02 Mar 2020 09:27:26 GMT

How can download this CSV file directly from JSL?

Thanks!

Re: How to use jsl to download yahoo's U.S. stock quotes.

louv — Mon, 02 Mar 2020 14:11:04 GMT

Have you seen this add-in?

Re: How to use jsl to download yahoo's U.S. stock quotes.

lwx228 — Mon, 02 Mar 2020 13:53:05 GMT

I used it according to the instructions, but still no data.

And maybe that's not what I want.Thank you very much!

Re: How to use jsl to download yahoo's U.S. stock quotes.

ron_horne — Sun, 07 Nov 2021 00:14:37 GMT

Hi @lwx228

can you try the following script:

Open ("https://query1.finance.yahoo.com/v7/finance/download/GE?period1=-252374400&period2=1636243200&interval=1d&events=history&includeAdjustedClose=true");

you can get the link by first setting the table in on the webpage and click apply.

then, right click on download and copy the link location. this is actually a link to a CSV file that opens correctly with just the open command and no other specifications required.

please let me know if it works for you.

ron

Re: How to use jsl to download yahoo's U.S. stock quotes.

lwx228 — Sun, 07 Nov 2021 02:40:54 GMT

Yes,it can.

Thanks Experts!

Re: How to use jsl to download yahoo's U.S. stock quotes.

lwx228 — Sun, 07 Nov 2021 03:09:53 GMT

How can download this file to "D:\ ge.jmp"?
Don't have to open it.

Thanks Experts!