Jumat, 27 Juli 2012

[smf_addin] Digest Number 2291

12 New Messages

Digest #2291
2b
Re: Errors when retrieving data for COP by "Randy Harmelink" rharmelink
3a
Problem with the Add In by "dorty5lafin" dorty5lafin
3b
Re: Problem with the Add In by "Randy Harmelink" rharmelink
3c
Re: Problem with the Add In by "Dj Daugherty" dorty5lafin
4a
Re: Problem with ticker COP by "eremon9" eremon9
4b
Re: Problem with ticker COP by "Randy Harmelink" rharmelink
4c
Re: Problem with ticker COP by "eremon9" eremon9
5b
Re: Getting Started with Stockcharts by "Randy Harmelink" rharmelink

Messages

Thu Jul 26, 2012 6:52 am (PDT) . Posted by:

"rr76012" rr76012

Hello,

Does anyone have a any guidence for a simple solution to downloading:

1. 5 YR Low PE
2. 5 YR High PE
3. Current PE
4. Current EPS
5. EPS Growth Rate
6. Forward PE

I want to build a simple forecast to a target future value?

Thank You.

Thu Jul 26, 2012 8:27 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I would use RCHGetYahooQuotes() to get everything other than the historical
P/E values, and AdvFN for those.

The VBA code I have for the Rule #1 valuation is:

Case "Rule #1 MOS Price"
n1 = RCHGetElementNumber(pTicker, 99) ' 5-Year High P/E
n2 = RCHGetElementNumber(pTicker, 102) ' 5-Year Low P/E
n3 = RCHGetElementNumber(pTicker, 44) ' Current EPS
n4 = RCHGetElementNumber(pTicker, 442) ' 5-Year Projected
Growth Rate
If n1 > 50 Then n1 = 50
n5 = FV(n4, 10, 0, -n3)
n6 = PV(0.15, 10, 0, -n5 * (n1 + n2) / 2) / 2

However, I think the 5-year high and low P/E from MSN have a lot of "N/A"
values.

On Thu, Jul 26, 2012 at 6:52 AM, rr76012 <rr76012@yahoo.com> wrote:

>
> Does anyone have a any guidence for a simple solution to downloading:
>
> 1. 5 YR Low PE
> 2. 5 YR High PE
> 3. Current PE
> 4. Current EPS
> 5. EPS Growth Rate
> 6. Forward PE
>
> I want to build a simple forecast to a target future value?
>

Thu Jul 26, 2012 6:54 am (PDT) . Posted by:

"eremon9" eremon9

Hi,

I have a spreadsheet that successfully retrieves a variety data elements for a number of companies. However, data associated with element numbers in the 600 - 1000 range return error values for COP (Conoco Phillips). I haven't been able to find anything to indicate that there's a problem with the COP ticker symbol. Any help would be appreciated.

Tom

Thu Jul 26, 2012 8:31 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

That range isn't really useful, since those element numbers come from a
number of different sources.

However, elements 600 and 700 both come from Yahoo Analyst Estimates page
and are working fine for me for ticker symbol COP.

What do you get for:

=RCHGetElementNumber("Version")
=RCHGetElementNumber("MMM",600)
=RCHGetElementNumber("COP",600)
=smfGetAParms(600)

On Thu, Jul 26, 2012 at 6:54 AM, eremon9 <tamurphy@cableone.net> wrote:

>
> I have a spreadsheet that successfully retrieves a variety data elements
> for a number of companies. However, data associated with element numbers in
> the 600 - 1000 range return error values for COP (Conoco Phillips). I
> haven't been able to find anything to indicate that there's a problem with
> the COP ticker symbol. Any help would be appreciated.
>

Thu Jul 26, 2012 8:32 am (PDT) . Posted by:

"dorty5lafin" dorty5lafin

Hi I am new to the add on and I can not get it to work correctly. I am selecting all cells and the entering in the formula =RCHGetYahooHistory("MSFT") then pressing ctrl,shift,enter. When I do this i get an error message "Excel cannot complete this task with available resources. Choose less data or close other applications". I do not have any other applications running. Can you help on this problem please.

Thu Jul 26, 2012 8:35 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sounds like you are exceeding an EXCEL limitation.

How big a range are you selecting? Which version of EXCEL? Can you do it
with a small range, say 3 rows by 7 columns?

On Thu, Jul 26, 2012 at 8:27 AM, dorty5lafin <dorty22@gmail.com> wrote:

> Hi I am new to the add on and I can not get it to work correctly. I am
> selecting all cells and the entering in the formula
> =RCHGetYahooHistory("MSFT") then pressing ctrl,shift,enter. When I do this
> i get an error message "Excel cannot complete this task with available
> resources. Choose less data or close other applications". I do not have
> any other applications running. Can you help on this problem please.
>

Thu Jul 26, 2012 8:51 am (PDT) . Posted by:

"Dj Daugherty" dorty5lafin

That was it. Thanks

Sent from my iPhone

On Jul 26, 2012, at 11:35 AM, Randy Harmelink <rharmelink@gmail.com> wrote:

>
>
> Sounds like you are exceeding an EXCEL limitation.
>
> How big a range are you selecting? Which version of EXCEL? Can you do it with a small range, say 3 rows by 7 columns?
>
> On Thu, Jul 26, 2012 at 8:27 AM, dorty5lafin <dorty22@gmail.com> wrote:
> Hi I am new to the add on and I can not get it to work correctly. I am selecting all cells and the entering in the formula =RCHGetYahooHistory("MSFT") then pressing ctrl,shift,enter. When I do this i get an error message "Excel cannot complete this task with available resources. Choose less data or close other applications". I do not have any other applications running. Can you help on this problem please.
>
>
>
>

Thu Jul 26, 2012 8:57 am (PDT) . Posted by:

"eremon9" eremon9

Sorry, but the reply button doesn't seem to be working properly for me. So here's a continuation of the previous thread on this subject...

=RCHGetElementNumber("Version")
returns: Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\Program Files\SMF add-in; 1)

=RCHGetElementNumber("MMM",600) returns: 6.37

=RCHGetElementNumber("COP",600) returns: Error

=smfGetAParms(600)
returns: YahooAE;Earnings Estimates -- Year Ago EPS -- FY2;http://finance.yahoo.com/q/ae?s=~~~~~;4;EARNINGS EST;YEAR AGO EPS; ; ;0;0;0;0

For COP I'm getting Error on 957, 969, 4929, 617, 977, 978, 979, 981.
I'm also getting a #Value on 965. All of these are returning what look like legitimate values for about 35 other companies.

Tom

Thu Jul 26, 2012 9:02 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I can't see any reason why COP shouldn't be working. It could be you got a
"time out" or had some other problem retrieving the web page. Does it get
corrected if you use the smfForceRecalculation macro (see LINKS area of
group for more info on the macro)?

On Thu, Jul 26, 2012 at 8:57 AM, eremon9 <tamurphy@cableone.net> wrote:

> Sorry, but the reply button doesn't seem to be working properly for me. So
> here's a continuation of the previous thread on this subject...
>
> =RCHGetElementNumber("Version")
> returns: Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\Program
> Files\SMF add-in; 1)
>
> =RCHGetElementNumber("MMM",600) returns: 6.37
>
> =RCHGetElementNumber("COP",600) returns: Error
>
> =smfGetAParms(600)
> returns: YahooAE;Earnings Estimates -- Year Ago EPS -- FY2;
> http://finance.yahoo.com/q/ae?s=~~~~~;4;EARNINGS EST;YEAR AGO EPS; ;
> ;0;0;0;0
>
> For COP I'm getting Error on 957, 969, 4929, 617, 977, 978, 979, 981.
> I'm also getting a #Value on 965. All of these are returning what look
> like legitimate values for about 35 other companies.
>

Thu Jul 26, 2012 9:17 am (PDT) . Posted by:

"eremon9" eremon9

Thanks. That did the trick. I'll remember to do that in the future before asking questions.

Tom

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I can't see any reason why COP shouldn't be working. It could be you got a
> "time out" or had some other problem retrieving the web page. Does it get
> corrected if you use the smfForceRecalculation macro (see LINKS area of
> group for more info on the macro)?
>
> On Thu, Jul 26, 2012 at 8:57 AM, eremon9 <tamurphy@...> wrote:
>
> > Sorry, but the reply button doesn't seem to be working properly for me. So
> > here's a continuation of the previous thread on this subject...
> >
> > =RCHGetElementNumber("Version")
> > returns: Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\Program
> > Files\SMF add-in; 1)
> >
> > =RCHGetElementNumber("MMM",600) returns: 6.37
> >
> > =RCHGetElementNumber("COP",600) returns: Error
> >
> > =smfGetAParms(600)
> > returns: YahooAE;Earnings Estimates -- Year Ago EPS -- FY2;
> > http://finance.yahoo.com/q/ae?s=~~~~~;4;EARNINGS EST;YEAR AGO EPS; ;
> > ;0;0;0;0
> >
> > For COP I'm getting Error on 957, 969, 4929, 617, 977, 978, 979, 981.
> > I'm also getting a #Value on 965. All of these are returning what look
> > like legitimate values for about 35 other companies.
> >
>

Thu Jul 26, 2012 3:24 pm (PDT) . Posted by:

"dice962" dice962



Hi Randy,

I'd like to see if I could pull Teddi Knight's market direction indicators (for any ticker). I'm looking to pull numbers but not really the graphs themselves:

Momentum
MACD
Ultimate Oscillator
Rate of Change
Slow Stochastic
Fast Stochastic

http://www.fullyinformed.com/market-direction-is-solidly-up-confirmed-by-market-timing-indicators/

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The add-in has been used to pull some things from the text version of the
> P&F charts, but what other things are you looking to extract?

Thu Jul 26, 2012 3:44 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Where are you seeing the numbers you want to extract from StockCharts?

Do you know the settings that Teddi uses for the market indicators?

Barchart has a several pages of various indicators that are easily
extractable:

http://www.barchart.com/technicals/stocks/MMM
http://www.barchart.com/opinions/stocks/MMM

On Thu, Jul 26, 2012 at 3:24 PM, dice962 <derekbarrett@gmail.com> wrote:

>
> I'd like to see if I could pull Teddi Knight's market direction indicators
> (for any ticker). I'm looking to pull numbers but not really the graphs
> themselves:
>
> Momentum
> MACD
> Ultimate Oscillator
> Rate of Change
> Slow Stochastic
> Fast Stochastic
>
>
> http://www.fullyinformed.com/market-direction-is-solidly-up-confirmed-by-market-timing-indicators/
>
Diposting oleh EXCEL FEED LEARNING di 04.18

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)