Selasa, 30 September 2014

[smf_addin] Digest Number 3194

5 Messages

Digest #3194
1a
Re: Adj Close by rjemery7
1b
Re: Adj Close by "Dan" dan2fl
1c
Re: Adj Close by "Randy Harmelink" rharmelink
2b
Re: Contents of Add-Ins Folder for SMF by "Randy Harmelink" rharmelink

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?

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?

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?
>

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.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar