Rabu, 04 Februari 2015

[smf_addin] Digest Number 3312

12 Messages

Digest #3312

Messages

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

soemoe.theinwin

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.

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.
>

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

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?
>
>

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



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.
>

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...

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>

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.

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

mff2805

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

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?
>

Tue Feb 3, 2015 8:54 pm (PST) . Posted by:

manish_sahajwani

Hello,


I am looking for a good excel-based stock screener. Do you know of any place from where I can download a stock screener?


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

Tidak ada komentar:

Posting Komentar