5 Messages
Digest #3194
Messages
Mon Sep 29, 2014 8:38 am (PDT) . Posted by:
rjemery7
Randy,
They did up until a week ago, because I was able to capture it. Then sometime during this past Saturday (9/27/2014), the info went dark. As of Monday morning (9/29/2014), it still isn't obtainable.
Google does provide almost the same information; Google adds volume but not adjusted close. Also, the data, only 30 rows at a time, is not provided with an export-to-Excel link.
How might I obtain in bulk all the historical data for SP400 (Google's symbol) from Google's Finance website?
Also, how might I augment that data with the adjusted close?
They did up until a week ago, because I was able to capture it. Then sometime during this past Saturday (9/27/2014), the info went dark. As of Monday morning (9/29/2014), it still isn't obtainable.
Google does provide almost the same information; Google adds volume but not adjusted close. Also, the data, only 30 rows at a time, is not provided with an export-to-Excel link.
How might I obtain in bulk all the historical data for SP400 (Google'
Also, how might I augment that data with the adjusted close?
Mon Sep 29, 2014 12:08 pm (PDT) . Posted by:
"Dan" dan2fl
R.J.,
I have several suggestions for you.
The easiest is to use IJH, an ETF that tracks the S&P400 and has historic data on Yahoo going back to May 26, 2000.
Second, if this is not suitable, why not get in touch with Yahoo with your request about historic data on ^SP400.
Dan
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, September 29, 2014 11:38 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Adj Close
Randy,
They did up until a week ago, because I was able to capture it. Then sometime during this past Saturday (9/27/2014), the info went dark. As of Monday morning (9/29/2014), it still isn't obtainable.
Google does provide almost the same information; Google adds volume but not adjusted close. Also, the data, only 30 rows at a time, is not provided with an export-to-Excel link.
How might I obtain in bulk all the historical data for SP400 (Google's symbol) from Google's Finance website?
Also, how might I augment that data with the adjusted close?
I have several suggestions for you.
The easiest is to use IJH, an ETF that tracks the S&P400 and has historic data on Yahoo going back to May 26, 2000.
Second, if this is not suitable, why not get in touch with Yahoo with your request about historic data on ^SP400.
Dan
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, September 29, 2014 11:38 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Adj Close
Randy,
They did up until a week ago, because I was able to capture it. Then sometime during this past Saturday (9/27/2014), the info went dark. As of Monday morning (9/29/2014), it still isn't obtainable.
Google does provide almost the same information; Google adds volume but not adjusted close. Also, the data, only 30 rows at a time, is not provided with an export-to-Excel link.
How might I obtain in bulk all the historical data for SP400 (Google'
Also, how might I augment that data with the adjusted close?
Mon Sep 29, 2014 12:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
To grab the data from Google, you'd need to scrape it page by page. There's
an example in the FILES area of the Yahoo group:
smfGetTagContent-DJIA-Quotes-From-Google.xls
To adjust it, you'd need to pick up the history of split and dividends from
another source and apply them. However, most indexes aren't adjusted for
dividends, are they? It's one reason I use the ETFs for index total
returns, at least for their available history. Did you ever notice a
difference between close and adjusted close on ^SP400?
As Dan suggest, your best bet may be to point out to Yahoo that the data
isn't there. Use the "Send Feedback" link at the bottom of the web page. Or
the "Report an Issue" link near the top of the web page.
On Mon, Sep 29, 2014 at 8:38 AM, rjemery@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> They did up until a week ago, because I was able to capture it. Then
> sometime during this past Saturday (9/27/2014), the info went dark. As of
> Monday morning (9/29/2014), it still isn't obtainable.
>
> Google does provide almost the same information; Google adds volume but
> not adjusted close. Also, the data, only 30 rows at a time, is not
> provided with an export-to-Excel link.
>
> How might I obtain in bulk all the historical data for SP400 (Google's
> symbol) from Google's Finance website?
>
> Also, how might I augment that data with the adjusted close?
>
an example in the FILES area of the Yahoo group:
smfGetTagContent-DJIA-Quotes-From-Google.xls
To adjust it, you'd need to pick up the history of split and dividends from
another source and apply them. However, most indexes aren't adjusted for
dividends, are they? It's one reason I use the ETFs for index total
returns, at least for their available history. Did you ever notice a
difference between close and adjusted close on ^SP400?
As Dan suggest, your best bet may be to point out to Yahoo that the data
isn't there. Use the "Send Feedback" link at the bottom of the web page. Or
the "Report an Issue" link near the top of the web page.
On Mon, Sep 29, 2014 at 8:38 AM, rjemery@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> They did up until a week ago, because I was able to capture it. Then
> sometime during this past Saturday (9/27/2014), the info went dark. As of
> Monday morning (9/29/2014), it still isn't obtainable.
>
> Google does provide almost the same information; Google adds volume but
> not adjusted close. Also, the data, only 30 rows at a time, is not
> provided with an export-to-Excel link.
>
> How might I obtain in bulk all the historical data for SP400 (Google'
> symbol) from Google's Finance website?
>
> Also, how might I augment that data with the adjusted close?
>
Mon Sep 29, 2014 9:23 am (PDT) . Posted by:
rjemery7
My system runs XP and Excel 2007. In the Add-Ins folder and for SMF, what else should be there besides the *.xla file? I seem to have some extraneous files which I would like to delete if no longer applicable.
Mon Sep 29, 2014 12:13 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The smf-elements-*.txt files contain element definitions and the *.xls file
has documentation on elements. You can remove them if you never plan to use
the RCHGetElementNumber() function. Without those *.txt files, all
RCHGetElementNumber() functions will return "Undefined".
On Mon, Sep 29, 2014 at 9:23 AM, rjemery@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> My system runs XP and Excel 2007. In the Add-Ins folder and for SMF, what
> else should be there besides the *.xla file? I seem to have some
> extraneous files which I would like to delete if no longer applicable.
>
has documentation on elements. You can remove them if you never plan to use
the RCHGetElementNumber() function. Without those *.txt files, all
RCHGetElementNumber() functions will return "Undefined".
On Mon, Sep 29, 2014 at 9:23 AM, rjemery@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> My system runs XP and Excel 2007. In the Add-Ins folder and for SMF, what
> else should be there besides the *.xla file? I seem to have some
> extraneous files which I would like to delete if no longer applicable.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar