[smf_addin] Digest Number 4644

EXCEL Stock Market Functions Add-in Group

1 Message

Digest #4644

1

Morningstar returns by calender year by nelsonmuntz1000

Message

1

Morningstar returns by calender year

Sat Nov 9, 2019 10:43 am (PST) . Posted by:

nelsonmuntz1000

Hi Randy


Is it possible to extract the annual returns by year from the following pages?


http://performance. morningstar.com/stock/ performance-return.action? region=usa&t=bac&culture=en-US http://performance.morningstar.com/stock/performance-return.action?region=usa&t=bac&culture=en-US



http://performance. morningstar.com/funds/etf/ total-returns.action?t=SPY& region=usa&culture=en-US http://performance.morningstar.com/funds/etf/total-returns.action?t=SPY®ion=usa&culture=en-US



Also, can Rank in Category be pulled on the ETF page. I played around with RCHGetTableCell formula but I didn't have any luck.


Thanks in advance.

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

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

Visit Your Group

• Privacy • Unsubscribe • Terms of Use