3 Messages

Digest #3869

Price/Fair Value from Stockhouse web page by nelsonmuntz1000

Re: Canadian ETF by nelsonmuntz1000

Messages

1 Price/Fair Value from Stockhouse web page

Thu Dec 22, 2016 8:21 am (PST) . Posted by:

nelsonmuntz1000

Hi Randy

Any idea how to get the Price / Fair Value ratio from the following link:

http://www.stockhouse.com/companies/valuation?symbol=C http://www.stockhouse.com/companies/valuation?symbol=C

I tried using setting up RCHGetTableCell formula but I'm drawing a blank. I'm not sure I'm on the right track.

Thanks for your invaluable help.

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

2a

Re: Canadian ETF

Thu Dec 22, 2016 8:32 am (PST) . Posted by:

nelsonmuntz1000

Try using the following formulas from Morningstar:

=smfConvertData(smfGetTagContent("http://quotes.morningstar.com/fund/c-header?t="&$A1&"","span",-1,"vkey=""ExpenseRatio"""))

=smfConvertData(smfGetTagContent("http://quotes.morningstar.com/fund/c-header?t="&$A1&"","span",1,"gkey=""ttmYield"""))

where A1 cell contains the Morningstar Fund code.

Note that the Morningstar codes may differ from the Fund company codes. For example PH&N Bond D fund company code is RBF1110. Morningstar also uses F0CAN05LV0. Try both to see what works.