8 Messages
Digest #3252
Messages
Fri Nov 28, 2014 7:12 am (PST) . Posted by:
indinvestor111
Morning,
Does anybody have advise as to how to configure the smggettagcontent function to extract the data from the following tag:
<span class="price price-display"> <span class="sup">$</span>1,298<span class="visuallyhidden">.</span><span class="sup">00</span>
Thanks </span>
I've been tinkering around for awhile but have only been able to get "$" or "." or "00", so I think it's a matter of not being able to position it correctly.
Does anybody have advise as to how to configure the smggettagcontent function to extract the data from the following tag:
<span class="
Thanks </span>
I've been tinkering around for awhile but have only been able to get "$" or "." or "00"
Fri Nov 28, 2014 7:45 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but smfGetTagContent() doesn't work well with nested tags like that.
It's just looking for the first "</span" after a "<span";, to complete the
tag. It doesn't look for new "<span"; tags starting before that first
"</span".
You'll either need to capture the whole string within another tag, then use
smfStrExtr() to extract it out, or use RCHGetWebData() to pull out the
relevant part, again using smfStrExtr() to extract it out.
On Fri, Nov 28, 2014 at 8:12 AM, elandry@.. wrote:
> Does anybody have advise as to how to configure the smggettagcontent
> function to extract the data from the following tag:
>
> <span class="price price-display"> <span class="sup">$</span>1,298<span
> class="visuallyhidden">.</span><span class="sup">00</span>
>
>
> Thanks </span>
>
>
>
>
> I've been tinkering around for awhile but have only been able to get "$"
> or "." or "00", so I think it's a matter of not being able to position it
> correctly.
>
>
It's just looking for the first "</span&quo
tag. It doesn't look for new "<span"
"</span&quo
You'll either need to capture the whole string within another tag, then use
smfStrExtr() to extract it out, or use RCHGetWebData(
relevant part, again using smfStrExtr() to extract it out.
On Fri, Nov 28, 2014 at 8:12 AM, elandry@.. wrote:
> Does anybody have advise as to how to configure the smggettagcontent
> function to extract the data from the following tag:
>
> <span class="
> class="
>
>
> Thanks </span>
>
>
>
>
> I've been tinkering around for awhile but have only been able to get "$"
> or "." or "00"
> correctly.
>
>
Fri Nov 28, 2014 8:38 am (PST) . Posted by:
indinvestor111
Thanks. I was using RCHGetWebData(), but it stopped working for that site 2 days ago.
This returns "#VALUE", for some reason:
=rchgetwebdata("http://www.walmart.com/ip/Samsung-UN65HU7250FXZA-65-4k-Ultra-HD-Curved-120Hz-Class-LED-Smart-HDTV/37406564","http://schema.org/Product",135)
It worked until yesterday evening.
This returns "#VALUE", for some reason:
=rchgetwebdata("http://www.walmart.com/ip/Samsung-UN65HU7250FXZA-65-4k-Ultra-HD-Curved-120Hz-Class-LED-Smart-HDTV/37406564","http://schema.org/Product",135)
It worked until yesterday evening.
Fri Nov 28, 2014 10:03 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Not sure what to tell you. That formula works fine here, returning:
http://schema.org/Product" content="887276035253"><meta itemprop="price"
itemtype="http://schema.org/Product" content="$1997.99"><meta
On Fri, Nov 28, 2014 at 9:38 AM, elandry@... wrote:
>
> Thanks. I was using RCHGetWebData(), but it stopped working for that site
> 2 days ago.
>
> This returns "#VALUE", for some reason:
>
> =rchgetwebdata("
> http://www.walmart.com/ip/Samsung-UN65HU7250FXZA-65-4k-Ultra-HD-Curved-120Hz-Class-LED-Smart-HDTV/37406564
> ","http://schema.org/Product",135)
>
> It worked until yesterday evening.
>
http://schema.org/Product" content="887276035253"><meta itemprop="price"
itemtype="http://schema.org/Product" content="$1997.99"><meta
On Fri, Nov 28, 2014 at 9:38 AM, elandry@... wrote:
>
> Thanks. I was using RCHGetWebData(), but it stopped working for that site
> 2 days ago.
>
> This returns "#VALUE", for some reason:
>
> =rchgetwebdata("
> http://www.walmart.com/ip/Samsung-UN65HU7250FXZA-65-4k-Ultra-HD-Curved-120Hz-Class-LED-Smart-HDTV/37406564
> ","http://schema.org/Product",135)
>
> It worked until yesterday evening.
>
Fri Nov 28, 2014 10:16 am (PST) . Posted by:
indinvestor111
Thanks! Looks like there's a problem elsewhere, then.
Fri Nov 28, 2014 10:04 am (PST) . Posted by:
"John Knudson" johneknudson
Randy,I'm a new user to your excellent add-in. And while I have been able to get some basic quote data reporting for me, I have not been able to get the Option quotes to function for me. My attempts and configurations are below, can you help? -JK =smfGetMSNOptionQuote("COH","C",DATE(2015,2,20),39,"b") Gives a "Error" result=smfGetOptionQuotes("COH Jan 20 2017 $28 C","ba") Gives a "Invalid Put/Call indicator (must be a P or C): $=smfGetOptionQuotes("COH Jan 2017 $28 C","ba") Gives a "Error" result I'm running Excel as part of Microsoft Office Professional Plus 2013Microsoft Excel 2013 (15.0.4569.1504) 32-bitOn a Windows 8 Enterprise edition.
Fri Nov 28, 2014 10:51 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry about the problems you're having. Unfortunately, option quotes are in
flux right now.
>>> =smfGetMSNOptionQuote("COH","C",DATE(2015,2,20),39,"b")
MSN recently redid all of their MSN Money web pages and is unlikely to be
used again because of how they crippled their data pages.
>>> =smfGetOptionQuotes("COH Jan 20 2017 $28 C","ba")
Right now, Yahoo is rendering option chains one way on FireFox and Chrome,
and another way on IE. I updated all of the routines to the new way when
the IE presentation was at first updated, but then Yahoo backed out the IE
changes. So I'm not sure what the future of IE option chains will be. In
any case, your date is incorrectly stated, you can try:
=smfGetOptionQuotes("COH 1/20 2017 $28 C","ba")
Depending on which version of the add-in you have, that might work. It
doesn't work in the version I'm using, because it's been updated to the new
version of the web page (which Yahoo backed off from, sigh).
>>> =smfGetOptionQuotes("COH Jan 2017 $28 C","ba")
This error is because of a change starting February 1, 2015. That's when
the CBOE is aligning monthly expirations to Fridays, so they will match the
weekly expiration. The add-in has been fixed for that (so the copy I'm
using would accept that date configuration), but the change was made on
2014-09-15, so you'd need a version of the add-in after that date to make
the above formula work.
Sigh. I hate it when the websites make changes...unless it's because
they're adding a lot of functionality.
You could try OptionsXPress if the Yahoo formula I cited above didn't work:
=smfGetOptionQuotes("COH 1/20 2017 $28 C","ba",,"ox2")
Unfortunately, although OptionsXPress is the most reliable source so far,
it's also the slowest source for option quotes.
On Fri, Nov 28, 2014 at 10:01 AM, John Knudson johneknudson@... wrote:
>
> I'm a new user to your excellent add-in. And while I have been able to
> get some basic quote data reporting for me, I have not been able to get the
> Option quotes to function for me. My attempts and configurations are
> below, can you help? -JK
>
> =smfGetMSNOptionQuote("COH","C",DATE(2015,2,20),39,"b")
> Gives a "Error" result
> =smfGetOptionQuotes("COH Jan 20 2017 $28 C","ba")
> Gives a "Invalid Put/Call indicator (must be a P or C): $
> =smfGetOptionQuotes("COH Jan 2017 $28 C","ba")
> Gives a "Error" result
>
> I'm running Excel as part of Microsoft Office Professional Plus 2013
> Microsoft Excel 2013 (15.0.4569.1504) 32-bit
> On a Windows 8 Enterprise edition.
>
flux right now.
>>> =smfGetMSNOptionQuo
MSN recently redid all of their MSN Money web pages and is unlikely to be
used again because of how they crippled their data pages.
>>> =smfGetOptionQuotes
Right now, Yahoo is rendering option chains one way on FireFox and Chrome,
and another way on IE. I updated all of the routines to the new way when
the IE presentation was at first updated, but then Yahoo backed out the IE
changes. So I'm not sure what the future of IE option chains will be. In
any case, your date is incorrectly stated, you can try:
=smfGetOptionQuotes
Depending on which version of the add-in you have, that might work. It
doesn't work in the version I'm using, because it's been updated to the new
version of the web page (which Yahoo backed off from, sigh).
>>> =smfGetOptionQuotes
This error is because of a change starting February 1, 2015. That's when
the CBOE is aligning monthly expirations to Fridays, so they will match the
weekly expiration. The add-in has been fixed for that (so the copy I'm
using would accept that date configuration)
2014-09-15, so you'd need a version of the add-in after that date to make
the above formula work.
Sigh. I hate it when the websites make changes...unless it's because
they're adding a lot of functionality.
You could try OptionsXPress if the Yahoo formula I cited above didn't work:
=smfGetOptionQuotes
Unfortunately, although OptionsXPress is the most reliable source so far,
it's also the slowest source for option quotes.
On Fri, Nov 28, 2014 at 10:01 AM, John Knudson johneknudson@
>
> I'm a new user to your excellent add-in. And while I have been able to
> get some basic quote data reporting for me, I have not been able to get the
> Option quotes to function for me. My attempts and configurations are
> below, can you help? -JK
>
> =smfGetMSNOptionQuo
> Gives a "Error" result
> =smfGetOptionQuotes
> Gives a "Invalid Put/Call indicator (must be a P or C): $
> =smfGetOptionQuotes
> Gives a "Error" result
>
> I'm running Excel as part of Microsoft Office Professional Plus 2013
> Microsoft Excel 2013 (15.0.4569.1504) 32-bit
> On a Windows 8 Enterprise edition.
>
Fri Nov 28, 2014 12:41 pm (PST) . Posted by:
"John Knudson" johneknudson
The Option Express key worked for me. As I'm not at all concerned about speed (more of a option investor with daily or weekly checks on a handful of positions) this is a perfect solution for me. Thanks again for your excellent slicing of the HTML tables and the creation of these add-in functions, not to mention your responsive support. It's allowing me to keep to my 15min weekly portfolio update goal. Regards, -JK
On Friday, November 28, 2014 11:51 AM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Sorry about the problems you're having. Unfortunately, option quotes are in flux right now.
>>> =smfGetMSNOptionQuote("COH","C",DATE(2015,2,20),39,"b")
MSN recently redid all of their MSN Money web pages and is unlikely to be used again because of how they crippled their data pages.
>>> =smfGetOptionQuotes("COH Jan 20 2017 $28 C","ba")
Right now, Yahoo is rendering option chains one way on FireFox and Chrome, and another way on IE. I updated all of the routines to the new way when the IE presentation was at first updated, but then Yahoo backed out the IE changes. So I'm not sure what the future of IE option chains will be. In any case, your date is incorrectly stated, you can try:
=smfGetOptionQuotes("COH 1/20 2017 $28 C","ba")
Depending on which version of the add-in you have, that might work. It doesn't work in the version I'm using, because it's been updated to the new version of the web page (which Yahoo backed off from, sigh).
>>> =smfGetOptionQuotes("COH Jan 2017 $28 C","ba")
This error is because of a change starting February 1, 2015. That's when the CBOE is aligning monthly expirations to Fridays, so they will match the weekly expiration. The add-in has been fixed for that (so the copy I'm using would accept that date configuration), but the change was made on 2014-09-15, so you'd need a version of the add-in after that date to make the above formula work.
Sigh. I hate it when the websites make changes...unless it's because they're adding a lot of functionality.
You could try OptionsXPress if the Yahoo formula I cited above didn't work:
=smfGetOptionQuotes("COH 1/20 2017 $28 C","ba",,"ox2")
Unfortunately, although OptionsXPress is the most reliable source so far, it's also the slowest source for option quotes.
On Fri, Nov 28, 2014 at 10:01 AM, John Knudson johneknudson@... wrote:
I'm a new user to your excellent add-in. And while I have been able to get some basic quote data reporting for me, I have not been able to get the Option quotes to function for me. My attempts and configurations are below, can you help? -JK =smfGetMSNOptionQuote("COH","C",DATE(2015,2,20),39,"b") Gives a "Error" result=smfGetOptionQuotes("COH Jan 20 2017 $28 C","ba") Gives a "Invalid Put/Call indicator (must be a P or C): $=smfGetOptionQuotes("COH Jan 2017 $28 C","ba") Gives a "Error" result I'm running Excel as part of Microsoft Office Professional Plus 2013Microsoft Excel 2013 (15.0.4569.1504) 32-bitOn a Windows 8 Enterprise edition.
#yiv2604754444 #yiv2604754444 -- #yiv2604754444ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2604754444 #yiv2604754444ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2604754444 #yiv2604754444ygrp-mkp #yiv2604754444hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2604754444 #yiv2604754444ygrp-mkp #yiv2604754444ads {margin-bottom:10px;}#yiv2604754444 #yiv2604754444ygrp-mkp .yiv2604754444ad {padding:0 0;}#yiv2604754444 #yiv2604754444ygrp-mkp .yiv2604754444ad p {margin:0;}#yiv2604754444 #yiv2604754444ygrp-mkp .yiv2604754444ad a {color:#0000ff;text-decoration:none;}#yiv2604754444 #yiv2604754444ygrp-sponsor #yiv2604754444ygrp-lc {font-family:Arial;}#yiv2604754444 #yiv2604754444ygrp-sponsor #yiv2604754444ygrp-lc #yiv2604754444hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2604754444 #yiv2604754444ygrp-sponsor #yiv2604754444ygrp-lc .yiv2604754444ad {margin-bottom:10px;padding:0 0;}#yiv2604754444 #yiv2604754444actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2604754444 #yiv2604754444activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2604754444 #yiv2604754444activity span {font-weight:700;}#yiv2604754444 #yiv2604754444activity span:first-child {text-transform:uppercase;}#yiv2604754444 #yiv2604754444activity span a {color:#5085b6;text-decoration:none;}#yiv2604754444 #yiv2604754444activity span span {color:#ff7900;}#yiv2604754444 #yiv2604754444activity span .yiv2604754444underline {text-decoration:underline;}#yiv2604754444 .yiv2604754444attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2604754444 .yiv2604754444attach div a {text-decoration:none;}#yiv2604754444 .yiv2604754444attach img {border:none;padding-right:5px;}#yiv2604754444 .yiv2604754444attach label {display:block;margin-bottom:5px;}#yiv2604754444 .yiv2604754444attach label a {text-decoration:none;}#yiv2604754444 blockquote {margin:0 0 0 4px;}#yiv2604754444 .yiv2604754444bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2604754444 .yiv2604754444bold a {text-decoration:none;}#yiv2604754444 dd.yiv2604754444last p a {font-family:Verdana;font-weight:700;}#yiv2604754444 dd.yiv2604754444last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2604754444 dd.yiv2604754444last p span.yiv2604754444yshortcuts {margin-right:0;}#yiv2604754444 div.yiv2604754444attach-table div div a {text-decoration:none;}#yiv2604754444 div.yiv2604754444attach-table {width:400px;}#yiv2604754444 div.yiv2604754444file-title a, #yiv2604754444 div.yiv2604754444file-title a:active, #yiv2604754444 div.yiv2604754444file-title a:hover, #yiv2604754444 div.yiv2604754444file-title a:visited {text-decoration:none;}#yiv2604754444 div.yiv2604754444photo-title a, #yiv2604754444 div.yiv2604754444photo-title a:active, #yiv2604754444 div.yiv2604754444photo-title a:hover, #yiv2604754444 div.yiv2604754444photo-title a:visited {text-decoration:none;}#yiv2604754444 div#yiv2604754444ygrp-mlmsg #yiv2604754444ygrp-msg p a span.yiv2604754444yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2604754444 .yiv2604754444green {color:#628c2a;}#yiv2604754444 .yiv2604754444MsoNormal {margin:0 0 0 0;}#yiv2604754444 o {font-size:0;}#yiv2604754444 #yiv2604754444photos div {float:left;width:72px;}#yiv2604754444 #yiv2604754444photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2604754444 #yiv2604754444photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2604754444 #yiv2604754444reco-category {font-size:77%;}#yiv2604754444 #yiv2604754444reco-desc {font-size:77%;}#yiv2604754444 .yiv2604754444replbq {margin:4px;}#yiv2604754444 #yiv2604754444ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2604754444 #yiv2604754444ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2604754444 #yiv2604754444ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2604754444 #yiv2604754444ygrp-mlmsg select, #yiv2604754444 input, #yiv2604754444 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2604754444 #yiv2604754444ygrp-mlmsg pre, #yiv2604754444 code {font:115% monospace;}#yiv2604754444 #yiv2604754444ygrp-mlmsg * {line-height:1.22em;}#yiv2604754444 #yiv2604754444ygrp-mlmsg #yiv2604754444logo {padding-bottom:10px;}#yiv2604754444 #yiv2604754444ygrp-msg p a {font-family:Verdana;}#yiv2604754444 #yiv2604754444ygrp-msg p#yiv2604754444attach-count span {color:#1E66AE;font-weight:700;}#yiv2604754444 #yiv2604754444ygrp-reco #yiv2604754444reco-head {color:#ff7900;font-weight:700;}#yiv2604754444 #yiv2604754444ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2604754444 #yiv2604754444ygrp-sponsor #yiv2604754444ov li a {font-size:130%;text-decoration:none;}#yiv2604754444 #yiv2604754444ygrp-sponsor #yiv2604754444ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2604754444 #yiv2604754444ygrp-sponsor #yiv2604754444ov ul {margin:0;padding:0 0 0 8px;}#yiv2604754444 #yiv2604754444ygrp-
On Friday, November 28, 2014 11:51 AM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Sorry about the problems you're having. Unfortunately, option quotes are in flux right now.
>>> =smfGetMSNOptionQuo
MSN recently redid all of their MSN Money web pages and is unlikely to be used again because of how they crippled their data pages.
>>> =smfGetOptionQuotes
Right now, Yahoo is rendering option chains one way on FireFox and Chrome, and another way on IE. I updated all of the routines to the new way when the IE presentation was at first updated, but then Yahoo backed out the IE changes. So I'm not sure what the future of IE option chains will be. In any case, your date is incorrectly stated, you can try:
=smfGetOptionQuotes
Depending on which version of the add-in you have, that might work. It doesn't work in the version I'm using, because it's been updated to the new version of the web page (which Yahoo backed off from, sigh).
>>> =smfGetOptionQuotes
This error is because of a change starting February 1, 2015. That's when the CBOE is aligning monthly expirations to Fridays, so they will match the weekly expiration. The add-in has been fixed for that (so the copy I'm using would accept that date configuration)
Sigh. I hate it when the websites make changes...unless it's because they're adding a lot of functionality.
You could try OptionsXPress if the Yahoo formula I cited above didn't work:
=smfGetOptionQuotes
Unfortunately, although OptionsXPress is the most reliable source so far, it's also the slowest source for option quotes.
On Fri, Nov 28, 2014 at 10:01 AM, John Knudson johneknudson@
I'm a new user to your excellent add-in. And while I have been able to get some basic quote data reporting for me, I have not been able to get the Option quotes to function for me. My attempts and configurations are below, can you help? -JK =smfGetMSNOption
#yiv2604754444 #yiv2604754444 -- #yiv2604754444ygrp-