Simulated Security
| Account limit of 2124 requests per hour exceeded. |
What excel formula can I use to automatically generate a rating that’s one notch below the original rating?
I have a portfolio of securities and I would like to simulate a result under a situation in which all the securities get downgraded one notch. For example, if I have a security currently rated Aaa by Moodys, what formula can I use to make it downgrade to Aa automatically? I need a formula that can work with the whole portfolio. Thanks.
First, you have to set up a table(a simplified version of 4 ratings) say in A1:B3 you have
A1 A
A2 B
A3 C
B1 B
B2 C
B3 D
use a vlookup formula to lookup the downgraded rating, VLOOKUP(lookup_value ,table_array ,col_index_num ,range_lookup ) is the general format of the function, say the cell you want to show the downgraded rating is D1, so in D1, you put
=VLOOKUP( C1, A1:B3, 2, false)
C1 is the cell that has the original rating
A1:B3 is the table you build above
2 is the second column of that table you want the desire rating to return if there's a match
false is use because we expected there's an exact match
Simulated THOR Demonstration
« High Resolution | Home | Security Alarm »
Leave a Comment