Selasa, 18 Agustus 2015

[smf_addin] Digest Number 3491

8 Messages

Digest #3491
2a
Re: TMX website by morpheusca8
2b
Re: TMX website by morpheusca8
2c
Re: TMX website by morpheusca8
2d
Re: TMX website by "Randy Harmelink" rharmelink
2e
Re: TMX website by "Randy Harmelink" rharmelink
2f
Re: TMX website by "Randy Harmelink" rharmelink

Messages

Mon Aug 17, 2015 10:37 am (PDT) . Posted by:

friedman_steve

Hi Randy, It appears that Earnings Whisper changed how they format their site, and I can't get my old formulas to work.


Hoping you can help with formula to grab the 1) date, 2) time for the upcoming call for a stock.






Here's what I used to have that no longer works:


date:
=RCHGetTableCell("http://www.earningswhispers.com/stocks.asp?symbol="&$C1&"",1,"Release Date:")





time:
=RCHGetTableCell("http://www.earningswhispers.com/stocks.asp?symbol="&$C1&"",1,"Conference Call:")



confirmed:
=RCHGetTableCell("http://www.earningswhispers.com/stocks.asp?symbol="&$C1&"",1,"Consensus Estimate",,,,2)



Thanks.

Mon Aug 17, 2015 4:08 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfGetTagContent("https://www.earningswhispers.com/stocks/
"&B6,"div",-1,"/calendar?d=")

=smfGetTagContent("https://www.earningswhispers.com/stocks/
"&B7,"div",-1,"id=""earningstime""")

=smfConvertData(smfStrExtr(smfGetTagContent("
https://www.earningswhispers.com/stocks/
"&B8,"div",-1,"Consensus:"),":","~"))

On Mon, Aug 17, 2015 at 10:37 AM, friedman_steve@... wrote:

>
> It appears that Earnings Whisper changed how they format their site, and I
> can't get my old formulas to work.
>
> Hoping you can help with formula to grab the 1) date, 2) time for the
> upcoming call for a stock.
>
>
> Here's what I used to have that no longer works:
>
> date:
> =RCHGetTableCell("http://www.earningswhispers.com/stocks.asp?symbol="&$C1&"",1,"Release
> Date:")
>
>
> time:
> =RCHGetTableCell("http://www.earningswhispers.com/stocks.asp?symbol="&$C1&"",1,"Conference
> Call:")
>
> confirmed:
> =RCHGetTableCell("http://www.earningswhispers.com/stocks.asp?symbol="&$C1&"",1,"Consensus
> Estimate",,,,2)
>
>

Mon Aug 17, 2015 6:23 pm (PDT) . Posted by:

morpheusca8

http://web.tmxmoney.com/quote.php?qm_symbol=td http://web.tmxmoney.com/quote.php?qm_symbol=td

Mon Aug 17, 2015 6:23 pm (PDT) . Posted by:

morpheusca8

where do i find samples of how to do that??

Mon Aug 17, 2015 6:27 pm (PDT) . Posted by:

morpheusca8

I had it all working perfectly and they went and changed the site on me!!!

Mon Aug 17, 2015 6:42 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The documentation for the functions have examples of their usage.

On Mon, Aug 17, 2015 at 6:23 PM, mikesadd@... wrote:

>
> where do i find samples of how to do that??
>
>

Mon Aug 17, 2015 6:44 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmm. Not in the title of the web page, but this appears to work to extract
company name:

=smfGetTagContent("http://web.tmxmoney.com/quote.php?qm_symbol=td","h2",1)

On Mon, Aug 17, 2015 at 6:23 PM, mikesadd@hotmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> http://web.tmxmoney.com/quote.php?qm_symbol=td
>
>

Mon Aug 17, 2015 6:55 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Welcome to my world. :)

On Mon, Aug 17, 2015 at 6:27 PM, mikesadd@hotmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I had it all working perfectly and they went and changed the site on me!!!
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar