Selasa, 30 Juni 2015

[belajar-excel] Digest Number 3493

2 Messages

Digest #3493

Messages

Mon Jun 29, 2015 11:41 pm (PDT) . Posted by:

"Maman"

Assalaamu'alaikum Wr. Wb.

Dear Master Excel, mohon sharing ilmunya untuk mencari Nilai Pembagi
dari file terlampir.

Terima Kasih

Tue Jun 30, 2015 1:21 am (PDT) . Posted by:

"Dede"

Dear Mr Maman,

Sambil menunggu dari Master-master yang lain, coba masukan rumus di cell B3 :

=MID(A3;FIND("/";A3)+1;9)

Kemudian lakukan langkah seperti ini :

1. Blok kolom A

2. Tekan Ctrl +F

3. Pilih Replace

a. Find What diisi =

b. Replace with diisi #

c. Replace All

d. Close

Selesai.

Salam,

DD

From: Maman superm42n@gmail.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com]
Sent: 30 Juni 2015 13:35
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Mencari Nilai Pembagi [1 Attachment]

Assalaamu'alaikum Wr. Wb.

Dear Master Excel, mohon sharing ilmunya untuk mencari Nilai Pembagi
dari file terlampir.

Terima Kasih

_____

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
READ MORE....

Senin, 29 Juni 2015

[smf_addin] Digest Number 3445

15 Messages

Digest #3445
1.2
Re: New file uploaded to smf_addin by "Kermit W. Prather" kermitpra
3.1
Guru question by "Jim Ranum" amt2100
3.2
Re: Guru question by "Randy Harmelink" rharmelink
3.3
Re: Guru question by "Jim Ranum" amt2100
3.4
Re: Guru question by "Randy Harmelink" rharmelink
3.5
Re: Guru question by "Jim Ranum" amt2100
3.6
Re: Guru question by "Randy Harmelink" rharmelink
3.7
Re: Guru question by "Jim Ranum" amt2100
4a
Re: Looking for a stock screener [1 Attachment] by "Kermit W. Prather" kermitpra
4b
Re: Looking for a stock screener by "Randy Harmelink" rharmelink
5a
Re: Elements 3900 and 3901 get "error" return by "Kermit W. Prather" kermitpra
6a
Re: Looking for a stock screener by "Kermit W. Prather" kermitpra

Messages

Mon Jun 29, 2015 3:35 am (PDT) . Posted by:

panda317

Stock Market Functions add-in, Version 2.1.2012.12.29 (C:\Program Files\SMF Add-in; 1)

was my problem, I think...

I downloaded the latest beta, but it still doesn't work.

I tried to replace the symbols with a list of my stocks and that didn't work either.

Some of the sheet works, but I guess it's just not going to work for me

Sorry to have bothered you.

My sheet still works, so I'm happy.


Mon Jun 29, 2015 3:49 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

WOW! That is a really nice spreadsheet. Now I just have to figure out how to use it.

Thanks, Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Sunday, June 28, 2015 3:17 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: New file uploaded to smf_addin


This file just gives me #NAME? for almost all the fields.

How do I fix that?

Mon Jun 29, 2015 11:18 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The one in the "Uploads by forum members" folder here in the Yahoo group
still appears to work:

10 year model - GuruFocus - All Types (2003).xls

On Sun, Jun 28, 2015 at 10:43 PM, cburkhalterjr@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I've been using a workbook from a couple years back that was retrieving
> 10 years of annual financial data from Gurufocus (most cells retrieving
> data using the =RCHGetTableCell("http://www.gurufocus.com/financials/"&Ticker,D$1,"except
> for per share",">"&$C$5) formulas for the income statement, balance sheet,
> cash flow statement, and per share data).
>
> With the Gurufocus move to 15 year data, the spreadsheet has "crashed",
> meaning I get #VALUE!, error, and/or blank amounts for almost all fields,
> the period of which is now the first 10 of the 15 year period (i.e. no
> financial data for the most recent five years).
>
> Any suggestions on a new formula to go about retrieving the most recent 10
> years of financial data from Gurufocus?
>
> Otherwise, is there a different workbook that pulls this 10 year data from
> another site? I think I moved to the Gurufocus workbook from ADVFN, when
> the ADVFN website changed their formatting.
>
> Any formula updates, or different 10 year workbook suggestions would be
> appreciated.
>

Mon Jun 29, 2015 1:00 pm (PDT) . Posted by:

"Jim Ranum" amt2100

Hi Randy,

Having trouble getting the Forward P/E out of this mess.

Would like to get the Industry Forward P/E also, if it's not too much
trouble.

Thanks very much.

Best regards,

Jim

Pic below:

Mon Jun 29, 2015 4:32 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=RCHGetTableCell("http://www.gurufocus.com/stock/AXL",1,">Forward P/E")
=smfGetTagContent("http://www.gurufocus.com/stock/AXL","strong",1,">Forward
P/E")
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/stock/AXL","strong",2,">Forward
P/E"))
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/stock/AXL","a",1,">Forward
P/E"))
=smfConvertData(smfstrExtr(smfGetTagContent("
http://www.gurufocus.com/stock/AXL","td",2,">Forward P/E"),"Median:","vs"))

On Mon, Jun 29, 2015 at 1:00 PM, 'Jim Ranum' amt2100@... wrote:

>
>
> Hi Randy,
>
>
>
> Having trouble getting the Forward P/E out of this mess.
>
> Would like to get the Industry Forward P/E also, if it's not too much
> trouble.
>
>
>
> Thanks very much.
>
>
>
> Best regards,
>
> Jim
>
>
>
> Pic below:
>
>
>

Mon Jun 29, 2015 5:13 pm (PDT) . Posted by:

"Jim Ranum" amt2100

Thanks Randy.

Responses below:

Best regards,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, June 29, 2015 7:33 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Guru question

Try:

=RCHGetTableCell("http://www.gurufocus.com/stock/AXL",1,">Forward P/E") --> Error
=smfGetTagContent("http://www.gurufocus.com/stock/AXL","strong",1,">Forward P/E") --> I get the word: "higher" as a hyperlink
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/stock/AXL","strong",2,">Forward P/E")) --> I get: "0.77" as a hyperlink (correct number = 7.87)
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/stock/AXL","a",1,">Forward P/E")) --> I get: "402" as a hyperlink
=smfConvertData(smfstrExtr(smfGetTagContent("http://www.gurufocus.com/stock/AXL","td",2,">Forward P/E"),"Median:","vs")) --> this one works for the Industry Forward P/E

Since the Industry Forward P/E works, is there an adjustment that can be made to that line to get the 7.87 number? A complication is the name of the ticker is after the "vs.".

What does the "2" in that last line do?

Thanks!

On Mon, Jun 29, 2015 at 1:00 PM, 'Jim Ranum' amt2100@... wrote:

Hi Randy,

Having trouble getting the Forward P/E out of this mess.

Would like to get the Industry Forward P/E also, if it's not too much trouble.

Thanks very much.

Best regards,

Jim

Pic below:

Mon Jun 29, 2015 5:24 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sounds like you cut and pasted things incorrectly (be sure to edit special
to paste as text, not as HTML). The formula would not have the ability to
change the formatting of a cell to be a hyperlink. It can only place a
value in the cell.

The first formula returns 7.87 for me.

The "2" in the last formula says to get the content of the 2nd table cell
(i.e. "td") following the ">Forward P/E" string. The smfGetTagContent()
function grabs everything, including the HTML markup code within the table
cell, while RCHGetTableCell() automatically strips out any HTML code from
the table cell, leaving any remaining content.

On Mon, Jun 29, 2015 at 5:13 PM, 'Jim Ranum' amt2100@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Thanks Randy.
>
> Responses below:
>
>
>
> Best regards,
>
> Jim
>
>
>
> *From:* smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *Sent:* Monday, June 29, 2015 7:33 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] Guru question
>
>
>
>
>
> Try:
>
> =RCHGetTableCell("http://www.gurufocus.com/stock/AXL",1,">Forward P/E") à
> Error
> =smfGetTagContent("http://www.gurufocus.com/stock/AXL","strong",1,">Forward
> P/E") à I get the word: "higher" as a hyperlink
> =smfConvertData(smfGetTagContent("http://www.gurufocus.com/stock/AXL","strong",2,">Forward
> P/E")) à I get: "0.77" as a hyperlink (correct number = 7.87)
> =smfConvertData(smfGetTagContent("http://www.gurufocus.com/stock/AXL","a",1,">Forward
> P/E")) à I get: "402" as a hyperlink
> =smfConvertData(smfstrExtr(smfGetTagContent("
> http://www.gurufocus.com/stock/AXL","td",2,">Forward
> P/E"),"Median:","vs")) à this one works for the Industry Forward P/E
>
>
>
> Since the Industry Forward P/E works, is there an adjustment that can be
> made to that line to get the 7.87 number? A complication is the name of the
> ticker is after the "vs.".
>
> What does the "2" in that last line do?
>
> Thanks!
>
>
>
>
>
> On Mon, Jun 29, 2015 at 1:00 PM, 'Jim Ranum' amt2100@... wrote:
>
>
>
> Hi Randy,
>
>
>
> Having trouble getting the Forward P/E out of this mess.
>
> Would like to get the Industry Forward P/E also, if it's not too much
> trouble.
>
>
>
> Thanks very much.
>
>
>
> Best regards,
>
> Jim
>
>
>
> Pic below:
>
>
>
>
>
>
>
>
>

Mon Jun 29, 2015 6:16 pm (PDT) . Posted by:

"Jim Ranum" amt2100

Thanks Randy. Of course you're right.

The first line did work. I dorked it up in a manner not worth our time explaining.

There was an earlier discussion that I can't find now, about pulling the entire table of data from Guru and doing a vlookup. When you have an elaborate spreadsheet of items you want to evaluate, I'm guessing it's quicker to pull the whole table? Do you have to just put that table in another tab and then draw from that for your evaluation spreadsheet?

About how many queries (roughly) in a spreadsheet does it start to be more efficient to do that?

Thanks so much.

Best regards,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, June 29, 2015 8:24 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Guru question

Sounds like you cut and pasted things incorrectly (be sure to edit special to paste as text, not as HTML). The formula would not have the ability to change the formatting of a cell to be a hyperlink. It can only place a value in the cell.

The first formula returns 7.87 for me.

The "2" in the last formula says to get the content of the 2nd table cell (i.e. "td") following the ">Forward P/E" string. The smfGetTagContent() function grabs everything, including the HTML markup code within the table cell, while RCHGetTableCell() automatically strips out any HTML code from the table cell, leaving any remaining content.

On Mon, Jun 29, 2015 at 5:13 PM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

Thanks Randy.

Responses below:

Best regards,

Jim

From: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> [mailto:smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> ]
Sent: Monday, June 29, 2015 7:33 PM
To: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>
Subject: Re: [smf_addin] Guru question

Try:

=RCHGetTableCell("http://www.gurufocus.com/stock/AXL",1,">Forward P/E") --> Error
=smfGetTagContent("http://www.gurufocus.com/stock/AXL","strong",1,">Forward P/E") --> I get the word: "higher" as a hyperlink
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/stock/AXL","strong",2,">Forward P/E")) --> I get: "0.77" as a hyperlink (correct number = 7.87)
=smfConvertData(smfGetTagContent("http://www.gurufocus.com/stock/AXL","a",1,">Forward P/E")) --> I get: "402" as a hyperlink
=smfConvertData(smfstrExtr(smfGetTagContent("http://www.gurufocus.com/stock/AXL","td",2,">Forward P/E"),"Median:","vs")) --> this one works for the Industry Forward P/E

Since the Industry Forward P/E works, is there an adjustment that can be made to that line to get the 7.87 number? A complication is the name of the ticker is after the "vs.".

What does the "2" in that last line do?

Thanks!

On Mon, Jun 29, 2015 at 1:00 PM, 'Jim Ranum' amt2100@... wrote:

Hi Randy,

Having trouble getting the Forward P/E out of this mess.

Would like to get the Industry Forward P/E also, if it's not too much trouble.

Thanks very much.

Best regards,

Jim

Pic below:

Mon Jun 29, 2015 6:44 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It was actually using VBA code to open the GuruFocus XLS dataset and
copying over the "Historical Financial" worksheet, based on a list of
ticker symbols:

Set wb1 = ActiveWorkbook
For Each oCell In Range("A1:A4")
sTicker = oCell.Value
If sTicker = "" Then Exit For
Workbooks.Open Filename:="
http://www.gurufocus.com/download_dataset.php?symbol=" & sTicker
Sheets("Historical Financial").Name = sTicker & "-Financial"
Sheets(sTicker & "-Financial").Copy Before:=wb1.Sheets(1)
Windows("download_dataset.php").Close False
Next oCell

It's actually a pretty slow process. But does get 20 years of annual and
quarterly periods. An advantage is once you did it, you wouldn't need to do
it again for the same company. At least not until financial statements
change. But then you'd need a process to delete an old copy as well.

But saving all of the worksheets could make for a pretty large workbook. It
might actually make more sense to download the XLS file as needed and save
it. Then just use normal EXCEL formulas to reference the save workbooks
directly.

On Mon, Jun 29, 2015 at 6:16 PM, 'Jim Ranum' amt2100@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> There was an earlier discussion that I can't find now, about pulling the
> entire table of data from Guru and doing a vlookup. When you have an
> elaborate spreadsheet of items you want to evaluate, I'm guessing it's
> quicker to pull the whole table? Do you have to just put that table in
> another tab and then draw from that for your evaluation spreadsheet?
>
> About how many queries (roughly) in a spreadsheet does it start to be more
> efficient to do that?
>
>
>

Mon Jun 29, 2015 7:58 pm (PDT) . Posted by:

"Jim Ranum" amt2100

Thanks Randy.

I guess I'll stick with what I'm doing.

Best regards,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, June 29, 2015 9:40 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Guru question

It was actually using VBA code to open the GuruFocus XLS dataset and copying over the "Historical Financial" worksheet, based on a list of ticker symbols:

Set wb1 = ActiveWorkbook
For Each oCell In Range("A1:A4")
sTicker = oCell.Value
If sTicker = "" Then Exit For
Workbooks.Open Filename:="http://www.gurufocus.com/download_dataset.php?symbol=" & sTicker
Sheets("Historical Financial").Name = sTicker & "-Financial"
Sheets(sTicker & "-Financial").Copy Before:=wb1.Sheets(1)
Windows("download_dataset.php").Close False
Next oCell

It's actually a pretty slow process. But does get 20 years of annual and quarterly periods. An advantage is once you did it, you wouldn't need to do it again for the same company. At least not until financial statements change. But then you'd need a process to delete an old copy as well.

But saving all of the worksheets could make for a pretty large workbook. It might actually make more sense to download the XLS file as needed and save it. Then just use normal EXCEL formulas to reference the save workbooks directly.

On Mon, Jun 29, 2015 at 6:16 PM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

There was an earlier discussion that I can't find now, about pulling the entire table of data from Guru and doing a vlookup. When you have an elaborate spreadsheet of items you want to evaluate, I'm guessing it's quicker to pull the whole table? Do you have to just put that table in another tab and then draw from that for your evaluation spreadsheet?

About how many queries (roughly) in a spreadsheet does it start to be more efficient to do that?

Mon Jun 29, 2015 3:27 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Sorry it took me so long to respond. I been building toy for disadvantage kids. Since I introduced my wife to the "Kids Place" she has me working day and night on toys.
I'm making toy horse corrals now.

Thanks for the attachment. Everything worked great except these

Enterprise Value
Error
Error

EBITDA
$24,962
$24,434

> EV to EBITDA
#VALUE!
#VALUE!

I just opened the spreadsheet and change the source links to where I keep the SMF ADDIN.

You fantastic but then you do this day and night. Not sure when you sleep.

Thank again,
Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, June 26, 2015 6:07 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Looking for a stock screener [1 Attachment]

[Attachment(s) from Randy Harmelink included below]

This interested me, so I took a stab at it, using Guru Focus TTM data. I'm a premium member, and not sure if some of the data items collected are premium data items. I'm also using a few advanced techniques in the smfUpdateDownloadTable process (note defined names to pick up the relative location column items).
I did have some companies with no capital expenditures, so the ratio should probably be changed to a comparison. And some had no net income data element (I suspect financial institutions).
The companies I used were dividend champions, plus the 3 passing companies in the article. Using an online stock screener to get a limited number of candidates, then running them on this workbook for final computations, may be the best way to go. Please don't use this to bulk download LARGE amounts of data and THEN screen.

On Thu, Jun 25, 2015 at 9:32 AM, 'Kermit W. Prather' kermitp@... wrote:

I'm looking for a stock screener that will produce a stock list based on the 4 items below.
I'd appreciate any help. Naturally, I'd prefer a free stock screener.
These items are out of my normal scans on stock screeners. I am more of a short term trader.
But a friend ask if I could point him to an online stock screener that provides the below information:
No. 1. Cash operating profit margin: cash from operations / revenue (should be greater than 20%).
No. 2. Shareholder payout ratio: capital returned to shareholders / capital expenditures (should be greater than 1).
No. 3. Return on invested capital: net income / long-term debt + shareholder equity (should be greater than 20%).
No. 4. Returns on net tangible assets: net income / net tangible assets (should be greater than 20%).
Thanks,
Kermit



Mon Jun 29, 2015 4:22 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Looks like Enterprise value is only available to premium members on
GuruFocus. You could pick up the current value from Yahoo instead:

=RCHGetTableCell("http://finance.yahoo.com/q/ks?s=MMM",1,">Enterprise
Value")

On Mon, Jun 29, 2015 at 3:26 PM, 'Kermit W. Prather' kermitp@... wrote:

>
>
> Sorry it took me so long to respond. I been building toy for disadvantage
> kids. Since I introduced my wife to the "Kids Place" she has me working day
> and night on toys.
>
> I'm making toy horse corrals now.
>
>
>
> Thanks for the attachment. Everything worked great except these
>
> Enterprise Value
>
> Error
>
> Error
>
> EBITDA
>
> $24,962
>
> $24,434
>
> > EV to EBITDA
>
> #VALUE!
>
> #VALUE!
>
>
>
> I just opened the spreadsheet and change the source links to where I keep
> the SMF ADDIN.
>
>
>
> You fantastic but then you do this day and night. Not sure when you sleep.
>
>
>
>

Mon Jun 29, 2015 3:37 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Very interesting, I'm a lifetime AAII member but I don't use the Stock Investor Pro screener. Let me know if you get a scan working on Investor Pro.

Good luck,
Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, June 26, 2015 10:52 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Elements 3900 and 3901 get "error" return


I built a screen for Stock Investor Pro evaluating just the prior years data. I eliminated OTC, ADR/ADS, Utilities and Financial sectors from consideration. Only 19 companies cut the mustard and all look to be good candidates. There are a few that came up as potential buys once their technicals look just a little better (MACD, RSI, Stochastics, etc.). Thanks for the idea.

To: smf_addin@yahoogroups.com
From: smf_addin@yahoogroups.com
Date: Fri, 26 Jun 2015 14:24:07 -0400
Subject: RE: [smf_addin] Elements 3900 and 3901 get "error" return

It appears I have the same failures with elements 3930 and 3931.

I'm wondering if goggle is no longer supporting years 5 and 6?

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, June 26, 2015 2:04 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Elements 3900 and 3901 get "error" return


I was looking at my Daily trade alerts and decided to read this article.
The article is suppose to be a method of determining "Quality and value" as the article states"

"What you'll find below is a nearly foolproof way to evaluate the quality and the value of any business."

http://dailytradealert.com/2015/06/25/before-you-buy-another-stock-read-this-3/

After reading it I thought I'd try creating a sample SMF ADDIN workbook to calculate the values mention in the paper.

In looking thru the RCHGetElementNumber-Element-Definitions.xls for the proper elements
I got "error" return on 2 elements 3900 and 3901.

I had an older version than the one in the work-in-progress folder. So I upgraded to the latest version as shown the table below.



ROWS
Columns
M
N
O
P
Q
R
S

3
Ticker
Annual Cash Flow -- Cash from Operating Activities -- FY1
Annual Cash Flow -- Cash from Operating Activities -- FY2
Annual Cash Flow -- Cash from Operating Activities -- FY3
Annual Cash Flow -- Cash from Operating Activities -- FY4
Annual Cash Flow -- Cash from Operating Activities -- FY5
Annual Cash Flow -- Cash from Operating Activities -- FY6
All money values are in Thousands

4
KO
$ 10,615.00
$ 10,542.00
$ 10,645.00
$ 9,474.00
Error
Error
Stock Market Functions add-in, Version 2.1.2015.06.08 (C:\SMFADDIN; ; ; 1)

5

3896
3897
3898
3899
3900
3901


The first error cell has this value =RCHGetElementNumber(Symbol,Q5)

No. 1. Cash operating profit margin: cash from operations / revenue (should be greater than 20%).
No. 2. Shareholder payout ratio: capital returned to shareholders / capital expenditures (should be greater than 1).
No. 3. Return on invested capital: net income / long-term debt + shareholder equity (should be greater than 20%).
No. 4. Returns on net tangible assets: net income / net tangible assets (should be greater than 20%).


I'd appreciate any help anyone can provide as to why elements 3900 and 3901 is not working?

Kermit


Mon Jun 29, 2015 3:40 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Thanks, for the info I have never used Portflio123 but have heard good things about it.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, June 26, 2015 11:54 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Looking for a stock screener


I was able to set up and backtest the rules on Portfolio123.com, as:
SCREEN BACKTEST LOG 06/26/15-22:34:40

Screen id 141580
Period 01/02/1999 - 06/26/2015
Rebalance Days 7

RULES
Common Universe(NoOTC)
Common Showvar(@R1, OperCashFlTTM / SalesTTM)
Common @R1 > 0.2
Common Showvar(@R2, (DivPaidTTM + EqPurchTTM - EqIssuedTTM) / CapExTTM)
Common @R2 > 1
Common Showvar(@R3, NetIncBXorNonCTTM / (EqTotQ + DbtLTQ + DbtSTQ))
Common @R3 > 0.2
Common Showvar(@R4, NetIncBXorNonCTTM / (AstTotQ - LiabTotQ - AstIntanQ - PfdEquityQ))
Common @R4 > 0.2
Common Showvar(@R5, EV / EBITDATTM)
Common LoopSum("Vol(CTR) * Close(CTR) > 2000000", 50) = 50 // Liquidity check
With no trading costs, annual returns since 1999 are 9.65% per year, compared to 3.31% or the S&P 500 index.
If I add the 5th restriction, annual returns go up to 13.51%

On Thu, Jun 25, 2015 at 9:32 AM, 'Kermit W. Prather' kermitp@... wrote:

I'm looking for a stock screener that will produce a stock list based on the 4 items below.
I'd appreciate any help. Naturally, I'd prefer a free stock screener.
These items are out of my normal scans on stock screeners. I am more of a short term trader.
But a friend ask if I could point him to an online stock screener that provides the below information:
No. 1. Cash operating profit margin: cash from operations / revenue (should be greater than 20%).
No. 2. Shareholder payout ratio: capital returned to shareholders / capital expenditures (should be greater than 1).
No. 3. Return on invested capital: net income / long-term debt + shareholder equity (should be greater than 20%).
No. 4. Returns on net tangible assets: net income / net tangible assets (should be greater than 20%).
Thanks,
Kermit



Mon Jun 29, 2015 7:12 pm (PDT) . Posted by:

nelsonmuntz1000

Unfortunately, Yahoo has neglected to provide 1 year target price, beta, dividend and dividend yield in their download data since about mid March. Myself and others have repeatedly asked Yahoo to fix this issue since then, to no avail. They just seem to ignore any feedback they get.

As a workaround I have been using =RCHGetElementNumber("ticker",989)/Latest Price or alternatively =RCHGetElementNumber("ticker",990). Element 989 is YahooKS Dividend, element 990 is YahooKS Dividend Yield.


I prefer to use the first example because I keep my RCHGetElementNumber retrievals on a separate worksheet and usually update them weekly whereas I use =RCHGetYahooQuotes in array form on a different sheet to do daily updates. Yield will fluctuate based on price so I divide the dividend by the latest price to keep the yield up to date, assuming Yahoo is providing accurate data.


I wish Yahoo would just fix the issue. Here`s a link to the Yahoo "Suggestions" page:
https://yahoo.uservoice.com/forums/207809-finance-gs/category/68435-data-accuracy https://yahoo.uservoice.com/forums/207809-finance-gs/category/68435-data-accuracy
You don't have to look too far to find complaints about the problem. You can add your votes to the complaints or provide your own feedback, maybe Yahoo will do something to fix it but I'm not holding my breath.



For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
READ MORE....