Minggu, 06 November 2016

[smf_addin] Digest Number 3836[1 Attachment]

5 Messages

Digest #3836
1a
Barchart Weighted Alpha after website redesign by "Bill Carswell" wdcarswell2002
2b
Re: 20 Day moving avg. by "Randy Harmelink" rharmelink

Messages

Sat Nov 5, 2016 9:58 am (PDT) . Posted by:

"Bill Carswell" wdcarswell2002

First, I have used the addin for many years and certainly appreciate your
work and support of a great tool.

I used the value of "Weighted Alpha" from Barchart for quite a while. When
Barchart data formats changed several days ago I went to the smf_addin group
and found the changes and then updated the smf-elements-9.txt file. That
update fixed all but one of the data elements I access daily.

I have used a custom data definition to get Weighted Alpha from the old
site. The formula I used was
=RCHGetTableCell("https://www.barchart.com/stocks/quotes/~~~~~",1,"View
Help",">Weighted") and that worked until the site was redesigned. Could you
please be so kind to update that formula for the new Barchart Quotes page.
I apologize for asking you but I cannot figure out how to make this change
myself.

Attachment(s) from Bill Carswell
1 of 1 File(s)

Sat Nov 5, 2016 10:36 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

They now dynamically build the web page, so the displayed values are buried
in some JSON data. Try something like this:

=smfConvertData(smfStrExtr(RCHGetWebData("
https://www.barchart.com/stocks/quotes/MMM
","{""previousPrice"":"""),"""weightedAlpha"":""",""""))

On Sat, Nov 5, 2016 at 4:56 AM, 'Bill Carswell' b_carswell@
​...wrote:

>
> I used the value of "Weighted Alpha" from Barchart for quite a while. When
> Barchart data formats changed several days ago I went to the smf_addin
> group
> and found the changes and then updated the smf-elements-9.txt file. That
> update fixed all but one of the data elements I access daily.
>
> I have used a custom data definition to get Weighted Alpha from the old
> site. The formula I used was
> =RCHGetTableCell("https://www.barchart.com/stocks/quotes/~~~~~",1,"View
> Help",">Weighted") and that worked until the site was redesigned. Could
> you
> please be so kind to update that formula for the new Barchart Quotes page.
> I apologize for asking you but I cannot figure out how to make this change
> myself.
>

Sat Nov 5, 2016 1:04 pm (PDT) . Posted by:

wolfiyah

Hi Randy,

With 1218 above the top row, UpdateDownloadTable works, but with RCHGetElementNumber("~~~~~",1218) in it, I still get Error. Maybe you should retest that. Anyway, at least one way works.

Thanks again

Sat Nov 5, 2016 3:47 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

IIRC, it has to do with how the element is defined. If it's defined with
the "=" prefix, it has to be the number only. Otherwise, the add-in ends up
with a recursive evaluate statement, which VBA doesn't like.

If it's just the element number, the add-in does the first evaluation
itself, by replacing the element number with the formula in the element's
definition.

On Sat, Nov 5, 2016 at 1:04 PM, p.wolfensberger@
​...wrote:

>
> With 1218 above the top row, UpdateDownloadTable works, but with
> RCHGetElementNumber("~~~~~",1218) in it, I still get Error. Maybe you
> should retest that. Anyway, at least one way works.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar