Minggu, 29 Oktober 2017

[smf_addin] Digest Number 4185

4 Messages

Digest #4185

Messages

Sun Oct 29, 2017 8:00 am (PDT) . Posted by:

"Jose Jacob" pepecan47

Thank you Randy, it works!!   

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&quot;"")

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
#yiv2105873267 #yiv2105873267 -- #yiv2105873267ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2105873267 #yiv2105873267ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2105873267 #yiv2105873267ygrp-mkp #yiv2105873267hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2105873267 #yiv2105873267ygrp-mkp #yiv2105873267ads {margin-bottom:10px;}#yiv2105873267 #yiv2105873267ygrp-mkp .yiv2105873267ad {padding:0 0;}#yiv2105873267 #yiv2105873267ygrp-mkp .yiv2105873267ad p {margin:0;}#yiv2105873267 #yiv2105873267ygrp-mkp .yiv2105873267ad a {color:#0000ff;text-decoration:none;}#yiv2105873267 #yiv2105873267ygrp-sponsor #yiv2105873267ygrp-lc {font-family:Arial;}#yiv2105873267 #yiv2105873267ygrp-sponsor #yiv2105873267ygrp-lc #yiv2105873267hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2105873267 #yiv2105873267ygrp-sponsor #yiv2105873267ygrp-lc .yiv2105873267ad {margin-bottom:10px;padding:0 0;}#yiv2105873267 #yiv2105873267actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2105873267 #yiv2105873267activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2105873267 #yiv2105873267activity span {font-weight:700;}#yiv2105873267 #yiv2105873267activity span:first-child {text-transform:uppercase;}#yiv2105873267 #yiv2105873267activity span a {color:#5085b6;text-decoration:none;}#yiv2105873267 #yiv2105873267activity span span {color:#ff7900;}#yiv2105873267 #yiv2105873267activity span .yiv2105873267underline {text-decoration:underline;}#yiv2105873267 .yiv2105873267attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2105873267 .yiv2105873267attach div a {text-decoration:none;}#yiv2105873267 .yiv2105873267attach img {border:none;padding-right:5px;}#yiv2105873267 .yiv2105873267attach label {display:block;margin-bottom:5px;}#yiv2105873267 .yiv2105873267attach label a {text-decoration:none;}#yiv2105873267 blockquote {margin:0 0 0 4px;}#yiv2105873267 .yiv2105873267bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2105873267 .yiv2105873267bold a {text-decoration:none;}#yiv2105873267 dd.yiv2105873267last p a {font-family:Verdana;font-weight:700;}#yiv2105873267 dd.yiv2105873267last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2105873267 dd.yiv2105873267last p span.yiv2105873267yshortcuts {margin-right:0;}#yiv2105873267 div.yiv2105873267attach-table div div a {text-decoration:none;}#yiv2105873267 div.yiv2105873267attach-table {width:400px;}#yiv2105873267 div.yiv2105873267file-title a, #yiv2105873267 div.yiv2105873267file-title a:active, #yiv2105873267 div.yiv2105873267file-title a:hover, #yiv2105873267 div.yiv2105873267file-title a:visited {text-decoration:none;}#yiv2105873267 div.yiv2105873267photo-title a, #yiv2105873267 div.yiv2105873267photo-title a:active, #yiv2105873267 div.yiv2105873267photo-title a:hover, #yiv2105873267 div.yiv2105873267photo-title a:visited {text-decoration:none;}#yiv2105873267 div#yiv2105873267ygrp-mlmsg #yiv2105873267ygrp-msg p a span.yiv2105873267yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2105873267 .yiv2105873267green {color:#628c2a;}#yiv2105873267 .yiv2105873267MsoNormal {margin:0 0 0 0;}#yiv2105873267 o {font-size:0;}#yiv2105873267 #yiv2105873267photos div {float:left;width:72px;}#yiv2105873267 #yiv2105873267photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2105873267 #yiv2105873267photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2105873267 #yiv2105873267reco-category {font-size:77%;}#yiv2105873267 #yiv2105873267reco-desc {font-size:77%;}#yiv2105873267 .yiv2105873267replbq {margin:4px;}#yiv2105873267 #yiv2105873267ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2105873267 #yiv2105873267ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2105873267 #yiv2105873267ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2105873267 #yiv2105873267ygrp-mlmsg select, #yiv2105873267 input, #yiv2105873267 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2105873267 #yiv2105873267ygrp-mlmsg pre, #yiv2105873267 code {font:115% monospace;}#yiv2105873267 #yiv2105873267ygrp-mlmsg * {line-height:1.22em;}#yiv2105873267 #yiv2105873267ygrp-mlmsg #yiv2105873267logo {padding-bottom:10px;}#yiv2105873267 #yiv2105873267ygrp-msg p a {font-family:Verdana;}#yiv2105873267 #yiv2105873267ygrp-msg p#yiv2105873267attach-count span {color:#1E66AE;font-weight:700;}#yiv2105873267 #yiv2105873267ygrp-reco #yiv2105873267reco-head {color:#ff7900;font-weight:700;}#yiv2105873267 #yiv2105873267ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2105873267 #yiv2105873267ygrp-sponsor #yiv2105873267ov li a {font-size:130%;text-decoration:none;}#yiv2105873267 #yiv2105873267ygrp-sponsor #yiv2105873267ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2105873267 #yiv2105873267ygrp-sponsor #yiv2105873267ov ul {margin:0;padding:0 0 0 8px;}#yiv2105873267 #yiv2105873267ygrp-text {font-family:Georgia;}#yiv2105873267 #yiv2105873267ygrp-text p {margin:0 0 1em 0;}#yiv2105873267 #yiv2105873267ygrp-text tt {font-size:120%;}#yiv2105873267 #yiv2105873267ygrp-vital ul li:last-child {border-right:none !important;}#yiv2105873267

Sun Oct 29, 2017 3:31 pm (PDT) . Posted by:

krisha_mehta

Hi Randy,
I am using SMFHighBetween("intc",NOW()-360, NOW()) which always returns zero. I am using smfHighBetweeen to get 52 week high and this use to work, now it does not.

Thanks in advance!

Sun Oct 29, 2017 5:53 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

That function is not one that is supported. You should use the
smfPricesBetween() function instead.

Also, note that NOW() makes such a function volatile, which means it will
recalculate every time you change anything in your workbook. Too many of
those and you could have a long wait for each change you make.

On Sun, Oct 29, 2017 at 3:31 PM, krisha_mehta@
​...
wrote:

> I am using SMFHighBetween("intc",NOW()-360, NOW()) which always returns
> zero. I am using smfHighBetweeen to get 52 week high and this use to work,
> now it does not.
>
>
>

Sun Oct 29, 2017 6:15 pm (PDT) . Posted by:

"Gmail - rir.aknz"

Hi Randy,

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","}"),"""adv
ancingIssues"":""","""")) 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","}"),"""new
Highs"":""",""""))

and

=smfConvertData(smfStrExtr(smfStrExtr(RCHGetWebData(rURL),"NYSE","}"),"""new
Lows"":""",""""))

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=exchange,high52w,low52w
,newHighs,newLows,advancingVolume,unchangedVolume,decliningVolume,advancingI
ssues,percentAdvancingIssues,unchangedIssues,percentUnchangedIssues,declinin
gIssues,percentDecliningIssues
<https://core-api.barchart.com/v1/momentum/get?fields=exchange,high52w,low52
w,newHighs,newLows,advancingVolume,unchangedVolume,decliningVolume,advancing
Issues,percentAdvancingIssues,unchangedIssues,percentUnchangedIssues,declini
ngIssues,percentDecliningIssues&exchanges=NASDAQ,NYSE,OTC,AMEX>
&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","}"),"""hig
h52w"":""",""""))

and

=smfConvertData(smfStrExtr(smfStrExtr(RCHGetWebData(rURL),"NYSE","}"),"""low
52w"":""",""""))

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.

Thanks

Ian

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 19.18

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)