15 Messages
Digest #4263
Messages
Mon Dec 11, 2017 8:04 pm (PST) . Posted by:
mff2805
Hi,
I'm trying to logging in to the ibd website using the Get Web Data functionality. been doing it for 3-4 years. recently and even today, i cannot get a proper login screen to show up in the browser window. the first screen shows up with a login link, but after ESC'ing all the error messages and stopping the first page, then clicking on the login link, all i get is a mostly blank screen. I've tried putting my email address in the one entry box that seems to show up, but afterhitting enter, nothing shows up..
I've contacted IBD and they say they don't support. So, i'm about to cancel out of IBD and find an alternative.
Anyone have any thoughts or suggestions. I'd hate to give up on a process that I've developed and used for many years, but.....
Thanks,
Mike
p.s. my machine is window 10, excel 2010. but i've tried this with windows 7, excel 2016 and windows 10, excel 2016. same behavior.
I'm trying to logging in to the ibd website using the Get Web Data functionality. been doing it for 3-4 years. recently and even today, i cannot get a proper login screen to show up in the browser window. the first screen shows up with a login link, but after ESC'ing all the error messages and stopping the first page, then clicking on the login link, all i get is a mostly blank screen. I've tried putting my email address in the one entry box that seems to show up, but afterhitting enter, nothing shows up..
I've contacted IBD and they say they don't support. So, i'm about to cancel out of IBD and find an alternative.
Anyone have any thoughts or suggestions. I'd hate to give up on a process that I've developed and used for many years, but.....
Thanks,
Mike
p.s. my machine is window 10, excel 2010. but i've tried this with windows 7, excel 2016 and windows 10, excel 2016. same behavior.
Mon Dec 11, 2017 8:09 pm (PST) . Posted by:
"Brad Reel" reeldeal9090
You are trying to get to login screen within the browser in Excel, right?
Please confirm. I've had good luck not "escaping" but instead choosing"No"
to loading more scripts and then being able to login.
On Dec 11, 2017 10:04 PM, "mff3429@comcast.net [smf_addin]" <
smf_addin@yahoogroups.com> wrote:
>
>
> Hi,
> I'm trying to logging in to the ibd website using the Get Web Data
> functionality. been doing it for 3-4 years. recently and even today, i
> cannot get a proper login screen to show up in the browser window. the
> first screen shows up with a login link, but after ESC'ing all the error
> messages and stopping the first page, then clicking on the login link, all
> i get is a mostly blank screen. I've tried putting my email address in the
> one entry box that seems to show up, but afterhitting enter, nothing shows
> up.
> I've contacted IBD and they say they don't support. So, i'm about to
> cancel out of IBD and find an alternative.
> Anyone have any thoughts or suggestions. I'd hate to give up on a process
> that I've developed and used for many years, but.....
> Thanks,
> Mike
> p.s. my machine is window 10, excel 2010. but i've tried this with
> windows 7, excel 2016 and windows 10, excel 2016. same behavior.
>
>
>
>
Please confirm. I've had good luck not "escaping" but instead choosing"No"
to loading more scripts and then being able to login.
On Dec 11, 2017 10:04 PM, "mff3429@comcast.net [smf_addin]" <
smf_addin@yahoogroups.com> wrote:
>
>
> Hi,
> I'm trying to logging in to the ibd website using the Get Web Data
> functionality. been doing it for 3-4 years. recently and even today, i
> cannot get a proper login screen to show up in the browser window. the
> first screen shows up with a login link, but after ESC'ing all the error
> messages and stopping the first page, then clicking on the login link, all
> i get is a mostly blank screen. I've tried putting my email address in the
> one entry box that seems to show up, but afterhitting enter, nothing shows
> up.
> I've contacted IBD and they say they don't support. So, i'm about to
> cancel out of IBD and find an alternative.
> Anyone have any thoughts or suggestions. I'd hate to give up on a process
> that I've developed and used for many years, but.....
> Thanks,
> Mike
> p.s. my machine is window 10, excel 2010. but i've tried this with
> windows 7, excel 2016 and windows 10, excel 2016. same behavior.
>
>
>
>
Mon Dec 11, 2017 8:23 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but I don't want to try it now in case it would screw something up.
:(
However, if my notes are correct, the last time I logged in, I used this
URL in the IE object within EXCEL:
https://myibd.investors.com/secure/signin.aspx
I usually just close out any scripting error box that comes up. I don't use
ESC, because if you hit it too many times successively, it closes the
dialog completely. After the web page is displayed, with no more error
boxes coming up, I click on the red "X" on the top line several times --
it's to the right of the web address that was entered. In many cases when I
log in to a site, this seems to be a necessary step.
In most cases, my login credentials are already saved by IE, so it doesn't
take much to get logged in.
Hope that helps...
On Mon, Dec 11, 2017 at 9:04 PM, mff3429@
...
wrote:
>
> I'm trying to logging in to the ibd website using the Get Web Data
> functionality. been doing it for 3-4 years. recently and even today, i
> cannot get a proper login screen to show up in the browser window. the
> first screen shows up with a login link, but after ESC'ing all the error
> messages and stopping the first page, then clicking on the login link, all
> i get is a mostly blank screen. I've tried putting my email address in the
> one entry box that seems to show up, but afterhitting enter, nothing shows
> up.
> I've contacted IBD and they say they don't support. So, i'm about to
> cancel out of IBD and find an alternative.
> Anyone have any thoughts or suggestions. I'd hate to give up on a process
> that I've developed and used for many years, but.....
> Thanks,
> Mike
> p.s. my machine is window 10, excel 2010. but i've tried this with
> windows 7, excel 2016 and windows 10, excel 2016. same behavior.
>
>
>
:(
However, if my notes are correct, the last time I logged in, I used this
URL in the IE object within EXCEL:
https://myibd.investors.com/secure/signin.aspx
I usually just close out any scripting error box that comes up. I don't use
ESC, because if you hit it too many times successively, it closes the
dialog completely. After the web page is displayed, with no more error
boxes coming up, I click on the red "X" on the top line several times --
it's to the right of the web address that was entered. In many cases when I
log in to a site, this seems to be a necessary step.
In most cases, my login credentials are already saved by IE, so it doesn't
take much to get logged in.
Hope that helps...
On Mon, Dec 11, 2017 at 9:04 PM, mff3429@
...
wrote:
>
> I'm trying to logging in to the ibd website using the Get Web Data
> functionality. been doing it for 3-4 years. recently and even today, i
> cannot get a proper login screen to show up in the browser window. the
> first screen shows up with a login link, but after ESC'ing all the error
> messages and stopping the first page, then clicking on the login link, all
> i get is a mostly blank screen. I've tried putting my email address in the
> one entry box that seems to show up, but afterhitting enter, nothing shows
> up.
> I've contacted IBD and they say they don't support. So, i'm about to
> cancel out of IBD and find an alternative.
> Anyone have any thoughts or suggestions. I'd hate to give up on a process
> that I've developed and used for many years, but.....
> Thanks,
> Mike
> p.s. my machine is window 10, excel 2010. but i've tried this with
> windows 7, excel 2016 and windows 10, excel 2016. same behavior.
>
>
>
Mon Dec 11, 2017 9:40 pm (PST) . Posted by:
mff2805
oh yes, the browser in excel is what's not working. i've tried hitting yes to the error msg, no, and even ESC'ing every time.. just not working. worked rather okay for several years until about a month or so ago.
BTW, anyone know of good alternatives to IBD? ranking of stocks and industry groups,, etc. i don;t mind paying a reasonable fee.
BTW, anyone know of good alternatives to IBD? ranking of stocks and industry groups,, etc. i don;t mind paying a reasonable fee.
Mon Dec 11, 2017 9:50 pm (PST) . Posted by:
mff2805
oh yes, that particular link, in Firefox, brings me to a login page. but, alas, in Excel's web browser, no page shows up. a few scripting error boxes, then nothing. a status bar in the bottom right fills about halfway, but then stops. hitting the Stop red x leads nowhere, although about six months ago or so, it used to.
i'mm stumped.
looking for an alternative to IBD......
thanks,
Mike
i'mm stumped.
looking for an alternative to IBD......
thanks,
Mike
Mon Dec 11, 2017 10:11 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Zacks and Barchart both have industry groups and such.
They, and Stockscores, have a lot of ratings and technical scoring.
On Mon, Dec 11, 2017 at 10:40 PM, mff3429@
...
wrote:
>
> oh yes, the browser in excel is what's not working. i've tried hitting
> yes to the error msg, no, and even ESC'ing every time. just not working.
> worked rather okay for several years until about a month or so ago.
>
> BTW, anyone know of good alternatives to IBD? ranking of stocks and
> industry groups,, etc. i don;t mind paying a reasonable fee.
>
> __._,_
>
They, and Stockscores, have a lot of ratings and technical scoring.
On Mon, Dec 11, 2017 at 10:40 PM, mff3429@
...
wrote:
>
> oh yes, the browser in excel is what's not working. i've tried hitting
> yes to the error msg, no, and even ESC'ing every time. just not working.
> worked rather okay for several years until about a month or so ago.
>
> BTW, anyone know of good alternatives to IBD? ranking of stocks and
> industry groups,, etc. i don;t mind paying a reasonable fee.
>
> __._,_
>
Tue Dec 12, 2017 5:12 am (PST) . Posted by:
"Madhu Khemani" madhu_98
Have you tried our free Relative Strength stock screener?
Growth Stock Analytics http://www.GrowthStockAnalytics.com
Sent from Yahoo Mail for iPhone
On Tuesday, December 12, 2017, 12:52 AM, mff3429@comcast.net [smf_addin] <smf_addin@yahoogroups.com> wrote:
oh yes, that particular link, in Firefox, brings me to a login page. but, alas, in Excel's web browser, no page shows up. a few scripting error boxes, then nothing. a status bar in the bottom right fills about halfway, but then stops. hitting the Stop red x leads nowhere, although about six months ago or so, it used to.
i'mm stumped.
looking for an alternative to IBD......
thanks,
Mike
#yiv4030964970 #yiv4030964970 -- #yiv4030964970ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4030964970 #yiv4030964970ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4030964970 #yiv4030964970ygrp-mkp #yiv4030964970hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4030964970 #yiv4030964970ygrp-mkp #yiv4030964970ads {margin-bottom:10px;}#yiv4030964970 #yiv4030964970ygrp-mkp .yiv4030964970ad {padding:0 0;}#yiv4030964970 #yiv4030964970ygrp-mkp .yiv4030964970ad p {margin:0;}#yiv4030964970 #yiv4030964970ygrp-mkp .yiv4030964970ad a {color:#0000ff;text-decoration:none;}#yiv4030964970 #yiv4030964970ygrp-sponsor #yiv4030964970ygrp-lc {font-family:Arial;}#yiv4030964970 #yiv4030964970ygrp-sponsor #yiv4030964970ygrp-lc #yiv4030964970hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4030964970 #yiv4030964970ygrp-sponsor #yiv4030964970ygrp-lc .yiv4030964970ad {margin-bottom:10px;padding:0 0;}#yiv4030964970 #yiv4030964970actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4030964970 #yiv4030964970activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4030964970 #yiv4030964970activity span {font-weight:700;}#yiv4030964970 #yiv4030964970activity span:first-child {text-transform:uppercase;}#yiv4030964970 #yiv4030964970activity span a {color:#5085b6;text-decoration:none;}#yiv4030964970 #yiv4030964970activity span span {color:#ff7900;}#yiv4030964970 #yiv4030964970activity span .yiv4030964970underline {text-decoration:underline;}#yiv4030964970 .yiv4030964970attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4030964970 .yiv4030964970attach div a {text-decoration:none;}#yiv4030964970 .yiv4030964970attach img {border:none;padding-right:5px;}#yiv4030964970 .yiv4030964970attach label {display:block;margin-bottom:5px;}#yiv4030964970 .yiv4030964970attach label a {text-decoration:none;}#yiv4030964970 blockquote {margin:0 0 0 4px;}#yiv4030964970 .yiv4030964970bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4030964970 .yiv4030964970bold a {text-decoration:none;}#yiv4030964970 dd.yiv4030964970last p a {font-family:Verdana;font-weight:700;}#yiv4030964970 dd.yiv4030964970last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4030964970 dd.yiv4030964970last p span.yiv4030964970yshortcuts {margin-right:0;}#yiv4030964970 div.yiv4030964970attach-table div div a {text-decoration:none;}#yiv4030964970 div.yiv4030964970attach-table {width:400px;}#yiv4030964970 div.yiv4030964970file-title a, #yiv4030964970 div.yiv4030964970file-title a:active, #yiv4030964970 div.yiv4030964970file-title a:hover, #yiv4030964970 div.yiv4030964970file-title a:visited {text-decoration:none;}#yiv4030964970 div.yiv4030964970photo-title a, #yiv4030964970 div.yiv4030964970photo-title a:active, #yiv4030964970 div.yiv4030964970photo-title a:hover, #yiv4030964970 div.yiv4030964970photo-title a:visited {text-decoration:none;}#yiv4030964970 div#yiv4030964970ygrp-mlmsg #yiv4030964970ygrp-msg p a span.yiv4030964970yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4030964970 .yiv4030964970green {color:#628c2a;}#yiv4030964970 .yiv4030964970MsoNormal {margin:0 0 0 0;}#yiv4030964970 o {font-size:0;}#yiv4030964970 #yiv4030964970photos div {float:left;width:72px;}#yiv4030964970 #yiv4030964970photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4030964970 #yiv4030964970photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4030964970 #yiv4030964970reco-category {font-size:77%;}#yiv4030964970 #yiv4030964970reco-desc {font-size:77%;}#yiv4030964970 .yiv4030964970replbq {margin:4px;}#yiv4030964970 #yiv4030964970ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4030964970 #yiv4030964970ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4030964970 #yiv4030964970ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4030964970 #yiv4030964970ygrp-mlmsg select, #yiv4030964970 input, #yiv4030964970 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4030964970 #yiv4030964970ygrp-mlmsg pre, #yiv4030964970 code {font:115% monospace;}#yiv4030964970 #yiv4030964970ygrp-mlmsg * {line-height:1..22em;}#yiv4030964970 #yiv4030964970ygrp-mlmsg #yiv4030964970logo {padding-bottom:10px;}#yiv4030964970 #yiv4030964970ygrp-msg p a {font-family:Verdana;}#yiv4030964970 #yiv4030964970ygrp-msg p#yiv4030964970attach-count span {color:#1E66AE;font-weight:700;}#yiv4030964970 #yiv4030964970ygrp-reco #yiv4030964970reco-head {color:#ff7900;font-weight:700;}#yiv4030964970 #yiv4030964970ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4030964970 #yiv4030964970ygrp-sponsor #yiv4030964970ov li a {font-size:130%;text-decoration:none;}#yiv4030964970 #yiv4030964970ygrp-sponsor #yiv4030964970ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4030964970 #yiv4030964970ygrp-sponsor #yiv4030964970ov ul {margin:0;padding:0 0 0 8px;}#yiv4030964970 #yiv4030964970ygrp-text {font-family:Georgia;}#yiv4030964970 #yiv4030964970ygrp-text p {margin:0 0 1em 0;}#yiv4030964970 #yiv4030964970ygrp-text tt {font-size:120%;}#yiv4030964970 #yiv4030964970ygrp-vital ul li:last-child {border-right:none !important;}#yiv4030964970
Growth Stock Analytics http://www.GrowthStockAnalytics.com
Sent from Yahoo Mail for iPhone
On Tuesday, December 12, 2017, 12:52 AM, mff3429@comcast.net [smf_addin] <smf_addin@yahoogroups.com> wrote:
oh yes, that particular link, in Firefox, brings me to a login page. but, alas, in Excel's web browser, no page shows up. a few scripting error boxes, then nothing. a status bar in the bottom right fills about halfway, but then stops. hitting the Stop red x leads nowhere, although about six months ago or so, it used to.
i'mm stumped.
looking for an alternative to IBD......
thanks,
Mike
#yiv4030964970 #yiv4030964970 -- #yiv4030964970ygrp-
Tue Dec 12, 2017 5:33 am (PST) . Posted by:
"Ron Spruell" hashky
I stand corrected. I separated my Expiry Dates source from the Data Source. I wasn't aware that G, OX, Y, and B defaulted to Y.
smfGetOptionExpirations
Changing source from B to Y on the Expiry Dates causes no changes.
smfGetOptionStrikes Changing source from B to Y on Data Source causes changes.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Monday, December 11, 2017 11:04 AM
Subject: Re: [smf_addin] Problem with smfGetOptionExpirations()
Except that smfGetOptionExpirations() doesn't get expirations from Barchart. It actually gets them from Yahoo. I didn't want to require someone to have to use separate "Source" codes for the different option functions, so instead of not allowing "B" for smfGetOptionExpirations(), I just had it go to Yahoo as a substitute.
On Mon, Dec 11, 2017 at 6:24 AM, Ron Spruell hashky@... wrote:
I have found that Barcharts does a good job of getting expirations.
#yiv8994204871 #yiv8994204871 -- #yiv8994204871ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8994204871 #yiv8994204871ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8994204871 #yiv8994204871ygrp-mkp #yiv8994204871hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8994204871 #yiv8994204871ygrp-mkp #yiv8994204871ads {margin-bottom:10px;}#yiv8994204871 #yiv8994204871ygrp-mkp .yiv8994204871ad {padding:0 0;}#yiv8994204871 #yiv8994204871ygrp-mkp .yiv8994204871ad p {margin:0;}#yiv8994204871 #yiv8994204871ygrp-mkp .yiv8994204871ad a {color:#0000ff;text-decoration:none;}#yiv8994204871 #yiv8994204871ygrp-sponsor #yiv8994204871ygrp-lc {font-family:Arial;}#yiv8994204871 #yiv8994204871ygrp-sponsor #yiv8994204871ygrp-lc #yiv8994204871hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8994204871 #yiv8994204871ygrp-sponsor #yiv8994204871ygrp-lc .yiv8994204871ad {margin-bottom:10px;padding:0 0;}#yiv8994204871 #yiv8994204871actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8994204871 #yiv8994204871activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8994204871 #yiv8994204871activity span {font-weight:700;}#yiv8994204871 #yiv8994204871activity span:first-child {text-transform:uppercase;}#yiv8994204871 #yiv8994204871activity span a {color:#5085b6;text-decoration:none;}#yiv8994204871 #yiv8994204871activity span span {color:#ff7900;}#yiv8994204871 #yiv8994204871activity span .yiv8994204871underline {text-decoration:underline;}#yiv8994204871 .yiv8994204871attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8994204871 .yiv8994204871attach div a {text-decoration:none;}#yiv8994204871 .yiv8994204871attach img {border:none;padding-right:5px;}#yiv8994204871 .yiv8994204871attach label {display:block;margin-bottom:5px;}#yiv8994204871 .yiv8994204871attach label a {text-decoration:none;}#yiv8994204871 blockquote {margin:0 0 0 4px;}#yiv8994204871 .yiv8994204871bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8994204871 .yiv8994204871bold a {text-decoration:none;}#yiv8994204871 dd.yiv8994204871last p a {font-family:Verdana;font-weight:700;}#yiv8994204871 dd.yiv8994204871last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8994204871 dd.yiv8994204871last p span.yiv8994204871yshortcuts {margin-right:0;}#yiv8994204871 div.yiv8994204871attach-table div div a {text-decoration:none;}#yiv8994204871 div.yiv8994204871attach-table {width:400px;}#yiv8994204871 div.yiv8994204871file-title a, #yiv8994204871 div.yiv8994204871file-title a:active, #yiv8994204871 div.yiv8994204871file-title a:hover, #yiv8994204871 div.yiv8994204871file-title a:visited {text-decoration:none;}#yiv8994204871 div.yiv8994204871photo-title a, #yiv8994204871 div.yiv8994204871photo-title a:active, #yiv8994204871 div.yiv8994204871photo-title a:hover, #yiv8994204871 div.yiv8994204871photo-title a:visited {text-decoration:none;}#yiv8994204871 div#yiv8994204871ygrp-mlmsg #yiv8994204871ygrp-msg p a span.yiv8994204871yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8994204871 .yiv8994204871green {color:#628c2a;}#yiv8994204871 .yiv8994204871MsoNormal {margin:0 0 0 0;}#yiv8994204871 o {font-size:0;}#yiv8994204871 #yiv8994204871photos div {float:left;width:72px;}#yiv8994204871 #yiv8994204871photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8994204871 #yiv8994204871photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8994204871 #yiv8994204871reco-category {font-size:77%;}#yiv8994204871 #yiv8994204871reco-desc {font-size:77%;}#yiv8994204871 .yiv8994204871replbq {margin:4px;}#yiv8994204871 #yiv8994204871ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8994204871 #yiv8994204871ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8994204871 #yiv8994204871ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8994204871 #yiv8994204871ygrp-mlmsg select, #yiv8994204871 input, #yiv8994204871 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8994204871 #yiv8994204871ygrp-mlmsg pre, #yiv8994204871 code {font:115% monospace;}#yiv8994204871 #yiv8994204871ygrp-mlmsg * {line-height:1.22em;}#yiv8994204871 #yiv8994204871ygrp-mlmsg #yiv8994204871logo {padding-bottom:10px;}#yiv8994204871 #yiv8994204871ygrp-msg p a {font-family:Verdana;}#yiv8994204871 #yiv8994204871ygrp-msg p#yiv8994204871attach-count span {color:#1E66AE;font-weight:700;}#yiv8994204871 #yiv8994204871ygrp-reco #yiv8994204871reco-head {color:#ff7900;font-weight:700;}#yiv8994204871 #yiv8994204871ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8994204871 #yiv8994204871ygrp-sponsor #yiv8994204871ov li a {font-size:130%;text-decoration:none;}#yiv8994204871 #yiv8994204871ygrp-sponsor #yiv8994204871ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8994204871 #yiv8994204871ygrp-sponsor #yiv8994204871ov ul {margin:0;padding:0 0 0 8px;}#yiv8994204871 #yiv8994204871ygrp-text {font-family:Georgia;}#yiv8994204871 #yiv8994204871ygrp-text p {margin:0 0 1em 0;}#yiv8994204871 #yiv8994204871ygrp-text tt {font-size:120%;}#yiv8994204871 #yiv8994204871ygrp-vital ul li:last-child {border-right:none !important;}#yiv8994204871
smfGetOptionExpirations
Changing source from B to Y on the Expiry Dates causes no changes.
smfGetOptionStrikes Changing source from B to Y on Data Source causes changes.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Monday, December 11, 2017 11:04 AM
Subject: Re: [smf_addin] Problem with smfGetOptionExpirat
Except that smfGetOptionExpirat
On Mon, Dec 11, 2017 at 6:24 AM, Ron Spruell hashky@... wrote:
I have found that Barcharts does a good job of getting expirations.
#yiv8994204871 #yiv8994204871 -- #yiv8994204871ygrp-
Tue Dec 12, 2017 5:38 am (PST) . Posted by:
eclipsme
On this page:
https://seekingalpha.com/dividends/dividend-news https://seekingalpha.com/dividends/dividend-news
Is it possible to extract decreases from the series of divs (<font color="red"> for instance), or do your tools only work with tables?
Thanks
https://seekingalpha.com/dividends/dividend-news https://seekingalpha.com/dividends/dividend-news
Is it possible to extract decreases from the series of divs (<font color="
Thanks
Tue Dec 12, 2017 7:38 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You would use the smfGetTagContent() function to extract data from within
paired HTML tags.
However, finding each one with that function alone would be tedious. If all
you want is the decreases, you're probably going to have to do a cascading
extraction with RCHGetWebData() to find each one first and then do
specialized extraction of each.
On Tue, Dec 12, 2017 at 6:38 AM, harvey@
...
wrote:
>
> On this page:
> https://seekingalpha.com/dividends/dividend-news
>
> Is it possible to extract decreases from the series of divs (<font
> color="red"> for instance), or do your tools only work with tables?
>
>
>
paired HTML tags.
However, finding each one with that function alone would be tedious. If all
you want is the decreases, you're probably going to have to do a cascading
extraction with RCHGetWebData() to find each one first and then do
specialized extraction of each.
On Tue, Dec 12, 2017 at 6:38 AM, harvey@
...
wrote:
>
> On this page:
> https://seekingalpha.com/dividends/dividend-news
>
> Is it possible to extract decreases from the series of divs (<font
> color="
>
>
>
Tue Dec 12, 2017 12:51 pm (PST) . Posted by:
a.bereziuk
Hi,
can somebody advice a website with a "dividend frequency" value (monthly, quarterly, etc.) to extract?
can somebody advice a website with a "dividend frequency" value (monthly, quarterly, etc.) to extract?
Tue Dec 12, 2017 2:43 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
GuruFocus appears to have it. Try:
=smfGetTagContent("https://www.gurufocus.com/dividend/
"&C4,"td",6,">Ex-Date","<tr")
Otherwise, you could count the number of dividends paid in the past year,
using Yahoo historical quotes:
=COUNT(smfGetYahooHistory(C4,B4-365,+B4,"v",,0,,20,2))/2
On Tue, Dec 12, 2017 at 1:51 PM, a.bereziuk@
...
wrote:
>
> can somebody advice a website with a "dividend frequency" value (monthly,
> quarterly, etc.) to extract?
>
>
>
=smfGetTagContent("https://www.gurufocus.com/dividend/
"&C4,"
Otherwise, you could count the number of dividends paid in the past year,
using Yahoo historical quotes:
=COUNT(smfGetYahooH
On Tue, Dec 12, 2017 at 1:51 PM, a.bereziuk@
...
wrote:
>
> can somebody advice a website with a "dividend frequency" value (monthly,
> quarterly, etc.) to extract?
>
>
>
Tue Dec 12, 2017 5:29 pm (PST) . Posted by:
lexstar
I'm using IE version 11
I get www.yahoo.com http://www.yahoo.com site when ALT+D+D+W
And, yes, I can see the historical quotes for MMM
My problem now is that sometimes I get data and sometimes I don't. For example, for SPY, I may get data for October, but not for November and December. All I get is "ERROR".
A couple of times I went back to the ADD-INS and uncheck the Stock Market Functions Add-in and then re-check again, and it works.
Now, it doesn't.
I'm just at a lost now.
I get www.yahoo.com http://www.yahoo.com site when ALT+D+D+W
And, yes, I can see the historical quotes for MMM
My problem now is that sometimes I get data and sometimes I don't. For example, for SPY, I may get data for October, but not for November and December. All I get is "ERROR"
A couple of times I went back to the ADD-INS and uncheck the Stock Market Functions Add-in and then re-check again, and it works.
Now, it doesn't.
I'm just at a lost now.
Tue Dec 12, 2017 5:58 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
What did you get with this URL in the IE object within EXCEL:
http://www.pinlady.net/PluginDetect/IE/
In any case, if neither of these work:
=RCHGetWebData("
https://finance.yahoo.com/quote/MMM/history?period1=1512950400&period2=1513123200&interval=1d&filter=history&frequency=1d
","HistoricalPriceStore",200)
=RCHGetWebData("
https://finance.yahoo.com/quote/MMM/history?period1=1512950400&period2=1513123200&interval=1d&filter=history&frequency=1d
","""open"":236",200)
....then none of smfGetYahooHistory(), RCHGetYahooHistory(),
smfPricesByDates(), or smfPricesBetween() will work, because they all use a
form of that first function to get the raw data in the first place.
The only other thing I can think to try is to try and remove the add-in
altogether, and then re-install it:
1. Go to the add-in manager and uncheck the add-in.
2. Exit EXCEL.
3. Physically delete the add-in folder (or at least change the name of the
folder temporarily).
4. Restart EXCEL. Hopefully, it will ask you about the add-in? Either way,
go into the add-in manager and see if it is still there. It should be gone.
If it does still exist, check to see where it is located, and see if you
can run the function to get the version.
5. Exit EXCEL
6. Restore the folder and the add-in files.
7. Restart EXCEL.
8. Go to the add-in manager and reactivate the add-in from that folder.
Check the version again.
9. Exit EXCEL
10. Restart EXCEL. Check the version.
Try those two functions above, plus an smfGetYahooHistory() function.
On Tue, Dec 12, 2017 at 6:29 PM, lexstar@
...
wrote:
>
> I'm using IE version 11
>
> I get www.yahoo.com site when ALT+D+D+W
>
> And, yes, I can see the historical quotes for MMM
>
> My problem now is that sometimes I get data and sometimes I don't. For
> example, for SPY, I may get data for October, but not for November and
> December. All I get is "ERROR".
>
> A couple of times I went back to the ADD-INS and uncheck the Stock Market
> Functions Add-in and then re-check again, and it works.
>
> Now, it doesn't.
>
> I'm just at a lost now.
>
http://www.pinlady.net/PluginDetect/IE/
In any case, if neither of these work:
=RCHGetWebData("
https://finance.yahoo.com/quote/MMM/history?period1=1512950400&period2=1513123200&interval=1d&filter=history&frequency=1d
","HistoricalPriceStore",200)
=RCHGetWebData("
https://finance.yahoo.com/quote/MMM/history?period1=1512950400&period2=1513123200&interval=1d&filter=history&frequency=1d
","
....then none of smfGetYahooHistory(
smfPricesByDates(
form of that first function to get the raw data in the first place.
The only other thing I can think to try is to try and remove the add-in
altogether, and then re-install it:
1. Go to the add-in manager and uncheck the add-in.
2. Exit EXCEL.
3. Physically delete the add-in folder (or at least change the name of the
folder temporarily)
4. Restart EXCEL. Hopefully, it will ask you about the add-in? Either way,
go into the add-in manager and see if it is still there. It should be gone.
If it does still exist, check to see where it is located, and see if you
can run the function to get the version.
5. Exit EXCEL
6. Restore the folder and the add-in files.
7. Restart EXCEL.
8. Go to the add-in manager and reactivate the add-in from that folder.
Check the version again.
9. Exit EXCEL
10. Restart EXCEL. Check the version.
Try those two functions above, plus an smfGetYahooHistory(
On Tue, Dec 12, 2017 at 6:29 PM, lexstar@
...
wrote:
>
> I'm using IE version 11
>
> I get www.yahoo.com site when ALT+D+D+W
>
> And, yes, I can see the historical quotes for MMM
>
> My problem now is that sometimes I get data and sometimes I don't. For
> example, for SPY, I may get data for October, but not for November and
> December. All I get is "ERROR"
>
> A couple of times I went back to the ADD-INS and uncheck the Stock Market
> Functions Add-in and then re-check again, and it works.
>
> Now, it doesn't.
>
> I'm just at a lost now.
>
Tue Dec 12, 2017 6:08 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Another thing that might be worth trying:
=smfStripHTML(smfGetTagContent("http://www.pinlady.net/PluginDetect/IE/","div",-1,"Your
browser is",,,,,,1))
I usually get "Error" with that the first time I use it, but if I do an
smfForceRecalculation I get:
"Internet Explorer Browser Detector
Your browser is IE: true
Your IE browser version: 11
----------------------------------------------------------
True IE browser version (independent of userAgent, document mode, or
browser mode): null
IE browser version (derived from navigator.userAgent): 11
IE browser document mode: 11"
That should be the actual browser software? Or, with:
=smfStripHTML(smfGetTagContent("http://www.pinlady.net/PluginDetect/IE/","div",-1,"Your
browser is",,,,,,2))
....I get (this should be the IE object within EXCEL):
"Internet Explorer Browser Detector
Your browser is IE: true
Your IE browser version: 11.15
----------------------------------------------------------
True IE browser version (independent of userAgent, document mode, or
browser mode): 11.15.16299.0
IE browser version (derived from navigator.userAgent): 7
IE browser document mode: 7"
On Tue, Dec 12, 2017 at 6:29 PM, lexstar@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I'm using IE version 11
>
> I get www.yahoo.com site when ALT+D+D+W
>
> And, yes, I can see the historical quotes for MMM
>
> My problem now is that sometimes I get data and sometimes I don't. For
> example, for SPY, I may get data for October, but not for November and
> December. All I get is "ERROR".
>
> A couple of times I went back to the ADD-INS and uncheck the Stock Market
> Functions Add-in and then re-check again, and it works.
>
> Now, it doesn't.
>
> I'm just at a lost now.
>
>
=smfStripHTML(smfGetTagContent("http://www.pinlady.net/PluginDetect/IE/","div",-1,"Your
browser is",,,,,,1))
I usually get "Error" with that the first time I use it, but if I do an
smfForceRecalculation I get:
"Internet Explorer Browser Detector
Your browser is IE: true
Your IE browser version: 11
----------------------------------------------------------
True IE browser version (independent of userAgent, document mode, or
browser mode): null
IE browser version (derived from navigator.userAgent): 11
IE browser document mode: 11"
That should be the actual browser software? Or, with:
=smfStripHTML(smfGetTagContent("http://www.pinlady.net/PluginDetect/IE/","div",-1,"Your
browser is",,,,,,2))
....I get (this should be the IE object within EXCEL):
"Internet Explorer Browser Detector
Your browser is IE: true
Your IE browser version: 11.15
----------------------------------------------------------
True IE browser version (independent of userAgent, document mode, or
browser mode): 11.15.16299.0
IE browser version (derived from navigator.userAgent): 7
IE browser document mode: 7"
On Tue, Dec 12, 2017 at 6:29 PM, lexstar@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I'm using IE version 11
>
> I get www.yahoo.com site when ALT+D+D+W
>
> And, yes, I can see the historical quotes for MMM
>
> My problem now is that sometimes I get data and sometimes I don't. For
> example, for SPY, I may get data for October, but not for November and
> December. All I get is "ERROR"
>
> A couple of times I went back to the ADD-INS and uncheck the Stock Market
> Functions Add-in and then re-check again, and it works.
>
> Now, it doesn't.
>
> I'm just at a lost now.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar