8 Messages
Digest #3491
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.
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&"
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)
>
>
=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&"
> Estimate"
>
>
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: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??
>
>
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
>
>
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!!!
>
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:
Posting Komentar