Mapping Average Credit Quality Score before pulling in Excel
Under Consideration
Is there a way to convert this numerical score into the grade (AAA, AA, A, etc...) level in Excel?
Right now, the output is a number and we have to reference a table to perform a vlookup to show the grade level.
On a fund page, it shows - 5.00 (AA)
sarah@waldenwealth.com
I like this idea
Sean Janni - 7680 sean@prairieviewpartners.com
Hi Carl and Kimberly,
I’m trying to create the formula to enable my spreadsheet to populate the credit scores of the respective funds that I have input, but the field will only return a number that corresponds to a credit rating(1.00=AAA) I’ve discovered each number represents a credit score, but it’s not intuitive on its own. Is there a different formula that I can use in order to get the letter rating to populate? I’ve pasted the formula that I’ve been using for reference below.
YCP("SPXU","average_credit_quality_score")
Sean Janni - 7680 sean@prairieviewpartners.com
Hi Carl and Kimberly,
I’m trying to create the formula to enable my spreadsheet to populate the credit scores of the respective funds that I have input, but the field will only return a number that corresponds to a credit rating(1.00=AAA) I’ve discovered each number represents a credit score, but it’s not intuitive on its own. Is there a different formula that I can use in order to get the letter rating to populate? I’ve pasted the formula that I’ve been using for reference below.
YCP("SPXU","average_credit_quality_score")
Is this request really to just add an info point that is the letter version (string) of the credit rating? And have that info point avail in Excel?
Also, Can we share an Excel formula with these folks that interprets the score for a short term hack?
Is this request really to just add an info point that is the letter version (string) of the credit rating? And have that info point avail in Excel?
Also, Can we share an Excel formula with these folks that interprets the score for a short term hack?
Not Excel, but the ability to use this in the site in tolls such as Comp Tables. We have it on quote pages but it isn't available anywhere else.
Requested by Jire Baran and Todd Brauer at Neuberger Berman ($63k)
Not Excel, but the ability to use this in the site in tolls such as Comp Tables. We have it on quote pages but it isn't available anywhere else.
Requested by Jire Baran and Todd Brauer at Neuberger Berman ($63k)
Replies have been locked on this page!