3 Messages
Digest #3314
Messages
Thu Feb 5, 2015 9:07 am (PST) . Posted by:
"malli Boggala" malli.boggala
Thanks a lot, It's working fine.
Regards,Malli B
On Monday, February 2, 2015 4:47 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
That's because you're using a bad search string. The function will key off the first occurrence of that string it finds. In the case of "PFCF", there are nearly a dozen before that table entry, because it's used as part of HTML tag processing. That's why I usually use the ">" trick, but it can ONLY be used if the web page is written that way. It may be necessary to look at the source code of the web page to come up with good search strings. For example, this works:
=RCHGetTableCell("http://www.gurufocus.com/stock/"&B4,1,">PFCF")
Have you looked that the GuruFocus model/template that another add-in user has uploaded to the "Uploads by Forum Members" folder of the FILES area of the Yahoo group? You could save yourself a lot of work...
On Mon, Feb 2, 2015 at 12:42 PM, malli Boggala malli.boggala@...wrote:
I'm trying to access data form Gurufocus using below formula, bust cell is empty, not pulling any data. RCHGetTableCell("http://www.gurufocus.com/stock/"&A5&"",1,"PFCF")
But seems some other data working fine like RCHGetTableCell("http://www.gurufocus.com/stock/"&A5&"",1,"ROIC")
would you pls. help me.Thanks in advance.
#yiv9508619048 #yiv9508619048 -- #yiv9508619048ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9508619048 #yiv9508619048ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9508619048 #yiv9508619048ygrp-mkp #yiv9508619048hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9508619048 #yiv9508619048ygrp-mkp #yiv9508619048ads {margin-bottom:10px;}#yiv9508619048 #yiv9508619048ygrp-mkp .yiv9508619048ad {padding:0 0;}#yiv9508619048 #yiv9508619048ygrp-mkp .yiv9508619048ad p {margin:0;}#yiv9508619048 #yiv9508619048ygrp-mkp .yiv9508619048ad a {color:#0000ff;text-decoration:none;}#yiv9508619048 #yiv9508619048ygrp-sponsor #yiv9508619048ygrp-lc {font-family:Arial;}#yiv9508619048 #yiv9508619048ygrp-sponsor #yiv9508619048ygrp-lc #yiv9508619048hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9508619048 #yiv9508619048ygrp-sponsor #yiv9508619048ygrp-lc .yiv9508619048ad {margin-bottom:10px;padding:0 0;}#yiv9508619048 #yiv9508619048actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9508619048 #yiv9508619048activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9508619048 #yiv9508619048activity span {font-weight:700;}#yiv9508619048 #yiv9508619048activity span:first-child {text-transform:uppercase;}#yiv9508619048 #yiv9508619048activity span a {color:#5085b6;text-decoration:none;}#yiv9508619048 #yiv9508619048activity span span {color:#ff7900;}#yiv9508619048 #yiv9508619048activity span .yiv9508619048underline {text-decoration:underline;}#yiv9508619048 .yiv9508619048attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9508619048 .yiv9508619048attach div a {text-decoration:none;}#yiv9508619048 .yiv9508619048attach img {border:none;padding-right:5px;}#yiv9508619048 .yiv9508619048attach label {display:block;margin-bottom:5px;}#yiv9508619048 .yiv9508619048attach label a {text-decoration:none;}#yiv9508619048 blockquote {margin:0 0 0 4px;}#yiv9508619048 .yiv9508619048bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9508619048 .yiv9508619048bold a {text-decoration:none;}#yiv9508619048 dd.yiv9508619048last p a {font-family:Verdana;font-weight:700;}#yiv9508619048 dd.yiv9508619048last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9508619048 dd.yiv9508619048last p span.yiv9508619048yshortcuts {margin-right:0;}#yiv9508619048 div.yiv9508619048attach-table div div a {text-decoration:none;}#yiv9508619048 div.yiv9508619048attach-table {width:400px;}#yiv9508619048 div.yiv9508619048file-title a, #yiv9508619048 div.yiv9508619048file-title a:active, #yiv9508619048 div.yiv9508619048file-title a:hover, #yiv9508619048 div.yiv9508619048file-title a:visited {text-decoration:none;}#yiv9508619048 div.yiv9508619048photo-title a, #yiv9508619048 div.yiv9508619048photo-title a:active, #yiv9508619048 div.yiv9508619048photo-title a:hover, #yiv9508619048 div.yiv9508619048photo-title a:visited {text-decoration:none;}#yiv9508619048 div#yiv9508619048ygrp-mlmsg #yiv9508619048ygrp-msg p a span.yiv9508619048yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9508619048 .yiv9508619048green {color:#628c2a;}#yiv9508619048 .yiv9508619048MsoNormal {margin:0 0 0 0;}#yiv9508619048 o {font-size:0;}#yiv9508619048 #yiv9508619048photos div {float:left;width:72px;}#yiv9508619048 #yiv9508619048photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9508619048 #yiv9508619048photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9508619048 #yiv9508619048reco-category {font-size:77%;}#yiv9508619048 #yiv9508619048reco-desc {font-size:77%;}#yiv9508619048 .yiv9508619048replbq {margin:4px;}#yiv9508619048 #yiv9508619048ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9508619048 #yiv9508619048ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9508619048 #yiv9508619048ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9508619048 #yiv9508619048ygrp-mlmsg select, #yiv9508619048 input, #yiv9508619048 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9508619048 #yiv9508619048ygrp-mlmsg pre, #yiv9508619048 code {font:115% monospace;}#yiv9508619048 #yiv9508619048ygrp-mlmsg * {line-height:1.22em;}#yiv9508619048 #yiv9508619048ygrp-mlmsg #yiv9508619048logo {padding-bottom:10px;}#yiv9508619048 #yiv9508619048ygrp-msg p a {font-family:Verdana;}#yiv9508619048 #yiv9508619048ygrp-msg p#yiv9508619048attach-count span {color:#1E66AE;font-weight:700;}#yiv9508619048 #yiv9508619048ygrp-reco #yiv9508619048reco-head {color:#ff7900;font-weight:700;}#yiv9508619048 #yiv9508619048ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9508619048 #yiv9508619048ygrp-sponsor #yiv9508619048ov li a {font-size:130%;text-decoration:none;}#yiv9508619048 #yiv9508619048ygrp-sponsor #yiv9508619048ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9508619048 #yiv9508619048ygrp-sponsor #yiv9508619048ov ul {margin:0;padding:0 0 0 8px;}#yiv9508619048 #yiv9508619048ygrp-text {font-family:Georgia;}#yiv9508619048 #yiv9508619048ygrp-text p {margin:0 0 1em 0;}#yiv9508619048 #yiv9508619048ygrp-text tt {font-size:120%;}#yiv9508619048 #yiv9508619048ygrp-vital ul li:last-child {border-right:none !important;}#yiv9508619048
Regards,Malli B
On Monday, February 2, 2015 4:47 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
That's because you're using a bad search string. The function will key off the first occurrence of that string it finds. In the case of "PFCF", there are nearly a dozen before that table entry, because it's used as part of HTML tag processing. That's why I usually use the ">" trick, but it can ONLY be used if the web page is written that way. It may be necessary to look at the source code of the web page to come up with good search strings. For example, this works:
=RCHGetTableCell("http://www.gurufocus.com/stock/"&B4,1,">PFCF")
Have you looked that the GuruFocus model/template that another add-in user has uploaded to the "Uploads by Forum Members" folder of the FILES area of the Yahoo group? You could save yourself a lot of work...
On Mon, Feb 2, 2015 at 12:42 PM, malli Boggala malli.boggala@...wrote:
I'm trying to access data form Gurufocus using below formula, bust cell is empty, not pulling any data. RCHGetTableCell("http://www.gurufocus.com/stock/"&A5&"",1,"PFCF")
But seems some other data working fine like RCHGetTableCell("http://www.gurufocus.com/stock/"&A5&"
would you pls. help me.Thanks in advance.
#yiv9508619048 #yiv9508619048 -- #yiv9508619048ygrp-
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 : 10 Year financial data from GuruFocus, saved for Excel 2003. Please check for errors
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>
Thu Feb 5, 2015 9:18 am (PST) . Posted by:
hamishthedenizen
I included Randy's fix at the bottom of the updated GuruFocus model (2003)
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar