[smf_addin] Digest Number 4551[1 Attachment]

EXCEL Stock Market Functions Add-in Group

6 Messages

Digest #4551

1.1

RCHGetYahooHistory by lhassrick

1.2

Re: RCHGetYahooHistory by "Higrm" higrm

1.3

Re: RCHGetYahooHistory by "Randy Harmelink" rharmelink

2a

download morningstar index by wongkayau

2b

Re: download morningstar index by "Randy Harmelink" rharmelink

2c

Re: download morningstar index by wongkayau

Messages

1.1

RCHGetYahooHistory

Wed Jun 5, 2019 6:06 am (PDT) . Posted by:

lhassrick

About 3 weeks ago the formula gave me real results, now the result is 0. I have tested on numerous ticker symbols, including MMM


I was hoping it was a temporary Yahoo glitch, but is this method for retrieving dividend history now obsolete?


I tried changing RCHGetYahooHistory to smfGetYahooHistory and get #VALUE as a result.


Thank you,




c1=6/5/2019
q2="MMM"



=SUM(INDEX(RCHGetYahooHistory(Q2,YEAR(C1)-1,MONTH(C1),DAY(C1),YEAR(C1),MONTH(C1),DAY(C1),"v",,0,,,20,2),,2))

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

1.2

Re: RCHGetYahooHistory

Wed Jun 5, 2019 8:12 am (PDT) . Posted by:

"Higrm" higrm

Your formula works for me, I get 5.6 using your criteria. 

On Wednesday, June 5, 2019, 3:11:05 PM GMT+2, lhassrick@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

 

About 3 weeks ago the formula gave me real results, now the result is 0. I have tested on numerous ticker symbols, including MMM

I was hoping it was a temporary Yahoo glitch, but is this method for retrieving dividend history now obsolete?

I tried changing RCHGetYahooHistory to smfGetYahooHistory and get #VALUE as a result.

Thank you,

c1=6/5/2019

q2="MMM"

=SUM(INDEX(RCHGetYahooHistory(Q2,YEAR(C1)-1,MONTH(C1),DAY(C1),YEAR(C1),MONTH(C1),DAY(C1),"v",,0,,,20,2),,2))

Attachment(s) from Higrm

1 of 1 Photo(s)

1559747549570blob.jpg

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

1.3

Re: RCHGetYahooHistory

Wed Jun 5, 2019 9:06 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Your formula returns $5.60 here...

I would think it'd be a lot easier to use the smfGetYahooPortfolioView(),
so that you can get multiple data items for multiple tickers in a single
Internet access, by array-entering it over a range. Or use
RCHGetElementNumber(). Both of those also allow you to get a forward
estimate of dividends instead of trailing.

smfGetYahooHistory() has different parameters and with day-to-day
processing, may no longer be able to do that.

On Wed, Jun 5, 2019 at 6:06 AM lhassrick@... wrote:

> About 3 weeks ago the formula gave me real results, now the result is 0. I
> have tested on numerous ticker symbols, including MMM
>
> I was hoping it was a temporary Yahoo glitch, but is this method for
> retrieving dividend history now obsolete?
>
> I tried changing RCHGetYahooHistory to smfGetYahooHistory and get #VALUE
> as a result.
>
>
>

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

2a

download morningstar index

Wed Jun 5, 2019 6:52 am (PDT) . Posted by:

wongkayau

Hello Randy,


Good morning.



I would like to download Hang Seng Index historical price from morningstar.. The official page is:

https://quotes.morningstar.com/indexquote/quote.html?t=0P00001FL8


The page does not have "historical price" for export. This is different from the page for stock. Here is the example for 0700.HK:
http://performance.morningstar.com/stock/performance-return.action?p=price_history_page&t=700®ion=hkg&culture=en-US http://performance.morningstar.com/stock/performance-return.action?p=price_history_page&t=700®ion=hkg&culture=en-US



By using smfGetCSVFile, I can successfully download date for 0700.HK via http://performance.morningstar.com/perform/Performance/stock/exportStockPrice.action?t= http://performance.morningstar.com/perform/Performance/stock/exportStockPrice.action?t=. However, I can't download the stock index.. Do you know how may I do it?


Thank you very much.


Cheers,
Ka Yau

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

2b

Re: download morningstar index

Wed Jun 5, 2019 9:17 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Since they don't have the "Export" button on the page, I would bet they
don't have a CSV file for it. However, their charting option on the page
gets the data from a URL like:

https://mschart.morningstar.com/chartweb/defaultChart?type=getcc&secids=XIUSA0001Z;XI&dataid=8225&startdate=1900-01-01&enddate=2019-06-05¤cy=&format=1&callback=jQuery172024676469280029334_1559751064211&_=1559751096637

But it's JSON data and requires credentials, so the add-in can't use it.

On Wed, Jun 5, 2019 at 6:53 AM wongkayau@... wrote:

> I would like to download Hang Seng Index historical price from
> morningstar. The official page is:
>
> https://quotes.morningstar.com/indexquote/quote.html?t=0P00001FL8
>
> The page does not have "historical price" for export. This is different
> from the page for stock. Here is the example for 0700.HK:
>
>
> http://performance.morningstar.com/stock/performance-return.action?p=price_history_page&t=700®ion=hkg&culture=en-US
> <http://performance.morningstar.com/stock/performance-return.action?p=price_history_page&t=700®ion=hkg&culture=en-US>
>
> By using smfGetCSVFile, I can successfully download date for 0700.HK via
> http://performance.morningstar.com/perform/Performance/stock/exportStockPrice.action?t=.
> However, I can't download the stock index. Do you know how may I do it?
>
>
>

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

2c

Re: download morningstar index

Wed Jun 5, 2019 9:34 am (PDT) . Posted by:

wongkayau

Hi Randy,



thanks a lot for your quick reply! no wonder i tried few hours and failed..



thanks again.


Cheers,
Ka Yau

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

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

Visit Your Group

• Privacy • Unsubscribe • Terms of Use