Hi,

I stumbled across this group and think the work is incredible.

I have been using the "10 year Model - Gurufocus - All Types (2003)" xls but so far in testing, it only picks up US listed assets. I'd like to use this for European and Asia listed stocks. Is this possible? I have a GF subscription which allows me to access these markets.

Many thanks in advance.

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

1b

Re: Gurufocus Non US Listed Stocks

Tue Feb 3, 2015 3:40 am (PST) . Posted by:

"Randy Harmelink" rharmelink

How about a few sample ticker symbols?

If you have a subscription, isn't the 15-year XLS file easier to use?

On Tue, Feb 3, 2015 at 4:29 AM, soemoe.theinwin@... wrote:

>
> I stumbled across this group and think the work is incredible.
>
> I have been using the "10 year Model - Gurufocus - All Types (2003)" xls
> but so far in testing, it only picks up US listed assets. I'd like to use
> this for European and Asia listed stocks. Is this possible? I have a GF
> subscription which allows me to access these markets.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

1c

Re: Gurufocus Non US Listed Stocks

Tue Feb 3, 2015 5:32 am (PST) . Posted by:

soemoe.theinwin

Hi - I tried BMW, LVMH, VW, GSK - none worked?

I didn't know there was a 15 year version..where would I find that?

Cheers

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

1d

Re: Gurufocus Non US Listed Stocks

Tue Feb 3, 2015 5:40 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Oops. I don't have a global membership, so I can't try them. Sorry.

You do know you none of those ticker symbols would get you to a non-US
traded company though, right? You would need to use the appropriate prefix.

The 15-year download file is the "Data Download" link on the web page of
the company on GuruFocus.

On Tue, Feb 3, 2015 at 6:32 AM, soemoe.theinwin@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hi - I tried BMW, LVMH, VW, GSK - none worked?
>
> I didn't know there was a 15 year version..where would I find that?
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

1e

Re: Gurufocus Non US Listed Stocks

Tue Feb 3, 2015 6:48 am (PST) . Posted by:

hamishthedenizen

I don't have a subscription either, but here's an educated guess:
Search for the stock you're looking for on gurufocus, and then go to the page. Look at the URL. For VW, I saw:
Volkswagen AG (XTER:VOW) Stock Analysis - GuruFocus.com http://www.gurufocus.com/stock/XTER:VOW
I'm guessing if you use XTER:VOW in the symbol box of the spreadsheet that it will work. But no guarantees.

A couple of things - I built the sheet to pull some data from Yahoo (last price, and company description). Yahoo uses different ticker conventions that GuruFocus, so that won't work for you. You can probably code around it.

Randy - I completely suck at this stuff, how would you pick up price and business description off the standard US GuruFocus page? I'll update the model accordingly if you can help out.

Thanks

Volkswagen AG (XTER:VOW) Stock Analysis - GuruFocus.com http://www.gurufocus.com/stock/XTER:VOW Please enter Portfolio Name for new portfolio.

View on www.gurufocus.com http://www.gurufocus.com/stock/XTER:VOW
Preview by Yahoo

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

1f

Re: Gurufocus Non US Listed Stocks

Tue Feb 3, 2015 7:13 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Try something like:

=smfConvertData(smfGetTagContent("http://www.gurufocus.com/stock/
"&$C7,"font",1,"stock_header_price"))
=RCHGetTableCell("http://www.gurufocus.com/stock/"&$C7,0,">Business
Description","colspan=2")

On Tue, Feb 3, 2015 at 7:48 AM, dan-carroll@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> A couple of things - I built the sheet to pull some data from Yahoo (last
> price, and company description). Yahoo uses different ticker conventions
> that GuruFocus, so that won't work for you. You can probably code around it.
>
> Randy - I completely suck at this stuff, how would you pick up price and
> business description off the standard US GuruFocus page? I'll update the
> model accordingly if you can help out.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

1g

Re: Gurufocus Non US Listed Stocks

Tue Feb 3, 2015 9:25 am (PST) . Posted by:

hamishthedenizen

Thanks Randy. Updated the file and uploaded it. Works for US stocks but can't test it for overseas. LMK if it works...

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

2.1 New file uploaded to smf_addin

Tue Feb 3, 2015 8:21 am (PST) . Posted by:

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Uploads by forum members/10 year model - GuruFocus - All Types (2003).xls
Uploaded by : hamishthedenizen <dan-carroll@yahoo.com>
Description : Converted template model to Excel 2003...please LMK if any issues

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/10%20year%20model%20-%20GuruFocus%20-%20All%20Types%20%282003%29.xls

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

hamishthedenizen <dan-carroll@yahoo.com>

Reply to sender . Reply to group . Reply via Web Post . All Messages (70) . Top ^

3 Rate Explorer Workbook

Tue Feb 3, 2015 2:01 pm (PST) . Posted by:

bobsledproductions

Just finished up a workbook that allows you to look at / explore interest rates and their relationships to each other. Data comes from QUANDL. It provides the ability to make some interesting observations:

- Prime (which HELOC's are typically tied to) vs 30 Year Fixed - which may help identify when to re-finance
- Relationship between 10 Year CMT (constant maturity treasury) and 30 year fixed which appears to follow the 10 year
- Comparison between different loan options (car, personal, credit card)
- Comparison between different saving rates

and so on.

Instructions, link to download in the following:

Rate Explorer | The Toteboard @Toteboard.net http://toteboard.net/blog/workbooks/rate-explorer/

http://toteboard.net/blog/workbooks/rate-explorer/

Rate Explorer | The Toteboard @Toteboard.net http://toteboard.net/blog/workbooks/rate-explorer/ Functionality Overview

View on toteboard.net http://toteboard.net/blog/workbooks/rate-explorer/
Preview by Yahoo

Let me know your thoughts.

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

4a

Re: excel - not responding - what can i do

Tue Feb 3, 2015 5:51 pm (PST) . Posted by:

mff2805

thanks,
on the Navellier template, how can one get the company profile text?

Reply to sender . Reply to group . Reply via Web Post . All Messages (10) . Top ^

4b

Re: excel - not responding - what can i do

Tue Feb 3, 2015 6:01 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Try something like:

=smfGetTagContent("
http://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?q="&Ticker,"p",1,">Company
Profile")

On Tue, Feb 3, 2015 at 6:51 PM, mff3429@... wrote:

>
> on the Navellier template, how can one get the company profile text?
>