7 Messages
Digest #4504
Messages
Wed Mar 20, 2019 8:16 am (PDT) . Posted by:
friedman_steve
Randy, unfortunately this link you created stopped working. I couldn't figure out how to get going again to grab the table of analyst ratings/targets from the website. Are you able to update it?
Thanks again for your work Randy..... amazing work you do.
old link you created:
=RCHGetHTMLTable("https://www.marketbeat.com/stocks/NYSE/ https://www.marketbeat.com/stocks/NYSE/"&$A$1&"/price-target/",">Brokerage")
Thanks again for your work Randy..... amazing work you do.
old link you created:
=RCHGetHTMLTable("https://www.marketbeat.com/stocks/NYSE/ https://www.marketbeat.com/stocks/NYSE/"&$A$1&"
Wed Mar 20, 2019 9:16 am (PDT) . Posted by:
"Higrm" higrm
I just tested the formula and it worked fine for me.Good luck..
o Date Brokerage Action Rating Price Target Impact on Share Price Details
3/19/2019 Capital One Financial Downgrade Equal Weight ➝ Underweight
Medium
2/26/2019 Citigroup Set Price Target Hold 70 Low
11/15/2018 Bank of America Upgrade Neutral ➝ Buy 72 Medium
11/6/2018 Royal Bank of Canada Boost Price Target Sector Perform ➝ Sector Perform 57.00 ➝ $60.00 Low
10/1/2018 Morgan Stanley Downgrade Overweight ➝ Equal 31 Medium
On Wednesday, March 20, 2019, 5:09:02 PM GMT+1, friedman_steve@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Randy,
unfortunately this link you created stopped working. I couldn't figure out how to get going again to grab the table of analyst ratings/targets from the website. Are you able to update it?
Thanks again for your work Randy..... amazing work you do.
old link you created:=RCHGetHTMLTable("https://www.marketbeat.com/stocks/NYSE/"&$A$1&"/price-target/",">Brokerage")
o Date Brokerage Action Rating Price Target Impact on Share Price Details
3/19/2019 Capital One Financial Downgrade Equal Weight ➝ Underweight
Medium
2/26/2019 Citigroup Set Price Target Hold 70 Low
11/15/2018 Bank of America Upgrade Neutral ➝ Buy 72 Medium
11/6/2018 Royal Bank of Canada Boost Price Target Sector Perform ➝ Sector Perform 57.00 ➝ $60.00 Low
10/1/2018 Morgan Stanley Downgrade Overweight ➝ Equal 31 Medium
On Wednesday, March 20, 2019, 5:09:02 PM GMT+1, friedman_steve@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Randy,
unfortunately this link you created stopped working. I couldn't figure out how to get going again to grab the table of analyst ratings/targets from the website. Are you able to update it?
Thanks again for your work Randy..... amazing work you do.
old link you created:=RCHGetHTMLTable("https://www.marketbeat.com/stocks/NYSE/"&$A$1&"
Wed Mar 20, 2019 9:29 am (PDT) . Posted by:
friedman_steve
hmmm, I just tried with T, and it worked too.
But doesn't with a Nasdaq ticker...... try AAPL
But doesn't with a Nasdaq ticker...... try AAPL
Wed Mar 20, 2019 9:37 am (PDT) . Posted by:
"Higrm" higrm
Make this change to the formula and you can remove the special characters:
=SUBSTITUTE(RCHGetHTMLTable("https://www.marketbeat.com/stocks/NYSE/"&$A$1&"/price-target/",">Brokerage"),"➝","➝")
On Wednesday, March 20, 2019, 5:09:02 PM GMT+1, friedman_steve@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Randy,
unfortunately this link you created stopped working. I couldn't figure out how to get going again to grab the table of analyst ratings/targets from the website. Are you able to update it?
Thanks again for your work Randy..... amazing work you do.
old link you created:=RCHGetHTMLTable("https://www.marketbeat.com/stocks/NYSE/"&$A$1&"/price-target/",">Brokerage")
=SUBSTITUTE(RCHGetHTMLTable("https://www.marketbeat.com/stocks/NYSE/"&$A$1&"/price-target/",">Brokerage"),"➝","➝")
On Wednesday, March 20, 2019, 5:09:02 PM GMT+1, friedman_steve@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Randy,
unfortunately this link you created stopped working. I couldn't figure out how to get going again to grab the table of analyst ratings/targets from the website. Are you able to update it?
Thanks again for your work Randy..... amazing work you do.
old link you created:=RCHGetHTMLTable("https://www.marketbeat.com/stocks/NYSE/"&$A$1&"
Wed Mar 20, 2019 9:46 am (PDT) . Posted by:
friedman_steve
actually, i just tried a NYSE ticker (T), and it worked.
But, doesn't work with ticker like AAPL. I know NYSE is in URL, but used to work anyhow in past. Plus, if replace NYSE with NASDAQ in the URL, it still doesn't work.
But, doesn't work with ticker like AAPL. I know NYSE is in URL, but used to work anyhow in past. Plus, if replace NYSE with NASDAQ in the URL, it still doesn't work.
Wed Mar 20, 2019 10:37 am (PDT) . Posted by:
"Craig Passow" passow
What does the URL look like if you navigate to the price target page for
AAPL? Once you have that information, adjust the formula accordingly.
On 3/20/2019 11:28 AM, friedman_steve@yahoo.com [smf_addin] wrote:
>
>
> actually, i just tried a NYSE ticker (T), and it worked.
>
>
> But, doesn't work with ticker like AAPL. I know NYSE is in URL, but
> used to work anyhow in past. Plus, if replace NYSE with NASDAQ in the
> URL, it still doesn't work.
>
AAPL? Once you have that information, adjust the formula accordingly.
On 3/20/2019 11:28 AM, friedman_steve@yahoo.com [smf_addin] wrote:
>
>
> actually, i just tried a NYSE ticker (T), and it worked.
>
>
> But, doesn't work with ticker like AAPL. I know NYSE is in URL, but
> used to work anyhow in past. Plus, if replace NYSE with NASDAQ in the
> URL, it still doesn't work.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar