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

[#1]

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=... 

file

https://query1.finance.yahoo.com/v7/finance/download/GE?period1=-252374400&period2=1583107200&interv... 

• Error message for downloading with JSL

• 

Thanks!

[#2]

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 ) )
);

[#3]

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.

[#4]

How can download this CSV file directly from JSL?

Thanks!

[#5 · Accepted solution]

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

[#6]

Yes,it can.

Thanks Experts!

[#7]

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

Thanks Experts!

[#8]

Have you seen this add-in? Yahoo Finance Fetcher 

[#9]

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

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