Jumat, 03 Januari 2014

[smf_addin] Digest Number 2913

13 New Messages

Digest #2913
2a
Zack's element number 1286-1400 by infinityholdings@ymail.com
2b
Re: Zack's element number 1286-1400 by "Randy Harmelink" rharmelink
2c
Re: Zack's element number 1286-1400 by infinityholdings@ymail.com
2d
Re: Zack's element number 1286-1400 by "Randy Harmelink" rharmelink
2f
Re: Zack's element number 1286-1400 by infinityholdings@ymail.com
2g
Re: Zack's element number 1286-1400 by "Randy Harmelink" rharmelink
2h
Re: Zack's element number 1286-1400 by "Randy Harmelink" rharmelink
4b
Re: Element number defs by "Randy Harmelink" rharmelink

Messages

Thu Jan 2, 2014 6:39 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

This is a site that I have been following recently. Its free to follow but he does have paid services if one is interested.
Personally, I just use the free stuff.
I thought others might benefit from some of his best articles.

Happy new year everyone,

Kermit


<http://cdn6.aweber-static.com/hosted/logo/1244628?etag=1IueyZnAIxFbhF32h4ATBJ>
Practical, Relevant and Resourceful Value Investing Updates

The Most Popular Articles of 2013 and What Went On During the Year

Many investing blogs have disappeared over the years.
Compared to 2-3 years ago, my blog reading list has been cut in half, and even the ones on my list are not very active.
Seeking Alpha and social media platforms have made it easy for people to provide their opinions.
But to see the readership at old school value still going strong is something that I'm very proud of.
I've got you to thank for that.
Over the years, I've focused on providing the best possible value investing content to you and that is a pledge that I plan to keep going forward.
Now without further ado, here is a list of the 10 most popular articles from 2013.

The Top 10 Posts from 2013

1. Use the Benjamin Graham Investing Checklist to Invest Like Him <http://www.oldschoolvalue.com/blog/investing-strategy/benjamin-graham-investing-checklist/?awt_l=4ruYg&awt_m=3jMpKSLmzBrtc_J&source=rss>

Graham had a checklist which he used against every company he looked at. If it passed, he bought some stock. See what the criteria of his checklist were.

2. 20 Balance Sheet Ratios to Quickly Determine a Company's Health <http://www.oldschoolvalue.com/blog/valuation-methods/balance-sheet-ratios/?awt_l=4ruYg&awt_m=3jMpKSLmzBrtc_J&source=rss>

A list of 20 balance sheet ratios that you need to know.
Also download the pdf version and keep it handy if you need a reminder once in a while.

3. The Practical <http://www.oldschoolvalue.com/blog/resources/practical-guide-finding-stock-ideas/?awt_l=4ruYg&awt_m=3jMpKSLmzBrtc_J&source=rss> Guide to Finding Stock Ideas

Everybody wants to know how to find stocks efficiently. Although finding stocks is a time consuming process, there are resources which you can leverage to speed up the search process.

4. The Evolution of Warren Buffett's Career from 1936 to 2013 <http://www.oldschoolvalue.com/blog/investing-perspective/warren-buffett-career-timeline-investments/?awt_l=4ruYg&awt_m=3jMpKSLmzBrtc_J&source=rss>

A timeline of Warren Buffett's life from when he was a boy to now. Goes over what investments he made.

5. Does the Magic Formula Really Work? <http://www.oldschoolvalue.com/blog/investing-strategy/the-magic-formula-investing/?awt_l=4ruYg&awt_m=3jMpKSLmzBrtc_J&source=rss>

The magic formula is well known in the value investing community, but how reliable are the results?
I was surprised by the results. Very different to my hypothesis.

6. 7 Low Risk Investments Strategies You Should Apply Today <http://www.oldschoolvalue.com/blog/investing-strategy/low-risk-investments/?awt_l=4ruYg&awt_m=3jMpKSLmzBrtc_J&source=rss>

A simple look at 7 characteristics to make low risk, high return investments.

7. You Missed Out on Visa and Mastercard. Then Keep an Eye on This One. <http://www.oldschoolvalue.com/blog/stock-analysis/fleetcor-technologies-flt/?awt_l=4ruYg&awt_m=3jMpKSLmzBrtc_J&source=rss>

The only stock related article to make the top 10. If you bought it early on, congratulations, because it has been on a tear.

8. The 3 Most Profitable Criteria of the Piotroski Score that Beats the Market <http://www.oldschoolvalue.com/blog/investing-strategy/profitable-piotroski-score/?awt_l=4ruYg&awt_m=3jMpKSLmzBrtc_J&source=rss>

There are 9 points in the Piotroski score.
I wanted to see whether it could be simplified with better results, and I came up with 3 of the 9 criteria which provides the best results.
Take a look at what it is.

9. The Importance of Learning How to Invest, Not What to Invest. <http://www.oldschoolvalue.com/blog/investing-perspective/how-to-invest/?awt_l=4ruYg&awt_m=3jMpKSLmzBrtc_J&source=rss>

Everyone comes from a different background and has a special set of skills. Too often, we fall in the trap of trying to copy or simulate someone else.
However, when you look at the successful people, they don't focus on what others are doing or try to copy them.
That's where bringing your own experience and applying it to investing helps.
This post also includes about 30 things you can think of and apply to become a better investor.

10. Finally. Proof that Ben Graham Knew How to Time the Market. <http://www.oldschoolvalue.com/blog/investing-strategy/ben-graham-time-the-market/?awt_l=4ruYg&awt_m=3jMpKSLmzBrtc_J&source=rss>

Who knew that you could measure how overvalued a market is by counting the number of available net nets.
I won't win a Nobel Prize for this research, but it does show that a simple measure like NCAV can be used to measure the market and even apply it as a market timing tactic.

What Went Down in 2013

During 2013, I placed a lot of focus on trying to create resources.
Some were hits.
* The Ultimate Guide to Stock Valuation <http://clicks.aweber.com/y/ct/?l=4ruYg&m=3jMpKSLmzBrtc_J&b=VsFnYX5sSBifr.RJlXWqBg> was downloaded and shared thousands of times
* 30 Sizzling Slides of Value Investing Quotes and Wisdom <http://www.oldschoolvalue.com/blog/investing-perspective/value-investing-quotes-wisdom/?awt_l=4ruYg&awt_m=3jMpKSLmzBrtc_J&source=rss> was another popular one
* The best investment books <http://clicks.aweber.com/y/ct/?l=4ruYg&m=3jMpKSLmzBrtc_J&b=6cHjgxIzugzNKLeYeBWPEg> was completely redesigned
There were duds too, which I won't waste time on.
On top of that, 147 articles were published in 2013.
That's about 3 posts a week with a focus on quality and timelessness over quantity.
I'm also proud to have achieved my 2013 goal of posts per week.
In 2014, I have a line of resources to create and ideas to put down on paper so keep coming back and let's make 2014 a great year.
This post was first published at old school value <http://www.oldschoolvalue.com?awt_l=4ruYg&awt_m=3jMpKSLmzBrtc_J> .
You can read the original blog post here The Most Popular Articles of 2013 and What Went On During the Year <http://www.oldschoolvalue.com/blog/reading-links/most-popular-articles-2013/?awt_l=4ruYg&awt_m=3jMpKSLmzBrtc_J> .
No related posts.
<http://yarpp.org/pixels/ee06053604563149991cc1bf7f69bca2>
<http://clicks.aweber.com/y/ct/?l=4ruYg&m=3jMpKSLmzBrtc_J&b=Y6CqnlUHd8X.LQ9aHcuqLg> <http://clicks.aweber.com/y/ct/?l=4ruYg&m=3jMpKSLmzBrtc_J&b=.0tmUdYHViZ0bJYzuVg63g> <http://clicks.aweber.com/y/ct/?l=4ruYg&m=3jMpKSLmzBrtc_J&b=fEbJu5AWUu6KSQkE11tNRQ> <http://clicks.aweber.com/y/ct/?l=4ruYg&m=3jMpKSLmzBrtc_J&b=4F6RkOxW5WI9iBr6IswOwA>
<http://feeds.feedburner.com/~r/OldSchoolValue/~4/XXKyFoOFwms>


P.S. Analyze companies faster, find profitable stocks and invest with confidence. Click here to learn more. <http://www.oldschoolvalue.com/tour.php?awt_l=4ruYg&awt_m=3jMpKSLmzBrtc_J>
P.O. Box 1546
Mercer Island, WA 98040
You are receiving this as you opted in for email updates.

Unsubscribe <http://www.aweber.com/z/r/?jEwsLGxMHLSsLGysbJwcnLRGtEyMrKxMHAxM> | Change Subscriber Options <http://www.aweber.com/z/r/?jEwsLGxMHLSsLGysbJwcnLRGtEyMrKxMHAxM>

<https://openrate.aweber.com/y/o/?l=4ruYg&m=3jMpKSLmzBrtc_J>

Thu Jan 2, 2014 7:32 am (PST) . Posted by:

infinityholdings@ymail.com

I cannot get the Zack's EA elements to work. Most everything else seems to be fine. Is this me or the add in.

Thank you for such a great add in

Thu Jan 2, 2014 7:37 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I just tried the workbook from the FILES area of the group, and it worked
fine for me using ticker symbol MMM.

