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?
file
Error message for downloading with JSL
Thanks!
Accepted Solutions
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
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 ) )
);
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.
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
Yes,it can.
Thanks Experts!
I used it according to the instructions, but still no data.
And maybe that's not what I want.Thank you very much!
