Senin, 30 Juli 2018

[smf_addin] Digest Number 4370

2 Messages

Digest #4370

Messages

Sun Jul 29, 2018 11:38 am (PDT) . Posted by:

mff2805

Randy,
Is there a easy way to download the earnings surprise info and earnings estimates info from this barchart page for BA.
https://www.barchart.com/stocks/quotes/BA/earnings-estimates https://www.barchart.com/stocks/quotes/BA/earnings-estimates



I follwed the example of the the barchart technical indicators spreadsheet and your reply too my post last week to successfuly get info from the profilel page and the performance page, but my understanding of html is not so great. i've futzed around with the GetTAgContent and GetTableCell functions, but feel lost. any help you could provide would be helpful.


thanks,
Mike


Sun Jul 29, 2018 12:04 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Easiest way is to just grab the two tables at once, with:

=RCHGetHTMLTable("
https://www.barchart.com/stocks/quotes/BA/earnings-estimates",">Earnings
History - Surprises",1,,2)

Individual items could be retrieved with something like:

=RCHGetTableCell("
https://www.barchart.com/stocks/quotes/BA/earnings-estimates",1,">Earnings
History - Surprises",">Reported")

On Sun, Jul 29, 2018 at 11:37 AM, mff3429@
....
wrote:

> Is there a easy way to download the earnings surprise info and earnings
> estimates info from this barchart page for BA.
>
> https://www.barchart.com/stocks/quotes/BA/earnings-estimates
>
> I follwed the example of the the barchart technical indicators spreadsheet
> and your reply too my post last week to successfuly get info from the
> profilel page and the performance page, but my understanding of html is not
> so great. i've futzed around with the GetTAgContent and GetTableCell
> functions, but feel lost. any help you could provide would be helpful.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar