11 Messages
Digest #4247
Messages
Fri Nov 24, 2017 10:43 pm (PST) . Posted by:
mff2805
hi,
i finally got in to the IBD via the get web data query function, but it seems to have changed a bit.
anyway, i recall getting the stock name off of the IBD web page via one of the templates. Did it go away? if so, can it be restored? part of my process to to start with a ticker and get the name.
thanks much for all you help.
mike
i finally got in to the IBD via the get web data query function, but it seems to have changed a bit.
anyway, i recall getting the stock name off of the IBD web page via one of the templates. Did it go away? if so, can it be restored? part of my process to to start with a ticker and get the name.
thanks much for all you help.
mike
Sat Nov 25, 2017 8:15 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You can grab it from the title tag of the web page:
=smfStrExtr(smfGetTagContent("
https://research.investors.com/stock-quotes/xxxx-IBM.htm","title"),"~","
Stock Quote")
On Fri, Nov 24, 2017 at 11:43 PM, mff3429@
...
wrote:
>
> i finally got in to the IBD via the get web data query function, but it
> seems to have changed a bit.
>
> anyway, i recall getting the stock name off of the IBD web page via one of
> the templates. Did it go away? if so, can it be restored? part of my
> process to to start with a ticker and get the name.
>
=smfStrExtr(smfGetTagContent("
https://research.investors.com/stock-quotes/xxxx-IBM.htm","
Stock Quote")
On Fri, Nov 24, 2017 at 11:43 PM, mff3429@
...
wrote:
>
> i finally got in to the IBD via the get web data query function, but it
> seems to have changed a bit.
>
> anyway, i recall getting the stock name off of the IBD web page via one of
> the templates. Did it go away? if so, can it be restored? part of my
> process to to start with a ticker and get the name.
>
Sat Nov 25, 2017 12:00 pm (PST) . Posted by:
mff2805
ook. thanks.
i also now was able to get this to work, by changing http to https
=smfStrExtr(RCHGetWebData("https://research.investors.com/stock-checkup/xxxx-"&E2&".aspx",UPPER(E2)&","),UPPER(E2)&", "," |")
is this way preferable to what you suggested?
thx,
mike
i also now was able to get this to work, by changing http to https
=smfStrExtr(RCHGetWebData("https://research.investors.com/stock-checkup/xxxx-"&E2&"
is this way preferable to what you suggested?
thx,
mike
Sat Nov 25, 2017 12:15 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It depends on whether you're getting the other IBD data from the quotes
page or the checkup page. You should use the same web page, to reduce the
number of web page retrievals.
Keep in mind that IBD does limit the number of checkups you can do within a
24-hour period (300 or 400?).
On Sat, Nov 25, 2017 at 1:00 PM, mff3429@ wrote:
>
> ook. thanks.
> i also now was able to get this to work, by changing http to https
> =smfStrExtr(RCHGetWebData("https://research.investors.com/st
> ock-checkup/xxxx-"&E2&".aspx",UPPER(E2)&","),UPPER(E2)&", "," |")
>
> is this way preferable to what you suggested?
>
>
page or the checkup page. You should use the same web page, to reduce the
number of web page retrievals.
Keep in mind that IBD does limit the number of checkups you can do within a
24-hour period (300 or 400?).
On Sat, Nov 25, 2017 at 1:00 PM, mff3429@ wrote:
>
> ook. thanks.
> i also now was able to get this to work, by changing http to https
> =smfStrExtr(RCHGetWebData("https://research.investors.com/st
> ock-checkup/
>
> is this way preferable to what you suggested?
>
>
Sat Nov 25, 2017 2:51 pm (PST) . Posted by:
mff2805
thanks. i do pull info using the rchgetelementnumber fucniton, pulling from the stock checkup page. so i'll use the GetWebData approach.
thanks.
thanks.
Sat Nov 25, 2017 2:06 am (PST) . Posted by:
"Rico Teikotte" dzi6ewzrdnxj7wkxo5f6mlhps7ydjxexnjzqjzdg
Clear, thank you Randy!
Sent from Yahoo Mail. Get the app
On Friday, November 24, 2017 2:19 AM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
You can grab some competitor info from MorningStar with something like:
=RCHGetHTMLTable("http://financials.morningstar.com/competitors/industry-peer-data.action?type=com&t=MMM","P/S",-1,"",1)
...but not the metrics you mention.
On Wed, Nov 22, 2017 at 1:06 PM, ricoteikotte@... wrote:
Does somebody know how to retrieve competitor data?I'm looking for ROA, ROE, ROIC data v.s. competitors and/or industry.Can anybody help me out with this?
#yiv7587754419 #yiv7587754419 -- #yiv7587754419ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7587754419 #yiv7587754419ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7587754419 #yiv7587754419ygrp-mkp #yiv7587754419hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7587754419 #yiv7587754419ygrp-mkp #yiv7587754419ads {margin-bottom:10px;}#yiv7587754419 #yiv7587754419ygrp-mkp .yiv7587754419ad {padding:0 0;}#yiv7587754419 #yiv7587754419ygrp-mkp .yiv7587754419ad p {margin:0;}#yiv7587754419 #yiv7587754419ygrp-mkp .yiv7587754419ad a {color:#0000ff;text-decoration:none;}#yiv7587754419 #yiv7587754419ygrp-sponsor #yiv7587754419ygrp-lc {font-family:Arial;}#yiv7587754419 #yiv7587754419ygrp-sponsor #yiv7587754419ygrp-lc #yiv7587754419hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7587754419 #yiv7587754419ygrp-sponsor #yiv7587754419ygrp-lc .yiv7587754419ad {margin-bottom:10px;padding:0 0;}#yiv7587754419 #yiv7587754419actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7587754419 #yiv7587754419activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7587754419 #yiv7587754419activity span {font-weight:700;}#yiv7587754419 #yiv7587754419activity span:first-child {text-transform:uppercase;}#yiv7587754419 #yiv7587754419activity span a {color:#5085b6;text-decoration:none;}#yiv7587754419 #yiv7587754419activity span span {color:#ff7900;}#yiv7587754419 #yiv7587754419activity span .yiv7587754419underline {text-decoration:underline;}#yiv7587754419 .yiv7587754419attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7587754419 .yiv7587754419attach div a {text-decoration:none;}#yiv7587754419 .yiv7587754419attach img {border:none;padding-right:5px;}#yiv7587754419 .yiv7587754419attach label {display:block;margin-bottom:5px;}#yiv7587754419 .yiv7587754419attach label a {text-decoration:none;}#yiv7587754419 blockquote {margin:0 0 0 4px;}#yiv7587754419 .yiv7587754419bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7587754419 .yiv7587754419bold a {text-decoration:none;}#yiv7587754419 dd.yiv7587754419last p a {font-family:Verdana;font-weight:700;}#yiv7587754419 dd.yiv7587754419last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7587754419 dd.yiv7587754419last p span.yiv7587754419yshortcuts {margin-right:0;}#yiv7587754419 div.yiv7587754419attach-table div div a {text-decoration:none;}#yiv7587754419 div.yiv7587754419attach-table {width:400px;}#yiv7587754419 div.yiv7587754419file-title a, #yiv7587754419 div.yiv7587754419file-title a:active, #yiv7587754419 div.yiv7587754419file-title a:hover, #yiv7587754419 div.yiv7587754419file-title a:visited {text-decoration:none;}#yiv7587754419 div.yiv7587754419photo-title a, #yiv7587754419 div.yiv7587754419photo-title a:active, #yiv7587754419 div.yiv7587754419photo-title a:hover, #yiv7587754419 div.yiv7587754419photo-title a:visited {text-decoration:none;}#yiv7587754419 div#yiv7587754419ygrp-mlmsg #yiv7587754419ygrp-msg p a span.yiv7587754419yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7587754419 .yiv7587754419green {color:#628c2a;}#yiv7587754419 .yiv7587754419MsoNormal {margin:0 0 0 0;}#yiv7587754419 o {font-size:0;}#yiv7587754419 #yiv7587754419photos div {float:left;width:72px;}#yiv7587754419 #yiv7587754419photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7587754419 #yiv7587754419photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7587754419 #yiv7587754419reco-category {font-size:77%;}#yiv7587754419 #yiv7587754419reco-desc {font-size:77%;}#yiv7587754419 .yiv7587754419replbq {margin:4px;}#yiv7587754419 #yiv7587754419ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7587754419 #yiv7587754419ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7587754419 #yiv7587754419ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7587754419 #yiv7587754419ygrp-mlmsg select, #yiv7587754419 input, #yiv7587754419 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7587754419 #yiv7587754419ygrp-mlmsg pre, #yiv7587754419 code {font:115% monospace;}#yiv7587754419 #yiv7587754419ygrp-mlmsg * {line-height:1.22em;}#yiv7587754419 #yiv7587754419ygrp-mlmsg #yiv7587754419logo {padding-bottom:10px;}#yiv7587754419 #yiv7587754419ygrp-msg p a {font-family:Verdana;}#yiv7587754419 #yiv7587754419ygrp-msg p#yiv7587754419attach-count span {color:#1E66AE;font-weight:700;}#yiv7587754419 #yiv7587754419ygrp-reco #yiv7587754419reco-head {color:#ff7900;font-weight:700;}#yiv7587754419 #yiv7587754419ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7587754419 #yiv7587754419ygrp-sponsor #yiv7587754419ov li a {font-size:130%;text-decoration:none;}#yiv7587754419 #yiv7587754419ygrp-sponsor #yiv7587754419ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7587754419 #yiv7587754419ygrp-sponsor #yiv7587754419ov ul {margin:0;padding:0 0 0 8px;}#yiv7587754419 #yiv7587754419ygrp-text {font-family:Georgia;}#yiv7587754419 #yiv7587754419ygrp-text p {margin:0 0 1em 0;}#yiv7587754419 #yiv7587754419ygrp-text tt {font-size:120%;}#yiv7587754419 #yiv7587754419ygrp-vital ul li:last-child {border-right:none !important;}#yiv7587754419
Sent from Yahoo Mail. Get the app
On Friday, November 24, 2017 2:19 AM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
You can grab some competitor info from MorningStar with something like:
=RCHGetHTMLTable("http://financials.morningstar.com/competitors/industry-peer-data.action?type=com&t=MMM","
...but not the metrics you mention.
On Wed, Nov 22, 2017 at 1:06 PM, ricoteikotte@... wrote:
Does somebody know how to retrieve competitor data?I'm looking for ROA, ROE, ROIC data v.s. competitors and/or industry.Can anybody help me out with this?
#yiv7587754419 #yiv7587754419 -- #yiv7587754419ygrp-
Sat Nov 25, 2017 7:39 am (PST) . Posted by:
rpower0714
It seems like Yahoo n and lastprice are no longer working
What can I use instead?
Richard
What can I use instead?
Richard
Sat Nov 25, 2017 8:20 am (PST) . Posted by:
"Randy Harmelink" rharmelink
See recent entries on the announcements blog:
https://smf-add-in.blogspot.com/
On Sat, Nov 25, 2017 at 8:39 AM, db_design@
...
wrote:
>
> It seems like Yahoo n and lastprice are no longer working
> What can I use instead?
>
https://smf-add-in.blogspot.com/
On Sat, Nov 25, 2017 at 8:39 AM, db_design@
...
wrote:
>
> It seems like Yahoo n and lastprice are no longer working
> What can I use instead?
>
Sat Nov 25, 2017 7:49 am (PST) . Posted by:
cawley1647@rogers.com
Yes, I cut and pasted badly. It does work.
The FT one though certainly works but it picks up the current ex-div date, rather than the next one, which is a couple of lines down. Is there a way to pick that one up as it's in the future rather than the past?
The FT one though certainly works but it picks up the current ex-div date, rather than the next one, which is a couple of lines down. Is there a way to pick that one up as it's in the future rather than the past?
Sat Nov 25, 2017 8:28 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but I don't see it "a couple of lines down"?
https://markets.ft.com/data/equities/tearsheet/profile?s=ALA:TOR
I doubt the next dividend would have been declared yet?
On Sat, Nov 25, 2017 at 8:49 AM, cawley1647@
...
wrote:
> The FT one though certainly works but it picks up the current ex-div date,
> rather than the next one, which is a couple of lines down. Is there a way
> to pick that one up as it's in the future rather than the past?
>
https://markets.ft.com/data/equities/tearsheet/profile?s=ALA:TOR
I doubt the next dividend would have been declared yet?
On Sat, Nov 25, 2017 at 8:49 AM, cawley1647@
...
wrote:
> The FT one though certainly works but it picks up the current ex-div date,
> rather than the next one, which is a couple of lines down. Is there a way
> to pick that one up as it's in the future rather than the past?
>
Sat Nov 25, 2017 5:54 pm (PST) . Posted by:
dcrapo
Thanks Randy!
I converted arrays from RCHGetYahooQuotes but smfGetYahooPortfolioView will not fill in cells for the additional entries following the first listing. That is, my arrays contain multiple entries of same stock (same stock on succeeding rows - - new entry for every purchase of that stock recording the different purchase prices, comminssions, number of shares etc.).The first entry is filled in but succeeding entries of that same stock are left blank.
Any suggestions for getting all of the cells for all of the stocks filled in?
Is there another source rather than smfGetYahooPorfolioView that will better provide basic info on primarily Canadian stocks?
Thanks, Doug
I converted arrays from RCHGetYahooQuotes but smfGetYahooPortfoli
Any suggestions for getting all of the cells for all of the stocks filled in?
Is there another source rather than smfGetYahooPorfolio
Thanks, Doug
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar