6 Messages
Digest #2984
Messages
Wed Feb 26, 2014 6:43 am (PST) . Posted by:
rr76012
Hi Kermit,
Thank you. I find your responses to be very helpful, educational and informative.
I am focusing on MSN, ADFVN and morningstar for both eps and dividend growth rates, as I find most of these forecasted numbers are guess-estimations by guess-timators. Their numbers can not be much more worse or better than mine. So I want to use their estimates as a good starting place. Then, I find common sense is my best defense and offense. A little humor with the terminator language. :+_
These last 5 years have me thinking that I need to educate myself and be more proactive in my ira, 401K, small investment accts. Normally someone in my age would go to the bond market. But the fomc members have disseminated the yields, so they driven me to is the riskier stock market? I feel grateful to have found this smf website. I am trying to spend more time with it. I find the more time I spend with it, the more confidence I get.
I do not have alot to retire on, and I was laid off from banking 3 years ago. So I use my time to try and improve my finances using my savings.
The bond and stock markets seems to me to be very manipulated over the years. I just want to beat inflation and better than normalized CD rates, in other words I want 5-7%, in a 5 year period, and get it as safe as I can. My strategy is buy and hold with a horizon of 3-5 years per investment.
Kermit, One quick short story. My first stock investment was Exelon EXC right after their very public announcement they would not cut their dividend. Then shortly afterwards they did cut their dividend. So I find a lot of announcements and estimations websites need to be viewed thru rosey lenses?
For EXC I bought at $39,and it went down to the $26 range...SO I am very wary of the stock market. Morningstar pronounced this stock as one of the safest of all the stocks. It was not...
I have decided their are 2 big clubs swinging at the stock market. One is the growth rates of dividends and eps. The other is the market itself, it goes up and down with no catalyst or reasons. It just goes up or down on hype.
If market valuations are not working, and stock prices are higher than common sense valuations, then they call it simply momentum. If stocks are still going higher than valuations then they just simply raise the PE multiple higher on a whim, even if un-employment is high, gdp is low, higher taxes ect..
I am trying to focus on eps and dividend growth??? I plan on asking Randy to update his rchgetelement numbers for 2 more elements from msn that are not presently not available for eps last 5 years growth rate and the next 5 years growth rates. I want to compare them to see if they are close and if the forecast is better than the last 5 years growth rate.
I like the MSN website because it is a simple website to find info.
Right now I think the market is over-valued as a whole, but with small pockets of exceptions.
Kermit I wish us both the best of luck in 2014. :_)
Thank you. I find your responses to be very helpful, educational and informative.
I am focusing on MSN, ADFVN and morningstar for both eps and dividend growth rates, as I find most of these forecasted numbers are guess-estimations by guess-timators. Their numbers can not be much more worse or better than mine. So I want to use their estimates as a good starting place. Then, I find common sense is my best defense and offense. A little humor with the terminator language. :+_
These last 5 years have me thinking that I need to educate myself and be more proactive in my ira, 401K, small investment accts. Normally someone in my age would go to the bond market. But the fomc members have disseminated the yields, so they driven me to is the riskier stock market? I feel grateful to have found this smf website. I am trying to spend more time with it. I find the more time I spend with it, the more confidence I get.
I do not have alot to retire on, and I was laid off from banking 3 years ago. So I use my time to try and improve my finances using my savings.
The bond and stock markets seems to me to be very manipulated over the years. I just want to beat inflation and better than normalized CD rates, in other words I want 5-7%, in a 5 year period, and get it as safe as I can. My strategy is buy and hold with a horizon of 3-5 years per investment.
Kermit, One quick short story. My first stock investment was Exelon EXC right after their very public announcement they would not cut their dividend. Then shortly afterwards they did cut their dividend. So I find a lot of announcements and estimations websites need to be viewed thru rosey lenses?
For EXC I bought at $39,and it went down to the $26 range...SO I am very wary of the stock market. Morningstar pronounced this stock as one of the safest of all the stocks. It was not...
I have decided their are 2 big clubs swinging at the stock market. One is the growth rates of dividends and eps. The other is the market itself, it goes up and down with no catalyst or reasons. It just goes up or down on hype.
If market valuations are not working, and stock prices are higher than common sense valuations, then they call it simply momentum. If stocks are still going higher than valuations then they just simply raise the PE multiple higher on a whim, even if un-employment is high, gdp is low, higher taxes ect..
I am trying to focus on eps and dividend growth??? I plan on asking Randy to update his rchgetelement numbers for 2 more elements from msn that are not presently not available for eps last 5 years growth rate and the next 5 years growth rates. I want to compare them to see if they are close and if the forecast is better than the last 5 years growth rate.
I like the MSN website because it is a simple website to find info.
Right now I think the market is over-valued as a whole, but with small pockets of exceptions.
Kermit I wish us both the best of luck in 2014. :_)
Wed Feb 26, 2014 10:35 am (PST) . Posted by:
"Joseph Yu" joeyu51788
Hey Randy,
Thank you for the insight.
I'll give it a try and let you know the results.
Best regards
On Tuesday, February 25, 2014 8:16 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
For 75 tickers, you're accessing the Internet 300 times with those three formulas. So I suspect it would be slow. Especially since, the last month or so, people have been complaining about Yahoo being slower than normal.
You can get the same 225 data items in a single Internet access with this formula, array-entered over a range (adjust the range as needed for your ticker symbols -- you can have up to 200 of them):
=RCHGetYahooQuotes(B4:B78,"l1j1t8")
I don't know who spread the idea of using the smfPricesByDates() function to get the current day quote. Several people lately have said they use that method. That is a VERY bad way to go about it. During the day, it will first get the historical quotes for the ticker, then search it for the current date, not find it, and then issue another SMF function to get the data:
=RCHGetYahooQuotes(XX,"l1")
...so you end up with two Internet accesses just to get that piece of data. Not only that, but using a volatile date function makes EVERY one of those formulas volatile. That means your worksheet will recalculate every time you do something on it. I suspect that is why you are using manual calculation.
That array-entered function will get all of the data almost instantaneously.
On Tue, Feb 25, 2014 at 8:17 PM, <joeyu51788@yahoo.com> wrote:
>I've disabled auto calculate in my Excel 2013 and have enabled all processors to run calculations. Granted my system maxes out at 4 processors but I've noticed that when running calculate sheet updates, the process is tremendously slow.
>
>
>Sample sheet:
>Market Cap - =RCHGetElementNumber(XX,941)/1000
>Price - =smfpricesbydates(XX,Today's Date)
>Price Target - =RCHGetTableCell("http://finance.yahoo.com/q/ao?s=XXXX",1,">Mean Target")
>
>
>The sheet contains a list of about 75 tickers.
>
>
>Any thoughts would be greatly appreciated.
>
Thank you for the insight.
I'll give it a try and let you know the results.
Best regards
On Tuesday, February 25, 2014 8:16 PM, Randy Harmelink <rharmelink@gmail.
For 75 tickers, you're accessing the Internet 300 times with those three formulas. So I suspect it would be slow. Especially since, the last month or so, people have been complaining about Yahoo being slower than normal.
You can get the same 225 data items in a single Internet access with this formula, array-entered over a range (adjust the range as needed for your ticker symbols -- you can have up to 200 of them):
=RCHGetYahooQuotes(
I don't know who spread the idea of using the smfPricesByDates(
=RCHGetYahooQuotes(
...so you end up with two Internet accesses just to get that piece of data. Not only that, but using a volatile date function makes EVERY one of those formulas volatile. That means your worksheet will recalculate every time you do something on it. I suspect that is why you are using manual calculation.
That array-entered function will get all of the data almost instantaneously.
On Tue, Feb 25, 2014 at 8:17 PM, <joeyu51788@yahoo.
>I've disabled auto calculate in my Excel 2013 and have enabled all processors to run calculations. Granted my system maxes out at 4 processors but I've noticed that when running calculate sheet updates, the process is tremendously slow.
>
>
>Sample sheet:
>Market Cap - =RCHGetElementNumb
>Price - =smfpricesbydates(
>Price Target - =RCHGetTableCell(
>
>
>The sheet contains a list of about 75 tickers.
>
>
>Any thoughts would be greatly appreciated.
>
Wed Feb 26, 2014 10:46 am (PST) . Posted by:
"Joseph Yu" joeyu51788
The SMF-Template-RCHGetYahooQuotes is an awesome reference.
Thank you very much.
On , Joseph Yu <joeyu51788@yahoo.com> wrote:
Hey Randy,
Thank you for the insight.
I'll give it a try and let you know the results.
Best regards
On Tuesday, February 25, 2014 8:16 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
For 75 tickers, you're accessing the Internet 300 times with those three formulas. So I suspect it would be slow. Especially since, the last month or so, people have been complaining about Yahoo being slower than normal.
You can get the same 225 data items in a single Internet access with this formula, array-entered over a range (adjust the range as needed for your ticker symbols -- you can have up to 200 of them):
=RCHGetYahooQuotes(B4:B78,"l1j1t8")
I don't know who spread the idea of using the smfPricesByDates() function to get the current day quote. Several people lately have said they use that method. That is a VERY bad way to go about it. During the day, it will first get the historical quotes for the ticker, then search it for the current date, not find it, and then issue another SMF function to get the data:
=RCHGetYahooQuotes(XX,"l1")
...so you end up with two Internet accesses just to get that piece of data. Not only that, but using a volatile date function makes EVERY one of those formulas volatile. That means your worksheet will recalculate every time you do something on it. I suspect that is why you are using manual calculation.
That array-entered function will get all of the data almost instantaneously.
On Tue, Feb 25, 2014 at 8:17 PM, <joeyu51788@yahoo.com> wrote:
>I've disabled auto calculate in my Excel 2013 and have enabled all processors to run calculations. Granted my system maxes out at 4 processors but I've noticed that when running calculate sheet updates, the process is tremendously slow.
>
>
>Sample sheet:
>Market Cap - =RCHGetElementNumber(XX,941)/1000
>Price - =smfpricesbydates(XX,Today's Date)
>Price Target - =RCHGetTableCell("http://finance.yahoo.com/q/ao?s=XXXX",1,">Mean Target")
>
>
>The sheet contains a list of about 75 tickers.
>
>
>Any thoughts would be greatly appreciated.
>
Thank you very much.
On , Joseph Yu <joeyu51788@yahoo.
Hey Randy,
Thank you for the insight.
I'll give it a try and let you know the results.
Best regards
On Tuesday, February 25, 2014 8:16 PM, Randy Harmelink <rharmelink@gmail.
For 75 tickers, you're accessing the Internet 300 times with those three formulas. So I suspect it would be slow. Especially since, the last month or so, people have been complaining about Yahoo being slower than normal.
You can get the same 225 data items in a single Internet access with this formula, array-entered over a range (adjust the range as needed for your ticker symbols -- you can have up to 200 of them):
=RCHGetYahooQuotes(
I don't know who spread the idea of using the smfPricesByDates(
=RCHGetYahooQuotes(
...so you end up with two Internet accesses just to get that piece of data. Not only that, but using a volatile date function makes EVERY one of those formulas volatile. That means your worksheet will recalculate every time you do something on it. I suspect that is why you are using manual calculation.
That array-entered function will get all of the data almost instantaneously.
On Tue, Feb 25, 2014 at 8:17 PM, <joeyu51788@yahoo.
>I've disabled auto calculate in my Excel 2013 and have enabled all processors to run calculations. Granted my system maxes out at 4 processors but I've noticed that when running calculate sheet updates, the process is tremendously slow.
>
>
>Sample sheet:
>Market Cap - =RCHGetElementNumb
>Price - =smfpricesbydates(
>Price Target - =RCHGetTableCell(
>
>
>The sheet contains a list of about 75 tickers.
>
>
>Any thoughts would be greatly appreciated.
>
Wed Feb 26, 2014 11:53 am (PST) . Posted by:
rr76012
Thanks Randy, You are amazing kind for looking at msn, I think they have redesigned within the last year. I found it by reading a blog, that referenced msn over other websites.
The listings on the left side are:
Fundamentals -> then under Earnings, then under -> EARNINGS GROWTH RATES - NEXT 5 YEARS
http://investing.money.msn.com/investments/earnings-estimates?symbol=KO http://investing.money.msn.com/investments/earnings-estimates?symbol=KO
The listings on the left side are:
Fundamentals -> then under Earnings, then under -> EARNINGS GROWTH RATES - NEXT 5 YEARS
http://investing.
Wed Feb 26, 2014 12:56 pm (PST) . Posted by:
joeyu51788
Hello there! http://homeshopping
Tidak ada komentar:
Posting Komentar