4 Messages
Digest #4161
Messages
Sun Oct 1, 2017 5:21 pm (PDT) . Posted by:
lewglenn
Does anyone know how to download historical data directly from the Yahoo Finance site? It used to be the case that when you input the time period of interest Yahoo would download all the data to a csv file. Now, for example, when I input the max period for SPY (Jan 29, 1993 to present) all I get is a csv file with data from 9/5/2017 to 9/29/2017.
Sun Oct 1, 2017 6:20 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmm? Works fine for me.
1. I got to https://finance.yahoo.com/quote/SPY/history
2. I click on the time period, "Max", and "Done"
3. I click on "Apply", to apply those dates
4. I click on "Download Date" and get a CSV file back to 1/29/93
I suspect you are missing step #3?
On Sun, Oct 1, 2017 at 5:21 PM, lewglenn@
...
wrote:
>
> Does anyone know how to download historical data directly from the Yahoo
> Finance site? It used to be the case that when you input the time period of
> interest Yahoo would download all the data to a csv file. Now, for example,
> when I input the max period for SPY (Jan 29, 1993 to present) all I get is
> a csv file with data from 9/5/2017 to 9/29/2017.
>
1. I got to https://finance.yahoo.com/quote/SPY/history
2. I click on the time period, "Max"
3. I click on "Apply"
4. I click on "Download Date" and get a CSV file back to 1/29/93
I suspect you are missing step #3?
On Sun, Oct 1, 2017 at 5:21 PM, lewglenn@
...
wrote:
>
> Does anyone know how to download historical data directly from the Yahoo
> Finance site? It used to be the case that when you input the time period of
> interest Yahoo would download all the data to a csv file. Now, for example,
> when I input the max period for SPY (Jan 29, 1993 to present) all I get is
> a csv file with data from 9/5/2017 to 9/29/2017.
>
Sun Oct 1, 2017 5:41 pm (PDT) . Posted by:
lewglenn
When I use the vba code:
Range("C1:D20000") = smfGetYahooHistory("SPY", StartDate, EndDate, "d", "dc", , 1, 20000, 2)
to get adjusted closing prices for SPY, with StartDate of 7/30/2002 and EndDate of 9/29/2017 I get what appear to be unadjusted closing prices (when I compare the results to those I get by downloading the data directly to a csv file from the Yahoo Finance site). Am I using an outdated version of the RCH_Stock_Market_Functions.xla file? Or am I using the wrong parameters to get adjusted close results?
Range("
to get adjusted closing prices for SPY, with StartDate of 7/30/2002 and EndDate of 9/29/2017 I get what appear to be unadjusted closing prices (when I compare the results to those I get by downloading the data directly to a csv file from the Yahoo Finance site). Am I using an outdated version of the RCH_Stock_Market_
Sun Oct 1, 2017 6:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Again, working fine here (without specifying a start or end date). What
version of the add-in are you using?
The last change was on 2017.07.12 and involved the swapping of close and
unadjusted close, since Yahoo changed their meaning in the JSON code (it
used to be close and unadjusted close and they changed it to be close and
adjusted close).
On Sun, Oct 1, 2017 at 5:41 PM, lewglenn@
...
wrote:
>
> When I use the vba code:
>
>
> Range("C1:D20000") = smfGetYahooHistory("SPY", StartDate, EndDate, "d",
> "dc", , 1, 20000, 2)
>
> to get adjusted closing prices for SPY, with StartDate of 7/30/2002 and
> EndDate of 9/29/2017 I get what appear to be unadjusted closing prices
> (when I compare the results to those I get by downloading the data directly
> to a csv file from the Yahoo Finance site). Am I using an outdated version
> of the RCH_Stock_Market_Functions.xla file? Or am I using the wrong
> parameters to get adjusted close results?
>
version of the add-in are you using?
The last change was on 2017.07.12 and involved the swapping of close and
unadjusted close, since Yahoo changed their meaning in the JSON code (it
used to be close and unadjusted close and they changed it to be close and
adjusted close).
On Sun, Oct 1, 2017 at 5:41 PM, lewglenn@
...
wrote:
>
> When I use the vba code:
>
>
> Range("
> "dc"
>
> to get adjusted closing prices for SPY, with StartDate of 7/30/2002 and
> EndDate of 9/29/2017 I get what appear to be unadjusted closing prices
> (when I compare the results to those I get by downloading the data directly
> to a csv file from the Yahoo Finance site). Am I using an outdated version
> of the RCH_Stock_Market_
> parameters to get adjusted close results?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar