14 Messages
Digest #3907
Messages
Thu Feb 2, 2017 9:33 am (PST) . Posted by:
tonyestep
Thanks, Randy. I found the XD in the HTML on the ETF.com site. For example, for SPY, it says:
<span class="field-r-next-exdividend-date">03/17/17</span>
So I tried various text strings to get it to return something, but I just get Error. I can't figure out how to construct my call. Any advice?
<span class="
So I tried various text strings to get it to return something, but I just get Error. I can't figure out how to construct my call. Any advice?
Thu Feb 2, 2017 1:12 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Try something like this:
=smfGetTagContent("http://www.etf.com/"&E7,"span",1,">Next Ex-dividend")
On Thu, Feb 2, 2017 at 10:33 AM, tonyestep@
...wrote:
>
>
> Thanks, Randy. I found the XD in the HTML on the ETF.com site. For
> example, for SPY, it says:
>
> <span class="field-r-next-exdividend-date">03/17/17</span>
>
> So I tried various text strings to get it to return something, but I just
> get Error. I can't figure out how to construct my call. Any advice?
>
>
=smfGetTagContent("http://www.etf.com/"&E7,"
On Thu, Feb 2, 2017 at 10:33 AM, tonyestep@
...wrote:
>
>
> Thanks, Randy. I found the XD in the HTML on the ETF.com site. For
> example, for SPY, it says:
>
> <span class="
>
> So I tried various text strings to get it to return something, but I just
> get Error. I can't figure out how to construct my call. Any advice?
>
>
Thu Feb 2, 2017 1:47 pm (PST) . Posted by:
tonyestep
Yep, I tried that but it didn't work. So I tried variations on it, but no result. I am trying to match the tag contents but I'm not clear on how to formulate my request.
Thu Feb 2, 2017 3:22 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. It's working on the tickers I'm using -- SPY, IWM, and SPHD.
Which tickers are you using?
Can you attach a sample workbook with just a few of those formulas in it?
On Thu, Feb 2, 2017 at 2:47 PM, tonyestep@
...wrote:
>
> Yep, I tried that but it didn't work. So I tried variations on it, but no
> result. I am trying to match the tag contents but I'm not clear on how to
> formulate my request.
>
Which tickers are you using?
Can you attach a sample workbook with just a few of those formulas in it?
On Thu, Feb 2, 2017 at 2:47 PM, tonyestep@
...wrote:
>
> Yep, I tried that but it didn't work. So I tried variations on it, but no
> result. I am trying to match the tag contents but I'm not clear on how to
> formulate my request.
>
Thu Feb 2, 2017 10:45 am (PST) . Posted by:
trendsekr
When I opened my options spreadsheet Excel indicated that something was corrupted. It removed a couple records then opened. Stock market data is working but not options stuff.
RCH_Stock_Market_Functions.xla won't stay linked. In the "Edit Links" box the status comes up as "Unknown". Checking status changes it to "Source is open", but never to "OK". If I close that box then re-open it the status is back to "Unknown".
The "Workbook Connections" box has RCHGetElementNumber-Element-Definitions 'Element-Definitions$' listed. The lower box returns "Connection(s) not used in this workbook."
The "Add-Ins available:" box has "Stock Market Functions Add-in" listed and checked.
Thus the smfGetOptionQuotes() function isn't working.
Any suggestions?
Thanks much,
Michael
RCH_Stock_Market_
The "Workbook Connections" box has RCHGetElementNumber
The "Add-Ins available:" box has "Stock Market Functions Add-in" listed and checked.
Thus the smfGetOptionQuotes(
Any suggestions?
Thanks much,
Michael
Thu Feb 2, 2017 1:25 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The add-in should be correctly connected if it is working for non-option
items.
In a new workbook, create an smfGetOptionQuotes() function to see if it
works. For example:
=smfGetOptionQuotes("MMM 2/3 2017 $180 Call","l")
Does that work?
On Thu, Feb 2, 2017 at 11:45 AM, trendsekr@
...wrote:
> When I opened my options spreadsheet Excel indicated that something was
> corrupted. It removed a couple records then opened. Stock market data is
> working but not options stuff.
>
> RCH_Stock_Market_Functions.xla won't stay linked. In the "Edit Links" box
> the status comes up as "Unknown". Checking status changes it to "Source is
> open", but never to "OK". If I close that box then re-open it the status is
> back to "Unknown".
>
> The "Workbook Connections" box has RCHGetElementNumber-Element-Definitions
> 'Element-Definitions$' listed. The lower box returns "Connection(s) not
> used in this workbook."
>
> The "Add-Ins available:" box has "Stock Market Functions Add-in" listed
> and checked.
>
> Thus the
>
> smfGetOptionQuotes() function isn't working.
>
> Any suggestions?
>
>
items.
In a new workbook, create an smfGetOptionQuotes(
works. For example:
=smfGetOptionQuotes
Does that work?
On Thu, Feb 2, 2017 at 11:45 AM, trendsekr@
...wrote:
> When I opened my options spreadsheet Excel indicated that something was
> corrupted. It removed a couple records then opened. Stock market data is
> working but not options stuff.
>
> RCH_Stock_Market_
> the status comes up as "Unknown"
> open", but never to "OK"
> back to "Unknown"
>
> The "Workbook Connections" box has RCHGetElementNumber
> 'Element-
> used in this workbook."
>
> The "Add-Ins available:" box has "Stock Market Functions Add-in" listed
> and checked.
>
> Thus the
>
> smfGetOptionQuotes(
>
> Any suggestions?
>
>
Thu Feb 2, 2017 12:00 pm (PST) . Posted by:
"Kermit W. Prather" kermitpra
Sounds like you need to keep doing it. Have you loss any weight since starting the high protein diet?
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, January 30, 2017 4:10 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Charity
I started a low calorie Keto diet while in the hospital. Which basically means high protein at my body size. Still doing it now. Before the hospital, I was taking 400 units of insulin a day and averaging a 160 BG reading. I haven't used any insulin since I left rehab, and my BG has varied from 93 to 117.
On Mon, Jan 30, 2017 at 12:51 PM, simona G simona4051@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Dear Randy, so sorry to hear about it. Hope that you are getting the best medical advice. I'm actually for the industry (Pharma) and there are some effective treatments almost regardless of the disease stage. Let me know if you would want to talk about it.
Simona
Sent from my iPhone
On 30 Jan 2017, at 20:29, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Diabetes is that thing that's getting me the most these days. It affects almost everything in the body.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, January 30, 2017 4:10 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Charity
I started a low calorie Keto diet while in the hospital. Which basically means high protein at my body size. Still doing it now. Before the hospital, I was taking 400 units of insulin a day and averaging a 160 BG reading. I haven't used any insulin since I left rehab, and my BG has varied from 93 to 117.
On Mon, Jan 30, 2017 at 12:51 PM, simona G simona4051@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Dear Randy, so sorry to hear about it. Hope that you are getting the best medical advice. I'm actually for the industry (Pharma) and there are some effective treatments almost regardless of the disease stage. Let me know if you would want to talk about it.
Simona
Sent from my iPhone
On 30 Jan 2017, at 20:29, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Diabetes is that thing that's getting me the most these days. It affects almost everything in the body.
Thu Feb 2, 2017 1:34 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
No scale available. Weights on bariatric beds at the hospitals varied too
much to trust.
On Thu, Feb 2, 2017 at 12:59 PM, 'Kermit W. Prather' kermitp@
...wrote:
>
> Sounds like you need to keep doing it. Have you loss any weight since
> starting the high protein diet?
>
>
>
much to trust.
On Thu, Feb 2, 2017 at 12:59 PM, 'Kermit W. Prather' kermitp@
...wrote:
>
> Sounds like you need to keep doing it. Have you loss any weight since
> starting the high protein diet?
>
>
>
Thu Feb 2, 2017 1:29 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Give me an example of a formula and its results that "does not seem" to
work?
On Wed, Feb 1, 2017 at 5:15 PM, bopha99@
...wrote:
> Thanks for the add in. I've been using it for a couple years now and it
> has been working great. Recently, something has changed and the add-in
> does not seem to be pulling in numbers from Morningstar. For some reason,
> when I disabled the add in, numbers would pull in from Morningstar. Now,
> nothing is happening at all, even when I press Alt F8 and type in
> smfforcerecalculation or when I resign in to morningstar or when I try and
> access data via excel. I tried putting in the newer add in versions, but
> nothing seems to be helping. What could I be doing wrong?
>
work?
On Wed, Feb 1, 2017 at 5:15 PM, bopha99@
...wrote:
> Thanks for the add in. I've been using it for a couple years now and it
> has been working great. Recently, something has changed and the add-in
> does not seem to be pulling in numbers from Morningstar. For some reason,
> when I disabled the add in, numbers would pull in from Morningstar. Now,
> nothing is happening at all, even when I press Alt F8 and type in
> smfforcerecalculati
> access data via excel. I tried putting in the newer add in versions, but
> nothing seems to be helping. What could I be doing wrong?
>
Thu Feb 2, 2017 2:35 pm (PST) . Posted by:
"Sundeep Chadha" sundeep_chadha
Hi Randy -
Welcome back. I hope that you keep on feeling better and 2017 turns out to be a year of health for you.
Is is possible to get the Sector / Industry for a company from yahoo financials. They are listed on the profile page for the Company. For IBM is Sector: Technology
Industry: Information Technology Services
Thanks and regards, Sundeep Chadha
Welcome back. I hope that you keep on feeling better and 2017 turns out to be a year of health for you.
Is is possible to get the Sector / Industry for a company from yahoo financials. They are listed on the profile page for the Company. For IBM is Sector: Technology
Industry: Informatio
Thanks and regards, Sundeep Chadha
Thu Feb 2, 2017 3:25 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Easy peezy. Already exists. :)
Try:
=RCHGetElementNumber("IBM";,13865)
=RCHGetElementNumber("IBM";,13867)
On Thu, Feb 2, 2017 at 3:35 PM, Sundeep Chadha sundeep_chadha@
...wrote:
>
> Is is possible to get the Sector / Industry for a company from yahoo
> financials. They are listed on the profile page for the Company.
> For IBM is
> Sector: Technology
> Industry: Information Technology Services
>
>
>
Try:
=RCHGetElementNumbe
=RCHGetElementNumbe
On Thu, Feb 2, 2017 at 3:35 PM, Sundeep Chadha sundeep_chadha@
...wrote:
>
> Is is possible to get the Sector / Industry for a company from yahoo
> financials. They are listed on the profile page for the Company.
> For IBM is
> Sector: Technology
> Industry: Information Technology Services
>
>
>
Thu Feb 2, 2017 4:06 pm (PST) . Posted by:
"Sundeep Chadha" sundeep_chadha
Randy - Thank you for your prompt response - as always. Have a wonderful evening.
Thanks and regards, Sundeep Chadha
On Thursday, February 2, 2017 5:25 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Easy peezy. Already exists. :)
Try:
=RCHGetElementNumber("IBM";,13865)
=RCHGetElementNumber("IBM";,13867)
On Thu, Feb 2, 2017 at 3:35 PM, Sundeep Chadha sundeep_chadha@...wrote:
Is is possible to get the Sector / Industry for a company from yahoo financials. They are listed on the profile page for the Company. For IBM is Sector: Technology
Industry: Information Technology Services
#yiv9053436782 #yiv9053436782 -- #yiv9053436782ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9053436782 #yiv9053436782ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9053436782 #yiv9053436782ygrp-mkp #yiv9053436782hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9053436782 #yiv9053436782ygrp-mkp #yiv9053436782ads {margin-bottom:10px;}#yiv9053436782 #yiv9053436782ygrp-mkp .yiv9053436782ad {padding:0 0;}#yiv9053436782 #yiv9053436782ygrp-mkp .yiv9053436782ad p {margin:0;}#yiv9053436782 #yiv9053436782ygrp-mkp .yiv9053436782ad a {color:#0000ff;text-decoration:none;}#yiv9053436782 #yiv9053436782ygrp-sponsor #yiv9053436782ygrp-lc {font-family:Arial;}#yiv9053436782 #yiv9053436782ygrp-sponsor #yiv9053436782ygrp-lc #yiv9053436782hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9053436782 #yiv9053436782ygrp-sponsor #yiv9053436782ygrp-lc .yiv9053436782ad {margin-bottom:10px;padding:0 0;}#yiv9053436782 #yiv9053436782actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9053436782 #yiv9053436782activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9053436782 #yiv9053436782activity span {font-weight:700;}#yiv9053436782 #yiv9053436782activity span:first-child {text-transform:uppercase;}#yiv9053436782 #yiv9053436782activity span a {color:#5085b6;text-decoration:none;}#yiv9053436782 #yiv9053436782activity span span {color:#ff7900;}#yiv9053436782 #yiv9053436782activity span .yiv9053436782underline {text-decoration:underline;}#yiv9053436782 .yiv9053436782attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9053436782 .yiv9053436782attach div a {text-decoration:none;}#yiv9053436782 .yiv9053436782attach img {border:none;padding-right:5px;}#yiv9053436782 .yiv9053436782attach label {display:block;margin-bottom:5px;}#yiv9053436782 .yiv9053436782attach label a {text-decoration:none;}#yiv9053436782 blockquote {margin:0 0 0 4px;}#yiv9053436782 .yiv9053436782bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9053436782 .yiv9053436782bold a {text-decoration:none;}#yiv9053436782 dd.yiv9053436782last p a {font-family:Verdana;font-weight:700;}#yiv9053436782 dd.yiv9053436782last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9053436782 dd.yiv9053436782last p span.yiv9053436782yshortcuts {margin-right:0;}#yiv9053436782 div.yiv9053436782attach-table div div a {text-decoration:none;}#yiv9053436782 div.yiv9053436782attach-table {width:400px;}#yiv9053436782 div.yiv9053436782file-title a, #yiv9053436782 div.yiv9053436782file-title a:active, #yiv9053436782 div.yiv9053436782file-title a:hover, #yiv9053436782 div.yiv9053436782file-title a:visited {text-decoration:none;}#yiv9053436782 div.yiv9053436782photo-title a, #yiv9053436782 div.yiv9053436782photo-title a:active, #yiv9053436782 div.yiv9053436782photo-title a:hover, #yiv9053436782 div.yiv9053436782photo-title a:visited {text-decoration:none;}#yiv9053436782 div#yiv9053436782ygrp-mlmsg #yiv9053436782ygrp-msg p a span.yiv9053436782yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9053436782 .yiv9053436782green {color:#628c2a;}#yiv9053436782 .yiv9053436782MsoNormal {margin:0 0 0 0;}#yiv9053436782 o {font-size:0;}#yiv9053436782 #yiv9053436782photos div {float:left;width:72px;}#yiv9053436782 #yiv9053436782photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9053436782 #yiv9053436782photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9053436782 #yiv9053436782reco-category {font-size:77%;}#yiv9053436782 #yiv9053436782reco-desc {font-size:77%;}#yiv9053436782 .yiv9053436782replbq {margin:4px;}#yiv9053436782 #yiv9053436782ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9053436782 #yiv9053436782ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9053436782 #yiv9053436782ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9053436782 #yiv9053436782ygrp-mlmsg select, #yiv9053436782 input, #yiv9053436782 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9053436782 #yiv9053436782ygrp-mlmsg pre, #yiv9053436782 code {font:115% monospace;}#yiv9053436782 #yiv9053436782ygrp-mlmsg * {line-height:1.22em;}#yiv9053436782 #yiv9053436782ygrp-mlmsg #yiv9053436782logo {padding-bottom:10px;}#yiv9053436782 #yiv9053436782ygrp-msg p a {font-family:Verdana;}#yiv9053436782 #yiv9053436782ygrp-msg p#yiv9053436782attach-count span {color:#1E66AE;font-weight:700;}#yiv9053436782 #yiv9053436782ygrp-reco #yiv9053436782reco-head {color:#ff7900;font-weight:700;}#yiv9053436782 #yiv9053436782ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9053436782 #yiv9053436782ygrp-sponsor #yiv9053436782ov li a {font-size:130%;text-decoration:none;}#yiv9053436782 #yiv9053436782ygrp-sponsor #yiv9053436782ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9053436782 #yiv9053436782ygrp-sponsor #yiv9053436782ov ul {margin:0;padding:0 0 0 8px;}#yiv9053436782 #yiv9053436782ygrp-text {font-family:Georgia;}#yiv9053436782 #yiv9053436782ygrp-text p {margin:0 0 1em 0;}#yiv9053436782 #yiv9053436782ygrp-text tt {font-size:120%;}#yiv9053436782 #yiv9053436782ygrp-vital ul li:last-child {border-right:none !important;}#yiv9053436782
Thanks and regards, Sundeep Chadha
On Thursday, February 2, 2017 5:25 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Easy peezy. Already exists. :)
Try:
=RCHGetElementNumbe
=RCHGetElementNumbe
On Thu, Feb 2, 2017 at 3:35 PM, Sundeep Chadha sundeep_chadha@...wrote:
Is is possible to get the Sector / Industry for a company from yahoo financials. They are listed on the profile page for the Company. For IBM is Sector: Technology
Industry: Informatio
#yiv9053436782 #yiv9053436782 -- #yiv9053436782ygrp-
Thu Feb 2, 2017 4:18 pm (PST) . Posted by:
"Sundeep Chadha" sundeep_chadha
Randy and the Group -
Any idea why this would return an error ?=RCHGetElementNumber("YHOO",13867)
Even though I see correct value on the actual page.Lot of other symbols return correct value but some of then return with error even when there is good value on the page
Thanks and regards, Sundeep Chadha
On Thursday, February 2, 2017 6:04 PM, Sundeep Chadha <sundeep_chadha@yahoo.com> wrote:
Randy - Thank you for your prompt response - as always. Have a wonderful evening.
Thanks and regards, Sundeep Chadha
On Thursday, February 2, 2017 5:25 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Easy peezy. Already exists. :)
Try:
=RCHGetElementNumber("IBM";,13865)
=RCHGetElementNumber("IBM";,13867)
On Thu, Feb 2, 2017 at 3:35 PM, Sundeep Chadha sundeep_chadha@...wrote:
Is is possible to get the Sector / Industry for a company from yahoo financials. They are listed on the profile page for the Company. For IBM is Sector: Technology
Industry: Information Technology Services
#yiv2169148377 -- #yiv2169148377ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2169148377 #yiv2169148377ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2169148377 #yiv2169148377ygrp-mkp #yiv2169148377hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2169148377 #yiv2169148377ygrp-mkp #yiv2169148377ads {margin-bottom:10px;}#yiv2169148377 #yiv2169148377ygrp-mkp .yiv2169148377ad {padding:0 0;}#yiv2169148377 #yiv2169148377ygrp-mkp .yiv2169148377ad p {margin:0;}#yiv2169148377 #yiv2169148377ygrp-mkp .yiv2169148377ad a {color:#0000ff;text-decoration:none;}#yiv2169148377 #yiv2169148377ygrp-sponsor #yiv2169148377ygrp-lc {font-family:Arial;}#yiv2169148377 #yiv2169148377ygrp-sponsor #yiv2169148377ygrp-lc #yiv2169148377hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2169148377 #yiv2169148377ygrp-sponsor #yiv2169148377ygrp-lc .yiv2169148377ad {margin-bottom:10px;padding:0 0;}#yiv2169148377 #yiv2169148377actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2169148377 #yiv2169148377activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2169148377 #yiv2169148377activity span {font-weight:700;}#yiv2169148377 #yiv2169148377activity span:first-child {text-transform:uppercase;}#yiv2169148377 #yiv2169148377activity span a {color:#5085b6;text-decoration:none;}#yiv2169148377 #yiv2169148377activity span span {color:#ff7900;}#yiv2169148377 #yiv2169148377activity span .yiv2169148377underline {text-decoration:underline;}#yiv2169148377 .yiv2169148377attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2169148377 .yiv2169148377attach div a {text-decoration:none;}#yiv2169148377 .yiv2169148377attach img {border:none;padding-right:5px;}#yiv2169148377 .yiv2169148377attach label {display:block;margin-bottom:5px;}#yiv2169148377 .yiv2169148377attach label a {text-decoration:none;}#yiv2169148377 blockquote {margin:0 0 0 4px;}#yiv2169148377 .yiv2169148377bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2169148377 .yiv2169148377bold a {text-decoration:none;}#yiv2169148377 dd.yiv2169148377last p a {font-family:Verdana;font-weight:700;}#yiv2169148377 dd.yiv2169148377last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2169148377 dd.yiv2169148377last p span.yiv2169148377yshortcuts {margin-right:0;}#yiv2169148377 div.yiv2169148377attach-table div div a {text-decoration:none;}#yiv2169148377 div.yiv2169148377attach-table {width:400px;}#yiv2169148377 div.yiv2169148377file-title a, #yiv2169148377 div.yiv2169148377file-title a:active, #yiv2169148377 div.yiv2169148377file-title a:hover, #yiv2169148377 div.yiv2169148377file-title a:visited {text-decoration:none;}#yiv2169148377 div.yiv2169148377photo-title a, #yiv2169148377 div.yiv2169148377photo-title a:active, #yiv2169148377 div.yiv2169148377photo-title a:hover, #yiv2169148377 div.yiv2169148377photo-title a:visited {text-decoration:none;}#yiv2169148377 div#yiv2169148377ygrp-mlmsg #yiv2169148377ygrp-msg p a span.yiv2169148377yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2169148377 .yiv2169148377green {color:#628c2a;}#yiv2169148377 .yiv2169148377MsoNormal {margin:0 0 0 0;}#yiv2169148377 o {font-size:0;}#yiv2169148377 #yiv2169148377photos div {float:left;width:72px;}#yiv2169148377 #yiv2169148377photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2169148377 #yiv2169148377photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2169148377 #yiv2169148377reco-category {font-size:77%;}#yiv2169148377 #yiv2169148377reco-desc {font-size:77%;}#yiv2169148377 .yiv2169148377replbq {margin:4px;}#yiv2169148377 #yiv2169148377ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2169148377 #yiv2169148377ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2169148377 #yiv2169148377ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2169148377 #yiv2169148377ygrp-mlmsg select, #yiv2169148377 input, #yiv2169148377 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2169148377 #yiv2169148377ygrp-mlmsg pre, #yiv2169148377 code {font:115% monospace;}#yiv2169148377 #yiv2169148377ygrp-mlmsg * {line-height:1.22em;}#yiv2169148377 #yiv2169148377ygrp-mlmsg #yiv2169148377logo {padding-bottom:10px;}#yiv2169148377 #yiv2169148377ygrp-msg p a {font-family:Verdana;}#yiv2169148377 #yiv2169148377ygrp-msg p#yiv2169148377attach-count span {color:#1E66AE;font-weight:700;}#yiv2169148377 #yiv2169148377ygrp-reco #yiv2169148377reco-head {color:#ff7900;font-weight:700;}#yiv2169148377 #yiv2169148377ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2169148377 #yiv2169148377ygrp-sponsor #yiv2169148377ov li a {font-size:130%;text-decoration:none;}#yiv2169148377 #yiv2169148377ygrp-sponsor #yiv2169148377ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2169148377 #yiv2169148377ygrp-sponsor #yiv2169148377ov ul {margin:0;padding:0 0 0 8px;}#yiv2169148377 #yiv2169148377ygrp-text {font-family:Georgia;}#yiv2169148377 #yiv2169148377ygrp-text p {margin:0 0 1em 0;}#yiv2169148377 #yiv2169148377ygrp-text tt {font-size:120%;}#yiv2169148377 #yiv2169148377ygrp-vital ul li:last-child {border-right:none !important;}#yiv2169148377
Any idea why this would return an error ?=RCHGetElementNumber("YHOO",13867)
Even though I see correct value on the actual page.Lot of other symbols return correct value but some of then return with error even when there is good value on the page
Thanks and regards, Sundeep Chadha
On Thursday, February 2, 2017 6:04 PM, Sundeep Chadha <sundeep_chadha@yahoo.com> wrote:
Randy - Thank you for your prompt response - as always. Have a wonderful evening.
Thanks and regards, Sundeep Chadha
On Thursday, February 2, 2017 5:25 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Easy peezy. Already exists. :)
Try:
=RCHGetElementNumbe
=RCHGetElementNumbe
On Thu, Feb 2, 2017 at 3:35 PM, Sundeep Chadha sundeep_chadha@...wrote:
Is is possible to get the Sector / Industry for a company from yahoo financials. They are listed on the profile page for the Company. For IBM is Sector: Technology
Industry: Informatio
#yiv2169148377 -- #yiv2169148377ygrp-
Thu Feb 2, 2017 5:34 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Works fine here. Could be Yahoo or communication issues?
When you get an error on a ticker, do all of the items from that page
return Error?
*#* *Element*
13864 Sector Number
13865 Sector Name
13866 Industry Number
13867 Industry Name
13868 Industry Symbol
On Thu, Feb 2, 2017 at 5:15 PM, Sundeep Chadha sundeep_chadha@
...wrote:
>
> Any idea why this would return an error ?
> =RCHGetElementNumber("YHOO",13867)
>
> Even though I see correct value on the actual page.
> Lot of other symbols return correct value but some of then return with
> error even when there is good value on the page
>
When you get an error on a ticker, do all of the items from that page
return Error?
*#* *Element*
13864 Sector Number
13865 Sector Name
13866 Industry Number
13867 Industry Name
13868 Industry Symbol
On Thu, Feb 2, 2017 at 5:15 PM, Sundeep Chadha sundeep_chadha@
...wrote:
>
> Any idea why this would return an error ?
> =RCHGetElementNumbe
>
> Even though I see correct value on the actual page.
> Lot of other symbols return correct value but some of then return with
> error even when there is good value on the page
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar