Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
lwx228
Level VII

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

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.

 

2020-03-02_16-01.png
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

  • 2020-03-02_16-00.png

 

Thanks!

 

5 REPLIES 5
Highlighted
txnelson
Super User

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

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

internet.PNG

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 ) )
);
Jim
Highlighted
lwx228
Level VII

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

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.

 

2020-03-02_17-19.png

Highlighted
lwx228
Level VII

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

How can download this CSV file directly from JSL?

Thanks!
Highlighted
louv
Staff (Retired)

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

Have you seen this add-in? Yahoo Finance Fetcher 

 

 

 

Highlighted
lwx228
Level VII

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

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

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

 

2020-03-02_21-47.png

Article Labels

    There are no labels assigned to this post.