2 Messages

Digest #4153

RCHGetHTMLTable:Federal Reserve Bank of Boston by bushpilote

Re: RCHGetHTMLTable:Federal Reserve Bank of Boston by "Randy Harmelink" rharmelink

Messages

1a

RCHGetHTMLTable:Federal Reserve Bank of Boston

Fri Sep 22, 2017 12:15 pm (PDT) . Posted by:

bushpilote

Hi Randy,
Is it possible to grab the economic data from "'https://nationaleconomicsummary.bostonfed.org/EconomicSummary/" with RCHGetHTMLTable function?

I have tried multiple variations of the following array-entered formula " =RCHGetHTMLTable("'https://nationaleconomicsummary.bostonfed.org/EconomicSummary/","Labor Markets",-1,"",1)" by substituting "Labor Markets" with other headers without success.

Regards

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

1b

Re: RCHGetHTMLTable:Federal Reserve Bank of Boston

Fri Sep 22, 2017 2:10 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The data isn't within a table in the source code of that web page. It isn't
there at all. They build the web page from JSON output:

https://nationaleconomicsummary.bostonfed.org/Service.svc/json/GetEconomicSummaryView?EconomicSummaryViewID=1&APIKey=b6754932-9300-11e1-9ecd-4955bbe59b18

Extracting the data from it would not be a trivial task.

On Fri, Sep 22, 2017 at 12:15 PM, bushpilote@
...
wrote:

>
> Is it possible to grab the economic data from "'https://
> nationaleconomicsummary.bostonfed.org/EconomicSummary/" with
> RCHGetHTMLTable function?
>
> I have tried multiple variations of the following array-entered formula "
> =RCHGetHTMLTable("'https://nationaleconomicsummary.
> bostonfed.org/EconomicSummary/","Labor Markets",-1,"",1)" by
> substituting "Labor Markets" with other headers without success.
>
>