Sabtu, 30 Agustus 2014

[smf_addin] Digest Number 3164[1 Attachment]

12 Messages

Digest #3164

Messages

Fri Aug 29, 2014 6:07 am (PDT) . Posted by:

rogacox

Thanks for your help, Randy. This procedure does run the macro (after I remove the highlighted area). Strange that this macro worked with the highlighted area prior to my reinstallation - and still does on my other computer. DId you notice if the macro ran on your without removing the highlighted area selected?

All the best and thanks for a wonderful tool that you have been sharing with the world.

Roger

Fri Aug 29, 2014 6:14 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I got the error if I left your highlighting on, but it worked fine when I
took it off.

You may have a different version of the add-in on your other computer. The
ability to highlight a range was added on 2014-05-01, so you'd need a
version released after that date to have the functionality.

Are you sure the "reinstallation" wasn't done with a later version of the
add-in than what you had originally?

On Fri, Aug 29, 2014 at 6:05 AM, rogacox@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks for your help, Randy. This procedure does run the macro (after I
> remove the highlighted area). Strange that this macro worked with the
> highlighted area prior to my reinstallation - and still does on my other
> computer. DId you notice if the macro ran on your without removing the
> highlighted area selected?
>
> All the best and thanks for a wonderful tool that you have been sharing
> with the world.
>

Fri Aug 29, 2014 6:17 am (PDT) . Posted by:

rogacox

Hi Randy. An interesting note on the selected area. I back tested using the 1-30-2014 version of the smf addin and it worked. Something must have changed in the 5-25-2014 version.

Fri Aug 29, 2014 6:21 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yup. The highlighting capability was added on 2014-05-01, so it wouldn't
have been in the 2014-01-30 version.

On Fri, Aug 29, 2014 at 6:17 AM, rogacox@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hi Randy. An interesting note on the selected area. I back tested using
> the 1-30-2014 version of the smf addin and it worked. Something must have
> changed in the 5-25-2014 version.
>

Fri Aug 29, 2014 6:23 am (PDT) . Posted by:

rr76012

Hello Randy,


I love these 3 spreadsheets, very useful.


Question on the spreadsheet, http://ogres-crypt.com/SMF/Templates/SMF-Template-Morningstar-Stock-Data.xls http://ogres-crypt.com/SMF/Templates/SMF-Template-Morningstar-Stock-Data.xls.


On the Morningstar website, stock, valuation tab, there is a column to the right, that list the 5 year average pe ratio.


Here is the link:


http://financials.morningstar.com/valuation/price-ratio.html?t=WMT®ion=usa&culture=en-US



Current Valuation

WMT

WMT Industry Avg S&P 500 WMT 5Y Avg* Data as of 08/28/2014, *Price/Cash Flow uses 3-year average. Price/Earnings 15.8 17.7 18.2 14.3 Price/Book 3.3 3.5 2.6 3.1 Price/Sales 0.5 0.5 1.7 0.5 Price/Cash Flow 10.2 11.0 11.1 9.5 Dividend Yield % 2.5 2.1 2.3 2.3 Price/Fair Value http://analysis.morningstar.com/analystreport/ar.aspx?t=WMT&culture=usa http://analysis.morningstar.com/analystreport/ar.aspx?t=WMT&culture=usa
— — —









Do you know what the rchgetelemntnumber for the Morningstar 5 year average pe ratio on the Morningstar valuation tab? I would like to use it to do a quick equation, fv eps x avg pe = fv.


Thanks,
rr76012

Fri Aug 29, 2014 6:37 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The current valuation web page on MorningStar hasn't been converted to
element numbers yet. Let me see if I have some time later today. It
shouldn't take long.

On Fri, Aug 29, 2014 at 6:23 AM, rr76012@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Hello Randy,
>
>
> I love these 3 spreadsheets, very useful.
>
>
> Question on the spreadsheet,
> http://ogres-crypt.com/SMF/Templates/SMF-Template-Morningstar-Stock-Data.xls
> .
>
>
> On the Morningstar website, stock, valuation tab, there is a column to the
> right, that list the 5 year average pe ratio.
>
>
> Here is the link:
>
>
>
> http://financials.morningstar.com/valuation/price-ratio.html?t=WMT®ion=usa&culture=en-US
>
>
>
> Current Valuation
>
>
> WMT
>
>
> WMTIndustry AvgS&P 500WMT 5Y Avg*Data as of 08/28/2014, *Price/Cash Flow
> uses 3-year average.Price/Earnings15.817.718.214.3Price/Book3.33.52.63.1
> Price/Sales0.50.51.70.5Price/Cash Flow10.211.011.19.5Dividend Yield %2.5
> 2.12.32.3 Price/Fair Value
> http://analysis.morningstar.com/analystreport/ar.aspx?t=WMT&culture=usa
>
>
> ———
>
>
>
>
>
> Do you know what the rchgetelemntnumber for the Morningstar 5 year average
> pe ratio on the Morningstar valuation tab? I would like to use it to do a
> quick equation, fv eps x avg pe = fv.
>
>
> Thanks,
>
> rr76012
>

Fri Aug 29, 2014 11:14 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

OK. Elements have been added. The new smf-elements-4.txt file is in the
"Works in Progress" folder on the website.

# Usage Source Element Template or Notes Updated 14471 S MorningstarCV2 As
Of Date SMF-Template-Morningstar-Stock-Data.xls 2014-08-29 14472 S
MorningstarCV2 Price/Earnings - Stock
SMF-Template-Morningstar-Stock-Data.xls 2014-08-29 14473 S
MorningstarCV2 Price/Earnings
- Industry Average SMF-Template-Morningstar-Stock-Data.xls 2014-08-29 14474
S MorningstarCV2 Price/Earnings - S&P 500
SMF-Template-Morningstar-Stock-Data.xls 2014-08-29 14475 S
MorningstarCV2 Price/Earnings
- Stock 5-Year Average SMF-Template-Morningstar-Stock-Data.xls 2014-08-29
14476 S MorningstarCV2 Price/Book - Stock
SMF-Template-Morningstar-Stock-Data.xls 2014-08-29 14477 S
MorningstarCV2 Price/Book
- Industry Average SMF-Template-Morningstar-Stock-Data.xls 2014-08-29 14478
S MorningstarCV2 Price/Book - S&P 500
SMF-Template-Morningstar-Stock-Data.xls 2014-08-29 14479 S
MorningstarCV2 Price/Book
- Stock 5-Year Average SMF-Template-Morningstar-Stock-Data.xls 2014-08-29
14480 S MorningstarCV2 Price/Sales - Stock
SMF-Template-Morningstar-Stock-Data.xls 2014-08-29 14481 S
MorningstarCV2 Price/Sales
- Industry Average SMF-Template-Morningstar-Stock-Data.xls 2014-08-29 14482
S MorningstarCV2 Price/Sales - S&P 500
SMF-Template-Morningstar-Stock-Data.xls 2014-08-29 14483 S
MorningstarCV2 Price/Sales
- Stock 5-Year Average SMF-Template-Morningstar-Stock-Data.xls 2014-08-29
14484 S MorningstarCV2 Price/Cash Flow - Stock
SMF-Template-Morningstar-Stock-Data.xls 2014-08-29 14485 S
MorningstarCV2 Price/Cash
Flow - Industry Average SMF-Template-Morningstar-Stock-Data.xls 2014-08-29
14486 S MorningstarCV2 Price/Cash Flow - S&P 500
SMF-Template-Morningstar-Stock-Data.xls 2014-08-29 14487 S
MorningstarCV2 Price/Cash
Flow - Stock 5-Year Average SMF-Template-Morningstar-Stock-Data.xls
2014-08-29 14488 S MorningstarCV2 Dividend Yield % - Stock
SMF-Template-Morningstar-Stock-Data.xls 2014-08-29 14489 S
MorningstarCV2 Dividend
Yield % - Industry Average SMF-Template-Morningstar-Stock-Data.xls
2014-08-29 14490 S MorningstarCV2 Dividend Yield % - S&P 500
SMF-Template-Morningstar-Stock-Data.xls 2014-08-29 14491 S
MorningstarCV2 Dividend
Yield % - Stock 5-Year Average SMF-Template-Morningstar-Stock-Data.xls
2014-08-29 14492 S MorningstarCV2 Price/Fair Value
SMF-Template-Morningstar-Stock-Data.xls 2014-08-29

On Fri, Aug 29, 2014 at 6:23 AM, rr76012@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Hello Randy,
>
>
> I love these 3 spreadsheets, very useful.
>
>
> Question on the spreadsheet,
> http://ogres-crypt.com/SMF/Templates/SMF-Template-Morningstar-Stock-Data.xls
> .
>
>
> On the Morningstar website, stock, valuation tab, there is a column to the
> right, that list the 5 year average pe ratio.
>
>
> Here is the link:
>
>
>
> http://financials.morningstar.com/valuation/price-ratio.html?t=WMT®ion=usa&culture=en-US
>
>
>
> Current Valuation
>
>
> WMT
>
>
> WMTIndustry AvgS&P 500WMT 5Y Avg*Data as of 08/28/2014, *Price/Cash Flow
> uses 3-year average.Price/Earnings15.817.718.214.3Price/Book3.33.52.63.1
> Price/Sales0.50.51.70.5Price/Cash Flow10.211.011.19.5Dividend Yield %2.5
> 2.12.32.3 Price/Fair Value
> http://analysis.morningstar.com/analystreport/ar.aspx?t=WMT&culture=usa
>
>
> ———
>
>
>
>
>
> Do you know what the rchgetelemntnumber for the Morningstar 5 year average
> pe ratio on the Morningstar valuation tab? I would like to use it to do a
> quick equation, fv eps x avg pe = fv.
>
>

Fri Aug 29, 2014 11:21 am (PDT) . Posted by:

rr76012

Randy, I am not a very sophisticated stock buyer. I have read several books on buy and hold eg..Buffett.


The one thing that seems to consistent in all the books is to buy stocks below their 10 or 5 year pe ratio average.


So you can understand why Morningstar valuation tab is important to investors like me, the simple buy and hold strategy buyers.


I do not know how trade stocks, so my strategy is to buy and hold 3 - 5 years then sell, and then buy and hold something else that has potential???


I do not know if this will be smart and effective tactic, but at least I am trying.


As a retiree, my first pick was Exelon EXC utility. It is a disaster, so I am going to try and buy some other dividend stocks, with less risk, stocks below their 5 year pe average??


I hope it works.


Thank you. Have a great day, great weekend.


rr76012

Fri Aug 29, 2014 1:48 pm (PDT) . Posted by:

"Tom Seim" soar2morrow

Why did you pick EXC in the first place? A summary score of analysts put it as bearish, and the long term trend line is down. Buying and holding a loser is exactly that: a loser. Find something, anything, better. I think you may be better off in a mutual fund such as OAKLX, FLCSX, or FVDFX.

To: smf_addin@yahoogroups.com
From: smf_addin@yahoogroups.com
Date: Fri, 29 Aug 2014 11:21:01 -0700
Subject: [smf_addin] Re: MSN Earnings Growth Rates

Randy, I am not a very sophisticated stock buyer. I have read several books on buy and hold eg..Buffett.

The one thing that seems to consistent in all the books is to buy stocks below their 10 or 5 year pe ratio average.

So you can understand why Morningstar valuation tab is important to investors like me, the simple buy and hold strategy buyers.

I do not know how trade stocks, so my strategy is to buy and hold 3 - 5 years then sell, and then buy and hold something else that has potential???

I do not know if this will be smart and effective tactic, but at least I am trying.

As a retiree, my first pick was Exelon EXC utility. It is a disaster, so I am going to try and buy some other dividend stocks, with less risk, stocks below their 5 year pe average??

I hope it works.

Thank you. Have a great day, great weekend.

rr76012

Fri Aug 29, 2014 11:05 am (PDT) . Posted by:

cgrauballe


Hi


I am building a stock sheet, which takes the data from different pages. but the sheet seems to be getting slower and slower. There is quite a bit of data and a few calculations afterwards. does anyone else experience waiting time? and what is normal waiting time?:)


Is it fastest to get data with GetElement, or to get a whole page, for example future valuation, and then rearrange the data myself?:)


Best regards Caspar

Fri Aug 29, 2014 11:23 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The biggest bottleneck is typically the number of Internet accesses you
need to do to get the data. If you need different web pages for each ticker
symbol, and you have a lot of ticker symbols, it's going to take a lot of
time.

It does take longer if you have a large web page and extract a large number
of items from it. But that overhead is typically relatively small compared
to retrieving the web page in the first place.

One issue I've seen in the past is people using the RCHGetYahooQuotes()
function on a cell by cell basis, and making the functions volatile. That
means ALL of them need to do an Internet access every time something
changes in the workbook. The typical solution there is to use an
array-entered RCHGetYahooQuotes() function, so that Yahoo can create a
single CSV file with all the necessary data, in a single Internet access.

If you are using something like RCHGetElementNumber() or RCHGetTableCell()
to get a number of data items off the same web page, it only needs to
retrieve the web page once. The add-in recognizes that they data all come
from that same web page.

On Fri, Aug 29, 2014 at 11:04 AM, cgrauballe@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I am building a stock sheet, which takes the data from different pages.
> but the sheet seems to be getting slower and slower. There is quite a bit
> of data and a few calculations afterwards. does anyone else experience
> waiting time? and what is normal waiting time?:)
>
> Is it fastest to get data with GetElement, or to get a whole page, for
> example future valuation, and then rearrange the data myself?:)
>
>

Fri Aug 29, 2014 11:22 am (PDT) . Posted by:

digsupply

I Tried something else, I installed all updates to Office 2010 from the Microsoft webpage (more than 40) and I managed to get RCHGetElementNumber to work.

I am attaching a worksheet.
There SYMBOL_1 (SLW) & SYMBOL_2 (CREE) were done a month ago with the same computer but using office 2007.
Symbol_3 (SLW) was created after installing office 2010 and the updates, with the results you can see.
I use Zacks and Yahoo a lot and those are the pages that return most Errors.
Anyway I understand it is very difficult to diagnose this, and as you suggested I can use RCHGetTableCell() function to get the same data, or use other Element# from Barchart or Morningstar, that work OK
Again thanks a lot for all your help, I'll keep trying to fix this and I will let you know if I get lucky.
Roberto
Attachment(s) from
1 of 1 File(s)
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 01.38

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)