6 Messages
Digest #3998
Messages
Sat May 6, 2017 9:09 pm (PDT) . Posted by:
"Al Eaton" aleaton93309
Randy,
First, thanks for all your hard work on this Group, it. I have noticed that
Yahoo Quotes does not download most ETF dividends. Yahoo may show a yield
on the web site but the actual dividend is not downloaded. Do you know of
another source for ETF dividend downloads?
Al Eaton
aleaton48@gmail.com <mailto:aleaton48@gmail.com>
First, thanks for all your hard work on this Group, it. I have noticed that
Yahoo Quotes does not download most ETF dividends. Yahoo may show a yield
on the web site but the actual dividend is not downloaded. Do you know of
another source for ETF dividend downloads?
Al Eaton
aleaton48@gmail.com <mailto:aleaton48@gmail.com>
Sat May 6, 2017 9:39 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
=smfGetTagContent("http://etfs.morningstar.com/etfq/quote-banner?t=SPY
","span",1,"id=""Yield";"",,,,1)
On Sat, May 6, 2017 at 9:09 PM, 'Al Eaton' aleaton48@
...wrote:
>
>
> First, thanks for all your hard work on this Group, it. I have noticed
> that Yahoo Quotes does not download most ETF dividends. Yahoo may show a
> yield on the web site but the actual dividend is not downloaded. Do you
> know of another source for ETF dividend downloads?
>
>
>
=smfGetTagContent("http://etfs.morningstar.com/etfq/quote-banner?t=SPY
","
On Sat, May 6, 2017 at 9:09 PM, 'Al Eaton' aleaton48@
...wrote:
>
>
> First, thanks for all your hard work on this Group, it. I have noticed
> that Yahoo Quotes does not download most ETF dividends. Yahoo may show a
> yield on the web site but the actual dividend is not downloaded. Do you
> know of another source for ETF dividend downloads?
>
>
>
Sat May 6, 2017 9:10 pm (PDT) . Posted by:
mff2805
ok. that works. thanks could be easier.
do you know where the cookie is? can it be saved to a place and used again later, when a login is required?
do you know where the cookie is? can it be saved to a place and used again later, when a login is required?
Sat May 6, 2017 10:40 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not sure if that would work. In any case, not sure where it would be...
On Sat, May 6, 2017 at 9:10 PM, mff3429@
...wrote:
>
> ok. that works. thanks could be easier.
>
> do you know where the cookie is? can it be saved to a place and used
> again later, when a login is required?
>
On Sat, May 6, 2017 at 9:10 PM, mff3429@
...wrote:
>
> ok. that works. thanks could be easier.
>
> do you know where the cookie is? can it be saved to a place and used
> again later, when a login is required?
>
Sun May 7, 2017 10:21 am (PDT) . Posted by:
"Gary Reneau" gareneau
The sheet I'm using is from a friend who had this to say about looking up commodity prices (see below). Is he right?
Gary,
I can see why you can't retrieve commodity prices. Yahoo does not maintain historical prices on those commodity values. You can see this when you type them into Yahoo Finance. There is no tab for 'Historical Prices', unlike most other symbols.
The macro I use is 'RCHGetYahooHistory' which seeks out the tab described above.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Saturday, May 6, 2017 12:10 PM
Subject: Re: [smf_addin] Re: Current and Historical Data for Currencies and Commodities
I'd need more details on the actual functions you're using. I don't do anything with commodities. It looks to me like these work:
=RCHGetYahooQuotes("GC=F","l1")
=RCHGetYahooQuotes("GCZ22.CMX","l1")
On Sat, May 6, 2017 at 3:30 AM, gareneau@...wrote:
First time post - I'm using a customized Excel spreadsheet to track DeMark signals that integrates the smf add in. Two things: Yahoo provides commodity quotes, but when I enter those in my spreadsheet I get an error message. Why, if I can get a price quote in Yahoo Finance, does it not carry over into the smf add in function?
Also, I would like the spreadsheet to take a whole list of tickers and run the DeMark analytics against each every day (as opposed to my inputting each ticker symbol). What would also be great is to program the sheet to alert me when pertinent DeMark exhaustion points are reached, but that may not be possible.
Any ideas?
Thanks -
#yiv1445127154 #yiv1445127154 -- #yiv1445127154ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1445127154 #yiv1445127154ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1445127154 #yiv1445127154ygrp-mkp #yiv1445127154hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1445127154 #yiv1445127154ygrp-mkp #yiv1445127154ads {margin-bottom:10px;}#yiv1445127154 #yiv1445127154ygrp-mkp .yiv1445127154ad {padding:0 0;}#yiv1445127154 #yiv1445127154ygrp-mkp .yiv1445127154ad p {margin:0;}#yiv1445127154 #yiv1445127154ygrp-mkp .yiv1445127154ad a {color:#0000ff;text-decoration:none;}#yiv1445127154 #yiv1445127154ygrp-sponsor #yiv1445127154ygrp-lc {font-family:Arial;}#yiv1445127154 #yiv1445127154ygrp-sponsor #yiv1445127154ygrp-lc #yiv1445127154hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1445127154 #yiv1445127154ygrp-sponsor #yiv1445127154ygrp-lc .yiv1445127154ad {margin-bottom:10px;padding:0 0;}#yiv1445127154 #yiv1445127154actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1445127154 #yiv1445127154activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1445127154 #yiv1445127154activity span {font-weight:700;}#yiv1445127154 #yiv1445127154activity span:first-child {text-transform:uppercase;}#yiv1445127154 #yiv1445127154activity span a {color:#5085b6;text-decoration:none;}#yiv1445127154 #yiv1445127154activity span span {color:#ff7900;}#yiv1445127154 #yiv1445127154activity span .yiv1445127154underline {text-decoration:underline;}#yiv1445127154 .yiv1445127154attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1445127154 .yiv1445127154attach div a {text-decoration:none;}#yiv1445127154 .yiv1445127154attach img {border:none;padding-right:5px;}#yiv1445127154 .yiv1445127154attach label {display:block;margin-bottom:5px;}#yiv1445127154 .yiv1445127154attach label a {text-decoration:none;}#yiv1445127154 blockquote {margin:0 0 0 4px;}#yiv1445127154 .yiv1445127154bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1445127154 .yiv1445127154bold a {text-decoration:none;}#yiv1445127154 dd.yiv1445127154last p a {font-family:Verdana;font-weight:700;}#yiv1445127154 dd.yiv1445127154last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1445127154 dd.yiv1445127154last p span.yiv1445127154yshortcuts {margin-right:0;}#yiv1445127154 div.yiv1445127154attach-table div div a {text-decoration:none;}#yiv1445127154 div.yiv1445127154attach-table {width:400px;}#yiv1445127154 div.yiv1445127154file-title a, #yiv1445127154 div.yiv1445127154file-title a:active, #yiv1445127154 div.yiv1445127154file-title a:hover, #yiv1445127154 div.yiv1445127154file-title a:visited {text-decoration:none;}#yiv1445127154 div.yiv1445127154photo-title a, #yiv1445127154 div.yiv1445127154photo-title a:active, #yiv1445127154 div.yiv1445127154photo-title a:hover, #yiv1445127154 div.yiv1445127154photo-title a:visited {text-decoration:none;}#yiv1445127154 div#yiv1445127154ygrp-mlmsg #yiv1445127154ygrp-msg p a span.yiv1445127154yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1445127154 .yiv1445127154green {color:#628c2a;}#yiv1445127154 .yiv1445127154MsoNormal {margin:0 0 0 0;}#yiv1445127154 o {font-size:0;}#yiv1445127154 #yiv1445127154photos div {float:left;width:72px;}#yiv1445127154 #yiv1445127154photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1445127154 #yiv1445127154photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1445127154 #yiv1445127154reco-category {font-size:77%;}#yiv1445127154 #yiv1445127154reco-desc {font-size:77%;}#yiv1445127154 .yiv1445127154replbq {margin:4px;}#yiv1445127154 #yiv1445127154ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1445127154 #yiv1445127154ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1445127154 #yiv1445127154ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1445127154 #yiv1445127154ygrp-mlmsg select, #yiv1445127154 input, #yiv1445127154 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1445127154 #yiv1445127154ygrp-mlmsg pre, #yiv1445127154 code {font:115% monospace;}#yiv1445127154 #yiv1445127154ygrp-mlmsg * {line-height:1.22em;}#yiv1445127154 #yiv1445127154ygrp-mlmsg #yiv1445127154logo {padding-bottom:10px;}#yiv1445127154 #yiv1445127154ygrp-msg p a {font-family:Verdana;}#yiv1445127154 #yiv1445127154ygrp-msg p#yiv1445127154attach-count span {color:#1E66AE;font-weight:700;}#yiv1445127154 #yiv1445127154ygrp-reco #yiv1445127154reco-head {color:#ff7900;font-weight:700;}#yiv1445127154 #yiv1445127154ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1445127154 #yiv1445127154ygrp-sponsor #yiv1445127154ov li a {font-size:130%;text-decoration:none;}#yiv1445127154 #yiv1445127154ygrp-sponsor #yiv1445127154ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1445127154 #yiv1445127154ygrp-sponsor #yiv1445127154ov ul {margin:0;padding:0 0 0 8px;}#yiv1445127154 #yiv1445127154ygrp-text {font-family:Georgia;}#yiv1445127154 #yiv1445127154ygrp-text p {margin:0 0 1em 0;}#yiv1445127154 #yiv1445127154ygrp-text tt {font-size:120%;}#yiv1445127154 #yiv1445127154ygrp-vital ul li:last-child {border-right:none !important;}#yiv1445127154
Gary,
I can see why you can't retrieve commodity prices. Yahoo does not maintain historical prices on those commodity values. You can see this when you type them into Yahoo Finance. There is no tab for 'Historical Prices', unlike most other symbols.
The macro I use is 'RCHGetYahooHistory' which seeks out the tab described above.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Saturday, May 6, 2017 12:10 PM
Subject: Re: [smf_addin] Re: Current and Historical Data for Currencies and Commodities
I'd need more details on the actual functions you're using. I don't do anything with commodities. It looks to me like these work:
=RCHGetYahooQuotes(
=RCHGetYahooQuotes(
On Sat, May 6, 2017 at 3:30 AM, gareneau@...wrote:
First time post - I'm using a customized Excel spreadsheet to track DeMark signals that integrates the smf add in. Two things: Yahoo provides commodity quotes, but when I enter those in my spreadsheet I get an error message. Why, if I can get a price quote in Yahoo Finance, does it not carry over into the smf add in function?
Also, I would like the spreadsheet to take a whole list of tickers and run the DeMark analytics against each every day (as opposed to my inputting each ticker symbol). What would also be great is to program the sheet to alert me when pertinent DeMark exhaustion points are reached, but that may not be possible.
Any ideas?
Thanks -
#yiv1445127154 #yiv1445127154 -- #yiv1445127154ygrp-
Sun May 7, 2017 10:45 am (PDT) . Posted by:
"Gary Reneau" gareneau
Hi Randy,
The sheet I'm using is from a friend who had this to say about looking up commodity prices (see below). Is he right?
Gary,
I can see why you can't retrieve commodity prices. Yahoo does not maintain historical prices on those commodity values. You can see this when you type them into Yahoo Finance. There is no tab for 'Historical Prices', unlike most other symbols.
The macro I use is 'RCHGetYahooHistory' which seeks out the tab described above.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Saturday, May 6, 2017 12:10 PM
Subject: Re: [smf_addin] Re: Current and Historical Data for Currencies and Commodities
I'd need more details on the actual functions you're using. I don't do anything with commodities. It looks to me like these work:
=RCHGetYahooQuotes(
=RCHGetYahooQuotes(
On Sat, May 6, 2017 at 3:30 AM, gareneau@...wrote:
First time post - I'm using a customized Excel spreadsheet to track DeMark signals that integrates the smf add in. Two things: Yahoo provides commodity quotes, but when I enter those in my spreadsheet I get an error message. Why, if I can get a price quote in Yahoo Finance, does it not carry over into the smf add in function?
Also, I would like the spreadsheet to take a whole list of tickers and run the DeMark analytics against each every day (as opposed to my inputting each ticker symbol). What would also be great is to program the sheet to alert me when pertinent DeMark exhaustion points are reached, but that may not be possible.
Any ideas?
Thanks -
#yiv8559961381 #yiv8559961381 -- #yiv8559961381ygrp-
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar