[smf_addin] Digest Number 3712

EXCEL Stock Market Functions Add-in Group

3 Messages

Digest #3712

1a

Re: ETF Specific Data Items by norton1717

2a

Country default spreads and risk premiums by ohadbeno

2b

Re: Country default spreads and risk premiums by "Randy Harmelink" rharmelink

Messages

1a

Re: ETF Specific Data Items

Fri May 27, 2016 6:42 am (PDT) . Posted by:

norton1717

Thanks again. I will play around with the examples to get what I need.

Really appreciate your help.

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

2a

Country default spreads and risk premiums

Sat May 28, 2016 1:53 am (PDT) . Posted by:

ohadbeno

Hi Randy,
Is there a way to retrieve data from the table "Country default spreads and risk premiums"?


Ex. USD, total equity risk premium = 6%
http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/ctryprem.html http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/ctryprem.html



http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/ctryprem.html http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/ctryprem.html Country Africa Moody's rating Rating-based Default Spread Total Equity Risk Premium (based on rating) Country Risk Premium (based on rating) CDS Default Spread (net of US )



View on pages.stern.nyu.edu http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/ctryprem.html
Preview by Yahoo


Thanks

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

2b

Re: Country default spreads and risk premiums

Sat May 28, 2016 2:03 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=RCHGetTableCell("
http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/ctryprem.html",4,">United
States of America<")

On Sat, May 28, 2016 at 12:18 AM, ohadbeno@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Is there a way to retrieve data from the table "Country default spreads
> and risk premiums"?
>
> Ex. USD, total equity risk premium = 6%
>
> http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/ctryprem.html
>

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

• New Members 9

• Privacy • Unsubscribe • Terms of Use