Minggu, 28 September 2014

[smf_addin] Digest Number 3192

6 Messages

Digest #3192
1b
Re: Historical P/Es of Indices by "Randy Harmelink" rharmelink
2b
Re: Questions on SMFPricesBetween() by "Randy Harmelink" rharmelink
3a
Adj Close by rjemery7
3b
Re: Adj Close by "Randy Harmelink" rharmelink

Messages

Sat Sep 27, 2014 3:43 pm (PDT) . Posted by:

rjemery7

How might a retrieve historical P/Es for the major indices:

Dow Jones Industrials, Transportation, Utility
S&P 100, 500, MidCap 400, Small Cap 600
Nasdaq 100, Composite
NYSE Composite
Russell 1000, 2000, 3000
etc?

I would like to go back at least 20 years on a weekly basis.


Sat Sep 27, 2014 4:51 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

No idea. Try some Google searches. There may be a site that carries them.
Especially for the DJIA and the S&P 500. Maybe the federal reserve data
area? But I doubt you'll find anything on a weekly basis.

On Sat, Sep 27, 2014 at 3:43 PM, rjemery@... wrote:

>
> How might a retrieve historical P/Es for the major indices:
>
> Dow Jones Industrials, Transportation, Utility
> S&P 100, 500, MidCap 400, Small Cap 600
> Nasdaq 100, Composite
> NYSE Composite
> Russell 1000, 2000, 3000
> etc?
>
> I would like to go back at least 20 years on a weekly basis.
>

Sat Sep 27, 2014 3:48 pm (PDT) . Posted by:

rjemery7

Given the following function call (which works):

=SMFPricesBetween(A2,TODAY()-366,TODAY(),"0605040309")

1) What happens if either or both of the two date parameters falls on a day -- weekend or holiday -- when there was no trading?

2) The last field parameter of "09" reports the volume. What volume is this? The sum total of all shares traded between the two dates?

Example: For FLWS, the volume (09) is reported as 50,586,400, while using RCHGetYahooQuotes(), the volume (V) is reported as 289,543 while the Average Volume (A2) is reported as 137,644. Data is as of Saturday, 9/27/2014.


Sat Sep 27, 2014 5:02 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

On Sat, Sep 27, 2014 at 3:48 PM, rjemery@... wrote:

>
> Given the following function call (which works):
>
> =SMFPricesBetween(A2,TODAY()-366,TODAY(),"0605040309")
>
> 1) What happens if either or both of the two date parameters falls on a
> day -- weekend or holiday -- when there was no trading?
>

-- If the market is closed on the starting date, it will use the next
trading date as your starting date.

-- If the market is closed on the ending date, it will use the previous
trading date as the ending date.

2) The last field parameter of "09" reports the volume. What volume is
> this? The sum total of all shares traded between the two dates?
>

Yes, with an inclusive between.

Example: For FLWS, the volume (09) is reported as 50,586,400, while using
> RCHGetYahooQuotes(), the volume (V) is reported as 289,543 while the
> Average Volume (A2) is reported as 137,644. Data is as of Saturday,
> 9/27/2014.
>

I just retrieved data for FLWS using RCHGetYahooQuotes(). My sum of all the
volume for the designated dates i 50,586,400, as you see reported.

Historical quotes says the volume yesterday was 298,500.

Sun Sep 28, 2014 12:27 am (PDT) . Posted by:

rjemery7

How do I obtain the Adjusted Close for any given date or range of dates?


Sun Sep 28, 2014 12:30 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Use the RCHGetYahooHistory() function.

For a number of dates that aren't consecutive, look at the
smfPricesByDates() function.

On Sun, Sep 28, 2014 at 12:27 AM, rjemery@... wrote:

>
> How do I obtain the Adjusted Close for any given date or range of dates?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar