5 Messages
Digest #3229
Messages
Sun Nov 2, 2014 5:06 am (PST) . Posted by:
dsellari
The recalculate does not work properly. It winds up deleting all data gotten up to that point.
Sun Nov 2, 2014 5:31 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The recalculate statements are EXCEL processes being called by the add-in.
It wouldn't do any good to comment them out. If the EXCEL recalculate
process isn't working, you've got serious problems.
Give me a better idea of what you mean by "deleting all data"...
If I had to hazard a guess, I'd suggest maybe location errors. Can you copy
and paste a cell's formula where the data is being deleted, to show me what
it looks like?
On Sun, Nov 2, 2014 at 6:06 AM, don@cemero.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> The recalculate does not work properly. It winds up deleting all data
> gotten up to that point.
>
It wouldn't do any good to comment them out. If the EXCEL recalculate
process isn't working, you've got serious problems.
Give me a better idea of what you mean by "deleting all data"...
If I had to hazard a guess, I'd suggest maybe location errors. Can you copy
and paste a cell's formula where the data is being deleted, to show me what
it looks like?
On Sun, Nov 2, 2014 at 6:06 AM, don@cemero.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> The recalculate does not work properly. It winds up deleting all data
> gotten up to that point.
>
Sun Nov 2, 2014 7:00 am (PST) . Posted by:
jspattavina
How to use RCHGetTableCell to get Direct Competitor Comparison from Yahoo.
I can get the Market Cap Data using =RCHGetTableCell("https://finance.yahoo.com/q/co?s=IBM+Competitors",1,"Market Cap:"). But I cannot get the company names in the row above?
Any help?
Regards,
Jeffrey Pattavina
860-343-0482
jspattavina@comcast.net
I can get the Market Cap Data using =RCHGetTableCell("https://finance.yahoo.com/q/co?s=IBM+Competitors",1,"Market Cap:"). But I cannot get the company names in the row above?
Any help?
Regards,
Jeffrey Pattavina
860-343-0482
jspattavina@comcast.net
Sun Nov 2, 2014 7:28 am (PST) . Posted by:
rharmelink
Found by searching the Yahoo group message archives for "Yahoo Competitors":
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/21029
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/6974
---In smf_addin@yahoogroups.com, <jspattavina@...> wrote :
How to use RCHGetTableCell to get Direct Competitor Comparison from Yahoo.
I can get the Market Cap Data using =RCHGetTableCell("https://finance.yahoo.com/q/co?s=IBM+Competitors",1,"Market Cap:"). But I cannot get the company names in the row above?
Any help?
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/21029
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/6974
---In smf_addin@yahoogroups.com, <jspattavina@...> wrote :
How to use RCHGetTableCell to get Direct Competitor Comparison from Yahoo.
I can get the Market Cap Data using =RCHGetTableCell("https://finance.yahoo.com/q/co?s=IBM+Competitors",1,"
Any help?
Sun Nov 2, 2014 9:30 am (PST) . Posted by:
"T Shepherd" tonybshepherd
Hi Randy -Have you checked out the Firefox addin "User Agent Switcher"? I used to use it to access an "IE only" site with FF - worked for me then.
From the addin info: Adds a menu and a toolbar button to switch the user agent of a browser.The User Agent Switcher extension adds a menu and a toolbar button to switch the user agent of a browser.
Also, see: http://chrispederick.com/work/user-agent-switcher/
Hope this helps - regards - tbs
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, October 30, 2014 11:49 PM
Subject: Re: [smf_addin] Re: Getting data from MSN again with pointer &
The MSN web pages I'm looking at don't have the data in tables, but they use "li" and "p" tags to simulate a table. So, this works for a number of ticker symbols:
=smfConvertData(smfGetTagContent("http://www.msn.com/en-us/money/stockdetails/financials/fi-"&B7,"p",1,"Operating Income"))
However, when the add-in retrieves the source code of the NYCB web page, there is no financial statements data on the web page. FireFox displays it however, which is strange.
I'm seeing this more and more often lately -- FireFox displays one thing, but the add-in retrieves something different. I'm not sure what the cause is. I don't use IE as a browser, and don't have the current version of IE, so I can't really say what happens there. But it's still strange, as I though the XMLHTTP protocol I use to retrieve source code of a web page is the same engine that IE uses. Perhaps there is some server-side processing going on to identify the type of browser so that different sets of source code can be delivered? I don't know...
On Thu, Oct 30, 2014 at 8:17 PM, tzewei_79@... wrote:
But I noticed yahoo doesn't have all the data for some stocks....I have a ticker NYCB...the entire financial statement is empty..
I tried MSN again, and it seems that the link changed a little today but I can't get it to work like yahoo. Not sure if it was because the ticker prefix is a "-" and not "=". The formula below will show an error. Can this hyperlink be used this way?
=RCHGetTableCell("http://www.msn.com/en-us/money/stockdetails/financials/fi-"&A12,1,"Operating Income")
#yiv8588209962 #yiv8588209962 -- #yiv8588209962ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8588209962 #yiv8588209962ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8588209962 #yiv8588209962ygrp-mkp #yiv8588209962hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8588209962 #yiv8588209962ygrp-mkp #yiv8588209962ads {margin-bottom:10px;}#yiv8588209962 #yiv8588209962ygrp-mkp .yiv8588209962ad {padding:0 0;}#yiv8588209962 #yiv8588209962ygrp-mkp .yiv8588209962ad p {margin:0;}#yiv8588209962 #yiv8588209962ygrp-mkp .yiv8588209962ad a {color:#0000ff;text-decoration:none;}#yiv8588209962 #yiv8588209962ygrp-sponsor #yiv8588209962ygrp-lc {font-family:Arial;}#yiv8588209962 #yiv8588209962ygrp-sponsor #yiv8588209962ygrp-lc #yiv8588209962hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8588209962 #yiv8588209962ygrp-sponsor #yiv8588209962ygrp-lc .yiv8588209962ad {margin-bottom:10px;padding:0 0;}#yiv8588209962 #yiv8588209962actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8588209962 #yiv8588209962activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8588209962 #yiv8588209962activity span {font-weight:700;}#yiv8588209962 #yiv8588209962activity span:first-child {text-transform:uppercase;}#yiv8588209962 #yiv8588209962activity span a {color:#5085b6;text-decoration:none;}#yiv8588209962 #yiv8588209962activity span span {color:#ff7900;}#yiv8588209962 #yiv8588209962activity span .yiv8588209962underline {text-decoration:underline;}#yiv8588209962 .yiv8588209962attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8588209962 .yiv8588209962attach div a {text-decoration:none;}#yiv8588209962 .yiv8588209962attach img {border:none;padding-right:5px;}#yiv8588209962 .yiv8588209962attach label {display:block;margin-bottom:5px;}#yiv8588209962 .yiv8588209962attach label a {text-decoration:none;}#yiv8588209962 blockquote {margin:0 0 0 4px;}#yiv8588209962 .yiv8588209962bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8588209962 .yiv8588209962bold a {text-decoration:none;}#yiv8588209962 dd.yiv8588209962last p a {font-family:Verdana;font-weight:700;}#yiv8588209962 dd.yiv8588209962last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8588209962 dd.yiv8588209962last p span.yiv8588209962yshortcuts {margin-right:0;}#yiv8588209962 div.yiv8588209962attach-table div div a {text-decoration:none;}#yiv8588209962 div.yiv8588209962attach-table {width:400px;}#yiv8588209962 div.yiv8588209962file-title a, #yiv8588209962 div.yiv8588209962file-title a:active, #yiv8588209962 div.yiv8588209962file-title a:hover, #yiv8588209962 div.yiv8588209962file-title a:visited {text-decoration:none;}#yiv8588209962 div.yiv8588209962photo-title a, #yiv8588209962 div.yiv8588209962photo-title a:active, #yiv8588209962 div.yiv8588209962photo-title a:hover, #yiv8588209962 div.yiv8588209962photo-title a:visited {text-decoration:none;}#yiv8588209962 div#yiv8588209962ygrp-mlmsg #yiv8588209962ygrp-msg p a span.yiv8588209962yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8588209962 .yiv8588209962green {color:#628c2a;}#yiv8588209962 .yiv8588209962MsoNormal {margin:0 0 0 0;}#yiv8588209962 o {font-size:0;}#yiv8588209962 #yiv8588209962photos div {float:left;width:72px;}#yiv8588209962 #yiv8588209962photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8588209962 #yiv8588209962photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8588209962 #yiv8588209962reco-category {font-size:77%;}#yiv8588209962 #yiv8588209962reco-desc {font-size:77%;}#yiv8588209962 .yiv8588209962replbq {margin:4px;}#yiv8588209962 #yiv8588209962ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8588209962 #yiv8588209962ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8588209962 #yiv8588209962ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8588209962 #yiv8588209962ygrp-mlmsg select, #yiv8588209962 input, #yiv8588209962 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8588209962 #yiv8588209962ygrp-mlmsg pre, #yiv8588209962 code {font:115% monospace;}#yiv8588209962 #yiv8588209962ygrp-mlmsg * {line-height:1.22em;}#yiv8588209962 #yiv8588209962ygrp-mlmsg #yiv8588209962logo {padding-bottom:10px;}#yiv8588209962 #yiv8588209962ygrp-msg p a {font-family:Verdana;}#yiv8588209962 #yiv8588209962ygrp-msg p#yiv8588209962attach-count span {color:#1E66AE;font-weight:700;}#yiv8588209962 #yiv8588209962ygrp-reco #yiv8588209962reco-head {color:#ff7900;font-weight:700;}#yiv8588209962 #yiv8588209962ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8588209962 #yiv8588209962ygrp-sponsor #yiv8588209962ov li a {font-size:130%;text-decoration:none;}#yiv8588209962 #yiv8588209962ygrp-sponsor #yiv8588209962ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8588209962 #yiv8588209962ygrp-sponsor #yiv8588209962ov ul {margin:0;padding:0 0 0 8px;}#yiv8588209962 #yiv8588209962ygrp-text {font-family:Georgia;}#yiv8588209962 #yiv8588209962ygrp-text p {margin:0 0 1em 0;}#yiv8588209962 #yiv8588209962ygrp-text tt {font-size:120%;}#yiv8588209962 #yiv8588209962ygrp-vital ul li:last-child {border-right:none !important;}#yiv8588209962
From the addin info: Adds a menu and a toolbar button to switch the user agent of a browser.The User Agent Switcher extension adds a menu and a toolbar button to switch the user agent of a browser.
Also, see: http://chrispederick.com/work/user-agent-switcher/
Hope this helps - regards - tbs
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, October 30, 2014 11:49 PM
Subject: Re: [smf_addin] Re: Getting data from MSN again with pointer &
The MSN web pages I'm looking at don't have the data in tables, but they use "li" and "p" tags to simulate a table. So, this works for a number of ticker symbols:
=smfConvertData(smfGetTagContent("http://www.msn.com/en-us/money/stockdetails/financials/fi-"&B7,"p",1,"Operating Income"))
However, when the add-in retrieves the source code of the NYCB web page, there is no financial statements data on the web page. FireFox displays it however, which is strange.
I'm seeing this more and more often lately -- FireFox displays one thing, but the add-in retrieves something different. I'm not sure what the cause is. I don't use IE as a browser, and don't have the current version of IE, so I can't really say what happens there. But it's still strange, as I though the XMLHTTP protocol I use to retrieve source code of a web page is the same engine that IE uses. Perhaps there is some server-side processing going on to identify the type of browser so that different sets of source code can be delivered? I don't know...
On Thu, Oct 30, 2014 at 8:17 PM, tzewei_79@... wrote:
But I noticed yahoo doesn't have all the data for some stocks....I have a ticker NYCB...the entire financial statement is empty..
I tried MSN again, and it seems that the link changed a little today but I can't get it to work like yahoo. Not sure if it was because the ticker prefix is a "-" and not "=". The formula below will show an error. Can this hyperlink be used this way?
=RCHGetTableCell("http://www.msn.com/en-us/money/stockdetails/financials/fi-"&A12,1,
#yiv8588209962 #yiv8588209962 -- #yiv8588209962ygrp-
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar