Solved

VBA EXCEL assign and categorize data

Posted on 2009-05-14
3
403 Views
Last Modified: 2013-11-25
Hi, another question: I have a sheet (is attached) where I need to categorize data according to the Rating. On sheet "Info" we can find the rating (column B) for the particular bond - on sheet "Risk Criteria" we can find the the Riskrating (column E) which indicates that A+ to A- will get the rating 3 (this inculdes also A as it is in between A+ and A-). Everything BB+ and below will get a 5 - if there is no rating it should also get a 5. (AAA = 1; AA+, AA, AA- = 2; A+, A, A- = 3; BBB+, BBB, BBB- = 4, the rest =5). The result should be displayed in sheet "Calculation". The CUSIP/ISIN is the ID. If you have any help how to solve this I would be very grateful.
Moreover, I would like to classify the country by assinig them another rating. This rating still has to be calculated according to the data i am downloading on sheet "Country". Here we can see that there are many bonds with a number (yield) - this data actually has to be sorted by the numer (yield) so that we can perform the assignment of the Risk Criteria. On sheet "Risk Criteria" we can the 20% having the highest number (yield) should get the number 5 (80.01% - 100%) this should include all the countries on the bottim of the table on sheet "Country". If there is not country found the Bond should get a 5 (as with the Rating). The result should be displayed on sheet "Calculation". Again, I am grateful for any help.
RatingCountry.xls
0
Comment
Question by:kbrasco
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
EoDawg earned 500 total points
ID: 24386369
Hello,

Have a look and let me know, it was a bit confusing from your description but I think I got most of your requirements.
RatingCountry-1-.xls
0
 

Author Comment

by:kbrasco
ID: 24386608
Yes that works for me. Thanks
0
 
LVL 6

Expert Comment

by:EoDawg
ID: 24386968
Just to note you had "Germany" in your country list twice, this will skew your results by a very small percent.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now