[smf_addin] Digest Number 4548

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #4548

1a

Re: RCHCreateComment Function is not working by friedman_steve

1b

Re: RCHCreateComment Function is not working by "Randy Harmelink" rharmelink

2

Seeking Alpha Data Extraction Question by ridgebacksexcel

3a

Morningstar Credit Rating by ridgebacksexcel

Messages

1a

Re: RCHCreateComment Function is not working

Thu May 30, 2019 7:49 am (PDT) . Posted by:

friedman_steve

Hi Randy, Is there a way to edit the formula to change the # of days for the chart? I'm trying to do a 2 year, or 3 yr chart.
What do each of the things adjust in the formula? I was only able to figure out the pb50 and b200 changed the # of days for moving average lines.


here's my current formula:
=rchcreatecomment("https://c.stockcharts.com/c-sc/sc?chart="&$A$1&",uu[305,180]dacayaci[pb50!b200][dc]",99,450,421,1,0,50,500,,"Sell Side Analysts")



Thanks!

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

1b

Re: RCHCreateComment Function is not working

Thu May 30, 2019 9:09 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You can't specify a number of days, but there are two parameters related to
chart period and duration.

-- The "d" following "[305,180]" is for daily charting period. You can also
use "w" for weekly.
-- The "d" in the trailing "[dc]" is used for duration: a=1Month, b=3Month,
c=6Month, d=1Year, e=2Year, f=3Year

I had to go back to some notes I made in 2003 to find that. :)

On Thu, May 30, 2019 at 8:34 AM friedman_steve@... wrote:

>
> Is there a way to edit the formula to change the # of days for the chart?
> I'm trying to do a 2 year, or 3 yr chart.
> What do each of the things adjust in the formula? I was only able to
> figure out the pb50 and b200 changed the # of days for moving average
> lines.
>
> here's my current formula:
> =rchcreatecomment("https://c.stockcharts.com/c-sc/sc?chart="&$A$1&",uu[305,180]dacayaci[pb50!b200][dc]",99,450,421,1,0,50,500,,"Sell
> Side Analysts")
>
>
>

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

2

Seeking Alpha Data Extraction Question

Thu May 30, 2019 11:05 pm (PDT) . Posted by:

ridgebacksexcel

Randy,


I'm having trouble getting the "Dividend Growth" years from this URL:


https://seekingalpha.com/symbol/AAPL/dividends/scorecard https://seekingalpha.com/symbol/AAPL/dividends/scorecard


The answer should be 6 Years.




Or this URL:


https://seekingalpha.com/symbol/AAPL/dividends/dividend-growth https://seekingalpha.com/symbol/AAPL/dividends/dividend-growth


"Years of Growth" should be 6.


Either page would be fine as the data number I am looking for is the same.


Is it possible? I can't figure this one out.


Thanks.

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

3a

Morningstar Credit Rating

Thu May 30, 2019 11:29 pm (PDT) . Posted by:

ridgebacksexcel

Randy,


I'm also trying to extract a Credit Rating from Morningstar.
I can use the RCHGetTableCell function to get the credit rating from this URL:


https://ratingagency.morningstar.com/MCR/ratings-surveillance/transaction-detail-corporate/d0JvWmRKSTVJU2VKWmZYVHBMJTJiYVA3ZFB6dkJ6U09FVTNkZjNWYVVxck85U2wlMmYwMW53Qm9zdyUzZCUzZA%3d%3d https://ratingagency.morningstar.com/MCR/ratings-surveillance/transaction-detail-corporate/d0JvWmRKSTVJU2VKWmZYVHBMJTJiYVA3ZFB6dkJ6U09FVTNkZjNWYVVxck85U2wlMmYwMW53Qm9zdyUzZCUzZA%3d%3d


The problem is I have no way to reference the ticker AAPL that it refers to. Maybe its encoded on purpose.


The Credit Rating should be: AA-


Thanks.

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

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• Privacy • Unsubscribe • Terms of Use