[smf_addin] Digest Number 4631

EXCEL Stock Market Functions Add-in Group

2 Messages

Digest #4631

1a

Arms Index from Barrons by waterboy5555

1b

Re: Arms Index from Barrons by "Randy Harmelink" rharmelink

Messages

1a

Arms Index from Barrons

Fri Oct 18, 2019 1:27 pm (PDT) . Posted by:

waterboy5555

How would I get the Closing Arms (TRIN)† for NYSE for the lastest close? See link below. What would I do for the †? Thanks. I am just starting to figure this out.





https://www.barrons.com/market-data/stocks/markets-diary https://www.barrons.com/market-data/stocks/markets-diary

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: Arms Index from Barrons

Fri Oct 18, 2019 3:59 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Unfortunately, the data you wanted isn't within the delivered source code
of the web page. That web page is built dynamically with data retrieved
from another source. The data can be extracted from this JSON call:

=smfStrExtr(RCHGetWebData("
https://www.barrons.com/market-data/stocks/markets-diary?id={
""application"":""Barrons"",""marketsDiaryType"":""diaries""}&type=mdc_marketsdiary","(TRIN",150),"""latestClose"":""","""",1)

On Fri, Oct 18, 2019 at 1:28 PM bopha99@... wrote:

> How would I get the Closing Arms (TRIN)† for NYSE for the lastest
> close? See link below. What would I do for the †? Thanks. I am just
> starting to figure this out.
>
> https://www.barrons.com/market-data/stocks/markets-diary
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• Privacy • Unsubscribe • Terms of Use