I'm assuming you do have the updated element definitions, last updated in
early November?

If you have an older version of EXCEL (say 2003 or earlier), the problem
may be with that version's limitation on string lengths.

On Thu, Jan 2, 2014 at 7:55 AM, <coons_adam@yahoo.com> wrote:

> I cannot get the Zack's EA elements to work. Most everything else seems
> to be fine. Is this me or the add in.
>

Thu Jan 2, 2014 9:11 am (PST) . Posted by:

infinityholdings@ymail.com

I have the latest elements and addin from the work in progress area. I am running excel 2013. Is there anything I am supposed to do with the elements definition file to update them?

Thu Jan 2, 2014 9:53 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Just exit EXCEL, replace the file, then restart EXCEL.

What do you get for:

=RCHGetElementNumber("MMM";,1290)

=RCHGetElementNumber("Version&quot;)

=smfGetAParms(1290)

=smfstrExtr(smfstrExtr(smfWord(smfWord(","&smfstrExtr(smfGetTagContent("
http://www.zacks.com/stock/research/MMM/earnings-announcements","script",-1,"Period
Ending"),"""data"" : [ ","]"),1,"}"),2,","),": ","~"),"""","""")

=smfstrExtr(smfGetTagContent("
http://www.zacks.com/stock/research/MMM/earnings-announcements","script",-1,"Period
Ending"),"""data"" : [ ","]")

On Thu, Jan 2, 2014 at 10:11 AM, <coons_adam@yahoo.com> wrote:

> I have the latest elements and addin from the work in progress area. I
> am running excel 2013. Is there anything I am supposed to do with the
> elements definition file to update them?
>

Thu Jan 2, 2014 10:32 am (PST) . Posted by:

Charles8839

Hi Randy,

I'm interested in being able to pull the balance sheet, income statement and cash flow from yahoo finance. Do you have a template already setup or can you develop this for me.

Charles Coker

Thu Jan 2, 2014 10:59 am (PST) . Posted by:

infinityholdings@ymail.com

Here is what I get

1. Undefined
2. stock market functions add-in, Version 2.1.2013.10.17
3. Blank Cell
4. 1/30/2014
5. Blank Cell


Thu Jan 2, 2014 11:11 am (PST) . Posted by:

"Randy Harmelink" rharmelink

The "undefined&quot; result indicates that the element definition file isn't in
the same folder as the add-in. That would also be why #3 shows nothing. The
element definition hasn't been loaded.

#2, the "Version" result, is incomplete...

Result #5 should be impossible, given result #4, because #4 is EXTRACTING
data from the result of #5.

#4 *is* the element definition. So, if it works, it appears your problem is
you don't have the element definitions file properly located.

On Thu, Jan 2, 2014 at 11:59 AM, <coons_adam@yahoo.com> wrote:

> Here is what I get
>
> 1. Undefined
>
> 2. stock market functions add-in, Version 2.1.2013.10.17
>
> 3. Blank Cell
>
> 4. 1/30/2014
>
> 5. Blank Cell
>

Thu Jan 2, 2014 11:14 am (PST) . Posted by:

"Randy Harmelink" rharmelink

They already exist, in the "Templates and Examples > RCHGetTableCell&quot;
folder of the FILES area.

On Thu, Jan 2, 2014 at 11:32 AM, <charles.coker@cokersoft.com> wrote:

> I'm interested in being able to pull the balance sheet, income statement
> and cash flow from yahoo finance. Do you have a template already setup or
> can you develop this for me.
>

Thu Jan 2, 2014 11:34 am (PST) . Posted by:

Charles8839


Is there a way to pull the balance sheet, income statement and cash flow into excel spreadsheet.

Thanks.

Thu Jan 2, 2014 12:00 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Look through the "Templates and Examples" folder and its sub-folders in the
FILES area of the group, and you'll find a number of them, for the various
data providers.

Note also that the numbers are not always the same, so it's not a good idea
to mix and match data providers. You should use one consistent source for
your usage.

On Thu, Jan 2, 2014 at 12:34 PM, <charles.coker@cokersoft.com> wrote:

> Is there a way to pull the balance sheet, income statement and cash flow
> into excel spreadsheet.
>

Thu Jan 2, 2014 3:15 pm (PST) . Posted by:

amsiev

Where can I download the latest version of :

RCHGetElementNumber-Element-Definitions.xls

Regards, Ton.

Thu Jan 2, 2014 3:17 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The most recent uploaded one is in the "Works in Progress" folder...

On Thu, Jan 2, 2014 at 1:33 PM, <ton.sieverding@scarlet.be> wrote:

>
> Where can I download the latest version of :
>
> RCHGetElementNumber-Element-Definitions.xls
>

Tidak ada komentar:

Posting Komentar