9 Messages
Digest #4186
3a
Re: Barchart Momentum - NYSE New Highs and New Lows and Moving Avera by "Randy Harmelink" rharmelink
Messages
Mon Oct 30, 2017 8:14 am (PDT) . Posted by:
"Jose Jacob" pepecan47
Hi Randy - I am having a little problem with the table. I want to format the "Date" column to yyyy-mm-dd, But is not accepting the formatting. Could it be that in the date some strange character is appended?
In the source of the web page this is what I see:
<tr class="odd">
<td class="left">Oct 27, 2017</td>
<td class="right">2.42%
</td>
</tr>
Regards, Jose L. Jacob
On Saturday, October 28, 2017 6:20 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Try:
=RCHGetHTMLTable("http://www.multpl.com/10-year-treasury-rate/table/by-month","id=""datatable""")
On Sat, Oct 28, 2017 at 2:38 PM, Jose Jacob pepecan47@... wrote:
Do you know how can I extract the 10 Year Treasury history from this source? In a table, so I can do a vlookup?
10 Year Treasury Rate by Month
#yiv6684192894 #yiv6684192894 -- #yiv6684192894ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6684192894 #yiv6684192894ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6684192894 #yiv6684192894ygrp-mkp #yiv6684192894hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6684192894 #yiv6684192894ygrp-mkp #yiv6684192894ads {margin-bottom:10px;}#yiv6684192894 #yiv6684192894ygrp-mkp .yiv6684192894ad {padding:0 0;}#yiv6684192894 #yiv6684192894ygrp-mkp .yiv6684192894ad p {margin:0;}#yiv6684192894 #yiv6684192894ygrp-mkp .yiv6684192894ad a {color:#0000ff;text-decoration:none;}#yiv6684192894 #yiv6684192894ygrp-sponsor #yiv6684192894ygrp-lc {font-family:Arial;}#yiv6684192894 #yiv6684192894ygrp-sponsor #yiv6684192894ygrp-lc #yiv6684192894hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6684192894 #yiv6684192894ygrp-sponsor #yiv6684192894ygrp-lc .yiv6684192894ad {margin-bottom:10px;padding:0 0;}#yiv6684192894 #yiv6684192894actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6684192894 #yiv6684192894activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6684192894 #yiv6684192894activity span {font-weight:700;}#yiv6684192894 #yiv6684192894activity span:first-child {text-transform:uppercase;}#yiv6684192894 #yiv6684192894activity span a {color:#5085b6;text-decoration:none;}#yiv6684192894 #yiv6684192894activity span span {color:#ff7900;}#yiv6684192894 #yiv6684192894activity span .yiv6684192894underline {text-decoration:underline;}#yiv6684192894 .yiv6684192894attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6684192894 .yiv6684192894attach div a {text-decoration:none;}#yiv6684192894 .yiv6684192894attach img {border:none;padding-right:5px;}#yiv6684192894 .yiv6684192894attach label {display:block;margin-bottom:5px;}#yiv6684192894 .yiv6684192894attach label a {text-decoration:none;}#yiv6684192894 blockquote {margin:0 0 0 4px;}#yiv6684192894 .yiv6684192894bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6684192894 .yiv6684192894bold a {text-decoration:none;}#yiv6684192894 dd.yiv6684192894last p a {font-family:Verdana;font-weight:700;}#yiv6684192894 dd.yiv6684192894last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6684192894 dd.yiv6684192894last p span.yiv6684192894yshortcuts {margin-right:0;}#yiv6684192894 div.yiv6684192894attach-table div div a {text-decoration:none;}#yiv6684192894 div.yiv6684192894attach-table {width:400px;}#yiv6684192894 div.yiv6684192894file-title a, #yiv6684192894 div.yiv6684192894file-title a:active, #yiv6684192894 div.yiv6684192894file-title a:hover, #yiv6684192894 div.yiv6684192894file-title a:visited {text-decoration:none;}#yiv6684192894 div.yiv6684192894photo-title a, #yiv6684192894 div.yiv6684192894photo-title a:active, #yiv6684192894 div.yiv6684192894photo-title a:hover, #yiv6684192894 div.yiv6684192894photo-title a:visited {text-decoration:none;}#yiv6684192894 div#yiv6684192894ygrp-mlmsg #yiv6684192894ygrp-msg p a span.yiv6684192894yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6684192894 .yiv6684192894green {color:#628c2a;}#yiv6684192894 .yiv6684192894MsoNormal {margin:0 0 0 0;}#yiv6684192894 o {font-size:0;}#yiv6684192894 #yiv6684192894photos div {float:left;width:72px;}#yiv6684192894 #yiv6684192894photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6684192894 #yiv6684192894photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6684192894 #yiv6684192894reco-category {font-size:77%;}#yiv6684192894 #yiv6684192894reco-desc {font-size:77%;}#yiv6684192894 .yiv6684192894replbq {margin:4px;}#yiv6684192894 #yiv6684192894ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6684192894 #yiv6684192894ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6684192894 #yiv6684192894ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6684192894 #yiv6684192894ygrp-mlmsg select, #yiv6684192894 input, #yiv6684192894 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6684192894 #yiv6684192894ygrp-mlmsg pre, #yiv6684192894 code {font:115% monospace;}#yiv6684192894 #yiv6684192894ygrp-mlmsg * {line-height:1.22em;}#yiv6684192894 #yiv6684192894ygrp-mlmsg #yiv6684192894logo {padding-bottom:10px;}#yiv6684192894 #yiv6684192894ygrp-msg p a {font-family:Verdana;}#yiv6684192894 #yiv6684192894ygrp-msg p#yiv6684192894attach-count span {color:#1E66AE;font-weight:700;}#yiv6684192894 #yiv6684192894ygrp-reco #yiv6684192894reco-head {color:#ff7900;font-weight:700;}#yiv6684192894 #yiv6684192894ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6684192894 #yiv6684192894ygrp-sponsor #yiv6684192894ov li a {font-size:130%;text-decoration:none;}#yiv6684192894 #yiv6684192894ygrp-sponsor #yiv6684192894ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6684192894 #yiv6684192894ygrp-sponsor #yiv6684192894ov ul {margin:0;padding:0 0 0 8px;}#yiv6684192894 #yiv6684192894ygrp-text {font-family:Georgia;}#yiv6684192894 #yiv6684192894ygrp-text p {margin:0 0 1em 0;}#yiv6684192894 #yiv6684192894ygrp-text tt {font-size:120%;}#yiv6684192894 #yiv6684192894ygrp-vital ul li:last-child {border-right:none !important;}#yiv6684192894
In the source of the web page this is what I see:
<tr class="odd">
<td class="left">Oct 27, 2017</td>
<td class="right">2.42%
</td>
</tr>
Regards, Jose L. Jacob
On Saturday, October 28, 2017 6:20 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Try:
=RCHGetHTMLTable("http://www.multpl.com/10-year-treasury-rate/table/by-month","
On Sat, Oct 28, 2017 at 2:38 PM, Jose Jacob pepecan47@... wrote:
Do you know how can I extract the 10 Year Treasury history from this source? In a table, so I can do a vlookup?
10 Year Treasury Rate by Month
#yiv6684192894 #yiv6684192894 -- #yiv6684192894ygrp-
Mon Oct 30, 2017 8:42 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's text data. You'd need to convert it to an EXCEL serial date value in
order for it to accept a date format.
On Mon, Oct 30, 2017 at 8:14 AM, Jose Jacob pepecan47@
...
wrote:
>
> Hi Randy - I am having a little problem with the table. I want to format
> the "Date" column to yyyy-mm-dd, But is not accepting the formatting. Could
> it be that in the date some strange character is appended?
>
> In the source of the web page this is what I see:
>
> <tr class="odd">
>
> <td class="left">Oct 27, 2017</td>
>
> <td class="right">2.42%
>
> </td>
>
> </tr>
>
>
>
order for it to accept a date format.
On Mon, Oct 30, 2017 at 8:14 AM, Jose Jacob pepecan47@
...
wrote:
>
> Hi Randy - I am having a little problem with the table. I want to format
> the "Date" column to yyyy-mm-dd, But is not accepting the formatting. Could
> it be that in the date some strange character is appended?
>
> In the source of the web page this is what I see:
>
> <tr class="
>
> <td class="
>
> <td class="
>
> </td>
>
> </tr>
>
>
>
Mon Oct 30, 2017 10:07 am (PDT) . Posted by:
"Jose Jacob" pepecan47
Hi Randy, I guess this is a very elementary question, how can I convert the data to an EXCEL serial date?
What is different from Yahoo history? I don't have this problem with the dates.
Regards, Jose L. Jacob
On Monday, October 30, 2017 11:42 AM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
It's text data. You'd need to convert it to an EXCEL serial date value in order for it to accept a date format.
On Mon, Oct 30, 2017 at 8:14 AM, Jose Jacob pepecan47@... wrote:
Hi Randy - I am having a little problem with the table. I want to format the "Date" column to yyyy-mm-dd, But is not accepting the formatting. Could it be that in the date some strange character is appended?
In the source of the web page this is what I see:
<tr class="odd">
<td class="left">Oct 27, 2017</td>
<td class="right">2.42%
</td>
</tr>
#yiv3234639067 #yiv3234639067 -- #yiv3234639067ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3234639067 #yiv3234639067ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3234639067 #yiv3234639067ygrp-mkp #yiv3234639067hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3234639067 #yiv3234639067ygrp-mkp #yiv3234639067ads {margin-bottom:10px;}#yiv3234639067 #yiv3234639067ygrp-mkp .yiv3234639067ad {padding:0 0;}#yiv3234639067 #yiv3234639067ygrp-mkp .yiv3234639067ad p {margin:0;}#yiv3234639067 #yiv3234639067ygrp-mkp .yiv3234639067ad a {color:#0000ff;text-decoration:none;}#yiv3234639067 #yiv3234639067ygrp-sponsor #yiv3234639067ygrp-lc {font-family:Arial;}#yiv3234639067 #yiv3234639067ygrp-sponsor #yiv3234639067ygrp-lc #yiv3234639067hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3234639067 #yiv3234639067ygrp-sponsor #yiv3234639067ygrp-lc .yiv3234639067ad {margin-bottom:10px;padding:0 0;}#yiv3234639067 #yiv3234639067actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3234639067 #yiv3234639067activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3234639067 #yiv3234639067activity span {font-weight:700;}#yiv3234639067 #yiv3234639067activity span:first-child {text-transform:uppercase;}#yiv3234639067 #yiv3234639067activity span a {color:#5085b6;text-decoration:none;}#yiv3234639067 #yiv3234639067activity span span {color:#ff7900;}#yiv3234639067 #yiv3234639067activity span .yiv3234639067underline {text-decoration:underline;}#yiv3234639067 .yiv3234639067attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3234639067 .yiv3234639067attach div a {text-decoration:none;}#yiv3234639067 .yiv3234639067attach img {border:none;padding-right:5px;}#yiv3234639067 .yiv3234639067attach label {display:block;margin-bottom:5px;}#yiv3234639067 .yiv3234639067attach label a {text-decoration:none;}#yiv3234639067 blockquote {margin:0 0 0 4px;}#yiv3234639067 .yiv3234639067bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3234639067 .yiv3234639067bold a {text-decoration:none;}#yiv3234639067 dd.yiv3234639067last p a {font-family:Verdana;font-weight:700;}#yiv3234639067 dd.yiv3234639067last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3234639067 dd.yiv3234639067last p span.yiv3234639067yshortcuts {margin-right:0;}#yiv3234639067 div.yiv3234639067attach-table div div a {text-decoration:none;}#yiv3234639067 div.yiv3234639067attach-table {width:400px;}#yiv3234639067 div.yiv3234639067file-title a, #yiv3234639067 div.yiv3234639067file-title a:active, #yiv3234639067 div.yiv3234639067file-title a:hover, #yiv3234639067 div.yiv3234639067file-title a:visited {text-decoration:none;}#yiv3234639067 div.yiv3234639067photo-title a, #yiv3234639067 div.yiv3234639067photo-title a:active, #yiv3234639067 div.yiv3234639067photo-title a:hover, #yiv3234639067 div.yiv3234639067photo-title a:visited {text-decoration:none;}#yiv3234639067 div#yiv3234639067ygrp-mlmsg #yiv3234639067ygrp-msg p a span.yiv3234639067yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3234639067 .yiv3234639067green {color:#628c2a;}#yiv3234639067 .yiv3234639067MsoNormal {margin:0 0 0 0;}#yiv3234639067 o {font-size:0;}#yiv3234639067 #yiv3234639067photos div {float:left;width:72px;}#yiv3234639067 #yiv3234639067photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3234639067 #yiv3234639067photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3234639067 #yiv3234639067reco-category {font-size:77%;}#yiv3234639067 #yiv3234639067reco-desc {font-size:77%;}#yiv3234639067 .yiv3234639067replbq {margin:4px;}#yiv3234639067 #yiv3234639067ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3234639067 #yiv3234639067ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3234639067 #yiv3234639067ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3234639067 #yiv3234639067ygrp-mlmsg select, #yiv3234639067 input, #yiv3234639067 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3234639067 #yiv3234639067ygrp-mlmsg pre, #yiv3234639067 code {font:115% monospace;}#yiv3234639067 #yiv3234639067ygrp-mlmsg * {line-height:1.22em;}#yiv3234639067 #yiv3234639067ygrp-mlmsg #yiv3234639067logo {padding-bottom:10px;}#yiv3234639067 #yiv3234639067ygrp-msg p a {font-family:Verdana;}#yiv3234639067 #yiv3234639067ygrp-msg p#yiv3234639067attach-count span {color:#1E66AE;font-weight:700;}#yiv3234639067 #yiv3234639067ygrp-reco #yiv3234639067reco-head {color:#ff7900;font-weight:700;}#yiv3234639067 #yiv3234639067ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3234639067 #yiv3234639067ygrp-sponsor #yiv3234639067ov li a {font-size:130%;text-decoration:none;}#yiv3234639067 #yiv3234639067ygrp-sponsor #yiv3234639067ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3234639067 #yiv3234639067ygrp-sponsor #yiv3234639067ov ul {margin:0;padding:0 0 0 8px;}#yiv3234639067 #yiv3234639067ygrp-text {font-family:Georgia;}#yiv3234639067 #yiv3234639067ygrp-text p {margin:0 0 1em 0;}#yiv3234639067 #yiv3234639067ygrp-text tt {font-size:120%;}#yiv3234639067 #yiv3234639067ygrp-vital ul li:last-child {border-right:none !important;}#yiv3234639067
What is different from Yahoo history? I don't have this problem with the dates.
Regards, Jose L. Jacob
On Monday, October 30, 2017 11:42 AM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
It's text data. You'd need to convert it to an EXCEL serial date value in order for it to accept a date format.
On Mon, Oct 30, 2017 at 8:14 AM, Jose Jacob pepecan47@... wrote:
Hi Randy - I am having a little problem with the table. I want to format the "Date" column to yyyy-mm-dd, But is not accepting the formatting. Could it be that in the date some strange character is appended?
In the source of the web page this is what I see:
<tr class="
<td class="
<td class="
</td>
</tr>
#yiv3234639067 #yiv3234639067 -- #yiv3234639067ygrp-
Mon Oct 30, 2017 10:32 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
smfGetYahooHistory() knows that it is processing a date field, so it does
the conversion. In fact, the data that Yahoo sends in the JSON file is a
UNIX date (# of seconds since 1/1/70) and needs to be converted into an
EXCEL serial date (# of days since 1/1/1900). Otherwise, 2017-10-30 would
show up as 1509321600. The EXCEL serial date value is 43038.
You'd need to add another column to convert the date in each row. Something
like:
=DATEVALUE(D18)
Or, do your lookup using a formatted date -- something like:
=TEXT(C21,"mmm d, yyyy")
For example:
=INDEX($E$17:$E$52,MATCH(TEXT(C21,"mmm d, yyyy"),$D$17:$D$52,0))
...where $D$17:$E$52 contains the results of the RCHGetHTMLTable() function
and C21 is the EXCEL serial date value you're trying to look up.
On Mon, Oct 30, 2017 at 10:06 AM, Jose Jacob pepecan47@yahoo.ca [smf_addin]
<smf_addin@yahoogroups.com> wrote:
>
> Hi Randy, I guess this is a very elementary question, how can I convert
> the data to an EXCEL serial date?
>
> What is different from Yahoo history? I don't have this problem with the
> dates.
>
>
>
the conversion. In fact, the data that Yahoo sends in the JSON file is a
UNIX date (# of seconds since 1/1/70) and needs to be converted into an
EXCEL serial date (# of days since 1/1/1900). Otherwise, 2017-10-30 would
show up as 1509321600. The EXCEL serial date value is 43038.
You'd need to add another column to convert the date in each row. Something
like:
=DATEVALUE(D18)
Or, do your lookup using a formatted date -- something like:
=TEXT(C21,"mmm d, yyyy")
For example:
=INDEX($E$17:$E$52,MATCH(TEXT(C21,"mmm d, yyyy"),$D$17:$D$52,0))
...where $D$17:$E$52 contains the results of the RCHGetHTMLTable() function
and C21 is the EXCEL serial date value you're trying to look up.
On Mon, Oct 30, 2017 at 10:06 AM, Jose Jacob pepecan47@yahoo.ca [smf_addin]
<smf_addin@yahoogroups.com> wrote:
>
> Hi Randy, I guess this is a very elementary question, how can I convert
> the data to an EXCEL serial date?
>
> What is different from Yahoo history? I don't have this problem with the
> dates.
>
>
>
Mon Oct 30, 2017 10:32 am (PDT) . Posted by:
"Rick Roth" rroth07
Take the simple approach. Forget about yahoo and use this:
https://fred.stlouisfed.org/series/DGS10
On Mon, Oct 30, 2017 at 10:06 AM, Jose Jacob pepecan47@yahoo.ca [smf_addin]
<smf_addin@yahoogroups.com> wrote:
>
>
> Hi Randy, I guess this is a very elementary question, how can I convert
> the data to an EXCEL serial date?
>
> What is different from Yahoo history? I don't have this problem with the
> dates.
>
> Regards,
> Jose L. Jacob
>
>
> On Monday, October 30, 2017 11:42 AM, "Randy Harmelink
> rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
>
>
>
> It's text data. You'd need to convert it to an EXCEL serial date value in
> order for it to accept a date format.
>
> On Mon, Oct 30, 2017 at 8:14 AM, Jose Jacob pepecan47@
> ...
> wrote:
>
>
> Hi Randy - I am having a little problem with the table. I want to format
> the "Date" column to yyyy-mm-dd, But is not accepting the formatting. Could
> it be that in the date some strange character is appended?
>
> In the source of the web page this is what I see:
>
> <tr class="odd">
>
> <td class="left">Oct 27, 2017</td>
>
> <td class="right">2.42%
>
> </td>
>
> </tr>
>
>
>
>
>
>
https://fred.stlouisfed.org/series/DGS10
On Mon, Oct 30, 2017 at 10:06 AM, Jose Jacob pepecan47@yahoo.ca [smf_addin]
<smf_addin@yahoogroups.com> wrote:
>
>
> Hi Randy, I guess this is a very elementary question, how can I convert
> the data to an EXCEL serial date?
>
> What is different from Yahoo history? I don't have this problem with the
> dates.
>
> Regards,
> Jose L. Jacob
>
>
> On Monday, October 30, 2017 11:42 AM, "Randy Harmelink
> rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
>
>
>
> It's text data. You'd need to convert it to an EXCEL serial date value in
> order for it to accept a date format.
>
> On Mon, Oct 30, 2017 at 8:14 AM, Jose Jacob pepecan47@
> ...
> wrote:
>
>
> Hi Randy - I am having a little problem with the table. I want to format
> the "Date" column to yyyy-mm-dd, But is not accepting the formatting. Could
> it be that in the date some strange character is appended?
>
> In the source of the web page this is what I see:
>
> <tr class="
>
> <td class="
>
> <td class="
>
> </td>
>
> </tr>
>
>
>
>
>
>
Mon Oct 30, 2017 11:51 am (PDT) . Posted by:
"Gaston Bullrich" gbullr
goto
https://fred.stlouisfed.org/series/DGS10
download.
Get the addin from that page and download automatically into xcel.
On Sat, Oct 28, 2017 at 5:38 PM, Jose Jacob pepecan47@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Do you know how can I extract the 10 Year Treasury history from this
> source? In a table, so I can do a vlookup?
>
> 10 Year Treasury Rate by Month
> <http://www.multpl.com/10-year-treasury-rate/table/by-month>
>
> 10 Year Treasury Rate by Month
> By multpl
> Check out this fantastic 10 Year Treasury Rate table.
> <http://www.multpl.com/10-year-treasury-rate/table/by-month>
>
>
> Regards,
> Jose L. Jacob
>
>
>
--
Gaston Bullrich
9 Island Avenue Apt 1406
Miami Beach, Florida 33139
Cel. 917 517 9907
https://fred.stlouisfed.org/series/DGS10
download.
Get the addin from that page and download automatically into xcel.
On Sat, Oct 28, 2017 at 5:38 PM, Jose Jacob pepecan47@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Do you know how can I extract the 10 Year Treasury history from this
> source? In a table, so I can do a vlookup?
>
> 10 Year Treasury Rate by Month
> <http://www.multpl.com/10-year-treasury-rate/table/by-month>
>
> 10 Year Treasury Rate by Month
> By multpl
> Check out this fantastic 10 Year Treasury Rate table.
> <http://www.multpl.com/10-year-treasury-rate/table/by-month>
>
>
> Regards,
> Jose L. Jacob
>
>
>
--
Gaston Bullrich
9 Island Avenue Apt 1406
Miami Beach, Florida 33139
Cel. 917 517 9907
Mon Oct 30, 2017 9:00 am (PDT) . Posted by:
"Paul Austin" jpaulaustin
I am using the latest version of the GetYahooHistory with the "A" for
adjusted close price on monthly data and seem to only get the last price. I
also have the "Adjust" option set to "1."
Are there any ideas on this?
adjusted close price on monthly data and seem to only get the last price. I
also have the "Adjust" option set to "1."
Are there any ideas on this?
Mon Oct 30, 2017 11:21 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
This appears to work fine for me:
=RCHGetYahooHistory("MMM",,,,,,,"m","da")
Date Close
2017-10-30 $231.22
2017-10-01 $234.74
2017-09-01 $209.90
2017-08-01 $203.15
2017-07-01 $200.02
2017-06-01 $207.00
Which version of the add-in are you using?
=RCHGetElementNumber("Version")
On Mon, Oct 30, 2017 at 4:47 AM, Paul Austin paul@
...
wrote:
>
> I am using the latest version of the GetYahooHistory with the "A" for
> adjusted close price on monthly data and seem to only get the last price. I
> also have the "Adjust" option set to "1."
>
> Are there any ideas on this?
>
=RCHGetYahooHistory
Date Close
2017-10-30 $231.22
2017-10-01 $234.74
2017-09-01 $209.90
2017-08-01 $203.15
2017-07-01 $200.02
2017-06-01 $207.00
Which version of the add-in are you using?
=RCHGetElementNumbe
On Mon, Oct 30, 2017 at 4:47 AM, Paul Austin paul@
...
wrote:
>
> I am using the latest version of the GetYahooHistory with the "A" for
> adjusted close price on monthly data and seem to only get the last price. I
> also have the "Adjust" option set to "1."
>
> Are there any ideas on this?
>
Mon Oct 30, 2017 9:00 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It looks like Barchart has changed the web page, at least in changing the
URL and adding the 5-day moving average values.It also looks like I forgot
to change the momentum template to include the new element number instead
of the old hard-coded definitions.
However, all of my advances and declines for element definitions appear to
be coming through fine. For example:
*#* *Value*
1146 Mon, Oct 30th, 2017
1147 758
1148 1227
1149 41
1150 408760000
1151 434810000
1152 5830000
1153 84
The current definition of element #1153:
=RCHGetElementNumber("Definition",1153)
...should have this formula:
=smfGetYahooJSONField("None","barChartMM","data.1.raw.newHighs")
On Sun, Oct 29, 2017 at 5:56 PM, rir.aknz@
...
wrote:
>
>
> *New Highs and New Lows:*
>
> Since the change to the Barchart Momentum web-site late last year, I have
> been using the definitions in my Excel macro as used in
> SMF-Template-Barchart-Market-Momentum.xls
> <http://ogres-crypt.com/SMF/Templates/SMF-Template-Barchart-Market-Momentum.xls>
> dated 2016-11-11 to access various NYSE data for the equivalent of Elements
> 1147 through to 1154:
>
> For example:
>
> =smfConvertData(smfStrExtr(smfStrExtr(RCHGetWebData(rURL),"
> NYSE","}"),"""advancingIssues"":""","""")) etc
>
>
>
> However, in my Excel macro, the NYSE New High and New Low data seem to
> pick up data that is similar to, but not exactly that displayed on the
> web-site:
>
> https://www.barchart.com/stocks/momentum
>
> =smfConvertData(smfStrExtr(smfStrExtr(RCHGetWebData(rURL),"
> NYSE","}"),"""newHighs"":""",""""))
>
> and
>
> =smfConvertData(smfStrExtr(smfStrExtr(RCHGetWebData(rURL),"
> NYSE","}"),"""newLows"":""",""""))
>
>
>
> After some experimenting, I have discovered that the data displayed for
> New Highs and New Lows seem to be taken from the fields 'high52w' and
> 'low52w' rather than from fields 'newHighs' and 'newLows'.
>
> I have no idea whether one lot or the other are more accurate and they are
> both quite different from those reported at http://unicorn.us.com/advdec/.
>
>
>
> So, I included 'high52w' and 'low52w' into the api in
> SMF-Template-Barchart-Market-Momentum.xls
> <http://ogres-crypt.com/SMF/Templates/SMF-Template-Barchart-Market-Momentum.xls>
> as follows:
>
> rURL = https://core-api.barchart.com/v1/momentum/get?fields=exchang
> e,high52w,low52w,newHighs,newLows,advancingVolume,unchan
> gedVolume,decliningVolume,advancingIssues,percentAdvancingIs
> sues,unchangedIssues,percentUnchangedIssues,decliningIssues,
> percentDecliningIssues&exchanges=NASDAQ,NYSE,OTC,AMEX
>
>
>
> Then, I was able to extract the New High and New Low data as displayed in
> the Barchart Momentum web-page using:
>
> =smfConvertData(smfStrExtr(smfStrExtr(RCHGetWebData(rURL),"
> NYSE","}"),"""high52w"":""",""""))
>
> and
>
> =smfConvertData(smfStrExtr(smfStrExtr(RCHGetWebData(rURL),"
> NYSE","}"),"""low52w"":""",""""))
>
>
>
>
>
>
>
> *smf_elements-9.txt:*
>
> Now I have discovered that the definitions had been updated on 20th May
> 2017:
>
> 2017-05-20
>
> RCHGetElementNumber
>
> BarChart Market Momentum -- new elements #1115 thru #1138, reinstated
> #1146 thru #1178, on smf-elements-9.txt
>
>
>
> So, I tried to use them but obtain #VALUE!
>
> For example:
>
> =RCHGetElementNumber("BarchartMM",1153) obtains a result of #VALUE!
>
> So do all the Elements 1115 through 1138 and 1147 through to 1178 obtain a
> result of #VALUE!.
>
> (Element 1147 returns the day and date e.g. Sun, Oct 29th, 2017)
>
> What am I doing incorrectly?
>
>
>
>
>
> *SMF Add-in Version:*
>
> The Version I use is as follows:
>
> Stock Market Functions add-in, Version 2.1.2017.09.17 (C:\SMF Add-in;
> Windows (64-bit) NT :.00; 15.0; ; Local; 64)
>
>
>
> My smf_elements-9.txt file is dated 29/08/2017 12:20am 82kb.
>
>
>
>
>
> *MARKET AVERAGE:*
>
> Also, I notice that Barchart have added the 5 day moving averages on the
> Momentum web-page.
>
> Thus, the elements in smf-elements-9.txt 1195 through to 1214 are shown as
> the 20, 50, 100, 150 and 200 Day Averages whereas, they appear to be the 5,
> 20, 50, 100 and 150 Day Averages and the 200 Day Average is missing.
>
>
>
>
>
URL and adding the 5-day moving average values.It also looks like I forgot
to change the momentum template to include the new element number instead
of the old hard-coded definitions.
However, all of my advances and declines for element definitions appear to
be coming through fine. For example:
*#* *Value*
1146 Mon, Oct 30th, 2017
1147 758
1148 1227
1149 41
1150 408760000
1151 434810000
1152 5830000
1153 84
The current definition of element #1153:
=RCHGetElementNumber("Definition",1153)
...should have this formula:
=smfGetYahooJSONField("None","barChartMM","data.1.raw.newHighs")
On Sun, Oct 29, 2017 at 5:56 PM, rir.aknz@
...
wrote:
>
>
> *New Highs and New Lows:*
>
> Since the change to the Barchart Momentum web-site late last year, I have
> been using the definitions in my Excel macro as used in
> SMF-Template-Barchart-Market-Momentum.xls
> <http://ogres-crypt.com/SMF/Templates/SMF-Template-Barchart-Market-Momentum.xls>
> dated 2016-11-11 to access various NYSE data for the equivalent of Elements
> 1147 through to 1154:
>
> For example:
>
> =smfConvertData(smfStrExtr(smfStrExtr(RCHGetWebData(rURL),"
> NYSE","}"),"""advancingIssues"":""","""")) etc
>
>
>
> However, in my Excel macro, the NYSE New High and New Low data seem to
> pick up data that is similar to, but not exactly that displayed on the
> web-site:
>
> https://www.barchart.com/stocks/momentum
>
> =smfConvertData(smfStrExtr(smfStrExtr(RCHGetWebData(rURL),"
> NYSE","}"),"""newHighs"":""",""""))
>
> and
>
> =smfConvertData(smfStrExtr(smfStrExtr(RCHGetWebData(rURL),"
> NYSE","}"),"""newLows"":""",""""))
>
>
>
> After some experimenting, I have discovered that the data displayed for
> New Highs and New Lows seem to be taken from the fields 'high52w' and
> 'low52w' rather than from fields 'newHighs' and 'newLows'.
>
> I have no idea whether one lot or the other are more accurate and they are
> both quite different from those reported at http://unicorn.us.com/advdec/.
>
>
>
> So, I included 'high52w' and 'low52w' into the api in
> SMF-Template-Barchart-Market-Momentum.xls
> <http://ogres-crypt.com/SMF/Templates/SMF-Template-Barchart-Market-Momentum.xls>
> as follows:
>
> rURL = https://core-api.barchart.com/v1/momentum/get?fields=exchang
> e,high52w,low52w,
> gedVolume,declining
> sues,unchangedIssue
> percentDecliningIss
>
>
>
> Then, I was able to extract the New High and New Low data as displayed in
> the Barchart Momentum web-page using:
>
> =smfConvertData(
> NYSE","
>
> and
>
> =smfConvertData(
> NYSE","
>
>
>
>
>
>
>
> *smf_elements-
>
> Now I have discovered that the definitions had been updated on 20th May
> 2017:
>
> 2017-05-20
>
> RCHGetElementNumber
>
> BarChart Market Momentum -- new elements #1115 thru #1138, reinstated
> #1146 thru #1178, on smf-elements-
>
>
>
> So, I tried to use them but obtain #VALUE!
>
> For example:
>
> =RCHGetElementNumbe
>
> So do all the Elements 1115 through 1138 and 1147 through to 1178 obtain a
> result of #VALUE!.
>
> (Element 1147 returns the day and date e.g. Sun, Oct 29th, 2017)
>
> What am I doing incorrectly?
>
>
>
>
>
> *SMF Add-in Version:*
>
> The Version I use is as follows:
>
> Stock Market Functions add-in, Version 2.1.2017.09.
> Windows (64-bit) NT :.00; 15.0; ; Local; 64)
>
>
>
> My smf_elements-
>
>
>
>
>
> *MARKET AVERAGE:*
>
> Also, I notice that Barchart have added the 5 day moving averages on the
> Momentum web-page.
>
> Thus, the elements in smf-elements-
> the 20, 50, 100, 150 and 200 Day Averages whereas, they appear to be the 5,
> 20, 50, 100 and 150 Day Averages and the 200 Day Average is missing.
>
>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar