Rabu, 13 Mei 2015

[smf_addin] Digest Number 3406

12 Messages

Digest #3406
1a
Re: Investors.com data pull issues by "Brad Reel" reeldeal9090
1d
Re: Investors.com data pull issues by "Randy Harmelink" rharmelink
1e
Re: Investors.com data pull issues by "Brad Reel" reeldeal9090
2a
Retrieving data from Gurufocus.com by "Guy Lanfarm" guylanfarm
2b
Re: Retrieving data from Gurufocus.com by "Randy Harmelink" rharmelink
2c
Re: Retrieving data from Gurufocus.com by "Guy Lanfarm" guylanfarm
2d
Re: Retrieving data from Gurufocus.com by "Randy Harmelink" rharmelink
3a
Re: Tourist FX Rates by "Randy Harmelink" rharmelink
4b
Re: Google Element Number Errors by "Randy Harmelink" rharmelink

Messages

Tue May 12, 2015 3:25 am (PDT) . Posted by:

"Brad Reel" reeldeal9090

Thanks, Randy. Wanted some sort of confirmation that it wasn't on my
side. I'll work on it over the next few days and see if I can post updates
for what I pull.

On Mon, May 11, 2015 at 11:17 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> It looks like they've changed the URLs and content of various web pages. I
> can't make corrections because my version of IE can't access their web
> pages any more.
>
> On Mon, May 11, 2015 at 8:52 PM, brad.reel@yahoo.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>> Anyone else seeing issues with investors.com website? I am having
>> problems this evening pulling any data. For some reason I got logged out
>> of the web query (that has never happened) and now my data pulls are
>> erroring. I'm not sure if it is a one off event or if aynone else has seen
>> issues tonight or in the last couple of days. Feedback appreciated!
>>
>>
>
>

Tue May 12, 2015 1:50 pm (PDT) . Posted by:

"Bryan" ilmostro

Hopefully someone can update the add-in.
It looks like they added the "exchange" a stock is listed in the url's.
Here is a nasdaq listed stock:
http://research.investors.com/stock-checkup/nasdaq-skyworks-solutions-inc-swks.aspx
And here is a AMEX listed stock:
http://research.investors.com/quotes/amex-libbey-inc-lby.htm?fromsearch=1

I have come to rely on the add-in and would like it to start working for
the stock checkup again.
The quote pages haven't changed so I can still pull info from them with the
add-in.

Thanks for any help from anybody,
Bryan

On Mon, May 11, 2015 at 11:17 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> It looks like they've changed the URLs and content of various web pages. I
> can't make corrections because my version of IE can't access their web
> pages any more.
>
> On Mon, May 11, 2015 at 8:52 PM, brad.reel@yahoo.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>> Anyone else seeing issues with investors.com website? I am having
>> problems this evening pulling any data. For some reason I got logged out
>> of the web query (that has never happened) and now my data pulls are
>> erroring. I'm not sure if it is a one off event or if aynone else has seen
>> issues tonight or in the last couple of days. Feedback appreciated!
>>
>>
>
>

Tue May 12, 2015 1:52 pm (PDT) . Posted by:

"Bryan" ilmostro

oops here is the stock checkup url for LBY:
http://research.investors.com/stock-checkup/amex-libbey-inc-lby.aspx

On Tue, May 12, 2015 at 3:50 PM, Bryan <ilmostrobtw@gmail.com> wrote:

> Hopefully someone can update the add-in.
> It looks like they added the "exchange" a stock is listed in the url's.
> Here is a nasdaq listed stock:
>
> http://research.investors.com/stock-checkup/nasdaq-skyworks-solutions-inc-swks.aspx
> And here is a AMEX listed stock:
> http://research.investors.com/quotes/amex-libbey-inc-lby.htm?fromsearch=1
>
> I have come to rely on the add-in and would like it to start working for
> the stock checkup again.
> The quote pages haven't changed so I can still pull info from them with
> the add-in.
>
> Thanks for any help from anybody,
> Bryan
>
> On Mon, May 11, 2015 at 11:17 PM, Randy Harmelink rharmelink@gmail.com
> [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>>
>>
>> It looks like they've changed the URLs and content of various web pages.
>> I can't make corrections because my version of IE can't access their web
>> pages any more.
>>
>> On Mon, May 11, 2015 at 8:52 PM, brad.reel@yahoo.com [smf_addin] <
>> smf_addin@yahoogroups.com> wrote:
>>
>>> Anyone else seeing issues with investors.com website? I am having
>>> problems this evening pulling any data. For some reason I got logged out
>>> of the web query (that has never happened) and now my data pulls are
>>> erroring. I'm not sure if it is a one off event or if aynone else has seen
>>> issues tonight or in the last couple of days. Feedback appreciated!
>>>
>>>
>>
>>
>
>

Tue May 12, 2015 4:13 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's not a matter of updating the add-in.

For me, I can no longer create an IE security cookie, because they don't
support my old copy of IE.

It looks to me like the RCHGetTableCell-Template-IBD-Stock-Checkup.xls
template needs the following changes:

B3: =smfstrExtr(RCHGetWebData("
http://www.investors.com/search/searchresults.aspx?Ntt=
"&B2,"/quotes/"),"/quotes/",".htm")

B4: ="http://research.investors.com/stock-checkup/"&B3&".aspx"

...but I can't test the changes because I can't create the necessary
security cookie.

On Tue, May 12, 2015 at 1:50 PM, Bryan ilmostrobtw@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hopefully someone can update the add-in.
> It looks like they added the "exchange" a stock is listed in the url's.
> Here is a nasdaq listed stock:
>
> http://research.investors.com/stock-checkup/nasdaq-skyworks-solutions-inc-swks.aspx
> And here is a AMEX listed stock:
> http://research.investors.com/quotes/amex-libbey-inc-lby.htm?fromsearch=1
>
> I have come to rely on the add-in and would like it to start working for
> the stock checkup again.
> The quote pages haven't changed so I can still pull info from them with
> the add-in.
>
>

Tue May 12, 2015 9:32 pm (PDT) . Posted by:

"Brad Reel" reeldeal9090

Randy, I just tested your changes and they worked fine. When I updated
those two fields everything else I use from IBD tested fine. I have my own
custom built sheet, so I cannot confirm that everything on the template
will work, but I suspect everything will be fine.

I was not going to be able to dig into it until the weekend, so thanks much
for knocking it out. As always, very much appreciated.

On Tue, May 12, 2015 at 6:13 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> It's not a matter of updating the add-in.
>
> For me, I can no longer create an IE security cookie, because they don't
> support my old copy of IE.
>
> It looks to me like the RCHGetTableCell-Template-IBD-Stock-Checkup.xls
> template needs the following changes:
>
> B3: =smfstrExtr(RCHGetWebData("
> http://www.investors.com/search/searchresults.aspx?Ntt=
> "&B2,"/quotes/"),"/quotes/",".htm")
>
> B4: ="http://research.investors.com/stock-checkup/"&B3&".aspx"
>
> ...but I can't test the changes because I can't create the necessary
> security cookie.
>
> On Tue, May 12, 2015 at 1:50 PM, Bryan ilmostrobtw@gmail.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>>
>> Hopefully someone can update the add-in.
>> It looks like they added the "exchange" a stock is listed in the url's.
>> Here is a nasdaq listed stock:
>>
>> http://research.investors.com/stock-checkup/nasdaq-skyworks-solutions-inc-swks.aspx
>> And here is a AMEX listed stock:
>> http://research.investors.com/quotes/amex-libbey-inc-lby.htm?fromsearch=1
>>
>> I have come to rely on the add-in and would like it to start working for
>> the stock checkup again.
>> The quote pages haven't changed so I can still pull info from them with
>> the add-in.
>>
>>
>
>

Tue May 12, 2015 9:18 am (PDT) . Posted by:

"Guy Lanfarm" guylanfarm

I wrote the following string to retrieve the "TTM" (trailing-twelve month) figure for Cisco's "EV-to-EBITDA".
=RCHGetTableCell("http://www.gurufocus.com/financials/CSCO",12,"treasury","","","",52,"</BODY",10000,"",1)

The result that is generated is the literal string "EV-to-EBIT", wheras the numeric datapoint is 4.70.
What am I doing wrong?

Tue May 12, 2015 10:46 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Those are some parameters you're using. "treasury" is not really a good
search term, since it's one that can easily show up as text on the web
page, or as a class, or an id, whatever. And skip 52 rows? How can you be
sure every web page will have all the same rows? They might skip some or
add some depending on the security. I'm not even sure what the 10000 for
the Look# parameter would do. And the pType parameter or 1? That's an
experimental value, not to be considered reliable.

I'd go with more specific search terms, getting right to the data, as in:

=RCHGetTableCell("http://www.gurufocus.com/financials/CSCO
",0,"/term/ev2ebitda/","yesttm")

In any case, the reason

On Tue, May 12, 2015 at 8:54 AM, Guy Lanfarm guylanfarm@...wrote:

>
> I wrote the following string to retrieve the "TTM" (trailing-twelve month)
> figure for Cisco's "EV-to-EBITDA".
>
> =RCHGetTableCell("http://www.gurufocus.com/financials/CSCO
> ",12,"treasury","","","",52,"</BODY",10000,"",1)
>
> The result that is generated is the literal string "EV-to-EBIT", wheras
> the numeric datapoint is 4.70.
>
> What am I doing wrong?
>

Tue May 12, 2015 11:25 am (PDT) . Posted by:

"Guy Lanfarm" guylanfarm

I tried your string. It gave me an "ERROR".

On Tuesday, May 12, 2015 1:47 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  Those are some parameters you're using. "treasury" is not really a good search term, since it's one that can easily show up as text on the web page, or as a class, or an id, whatever. And skip 52 rows? How can you be sure every web page will have all the same rows? They might skip some or add some depending on the security. I'm not even sure what the 10000 for the Look# parameter would do. And the pType parameter or 1? That's an experimental value, not to be considered reliable.

I'd go with more specific search terms, getting right to the data, as in:

=RCHGetTableCell("http://www.gurufocus.com/financials/CSCO",0,"/term/ev2ebitda/","yesttm")

In any case, the reason

On Tue, May 12, 2015 at 8:54 AM, Guy Lanfarm guylanfarm@...wrote:

I wrote the following string to retrieve the "TTM" (trailing-twelve month) figure for Cisco's "EV-to-EBITDA".
=RCHGetTableCell("http://www.gurufocus.com/financials/CSCO",12,"treasury","","","",52,"</BODY",10000,"",1)

The result that is generated is the literal string "EV-to-EBIT", wheras the numeric datapoint is 4.70.
What am I doing wrong?

#yiv0107256322 #yiv0107256322 -- #yiv0107256322ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0107256322 #yiv0107256322ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0107256322 #yiv0107256322ygrp-mkp #yiv0107256322hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0107256322 #yiv0107256322ygrp-mkp #yiv0107256322ads {margin-bottom:10px;}#yiv0107256322 #yiv0107256322ygrp-mkp .yiv0107256322ad {padding:0 0;}#yiv0107256322 #yiv0107256322ygrp-mkp .yiv0107256322ad p {margin:0;}#yiv0107256322 #yiv0107256322ygrp-mkp .yiv0107256322ad a {color:#0000ff;text-decoration:none;}#yiv0107256322 #yiv0107256322ygrp-sponsor #yiv0107256322ygrp-lc {font-family:Arial;}#yiv0107256322 #yiv0107256322ygrp-sponsor #yiv0107256322ygrp-lc #yiv0107256322hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0107256322 #yiv0107256322ygrp-sponsor #yiv0107256322ygrp-lc .yiv0107256322ad {margin-bottom:10px;padding:0 0;}#yiv0107256322 #yiv0107256322actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0107256322 #yiv0107256322activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0107256322 #yiv0107256322activity span {font-weight:700;}#yiv0107256322 #yiv0107256322activity span:first-child {text-transform:uppercase;}#yiv0107256322 #yiv0107256322activity span a {color:#5085b6;text-decoration:none;}#yiv0107256322 #yiv0107256322activity span span {color:#ff7900;}#yiv0107256322 #yiv0107256322activity span .yiv0107256322underline {text-decoration:underline;}#yiv0107256322 .yiv0107256322attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0107256322 .yiv0107256322attach div a {text-decoration:none;}#yiv0107256322 .yiv0107256322attach img {border:none;padding-right:5px;}#yiv0107256322 .yiv0107256322attach label {display:block;margin-bottom:5px;}#yiv0107256322 .yiv0107256322attach label a {text-decoration:none;}#yiv0107256322 blockquote {margin:0 0 0 4px;}#yiv0107256322 .yiv0107256322bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0107256322 .yiv0107256322bold a {text-decoration:none;}#yiv0107256322 dd.yiv0107256322last p a {font-family:Verdana;font-weight:700;}#yiv0107256322 dd.yiv0107256322last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0107256322 dd.yiv0107256322last p span.yiv0107256322yshortcuts {margin-right:0;}#yiv0107256322 div.yiv0107256322attach-table div div a {text-decoration:none;}#yiv0107256322 div.yiv0107256322attach-table {width:400px;}#yiv0107256322 div.yiv0107256322file-title a, #yiv0107256322 div.yiv0107256322file-title a:active, #yiv0107256322 div.yiv0107256322file-title a:hover, #yiv0107256322 div.yiv0107256322file-title a:visited {text-decoration:none;}#yiv0107256322 div.yiv0107256322photo-title a, #yiv0107256322 div.yiv0107256322photo-title a:active, #yiv0107256322 div.yiv0107256322photo-title a:hover, #yiv0107256322 div.yiv0107256322photo-title a:visited {text-decoration:none;}#yiv0107256322 div#yiv0107256322ygrp-mlmsg #yiv0107256322ygrp-msg p a span.yiv0107256322yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0107256322 .yiv0107256322green {color:#628c2a;}#yiv0107256322 .yiv0107256322MsoNormal {margin:0 0 0 0;}#yiv0107256322 o {font-size:0;}#yiv0107256322 #yiv0107256322photos div {float:left;width:72px;}#yiv0107256322 #yiv0107256322photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0107256322 #yiv0107256322photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0107256322 #yiv0107256322reco-category {font-size:77%;}#yiv0107256322 #yiv0107256322reco-desc {font-size:77%;}#yiv0107256322 .yiv0107256322replbq {margin:4px;}#yiv0107256322 #yiv0107256322ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0107256322 #yiv0107256322ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0107256322 #yiv0107256322ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0107256322 #yiv0107256322ygrp-mlmsg select, #yiv0107256322 input, #yiv0107256322 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0107256322 #yiv0107256322ygrp-mlmsg pre, #yiv0107256322 code {font:115% monospace;}#yiv0107256322 #yiv0107256322ygrp-mlmsg * {line-height:1.22em;}#yiv0107256322 #yiv0107256322ygrp-mlmsg #yiv0107256322logo {padding-bottom:10px;}#yiv0107256322 #yiv0107256322ygrp-msg p a {font-family:Verdana;}#yiv0107256322 #yiv0107256322ygrp-msg p#yiv0107256322attach-count span {color:#1E66AE;font-weight:700;}#yiv0107256322 #yiv0107256322ygrp-reco #yiv0107256322reco-head {color:#ff7900;font-weight:700;}#yiv0107256322 #yiv0107256322ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0107256322 #yiv0107256322ygrp-sponsor #yiv0107256322ov li a {font-size:130%;text-decoration:none;}#yiv0107256322 #yiv0107256322ygrp-sponsor #yiv0107256322ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0107256322 #yiv0107256322ygrp-sponsor #yiv0107256322ov ul {margin:0;padding:0 0 0 8px;}#yiv0107256322 #yiv0107256322ygrp-text {font-family:Georgia;}#yiv0107256322 #yiv0107256322ygrp-text p {margin:0 0 1em 0;}#yiv0107256322 #yiv0107256322ygrp-text tt {font-size:120%;}#yiv0107256322 #yiv0107256322ygrp-vital ul li:last-child {border-right:none !important;}#yiv0107256322

Tue May 12, 2015 4:09 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not sure what to tell you. I just cut and pasted it from the message and it
worked fine for me. I wonder if I get different web page strings because
I'm a subscriber?

On Tue, May 12, 2015 at 11:22 AM, Guy Lanfarm guylanfarm@...wrote:

>
> I tried your string. It gave me an "ERROR".
>
> On Tuesday, May 12, 2015 1:47 PM, "Randy Harmelink rharmelink@...
> <rharmelink@gmail.com> wrote:
>
> I'd go with more specific search terms, getting right to the data, as in:
>
> =RCHGetTableCell("http://www.gurufocus.com/financials/CSCO
> ",0,"/term/ev2ebitda/","yesttm")
>

Tue May 12, 2015 10:58 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The data isn't in an HTML table, so RCHGetTableCell() won't be able to
extract it.

Try this:

=smfConvertData(smfGetTagContent("http://www.travelfx.co.uk/","div",-2,">Buy
Euros"))

On Tue, May 12, 2015 at 2:05 AM, Philip_R_Small@... wrote:

> I was looking to see if I can get data on currencies from the following
> site:
>
> http://www.travelfx.co.uk/
>
> I tried the following to get the GBP-Euro rate:
> =RCHGetTableCell("http://www.travelfx.co.uk/",1,"Popular
> currencies",,,,1,,) but jsut get "Error". Is there a better solution?
>

Tue May 12, 2015 2:07 pm (PDT) . Posted by:

bozzboy1

Hi

For certain tickers (such as Lockheed Martin "LMT") I keep getting errors for element numbers 3830, 3782, 3674, 3662, 3734, 3896, 3860, 3897, 3903, 3926, 3932. I think these are all Google links.


Also Morningstar elements 14388 - 14397 don't seem to work for me for financial companies.


Any ideas? They seem to work for most tickers, but not sure if there's a different address for certain companies?


Any help massively appreciated! As an aside is there anywhere we can donate? Truly one of the best resources I've come across on the internet.

Tue May 12, 2015 4:23 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

For Google, it appears you need the exchange definition on the LMT ticker
symbol. So the ticker symbol would need to be NYSE:LMT.

MorningStar has this message on their website:

"We're sorry, but we do not yet have 10-year data for companies in the
Financial Services sector. We hope to have this data available on
Morningstar.com soon."

I ask that people "pay it forward" and give that donation to a worthy
charity. Thanks for the thought.

On Tue, May 12, 2015 at 2:07 PM, bozzboy1@... wrote:

>
> For certain tickers (such as Lockheed Martin "LMT") I keep getting errors
> for element numbers 3830, 3782, 3674, 3662, 3734, 3896, 3860, 3897, 3903,
> 3926, 3932. I think these are all Google links.
>
> Also Morningstar elements 14388 - 14397 don't seem to work for me for financial
> companies.
>
> Any ideas? They seem to work for most tickers, but not sure if there's a
> different address for certain companies?
>
> Any help massively appreciated! As an aside is there anywhere we can
> donate? Truly one of the best resources I've come across on the internet.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar