Sabtu, 13 Desember 2014

[smf_addin] Digest Number 3266

10 Messages

Digest #3266

Messages

Fri Dec 12, 2014 5:49 am (PST) . Posted by:

DefelRadar

I second this fix of deleting the .exd file. It worked well for me with problems I was having but alas the advfn data is still an issue unfortunately.

Fri Dec 12, 2014 10:15 am (PST) . Posted by:

fincoolio

Randy,

Hi, been having trouble getting this to work:
=RCHGetTableCell("http://www.4-traders.com/ http://www.4-traders.com/"&D2&"/financials/",0,"Sales")



this doesn't work either:
=0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/"&d28&"/financials/",4,"Sales")," ","")



d28 could equal INTERNATIONAL-BUSINESS-MA-4828


however, this does work:
=0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/"&d28&"/financials/",4,"(EBITDA)")," ","")



any suggestions? spent 2 hours on this so far. thanks.

Fri Dec 12, 2014 11:28 am (PST) . Posted by:

"Randy Harmelink" rharmelink

"Sales" is not a good search term. It's not getting you to the table you
want, but is pointing you to this JavaScript code that is earlier on the
web page:

...4-traders.com","Million","Sales","Operating profit","...

Try something like this:

=smfConvertData(SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/"&D2&"/financials/",1,">Sales"),"
",""))

By the way, this might be a way to get the company tag they use in the URL
from a normal ticker symbol:

=smfstrExtr(smfGetTagContent("
http://www.4-traders.com/mods_a/search/findRapidSearch.php?objectName=GlobalSearch&addID=&null&company_name=
"&C2,"li",1),"/","/")

...where C2 contains something like "IBM" or "MMM".

On Fri, Dec 12, 2014 at 11:15 AM, scasty@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Hi, been having trouble getting this to work:
> =RCHGetTableCell("http://www.4-traders.com/"&D2&"/financials/",0,"Sales")
>
> this doesn't work either:
> =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/"&d28&"/financials/",4,"Sales"),"
> ","")
>
> d28 could equal INTERNATIONAL-BUSINESS-MA-4828
>
> however, this does work:
> =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/"&d28&"/financials/",4,"(EBITDA)"),"
> ","")
>
> any suggestions? spent 2 hours on this so far. thanks.
>

Fri Dec 12, 2014 4:17 pm (PST) . Posted by:

fincoolio

Randy, you're the man, thank you so much the help. Both formulas work great, the last one a nice extra bonus feature I didn't even think was possible to ask for.

Fri Dec 12, 2014 11:39 am (PST) . Posted by:

DefelRadar


Randy,

I know there are issues with ADVFN's site but I also noticed that RCHGetElementNumber functions for elements from smf-elements-0 which are the Piotroski scores. I'm assuming that the Piotroski scores are calculated from ADVFN values?

Thanks,

Aaron

Fri Dec 12, 2014 12:42 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

That is correct. The add-in retrieves data elements from AdvFN, and then
calculates the Piotroski score.

An alternative method would be to pick it up from GuruFocus, since they now
have it available -- for example:

=smfConvertData(smfstrExtr(RCHGetTableCell("
http://www.gurufocus.com/stock/MMM",0,"F-Score:"),":","~"))

That same web page has the Altman Z-Score and the Beneish M-Score.

On Fri, Dec 12, 2014 at 12:39 PM, defelradar@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I know there are issues with ADVFN's site but I also noticed that
> RCHGetElementNumber functions for elements from smf-elements-0 which are
> the Piotroski scores. I'm assuming that the Piotroski scores are
> calculated from ADVFN values?
>

Fri Dec 12, 2014 10:31 pm (PST) . Posted by:

zbgb952

Where can I find the Price/Funds From Operations for a stock? I see p/e , p/s, p/b everywhere but can't find p/ffo.

Randy..do you know where? Thanks.


Fri Dec 12, 2014 10:42 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I'm not familiar with that metric. Based on what I found using Google,
couldn't you just take the "Cash Flow from Operations" from the cash flow
statement and use the market capitalization for the price?

On Fri, Dec 12, 2014 at 11:31 PM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Where can I find the Price/Funds From Operations for a stock? I see p/e ,
> p/s, p/b everywhere but can't find p/ffo.
>
> Randy..do you know where? Thanks.
>

Fri Dec 12, 2014 11:11 pm (PST) . Posted by:

zbgb952

Randy, it is my understanding the p/ffo is a very important metric for evaluating stocks like REITs

here is an article you can read

http://seekingalpha.com/article/896161-the-price-ffo-metric-a-driving-force-of-outperformance http://seekingalpha.com/article/896161-the-price-ffo-metric-a-driving-force-of-outperformance

Again..I don't want to have to go digging through lots of reports for it...as i would need to have it calculated on a spreadsheet with many stock tickers..and along with other variables.


Also , I am sending this as a new item because Firefox 34 won't let me send a reply to your statement for some reason.

Sat Dec 13, 2014 1:06 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Well, if I use the market cap and cash from operations from year-end 2011
from GuruFocus, I get 12.6 for SUI and 5.5 for PEI. The article had 11.5
and 5.2 as the 9/2011 ratios.

I get current value of TTM ratios for SUI and PEI as 22.2 and 10.4.

Below is what I get for the REIT-Retail sector (based on U.S. tickers from
the Yahoo Industry browser). If you compute the P/FFO manually, are they
close to what you get?

Ticker Market Cap Oper Cash Flow (TTM)
Ratio CBL 3300 458 7.2 HPT 4600 452 10.2 PEI 1600 150 10.7 CDR 542.6 50
10.9 BRX 5900 490 12.0 BFS 1200 91 13.2 EPR 3200 244 13.1 TCO 4700 352
13.4 NRF 3900 283 13.8 RPT 1400 97 14.4 IRC 1100 74 14.9 UBA 724.3 49
14.8 RPAI 3800 260 14.6 DDR 6500 413 15.7 GRT 2000 126 15.9 O 10400 613
17.0 AAT 1700 100 17.0 WRI 4200 241 17.4 SKT 3500 199 17.6 KIM 10400 546
19.0 SPG 56100 2704 20.7 EQY 3100 144 21.5 REG 5800 268 21.6 GTY 594.5
27 22.0 GGP 24000 1090 22.0 ALX 2100 86 24.4 SLG 11600 453 25.6 ROIC
1500 57 26.3 FRT 8900 330 27.0 MAC 11300 390 29.0 TSRE 284.8 9 31.6 KRG
2300 26 88.5

Here's what I used to pull Market Cap and Operating Cash Flow (TTM) from
MorningStar:

=smfConvertData(smfGetTagContent("
http://quotes.morningstar.com/stock/c-header?t=
"&$C23,"span",0,"id=""MarketCap"""))/1000000

=smfConvertData(smfstrExtr(RCHGetWebData("
http://financials.morningstar.com/financials/getFinancePart.html?t="&$C23,"""Y10
i9\""",20),">","<"))

...where $C23 held the ticker symbol.

On Sat, Dec 13, 2014 at 12:11 AM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Randy, it is my understanding the p/ffo is a very important metric for
> evaluating stocks like REITs
>
> here is an article you can read
>
>
> http://seekingalpha.com/article/896161-the-price-ffo-metric-a-driving-force-of-outperformance
>
> Again..I don't want to have to go digging through lots of reports for
> it...as i would need to have it calculated on a spreadsheet with many stock
> tickers..and along with other variables.
>
> Also , I am sending this as a new item because Firefox 34 won't let me
> send a reply to your statement for some reason.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar