5 Messages
Digest #3836
1b
Re: Barchart Weighted Alpha after website redesign [1 Attachment] 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.
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,"
Help","
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.
>
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,"
> Help","
> 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
With 1218 above the top row, UpdateDownloadTable works, but with RCHGetElementNumber
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.
>
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'
definition.
On Sat, Nov 5, 2016 at 1:04 PM, p.wolfensberger@
...wrote:
>
> With 1218 above the top row, UpdateDownloadTable works, but with
> RCHGetElementNumber
> 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:
Posting Komentar