6 Messages
Digest #3192
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.
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.
>
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.
=SMFPricesBetween(
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(
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.
>
> Given the following function call (which works):
>
> =SMFPricesBetween(
>
> 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(
> Average Volume (A2) is reported as 137,644. Data is as of Saturday,
> 9/27/2014.
>
I just retrieved data for FLWS using RCHGetYahooQuotes(
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 a number of dates that aren't consecutive, look at the
smfPricesByDates(
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