[smf_addin] Digest Number 4507

EXCEL Stock Market Functions Add-in Group

7 Messages

Digest #4507

1a

Morningstar Data Now Requires Callback Parameter, What Can We Do Abo by gz_cp

1b

Re: Morningstar Data Now Requires Callback Parameter, What Can We Do by gz_cp

1c

Re: Morningstar Data Now Requires Callback Parameter, What Can We Do by "Randy Harmelink" rharmelink

1d

Re: Morningstar Data Now Requires Callback Parameter, What Can We Do by JCHyjun

1e

Re: Morningstar Data Now Requires Callback Parameter, What Can We Do by "Randy Harmelink" rharmelink

2a

Sustainability info from Yahoo with RCHGetElementNumber by thdoucakis

2b

Re: Sustainability info from Yahoo with RCHGetElementNumber by "Randy Harmelink" rharmelink

Messages

1a

Morningstar Data Now Requires Callback Parameter, What Can We Do Abo

Thu Mar 28, 2019 11:03 am (PDT) . Posted by:

gz_cp

Prior to yesterday, we were able to get historical data from morningstar.com using
http://mschart.morningstar.com/chartweb/defaultChart?type=getcc&secids=F00000H3VG;XI&dataid=8225&startdate=2018-03-28&enddate=2019-03-28 http://mschart.morningstar.com/chartweb/defaultChart?type=getcc&secids=F00000H3VG;XI&dataid=8225&startdate=2018-03-28&enddate=2019-03-28¤cy=&format=1&callback=jQuery17209497126185594382_1553795038840&_=1553795041139

But since yesterday, they requires a callback parameter like
http://mschart.morningstar.com/chartweb/defaultChart?type=getcc&secids=F00000H3VG;XI&dataid=8225&startdate=2018-03-28&enddate=2019-03-28¤cy=&format=1&callback=jQuery17209497126185594382_1553795038840&_=1553795041139 http://mschart.morningstar.com/chartweb/defaultChart?type=getcc&secids=F00000H3VG;XI&dataid=8225&startdate=2018-03-28&enddate=2019-03-28¤cy=&format=1&callback=jQuery17209497126185594382_1553795038840&_=1553795041139



I found that URL from the "F12" tab of Chrome on the quote page
http://quotes.morningstar.com/indexquote/quote.html?t=F00000H3VG http://quotes.morningstar.com/indexquote/quote.html?t=F00000H3VG



We can no longer directly pull the data from the first simple URL above. The question is, how can we know the callback parameter in order to make the second URL that works? It's not on the page source of the quote page.


Any ideas?
Thanks.

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

1b

Re: Morningstar Data Now Requires Callback Parameter, What Can We Do

Thu Mar 28, 2019 12:42 pm (PDT) . Posted by:

gz_cp

A simpler way to ask this question is:

I am thinking about scraping financial data behind the main chart on http://quotes.morningstar.com/indexquote/quote.html?t=F00000H3VG.


The URL of the json data is like this http://mschart.morningstar.com/chartweb/defaultChart?type=getcc&secids=F00000H3VG;XI&dataid=8225&startdate=2018-03-28&enddate=2019-03-28¤cy=&format=1&callback=jQuery17209497126185594382_1553795038840&_=1553795041139


I found it manually on the "F12" debug tab of Chrome when the chart is being loaded.


Is there a way to obtain this URL automatically?


Thanks.

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

1c

Re: Morningstar Data Now Requires Callback Parameter, What Can We Do

Thu Mar 28, 2019 4:12 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry. No luck here.

On Thu, Mar 28, 2019 at 12:44 PM gz_cp@... wrote:

>
> A simpler way to ask this question is:
>
> I am thinking about scraping financial data behind the main chart on
> http://quotes.morningstar.com/indexquote/quote.html?t=F00000H3VG.
>
> The URL of the json data is like this
> http://mschart.morningstar.com/chartweb/defaultChart?type=getcc&secids=F00000H3VG;XI&dataid=8225&startdate=2018-03-28&enddate=2019-03-28¤cy=&format=1&callback=jQuery17209497126185594382_1553795038840&_=1553795041139
>
> I found it manually on the "F12" debug tab of Chrome when the chart is
> being loaded.
>
> Is there a way to obtain this URL automatically?
>
>
>

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

1d

Re: Morningstar Data Now Requires Callback Parameter, What Can We Do

Thu Mar 28, 2019 4:56 pm (PDT) . Posted by:

JCHyjun

I collected M* data using

smfGetCSVFile("http://financials.morningstar.com/ajax/exportKR2CSV.html?t="&TICKER&";")
for awhile,but it also doesn't work now.


What are good alternatives to have 5 years and 5 quarters financial statements for free?


JCH

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

1e

Re: Morningstar Data Now Requires Callback Parameter, What Can We Do

Thu Mar 28, 2019 11:57 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Looks like Morningstar has added credentials to all of the data requests.

I'm no longer familiar with the different free sources, since I get my data
from GuruFocus, as a subscriber.

On Thu, Mar 28, 2019 at 4:56 PM jchyjun@... wrote:

>
> I collected M* data using
> smfGetCSVFile("http://financials.morningstar.com/ajax/exportKR2CSV.html?t=
> "&TICKER&";")
> for awhile,but it also doesn't work now.
>
> What are good alternatives to have 5 years and 5 quarters financial
> statements for free?
>
>
>

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

2a

Sustainability info from Yahoo with RCHGetElementNumber

Thu Mar 28, 2019 11:13 am (PDT) . Posted by:

thdoucakis

I am interested in capturing the sustainability info that Yahoo is now publishing



example
https://finance.yahoo.com/quote/AAPL/sustainability?p=AAPL&.tsrc=fin-srch https://finance.yahoo.com/quote/AAPL/sustainability?p=AAPL&.tsrc=fin-srch


Thoughts on enabling this

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

2b

Re: Sustainability info from Yahoo with RCHGetElementNumber

Thu Mar 28, 2019 11:44 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try something like:

=smfGetTagContent("https://finance.yahoo.com/quote/AAPL/sustainability","div",2,"Total
ESG Score",,,,1)
=smfGetTagContent("https://finance.yahoo.com/quote/AAPL/sustainability","div",2,"Total
ESG Score",">Environment",,,1)
=smfGetTagContent("https://finance.yahoo.com/quote/AAPL/sustainability","div",2,"Total
ESG Score",">Social",,,1)
=smfGetTagContent("https://finance.yahoo.com/quote/AAPL/sustainability","div",2,"Total
ESG Score",">Governance",,,1)

On Thu, Mar 28, 2019 at 11:14 AM Theodore_Doucakis@... wrote:

>
> I am interested in capturing the sustainability info that Yahoo is now
> publishing
>
> example
> https://finance.yahoo.com/quote/AAPL/sustainability?p=AAPL&.tsrc=fin-srch
>
> Thoughts on enabling this
>
>
>

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

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

Visit Your Group

• Privacy • Unsubscribe • Terms of Use